Free Oracle 1z1-062 Practice Test & Real Exam Questions

When is the UNDO_RETENTION parameter value ignored by a transaction?

In which situations does the Database Writer process (DBWn) write to data files? (choose two).

Identify three uses of the CROSSCHECK command (Choose three.)

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).
How would you achieve this?

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

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 statements are true about Enterprise Manager Database Express? (Choose three.)

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

DEFERRED_SEGMENT_CREATION is TRUE in one of your databases.
You execute this command:

Which three statements are true immediately after this statement executes successfully?

You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package How would you create this role?

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.)