单项选择题X 纠错
A.You have chosen the File System option as the storage option.
B.You have chosen the Automatic Storage Management (ASM) as the storage option.
C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
D.You are using General Purpose template and not the Custom Database template to create the database
你可能喜欢
多项选择题
A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported
多项选择题
A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the onlineredo log files
多项选择题
A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked
单项选择题
A.When the data file of the undo tablespace is autoextensible
B.When there are more than one undo tablespaces available in the database
C.When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.When the undo tablespace is autoextensible and retention guarantee is not enabled
多项选择题
A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic
单项选择题
A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace
单项选择题
A.The command executes successfully.
B.The command produces an error because the EMP table is owned by SCOTT.
C.The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
D.The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table
单项选择题
A.All sessions of the HR user only
B.All sessions of the HR user and the SYS user
C.The session of the HR user that executed the commands
D.All the sessions for which the database users have access privilege to the PERSONS table
多项选择题
A.Flashback log files
B.Backups that have become obsolete
C.User managed backups of the data files and control files
D.Archived redo log files that have multiple copies in a different archive location and not backed up
单项选择题
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management