1Z0-062 Online Practice Questions and Answers

As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.

Which command would you execute to create the database link?

A. CREATE DATABASE LINK HQ USING 'HQ';

B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING `HQ';

C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

A. The PDB must be open in read only mode.

B. The PDB must be dosed.

C. The unplugged PDB becomes a non-CDB.

D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

E. The unplugged PDB can be plugged into another CDB.

F. The PDB data files are automatically removed from disk.

Examine the following query output:

You issue the following command to import tables into the hr schema:

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?

A. All database operations performed by the impdp command are logged.

B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the

Oracle Database server. The database and listener are configured by using Oracle Restart.

Examine the following command and its output:

$ crsctl config has

CRS-4622: Oracle High Availability Services auto start is enabled.

What does this imply?

A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Examine the commands executed to monitor database operations:

$> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job' , FORCED_TRACKING => `Y');

Which two statements are true? (Choose two.)

A. Database operations will be monitored only when they consume a significant amount of resource.

B. Database operations for all sessions will be monitored.

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

D. Only DML and DDL statements will be monitored for the session.

E. All subsequent statements in the session will be treated as one database operation and will be monitored.

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.

B. It automatically makes necessary changes to Oracle environment variables.

C. It automatically enables unified auditing in the upgraded database.

D. It automatically adds new data files if there is not enough disk space to grow.

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

A. listener configured by using NETCA

B. database service created by using SRVCTL

C. database created by using a SQL statement

D. database created by using DBCA

E. ASM instance created by using ASMCA

F. database service created by using DBMS_SERVICE.CREATE_SERVICE

G. database service created by modifying the SERVICE_NAMES initialization parameter

Which four are true about creating and running a remote database scheduler jobs? (Choose four.)

A. A database destination must exist or be created for the remote database

B. It must run as a user that is defined on the remote database

C. Remote database jobs always run as the same user who submits the job on the local database

D. A credential is optional for a remote database job

E. A credential must be created to define the remote user

F. A database destination group must exist or be created for a job to run on multiple remote databases

G. A destination is optional for a remote database job because DB links can be used instead

Your database is configured in ARCHIVELOG mode.

Examine the RMAN configuration parameters:

Examine the command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which two are true? (Choose two.)

A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command

B. It creates image copies of the archivelogs

C. It creates a backupset of archive log files

D. It creates image copies of the database files

E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

A. dbca

B. asmca

C. netca

D. netmgr

E. lsnrctl