최신 1Z0-060 무료덤프 - Oracle Upgrade to Oracle Database 12c
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Which three statements are true concerning the multitenant architecture?
정답: B,E,F
설명: (DumpTOP 회원만 볼 수 있음)
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?
정답: B,D
설명: (DumpTOP 회원만 볼 수 있음)
Which three can be performed on a Data Pump type external table? (Choose three.)
정답: A,D,E
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:
Which statement is true about the common user created by the command?
Which statement is true about the common user created by the command?
정답: B
You notice that the performance of your production 24/7 Oracle database significantly degraded.
Sometimes you are not able to connect to the instance because it hangs.
You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
Sometimes you are not able to connect to the instance because it hangs.
You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
정답: E
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
정답: C,F
설명: (DumpTOP 회원만 볼 수 있음)
You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
`+RECO';
Which five steps are performed by RMAN?
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
`+RECO';
Which five steps are performed by RMAN?
정답: A,D,F,G,H
On your Oracle 12c database, you issue the following commands to create indexes:
SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id,
sales_rep_id);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which statement is correct?
SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id,
sales_rep_id);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which statement is correct?
정답: B
Which statement is true concerning dropping a pluggable database (PDB)?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)