Category «1Z0-062»

Exam 1z0-062: Oracle Database 12c: Installation and Administration (update December 12th, 2017)

Which two statements are true in this scenario?

Your database is running in ARCHIVEVLOG mode.You want to take a consistent whole database backup.Which two statements are true in this scenario? A. RMAN backups contain only data files. B. The database instance must be shut down to take a user-managed consistent backup. C. Consistent RMAN backups can be taken while the database is open. …

What must you do before executing it?

Examine the details of the uncompressed, non-partitioned heap table CITIES. Examine the command:SQL> ALTER TABLE cities SHRINK SPACE COMPACT;What must you do before executing it? A. Ensure free space that is approximately equal to the space used by the table should be available. B. Ensure there are no pending transactions on the table. C. Enable …

Which three statements are true?

Examine the command to perform a data pump export operation on a source database:$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_deptOn the target database, you execute the data pump import command:$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_deptWhich three statements are true? (Choose three.) A. The expdp operation exports data that satisfies the condition of the defining query used …

Which two configurations allow this command to execute successfully?

Examine the command:SQL> CONNECT hr/hr@orclWhich two configurations allow this command to execute successfully? (Choose two.) A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name. B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host. C. The orcl TNS alias should be defined …

What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?

The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR.You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.BOSTON is defined as a service name in the tnsnames.ora of both the databases.You plan to use the command:CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY …