单选题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？（）
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.

相似考题

1.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.

2. 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

3. 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.

4.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

更多“单选题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题：

    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_NO
    • B、ORDER_ID
    • C、STATUS
    • D、PROD_ID
    • E、ORD_TOTAL
    • F、composite index on ORDER_ID and ORDER_DATE

    正确答案:A,F

  • 第2题：

    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

    正确答案:B

  • 第3题：

    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.

    正确答案:C

  • 第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、 functions
    • B、 package
    • C、 procedure
    • D、 database trigger
    • E、 anonymous PL/SQL block

    正确答案:D

  • 第5题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

  • 第6题：

    单选题
    Which of the following statements is true according to the text?
    A

    Washington would not appreciate the idea of overthrowing social order.

    B

    Racial separation is an outcome of accommodationist ideology.

    C

    Washington would not support determined activist leadership.

    D

    The Philadelphia Negro is a book on blacks in American South.


    正确答案： A
    解析：
    推理判断题。由最后一段第二句“The major difference…Washington sought change that was evolutionary in nature and did not upset the social order…”可知，华盛顿追求本质上逐步发展的变化，不会扰乱社会秩序，即他不赞同推翻社会秩序，故选A；根据最后一段第一句“As a leader in education,…not only the tradition of racial segregation in the schools but also the accommodationist ideology of Booker T. Washington.”可知，杜·渡依斯对华盛顿的调和主义思想提出了挑战，故选项B错误；选项C在文中没有提及；The Philadelphia Negro是研究费城黑人的书，故D选项错误，所以答案为A项。

  • 第7题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    多选题
    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_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


    正确答案： A,F
    解析： 暂无解析

  • 第9题：

    单选题
    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

    function

    B

    package

    C

    procedure

    D

    database trigger

    E

    anonymous PL/SQL block


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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 LPARs

    B

     On/Off Capacity on Demand

    C

     Uncapped Micro-Partitioning

    D

     Enterprise Workload Manager


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    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_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


    正确答案： C,F
    解析： 暂无解析

  • 第13题：

    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、function
    • B、package
    • C、procedure
    • D、database trigger
    • E、anonymous PL/SQL block

    正确答案:D

  • 第14题：

    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.

    正确答案:B

  • 第15题：

    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_NO
    • B、ORDER_ID
    • C、STATUS
    • D、PROD_ID
    • E、ORD_TOTAL
    • F、Composite index on ORDER_ID and ORDER_DATE

    正确答案:A,F

  • 第16题：

    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

    正确答案:C

  • 第17题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    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_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


    正确答案： C,F
    解析： 暂无解析

  • 第22题：

    单选题
    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

     functions

    B

     package

    C

     procedure

    D

     database trigger

    E

     anonymous PL/SQL block


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    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_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


    正确答案： F,C
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

相关内容