多选题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled.  What are the twoeffects of this command（）AIt fails if any existing 

第1题：

Which syntax turns an existing constraint on?（）

• A、ALTER TABLE table_name   ENABLE constraint_name;
• B、ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;
• C、ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;
• D、ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;
• E、ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;

第2题：

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

• A、Because row IDs may change during the flashback operation
• B、Because the object number changes after the flashback operation
• C、Because the rows are retrieved from the recycle bin during the flashback operation
• D、Because the table is moved forward and back to a temporary during the flashback opertion

第3题：

What command would you issue to enable automated backups of control files？（）  

• A、 alter database controlfile autobackup on
• B、 alter system controlfile autobackup on
• C、 configure controlfile autobackup on
• D、 enable controlfile autobackup

第4题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

• A、ALTER TABLE students ADD PRIMARY KEY student_id;
• B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);
• C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
• D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);

第5题：

You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

• A、Monitor thealert.logfile
• B、Enable server-side SQL tracing for user sessions
• C、Enable fine-grained auditing for the customer table
• D、Enable Fine-Grained Access Control （FGAC） for the customer table
• E、Write a database trigger on the customer table on the SELECT event

第6题：

Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true 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.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled.  What are the twoeffects of this command（）

• A、It fails if any existing row violates the constraint.
• B、It does not validate the existing data in the table.
• C、It enables the constraint to be enforced at the end of each transaction.
• D、It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled

第14题：

Which syntax turns an existing constraint on?（）

• A、ALTER TABLE table_name ENABLE constraint_name;
• B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
• C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
• D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;

第15题：

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）

• A、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
• B、ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
• C、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
• D、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
• E、ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
• F、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

第16题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

• A、ALTER TABLE students ADD PRIMARY KEY _ id;
• B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
• C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
• D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
• E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

第17题：

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：   ALTER SESSION ENABLE RESUMABLE；   Which command could you issue to enable the resumable space allocation feature at the session level？（）  

• A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；
• B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；
• C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；
• D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；

第18题：

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.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：