最新的12c認證 1z0-063考試題庫

問題1

Which three RMAN persistent settings can be set explicitly? (Choose three.)

A. archivelog backup duplexing

B. controlfile autobackup formats

C. redo log backup duplexing

D. archivelog deletion policy

E. SPFILE backup duplexing

F. image copy duplexing

正確答案: B,D,F

問題2

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?

A. It is granted to the c##admin user only in the CDB.

B. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

C. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

D. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

正確答案: C

問題3

You use RMAN to take regular backups for your database.
Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP;
RMAN> DELETE EXPITED BACKUP;
Which statement is true?

A. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.

B. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

C. All backups that have exceeded the age set by the RMAN retention policy are deleted.

D. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

正確答案: A

問題4

Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

A. consistent whole database backup

B. backup of the database without shutting down the instance

C. backup of only those blocks that have changed since the last backup while database is mounted

D. backup of noncritical tablespaces without shutting down the instance

E. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open

正確答案: A,B,C

問題5

You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)

A. It has a common schema for all the PDBs.

B. It can create common users only when it is logged in to the CDB.

C. It can create only local users in all the PDBs.

D. It can create only local users in the CDB.

E. It can be granted only common roles in the PDBs.

正確答案: B,C

問題6

Which two statements are true about roles in multitenant container databases (CDBs)? (Choose two.)

A. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.

B. Local roles can be granted to local and common users.

C. A local role can be assigned to a common role in a PDB.

D. A common role can be granted only to a common user.

E. The root container can have both local and common roles.

F. A common role can be granted only system privileges.

正確答案: B,C

問題7

Examine these actions:
1. Log in to CDB$ROOT as a user with the SYSDBA privilege.
2. Log in to the PDB as a user with the SYSKM privilege.
3. Ensure that the CD keystore is open.
4. Ensure that the CDB keystore is closed.
5. Export the PDB key information.
6. Export the CDB key information.
7. Shut down the CDB.
8. Shut down the PDB.
9. Unplug the PDB.
Which of these are required to unplug an encrypted PDB?

A. 1, 4, 5, 7, 9

B. 1, 3, 5, 9

C. 2, 4, 5, 7

D. l, 3, 5, 7, 9

E. 2, 3, 6, 8

F. 1, 3, 5, 8, 9

正確答案: D

說明：（僅 VCESoft 成員可見）

問題8

Which four are true about Consolidated Database Replay? (Choose four.)

A. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

B. Multiple replay schedules can be defined for a consolidated replay.

C. A single replay schedule can be defined for a consolidated replay.

D. Multiple workload captures from multiple databases can be replayed simultaneously.

E. The workload capture and replay servers must run the same operating system (OS).

F. A subset of the captured workload can be replayed.

G. A superset of the captured workload can be replayed.

正確答案: B,C,D,F

問題9

Which three statements are true about the SQL*Loader utility? (Choose three.)

A. It can be used to load data from external files using direct path only.

B. It can be used to extract and reorganize data from external files, and then load it into a table.

C. It can be used to generate unique sequential values in specified columns while loading data.

D. It can be used to load data from multiple external files into multiple tables.

E. It can be used to create tables using data that is stored in external files.

正確答案: B,C,D

問題10

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.

A. 1, 5, 4, 7, and 6

B. 3, 2, 5, 1, 4, and 7

C. 2, 1, 3, 5, 7, and 6

D. 2, 5, 1, 4, 7, and 6

正確答案: D

說明：（僅 VCESoft 成員可見）

最新的Oracle Database 12c: Advanced Administration - 1z0-063免費考試真題

最新更新

站內鏈接

聯系我們