Oracle認(rèn)證考試章節(jié)練習(xí)(2019.12.31)

A.A
B.B
C.C
D.D

A. You must assign users to consumer groups.
B. You must grant the switch privilege to the users.
C. You must create a resource plan directive.
D. You must specify the complex resource plan.

A.Both USING and ON clauses can be used for equijoins and nonequijoins 
B.Amaximum of one pair of columns can be joined between two tables using the ON clause 
C.The ON clause can be used to join tables on columns that have different names but compatible data types 
D.The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

A.A MIUS B
B.B MINUS A
C.A INTERSECT B
D.B INTERSECT A

A.The instance aborts.
B.The database cannot be recovered.
C.The database can be recovered by restoring the control files from the backup.
D.The database remains opened and you have to shut it down with the ABORT option.
E.The database can be restored till the point of the last closed whole database backup.

A.Oracle代理服務(wù)
B.Oracle的偵聽程序
C.用于OEM管理結(jié)構(gòu)
D.Oracle網(wǎng)絡(luò)服務(wù)

A. MAX
B. MIN
C. SUM
D. COUNT
E. TOTAL
F. LARGEST

A.Archiving will be disabled because the destination for the redo log files is missing.
B.The database instance will shut down and the error details will be logged in the alert log file.
C.Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
D.Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.

A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

A. any class
B. only the Target class
C. any class in the test package
D. any class that extends Target