多項(xiàng)選擇題

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.

你可能感興趣的試題

多項(xiàng)選擇題

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

多項(xiàng)選擇題

The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable：
ERROR at line 1：
ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session ofSCOTT in this scenario（）

A.The session is terminated after receiving the error and JIM can continue with his transaction.
B.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C.The session is rolled back after receiving the error and JIM can continue with his transaction.
D.SCOTT has to reexecute the last command in the transaction after he commits the transaction.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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（）

你可能感興趣的試題

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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（）