A. The CDB must be open.
B. The CDB must be in the mount stage.
C. The CDB must be in the nomount stage.
D. Alt existing PDBs must be closed.
第1题:
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;What is the result?()
A. It executes successfully and creates an UNDO tablespace in hr_pdb.
B. It falls and reports an error because there can be only one undo tablespace in a cdb.
C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
E. It executes successfully but neither tablespace nor the data file is created.
第2题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()
A. All users except SYS
B. All users except SCOTT
C. All users except sys and SCOTT
D. All users except sys, system, and SCOTT
第3题:
Anadministratorisplanningaclusterrunningapplicationsin3separateresourcegroups.RGA-Database1RGB-WebServerRGC-Database2Database1andDatabase2mustbeonlinebeforetheWebServer.AllresourcegroupshaveaStartupPolicyofOnlineonHomeNodeOnly.Whichofthefollowingwillensurethattheresourcegroupsareprocessedinthecorrectorder?()
A.SettheSerialAcquisitionOrder
B.SettheParallelAcquisitionOrder
C.ConfigureOnlineontheSameNodeDependency
D.ConfigureOnlineonDifferentNodesDependency
第4题:
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result?()
A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
B. It fails and reports an error because the CONTAINER=ALL clause is not used.
C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
第5题:
A.selectfile->Database->newandgiveitafilenameof“blank.nsf”
B.selectfile->Database->new,chooselocalastheserver,andchosetheblanktemplate
C.selectfile->Database->new,chooselocalastheserver,andchosethedefault.ntftemplate
D.selectfile->Database->new,giveitafilenameof“blank.nsf”,andchosetheblanktemplate
第6题:
( ) – Is Miss White __________ English teacher, Maria?
– No, she teaches __________ geography.
A.your;my
B.you;mine
C.you;us
D.your;us