Online Access Free 1z0-063 Practice Test

Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

• A.The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
• B.Default permanent tablespaces can be shared across pluggable databases (PDBs).
• C.The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.
• D.The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
• E.Each PDB can have its own default temporary tablespace.

Examine the command:

Which statement is true about the execution of the command?

• A.It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.
• B.It fails because the log file parameter is not specified.
• C.It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
• D.It fails because no absolute path is specified for the log file and dump file.

A database is running in ARCHIVELOG mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

• A.multisection parallel backup by using RMAN
• B.cold backup after taking the tablespace offline
• C.image copy backup by using RMAN
• D.multisection image copy backup by using RMAN
• E.cold backup after placing the tablespace in backup mode

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace? (Choose two.)

• A.Create a new temporary tablespace and assign it as the default to the user.
• B.Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• C.Drop the tenp01.dbf file, and then re-create the temp file.
• D.Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E.Add a new temp file to the temporary tablespace and drop the temp01.dbf file.

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

• A.Flashback Data Archive is full after the first update statement.
• B.The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
• C.Supplemental logging is not enabled for the database.
• D.Undo retention guarantee is not enabled.
• E.The undo data that existed for versions of rows before the change to the table structure is invalidated.