OracleOCP认证考试练习真题1Z0-063英文.pdfVIP

试卷科目：考试

OracleOCP认证考试练习真题1Z0-063英文

说明：答案和解析在试卷最后

第1部分：单项选择题，共134题，每题只有一个正确答案,多选或少选均不得分。

1.[单选题]Youareadministeringamultitenantcontainerdatabase(CDB)cdb1.

Examinethecommandanditsoutput:

SQL>showparameterfile

NAMETYPEVALUE

Db_create_file_deststring

Db_file_name_converstring

Db_filesstring200

Youverifythatsufficientdiskspaceisavailableandthatnofilecurrentlyexistsinthe

‘/u0l/app/oracle/oradata/cdb1/salesdb'location.

Youplantocreateanewpluggabledatabase(PDB)byusingthecommand:

SQL>CREATEPLUGGABLEDATABASESALESPDB

ADMINUSERsalesadmIDENTIFIEDBYpasswordROLES=(dba)

DEFAULTTABLESPACEsales

DATAFILE'/u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf’SIZE250MAUTOEXTEND

ON

FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/',

'/u01/app/oracle/oradata/cdb1/salesdb/')

STORAGE(MAXSIZE2G)

PATH_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';

Whichstatementistrue?

A)SALESPDBiscreatedandisinmountstate.

B)PDBcreationfailsbecausetheDB_file_name_convertparameterisnotsetintheCDB.

C)SALESPDBiscreatedandisinread/writemode.

D)PDBcreationfailsbecauseadefaulttemporarytablespaceisnotdefinedforSALESPDB.

2.[单选题]Youareadministeringamultitenantcontainerdatabase(CDB)thatcontainsmultiple

Pluggabledatabases(PDBs).Youareconnectedtocdb$rootasthesysuser.

Youexecutethecommands:

SQL>CREATEUSERC##ADMINIDENTIFIEDBYorcl123;

SQL>CREATEROLEC##CONNECT;

SQL>GRANTCREATESESSION,CREATETABLE,SELECTANYTABLETOC##CONNECT;

SQL>GRANTC##CONNECTtoC##ADMINCONTAINER=ALL;

Whichstatementistrueaboutthec##connectrole?

A)Itiscreatedonlyincdb$rootandcannotbegrantedtothec##adminuserwiththe

Container=allclause.

B)Itisgrantedtothec##adminuseronlyintheCDB.

C)Itis