OracleOCP认证考试练习真题OCP063.pdfVIP

试卷科目：考试

OracleOCP认证考试练习真题OCP063

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

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

Examinethecommandanditsoutput:

SQLshowparameterfile

NAMETYPEVALUE

db_create_file_deststring

db_file_name_convertstring

db_filesinteger200

Youverifythatsufficientdiskspaceisavailableandthatnofilecurrentlyexistsinthe

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

Youplantocreateanewpluggabledatabase(PDB)byusingthecommand:

SQLCREATEPLUGGABLEDATABASESALESPDB

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.

答案:A

解析:

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

databases(PDBs).Youareconnectedtocdb$rootasthesysuser.

Youexecutethecommands:

SQLCREATEUSERC##ADMINIDENTIFIEDBYorcl123;

SQLCREATEROLEC##CONNECT;

SQLGRANTCREATESESSION,CREATETABLE,SELECTANYTABLETOC##CONNECT;SQL

GRANTC##CONNECTtoC##ADMINCONTAINER=ALL;

Whichstatementistrueaboutthec##connectrole?

A)Itiscreatedonlyincdb$rootandcannotbegrantedtothec##adminuserwiththecontainer=all

clause.

B)Itisgrantedtothec##adminuseronlyintheCDB.

C)Itisgrantedtothec##adminuserinallPDBsandcanbegrantedonlytoa