多項選擇題

You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；
Which statements describe the effect of the command（）

A.The tablespace would require recovery to go back online.
B.A checkpoint is taken on all data files that are associated with the SALES tablespace.
C.The sessions that subsequently try to access the objects in the SALES tablespace receive an error
D.The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

你可能感興趣的試題

多項選擇題

Examine the following statement that is used to modify the primary key constraint on the SALES table：
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；
Which three statements aretrue regarding the above command（）

A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint， but existing data is not checked.
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

多項選擇題

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

A.The retention period to support flashback
B.The expected length of the longest-running query
C.The number of undo tablespaces in the database
D.The size of the Flash Recovery Area for the database instance

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

你可能感興趣的試題

Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；
Which statements describe the effect of the command（）

Examine the following statement that is used to modify the primary key constraint on the SALES table：
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；
Which three statements aretrue regarding the above command（）