In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo retention?

Which files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggre

You install “Oracle Grid Infrastructure for a standalone server” on a host on which the ORCL1 and ORCL2 databases both have their instances running. Which two statements are true? (Choose two.)

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

Your database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ You execute the following command: And then grant OPS$GUEST_USER the CREATE SESSION privilege. Which two statements are true? (Choose two.)

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases. Examine these commands: Conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING 'orcl2'; What is the outcome of executing these commands in the ORCL1 database?

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database. Which two tools or utilities would you use to achieve this? (Choose two.)

Which three database operations can be performed only at MOUNT state? (Choose three.)

In which two scenarios do you use SQL* Loader to load data? (Choose two.)

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

What is a requirement for creating a remote database scheduler job?

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery? (Choose three.)

Which statement is true about redo log files during instance recovery?

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

Examine the parameter settings in your local ORCL database: Examine the parameter settings for the remote SALES database: As the SYS user, you issue the following command on ORCL: CREATE PUBLICDATABASE LINK sales.us.example.com USING ‘sales1’; The sales1 tnsnames entry points to the sales database instance. Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

Which two statements are true about resumable space allocation? (Choose two.)

You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file? (Choose two.)

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance. Which tool would you use to get advice on how to improve performance?