1Z0-042判断题每日一练(2020.03.29)

多项选择题
You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）
A.Profile
B.Account lock
C.Account unlock
D.Password expire
E.Quota 10MB on Certkiller TBS1
F.Password never expire
G.Defaulttablespace Certkiller TBS1
H.Quota unlimited on Certkiller TBS1
I.TemporarytablespaceTEMP
J.TemporarytablespaceSYSTEM
单项选择题
You executed the following command to start the database： SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytesORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）
A.V$INSTANCE
B.V$CONTROLFILE
C.DBA_CONTROL_FILES
D.V$DATABASE_PROPERTIES
E.V$CONTROLFILE_RECORD_SECTION
单项选择题
You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）
A.The instance would normally abort.
B.The instance would not be affected.
C.The instance would be invalid， so would have to be aborted.
D.The instance would remain open， but the LGWR process would fail.
E.The instance would remain open and would automatically create the missing file
多项选择题
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
A.The destination must be global only.
B.A maximum of five destinations can be assigned.
C.A maximum of ten different destinations can be assigned.
D.All the destinations are determined by the server automatically.
E.The destination may be local or remote for a Standby Database.
F.The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
单项选择题
You are connecting to an Oracle database server from a client by using the following connect string： SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb Which naming method is being used in this case？（）
A.Local Naming
B.Easy Connect
C.External Naming
D.Directory Naming