单选题Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）AIt would be automatically enabled and deferred.BIt would be automatically enabled and immediate.CIt would remain disable

题目

单选题

Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）

It would be automatically enabled and deferred.

It would be automatically enabled and immediate.

It would remain disabled and has to be enabled manually using the ALTER TABLE command.

It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

参考答案和解析

正确答案： C

解析：暂无解析

更多“单选题Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）A It would be automatically enabled and deferred.B It would be automatically enabled and immediate.C It would remai”相关问题

第1题

You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backup after seven days？（）A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.

点击查看答案
第2题

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A、The database would open normally.B、The database would not open， and it would stop at mount stage.C、The database would open after automatically performing instance recovery.D、The database would not open， and you have to perform database recovery to open it.

点击查看答案
第3题

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）A、SER_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、Composite index on ORDER_ID and ORDER_DATE

点击查看答案
第4题

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）A、 functionsB、 packageC、 procedureD、 database triggerE、 anonymous PL/SQL block

点击查看答案
第5题

Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A、16 B、100 C、160 D、200 E、150

点击查看答案
第6题

单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A The instance would normally abort.B The instance would not be affected.C The instance would be invalid， so would have to be aborted.D The instance would remain open， but the LGWR process would fail.E The instance would remain open and would automatically create the missing file

点击查看答案
第7题

单选题Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）AIt would be automatically enabled and deferred.BIt would be automatically enabled and immediate.CIt would remain disabled and has to be enabled manually using the ALTER TABLE command.DIt would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

点击查看答案

单选题Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）A It would be automatically enabled and deferred.B It would be automatically enabled and immediate.C It would remai

题目

参考答案和解析

更多“单选题Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）A It would be automatically enabled and deferred.B It would be automatically enabled and immediate.C It would remai”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容