单选题EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table? ()AABBCCDD

题目
单选题
EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table? ()
A

A

B

B

C

C

D

D


相似考题
参考答案和解析
正确答案: C
解析: 暂无解析
更多“单选题EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table? ()A AB BC CD D”相关问题
  • 第1题:

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

    A.Table

    B.Columns

    C.Table and Alias

    D.Columns and Alias


    参考答案:A

  • 第2题:

    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()

    • A、MERGE
    • B、SELECT …CROSS JOIN
    • C、INSERT ALL …SELECT
    • D、CREATE VIEW …CONSTRAINT

    正确答案:A

  • 第3题:

    Which two operations can be performed on an external table()

    • A、Create a view on the table.
    • B、Create an index on the table.
    • C、Create a synonym on the table.
    • D、Add a virtual column to the table.
    • E、Update the table using the UPDATE statement.
    • F、Delete rows in the table using the DELETE command.

    正确答案:A,C

  • 第4题:

    User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session()

    • A、LOCK TABLE emp IN SHARE MODE;
    • B、LOCK TABLE emp IN EXCLUSIVE MODE;
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER;
    • D、INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

    正确答案:A,B,E

  • 第5题:

    Which two operations can be performed on an external table()

    • A、Create a view on the table.
    • B、Create an index on the table.
    • C、Create a synonym on the table.
    • D、Add a virtual column to the table.
    • E、Update the table using the UPDATE statement.
    • F、Delete rows in the table using the DELETE command

    正确答案:A,C

  • 第6题:

    单选题
    You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table,you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:  a) No other user data in the database is affected.  b) The operation takes the minimum possible time.  Which option would you choose?()
    A

    use the ROLLBACK command with SCN 663571

    B

    perform Flashback Transaction Query with SCN 663571

    C

    execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    D

    execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


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

  • 第7题:

    单选题
    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()
    A

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


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

  • 第8题:

    单选题
    You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()
    A

    The rows stay in the table only until session termination.

    B

    The rows stay in the table only until the next transaction starts on the table.

    C

    The rows are visible to all current sessions after the transaction is committed.

    D

    The rows stay available for subsequent sessions after the transaction is committed


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

  • 第9题:

    多选题
    Which two operations can be performed on an external table()
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command


    正确答案: E,F
    解析: 暂无解析

  • 第10题:

    单选题
    You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()
    A

    Immediately following statement execution 

    B

    After the ALTER TABLE DROP UNUSED COLUMNS command is issued 

    C

    After the ALTER TABLE SET UNUSED COLUMN command is issued 

    D

    After the ALTER TABLE MODIFY command is issued


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

  • 第11题:

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command:  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()
    A

    LOCK TABLE emp IN SHARE MODE;

    B

    LOCK TABLE emp IN EXCLUSIVE MODE;

    C

    DELETE FROM emp WHERE job=’MANAGER’;

    D

    INSERT INTO emp(empno,ename) VALUES (1289,’Dick’);

    E

    SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;


    正确答案: E,C
    解析: 暂无解析

  • 第12题:

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session()
    A

    LOCK TABLE emp IN SHARE MODE;

    B

    LOCK TABLE emp IN EXCLUSIVE MODE;

    C

    UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?

    D

    INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);

    E

    SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno


    正确答案: A,D
    解析: 暂无解析

  • 第13题:

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

    • A、Table
    • B、Columns
    • C、Table and Alias
    • D、Columns and Alias

    正确答案:A

  • 第14题:

    You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()

    • A、Immediately following statement execution 
    • B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
    • C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
    • D、After the ALTER TABLE MODIFY command is issued

    正确答案:B

  • 第15题:

    User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to?()

    • A、null lock on the row being updated
    • B、null lock on the table containing the row
    • C、ROW SHARE lock for the row being updated
    • D、ROW EXCLUSIVE lock for the row being updated
    • E、shared row-exclusive lock for the row being updated
    • F、a shareable table lock for the table containing the row
    • G、exclusive table-level lock for the table containing the row

    正确答案:D,F

  • 第16题:

    User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session()

    • A、LOCK TABLE emp IN SHARE MODE;
    • B、LOCK TABLE emp IN EXCLUSIVE MODE;
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?
    • D、INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

    正确答案:A,B,E

  • 第17题:

    User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command:  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()

    • A、LOCK TABLE emp IN SHARE MODE;
    • B、LOCK TABLE emp IN EXCLUSIVE MODE;
    • C、DELETE FROM emp WHERE job=’MANAGER’;
    • D、INSERT INTO emp(empno,ename) VALUES (1289,’Dick’);
    • E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

    正确答案:A,B,E

  • 第18题:

    单选题
    When building the job stream MASTER#NEW_STREAM in the composer  command line, which option should be used to apply the settings in the  Variable Table "LIVE_VARS" to be associated to the  jobs in the job stream?()
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第19题:

    多选题
    User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to?()
    A

    null lock on the row being updated

    B

    null lock on the table containing the row

    C

    ROW SHARE lock for the row being updated

    D

    ROW EXCLUSIVE lock for the row being updated

    E

    shared row-exclusive lock for the row being updated

    F

    a shareable table lock for the table containing the row

    G

    exclusive table-level lock for the table containing the row


    正确答案: B,A
    解析: 暂无解析

  • 第20题:

    多选题
    Which two operations can be performed on an external table()
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command.


    正确答案: F,B
    解析: 暂无解析

  • 第21题:

    单选题
    You must configure a SCREEN option that would protect your device from a session table flood.Which configuration meets this requirement?()
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第22题:

    单选题
    Which command will save the current active configuration as the rescue configuration?()
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第23题:

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session()
    A

    LOCK TABLE emp IN SHARE MODE;

    B

    LOCK TABLE emp IN EXCLUSIVE MODE;

    C

    UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER;

    D

    INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);

    E

    SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;


    正确答案: B,C
    解析: 暂无解析