Which two statements are true in this scenario?

Your database is running in ARCHIVEVLOG mode.You want to take a consistent whole database backup.Which two statements are true in this scenario? A. RMAN backups contain only data files. B. The database instance must be shut down to take a user-managed consistent backup. C. Consistent RMAN backups can be taken while the database is open. […]

Read More

Which statement is true regarding the DEFAULT profile?

Which statement is true regarding the DEFAULT profile? A. The values assigned to the resource limits and password parameters in the default profile can be altered. B. A different DEFAULT profile can be created before each user in a database. C. It can be dropped and recreated. D. it must be explicitly assigned to the […]

Read More

What must you do before executing it?

Examine the details of the uncompressed, non-partitioned heap table CITIES. Examine the command:SQL> ALTER TABLE cities SHRINK SPACE COMPACT;What must you do before executing it? A. Ensure free space that is approximately equal to the space used by the table should be available. B. Ensure there are no pending transactions on the table. C. Enable […]

Read More

Which three statements are true?

Examine the command to perform a data pump export operation on a source database:$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_deptOn the target database, you execute the data pump import command:$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_deptWhich three statements are true? (Choose three.) A. The expdp operation exports data that satisfies the condition of the defining query used […]

Read More

which two recovery scenarios must you use the RESETLOGS option?

In your database, archive logging and control file autobackup are enabled.The data files and redo log files are intact but control files are impacted due to media failure.In which two recovery scenarios must you use the RESETLOGS option? (Choose two.) A. One control file copy is intact so the spfile is changed to refer to […]

Read More

Which three statements are true about Oracle Data Pump?

Which three statements are true about Oracle Data Pump? (Choose three.) A. Oracle Data Pump export and import operations can be performed to move data across different database releases. B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients. C. A directory object must exist and a user performing an EXPDP or IMPDP […]

Read More

Which two configurations allow this command to execute successfully?

Examine the command:SQL> CONNECT hr/hr@orclWhich two configurations allow this command to execute successfully? (Choose two.) A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name. B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host. C. The orcl TNS alias should be defined […]

Read More