OracleOCP认证考试练习真题题库五.pdfVIP

试卷科目：考试

OracleOCP认证考试练习真题题库五

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

1.[单选题]Question:19.

WhichstatementbestdescribesthepurposeoftheInnoDBbufferpool?

A)Itisamountofbuffersavailableduringatransaction.

B)ItcachesonlytheindexesforInnoDBtables.

C)ItcachesdataandindexesforInnoDBtables.

D)Itholdschangesmadeduringatransactionbeforetheyarewrittentothelog.

E)ItisapoolofmemoryforSQLquerysortoperationsfromwithintheInnoDBengine.

答案:C

解析:

2.[单选题]Question:56.

Youarecontactedbyauserwhodoesnothavepermissiontoaccessadatabasetable.You

Determineafterinvestigationthatthisusershouldbepermittedtohaveaccessandsoyou

ExecuteaGRANTstatementtoenabletheusertoaccessthetable.

Whichstatementdescribestheactivationofthataccessfortheuser?

A)Theaccessdoesnottakeeffectuntiltheuserlogsoutandbackin.

B)Theaccessdoesnottakeeffectuntilthenexttimetheserverisstarted.

C)Theaccessisavailableimmediately.

D)TheaccessdoesnottakeeffectuntilyouissuetheFLUSHPRIVILEGESstatement.

答案:C

解析:

3.[单选题]Question:112.

YouhaveinstalledMySQLonOracleLinux7usingtheofficial...

Examinethisextractoftheffile:

[mysql]

Port=3301

[mysqld]

Port=3302

[mysqld@replica]

Port=3303

[replica]

Port=3304

YouissuethiscommandtostartMySQLServer:

Systemctlstartmysqld@replica

Onwhichportistheserverlistening?

A)3302

B)3303

C)3304

D)3301

答案:B

解析:

4.[单选题]Question:142.

考试真题题1/3

试卷科目：考试

MySQLServerhasbeenintallandthe/etc/ffilehasbeenedited.

Theserverdoesnotstartwhenyouattempttousethestartscriptoftheos,butstartsonlywhenyou

providealltheoptionsonthecommandline.

Youcheckthe