单选题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 remain disabled and has to be enabled manually using the ALTER TABLE command.D It 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 remain disabled and has to be enabled manually using the ALTER TABLE command.
D
It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
参考解析
解析：
暂无解析
相关考题：
Evaluate the following statements:What are the two consequences of the above statements?() A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? () A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
A customer would like to share the processor resources automatically between logical partitions. Which of the following would accomplish this requirement without user interaction？ （）A、 Dynamic LPARsB、 On/Off Capacity on DemandC、 Uncapped Micro-PartitioningD、 Enterprise Workload Manager
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A、 It would be created only if a unique index is manually created first.B、 It would be created and would use an automatically created unique index.C、 It would be created and would use an automatically created nonunique index.D、 It would be created and remains in a disabled state because no index is specified in the command.
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(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 above SQL statement? （）A、SER_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、composite index on ORDER_ID and ORDER_DATE
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/x7frelated problem？ （）A、functionB、packageC、procedureD、database triggerE、anonymous PL/SQL block
You work as a database administrator for Supportcenter.cn. 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
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.
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.
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
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
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
单选题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？（）AThe instance would normally abort.BThe instance would not be affected.CThe instance would be invalid， so would have to be aborted.DThe instance would remain open， but the LGWR process would fail.EThe instance would remain open and would automatically create the missing file
单选题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 remain disabled and has to be enabled manually using the ALTER TABLE command.D It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
单选题Which of the following statements is true according to the text?AWashington would not appreciate the idea of overthrowing social order.BRacial separation is an outcome of accommodationist ideology.CWashington would not support determined activist leadership.DThe Philadelphia Negro is a book on blacks in American South.
单选题Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A It would be created only if a unique index is manually created first.B It would be created and would use an automatically created unique index.C It would be created and would use an automatically created nonunique index.D It would be created and remains in a disabled state because no index is specified in the command.
单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）A The statement would not execute because table aliases are not allowed in the JOIN clause.B The statement would not execute because the table alias prefix is not used in the USING clause.C The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
单选题Which of the following options would best help to reduce packet fragmentation for a TCP application transferring large amounts of data between servers across a path of multiple networks？（）A Adjust Path MTU attributes， using the no command.B Adjust the status queue size on the adapters， using the chdev command.C Adjust ipforwarding to enabled， using the no command.D Adjust tcp_maxburst to enabled， using the no command.
多选题Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(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 above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE
单选题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？（）AThe database would open normally.BThe database would not open， and it would stop at mount stage.CThe database would open after automatically performing instance recovery.DThe database would not open， and you have to perform database recovery to open it.
单选题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/x7frelated problem？ （）AfunctionBpackageCprocedureDdatabase triggerEanonymous PL/SQL block
多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
单选题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.
单选题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
单选题A customer would like to share the processor resources automatically between logical partitions. Which of the following would accomplish this requirement without user interaction？ （）A Dynamic LPARsB On/Off Capacity on DemandC Uncapped Micro-PartitioningD Enterprise Workload Manager
多选题Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(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 above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A16 B100 C160 D200 E150