Free 1z0-060 Exam Dumps

Question 16

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:
1Z0-060 dumps exhibit
What is the result of the last SET CONTAINER statement and why is it so?

A. It succeeds because the PDB_ADMIN user has the required privileges.
B. It fails because common users are unable to use the SET CONTAINER statement.
C. It fails because local users are unable to use the SET CONTAINER statement.
D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Correct Answer:C

Question 17

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

A. The index remains invisible.
B. The index is not updated by the DML statements on the indexed table.
C. The index automatically becomes visible in order to have it updated by DML on the table.
D. The index becomes unusable but the table is updated by the DML.
E. The index is updated by the DML on the table.

Correct Answer:AE

Question 18

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
1Z0-060 dumps exhibit
Which three are prerequisites for successful execution of the command?

A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
B. All the user-defined tablespaces must be in read-only mode on the source database.
C. The export dump file must be created before starting the import on the target database.
D. The source and target database must be running on the same platform with the same endianness.
E. The path of data files on the target database must be the same as that on the source database.
F. The impdp operation must be performed by the same user that performed the expdp operation.

Correct Answer:ABD

Question 19

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

A. Set DB_FLASH_CACHE_ZISE = 64G.
B. Set DB_FLASH_CACHE_ZISE = 64G, 64G
C. Set DB_FLASH_CACHE_ZISE = 128G.
D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Correct Answer:B

Question 20

To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

A. It results in an error because these parameter settings are invali
B. One 64G flash cache file will be use
C. Two 64G flash cache files will be use
D. Two 32G flash cache files will be use

Correct Answer:A