多项选择题X 纠错
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
单项选择题
A.Cluster
B.Database link
C.Mapping table
D.Materialized view
单项选择题
A.The database user OPS$SKD will be able to administer the database.
B.The authentication detail for the database user OPS$SKD is recorded in the password file.
C.The local operating system user SKD will be able to access the database instance without specifying theusername and password.
D.The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
单项选择题
A.The DML operations re-create the Bitmap index blocks.
B.The Bitmap index is rebuilt automatically after a DML operation.
C.The smallest amount of a bitmap that can be locked is a bitmap segment.
D.Additional time is taken to remove NULL values from the Bitmap index after a DML operation.
单项选择题
A.An Automatic Workload Repository snapshot has been taken recently.
B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but notthe threshold alerts related to instance metrics
多项选择题
A.It can span multiple databases.
B.It can consist of multiple data files.
C.It can contain blocks of different sizes.
D.It can contain segments of different sizes.
E.It can contain a part of a nonpartitioned segment