最新的Oracle 1z0-063免費考試真題

問題1

Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B. When a PDB is created, a service with the same name as the PDB is created in the PDB.

C. Only a common user can create additional services for a PDB.

D. A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.

E. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

正確答案: A,D

問題2

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true? (Choose two.)

A. A resumable statement can be suspended and resumed only once during execution.

B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

C. A suspended statement will report an error if no corrective action has taken place during a timeout period.

D. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

E. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

正確答案: C,E

問題3

Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB):
SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE
UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

A. undotbs1 is used as the undo tablespace for both the root and seed databases.

B. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.

C. It creates a multitenant container database with the root database opened and the seed database mounted.

D. It sets the users tablespace as the default for both the root and seed databases.

E. The files created for both the root and seed databases use Oracle Managed Files (OMF).

F. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.

正確答案: A,E,F

問題4

Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).
It was started up by using the command which executed successfully with no errors:
SQL> STARTUP MOUNT
Which two statements are true? (Choose two.)

A. All tempfiles are opened.

B. All redo logs are opened.

C. The SPFILE is opened.

D. All control files are opened.

E. CDB$ROOT is opened.

正確答案: B,E

問題5

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

Which statement is true about granting the SELECT privilege on the DBA_USERS view to the c##ROLE1 role?

A. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view in CDB$ROOT and all the PDBs.

B. The command succeeds and the common user C##ADMIN can create a session in CDB$ROOT and all the PDBs, but can only query the DBA_USERS view in CDB$ROOT.

C. The command fails because CONTAINER is not set to CURRENT.

D. The command fails and gives an error because object privileges cannot be granted to a common user.

E. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view only in CDB$ROOT.

正確答案: A

問題6

You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Which two are required for the successful execution? (Choose two.)

A. Flashback Database must be enabled.

B. Undo retention guarantee must be enabled.

C. The Fast Recovery Area must be configured.

D. The database must be opened.

E. The database must be in ARCHIVELOG mode.

F. The database must be mounted.

正確答案: C,E

問題7

Examine the command to back up the ASM metadata:
ASMCMD> md_backup /backup/ASM_backup
In which three situations can you use the backup? (Choose three.)

A. when one or more file directory paths are accidentally deleted from an ASM disk group

B. when all the ASM disk groups for the ASM instance are lost

C. when the data file on an ASM disk group gets corrupted

D. when one or more disks in an ASM disk group are lost

E. when one of the disks in a disk group is accidentally unplugged

正確答案: A,B,D

問題8

Which three factors influences the optimizer's choice of an execution plan? (Choose three.)

A. The OPTIMIZER_MODE initialization parameter

B. Type of connection used to connect to database instance

C. Cardinality estimates

D. Object statistics in the data dictionary

E. Fixed baselines

正確答案: A,C,D

問題9

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. l, 3, 5, 7, 9

C. 2, 4, 5, 7

D. 1, 3, 5, 8, 9

E. 2, 3, 6, 8

F. 1, 3, 5, 9

正確答案: B

說明：（僅 Fast2test 成員可見）

問題10

Which three statements are true about the keystore storage framework for transparent data encryption?
(Choose three.)

A. It facilitates and helps to enforce keystore backup requirements.

B. It enables a keystore to be stored only in a file on a file system.

C. It transparently decrypts data for the database users and applications that access this data.

D. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

E. It enables separation of duties between the database administrator and the security administrator.

F. It handles encrypted data without modifying applications.

正確答案: A,D,E

問題11

In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
$> sqlldr hr/hr@pdb table=employees
Which three are true? (Choose three.)

A. It succeeds if HR is a local user in the PDB to which HR connects.

B. It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.

C. It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.

D. It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.

E. It succeeds if HR is a common user.

正確答案: A,B,D

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

聯系我們

站內鏈接

最新更新