Online Access Free 1Z1-060 Practice Test

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

• A.BACKUP DATABASE while connected to the boot container
• B.BACKUP PLUGGABLE database PDB1 while connected to PDB2
• C.BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• D.BACKUP DATABASE while connected to the PDB1 container
• E.BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database
12c when it is enabled? (Choose two.)

• A.reduced logical I/O
• B.improved Serial Execution performance
• C.reduced physical I/O
• D.reduced virtual memory utilization
• E.reduced CPU utilization

Which three statements are true about the use of the query result cache? (Choose three.)

• A.Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false.
• B.Results obtained from a query rewrite to a materialized view may be stored in the query result cache.
• C.Results from distributed queries are never stored in the query result cache.
• D.Results from remote queries may sometimes be stored in the query result cache.
• E.Stale results may still be obtained from the query result cache, if the query session's parameter is set to stale_tolerated.
  query_rewrite_integrity
• F.Results obtained from a join between a table and a view may be stored in the query result cache.

Which two statements are true regarding single row functions?

• A.TRIM: can be used to remove all the occurrences of a character from a string
• B.MOD: returns the quotient of a division
• C.TRUNC: can be used with number and date values
• D.SYSDATE: returns the database server current date and time
• E.INSTR: can be used to find only the first occurrence of a character in a string
• F.CONCAT: can be used to combine any number of values

An application accesses a small lookup table frequently.
You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A.Increase the database buffer cache size.
• B.Configure Automata Shared Memory Management.
• C.Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• D.Configure Automatic Memory Management-
• E.Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause.