A. Snapshot
B. Incremental
C. Copy
D. Differential
第1题:
A.V$BACKUP
B.V$BACKUP_STATUS
C.V$BACKUP_DATAFILE
D.V$DATAFILE_BACKUP
E.V$TABLESPCE_BACKUP
第2题:
A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.
B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.
C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.
D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup,and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup
第3题:
A.CONNECT
B.IMP_FULL_DATABASE
C.FULL_EXPORT_PRIVS
D.RESOURCE
E.FULL_IMPORT_PRIVS
第4题:
Thewarninglevelthresholdvalueforatablespace,DATA1,issetto60%andthecriticallevelthresholdvalueissetto80%.Thetablespace,DATA1,isinfrequentlyusedandisnotapartoftheproductionenvironment.Youissuedthefollowingcommand:
SQL>EXECUTE
DBMS_SERVER_ALERT.SET_THRESHOLD
(dbms_server_alert.tablespace_pct_full,
dbms_server_alert.operator_ge,80,
dbms_server_alert.operator_ge,90,
1,1,NULL,
dbms_server_alert.object_type_tablespace,’DATA’);
Whatwillbetheresultofthecommand?()
第5题:
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.You run the following statements in the mydb database: Mysql> CALL prepare_db ( );Mysql> LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql> SHOW TABLES;How many events are added to the audit log as a result of the preceding statements?()
A.12; only top-level statements and stored procedure events are logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
第6题:
AnOrganization2010has2MailboxServersnamedServer1andServer2.EachonehasMailboxDatabaseand1PublicFolderDatabase.AlluserscreatePublicFoldersonServer1only.YouneedtoensurethatalluserscreatePublicFolderonServer2only.Whatshouldyoudo?()
A.MoveallMailboxestoServer2
B.RemoveallPublicFolderreplicasfromServer1
C.ModifypropertiesofbothMailboxDatabases
D.ModifypropertiesofbothPublicFolderDatabases