多项选择题

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.

相关考题

单项选择题 View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr;  Which statement describes the outcome of the command()

单项选择题 Observe the information in the columns:  1: The SGA     a. Text and parsed forms of all SQL statements  2: The cursor state   b. Run-time memory values for the SQL statement, such as rows retrieved  3: User-session data   c. Security and resource usage information  4:The stack space   d. Local variables for the process  Which option has the correct match between the memory areas and their contents()

单项选择题 You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database:  1:SGA is allocated.  2:Control file is read.  3:Redo log files are read.  4:Instance recovery is started.  5:Background processes are started.  6:Data files are checked for consistency.  7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()