Which statement is true about smallfile tablespaces? A. Extent location metadata is stored in the data dictionary by default. B. The number of data files is constrained only by the size of the storage array. C. Maximum file size can…
DATADIR1 and DATADIR2 are database directory objects. Examine this command: Which two are true about the expdp operation? (Choose two.) A. It creates a dump file for the entire database. B. It fails if the total size of the dump…
Which three types of files are created by expdp operations? (Choose three.) A. SQL files B. dump files C. reject files D. log files E. input data files F. bad files G. control files
TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). Examine this command: Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system? A. The INCLUDING CONTENTS AND DATAFILES clause…
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. UNDOTBS2 is the active undo tablespace. Examine these commands: USER1 executes DML, which generates more than 2 MB of UNDO. What is the result and why? A. It suspends the transaction, which…
In your database, you create a user, HR, and then execute this command: Which three actions can HR perform? (Choose three.) A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users. B. Grant the CREATE SESSION privilege with…
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1. USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. TBS1 is exported from ORCL by using this command:…
Your client application and Oracle database are located on different hosts. Which statement is true about establishing a connection between them? A. Oracle Connection Manager must be installed on the client. B. Net service names must be configured on both…
Which three are true about Oracle Managed Files (OMF)? (Choose three.) A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default. B. If DB_RECOVERY_FILE_DEST is specified, at least two…
Which three failures require intervention for recovery? (Choose three.) A. a user error such as dropping the wrong table B. network interface card (NIC) failure C. user process failure D. statement failure E. media failure