单选题View the following SQL statements：   Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；  Transaction T3 UPDATE hr.regions SET region_name=’North and Sou

题目
单选题
View the following SQL statements：   Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；  Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5；   You want to back out transaction T2.  Which option would you use？（）
A

 It is possible，but transaction T3 also backs out.

B

 It is possible with the NOCASCADE_FORCE option.

C

 It is possible with the NONCONFLICT_ONLY option.

D

 It is not possible because it has conflicts with transaction T3.

相似考题

1.Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

2.Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3

3.Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;（）A.3B.2C.1D.0

4.View the following SQL statements:You want to back out transaction T2. Which option would you use?()A. It is possible, but transaction T3 also backs out.B. It is possible with the NOCASCADE_FORCE option.C. It is possible with the NONCONFLICT_ONLY option.D. It is not possible because it has conflicts with transaction T3.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“View the following SQL statements：   Transaction T1 INSERT I”相关问题

  • 第1题：

    Given the following two tables:TAB1 C1 C21 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY5 Europe 6 North America 7 South AmericaWhich of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）

    A.INSERT INTO tab1 SELECT cx, cy FROM tab2

    B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

    C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)

    D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)


    参考答案：A

  • 第2题：

    Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1

    • A、1, 2, 3, 3
    • B、1, 2, 2, 4
    • C、1, 2, 3, 3, 6
    • D、1, 2, 2, 5, 6

    正确答案:A

  • 第3题：

    At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

    • A、 William used the Flashback Version Query feature.
    • B、 William issued the CROSSCHECK command at the RMAN prompt.
    • C、 William viewed the alert log file.
    • D、 William used the Flashback Table feature.

    正确答案:A

  • 第4题：

    Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

    • A、INSERT 
    • B、SELECT 
    • C、UPDATE 
    • D、DELETE

    正确答案:B

  • 第5题：

    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）

    • A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.
    • B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.
    • C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.
    • D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

    正确答案:A,C

  • 第6题：

    单选题
    Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1
    A

    1, 2, 3, 3

    B

    1, 2, 2, 4

    C

    1, 2, 3, 3, 6

    D

    1, 2, 2, 5, 6


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

  • 第7题：

    多选题
    Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
    A

    You can find information about only active transactions from the view

    B

    You can find information about read only transactions from the view

    C

    You require the SELECT ANY TRANSACTION system privilege to access the view

    D

    You can find information about both active and committed transactions from the view

    E

    You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view


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

  • 第8题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
    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.


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

  • 第9题：

    单选题
    Which of the following will begin a new unit of work?（）
    A

    The CONNECT statement

    B

    The first FETCH of a cursor

    C

    The BEGIN TRANSACTION statement

    D

    The first executable SQL statement


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

  • 第10题：

    单选题
    Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）
    A

     point-in-time recovery

    B

     execute the ROLLBACK command with transaction number

    C

     flashback the database to before the transaction was committed

    D

     determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery


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

  • 第11题：

    单选题
    A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）
    A

    When view V1 is created

    B

    Each time the REFRESH VIEW v1 statement is executed

    C

    Each time an SQL statement is executed against view V1

    D

    Only the first time an SQL statement is executed against view V1


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

  • 第12题：

    单选题
    View the following SQL statements：   Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；  Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5；   You want to back out transaction T2.  Which option would you use？（）
    A

     It is possible，but transaction T3 also backs out.

    B

     It is possible with the NOCASCADE_FORCE option.

    C

     It is possible with the NONCONFLICT_ONLY option.

    D

     It is not possible because it has conflicts with transaction T3.


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

  • 第13题：

    Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）

    • A、The database manager will rollback the transaction in both applications.
    • B、The database manager will rollback the transaction in one of the two applications.
    • C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
    • D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

    正确答案:B

  • 第14题：

    Which of the following will begin a new unit of work?（）

    • A、The CONNECT statement
    • B、The first FETCH of a cursor
    • C、The BEGIN TRANSACTION statement
    • D、The first executable SQL statement

    正确答案:D

  • 第15题：

    Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）

    • A、point-in-time recovery
    • B、execute the ROLLBACK command with transaction number
    • C、flashback the database to before the transaction was committed
    • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

    正确答案:D

  • 第16题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

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

    正确答案:A,B,C

  • 第17题：

    A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）

    • A、 Ensure that all statements execute in the same database transaction.
    • B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.
    • C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.
    • D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.

    正确答案:A

  • 第18题：

    单选题
    A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）
    A

     Ensure that all statements execute in the same database transaction.

    B

     Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.

    C

     Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.

    D

     Open a new connection to the database. Use a separate transaction scope to roll back the original operation.


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

  • 第19题：

    单选题
    You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
    A

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

    B

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

    C

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

    D

    One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

    E

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.


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

  • 第20题：

    单选题
    Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）
    A

    0

    B

    1

    C

    2

    D

    3


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

  • 第21题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    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.


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

  • 第22题：

    单选题
    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）
    A

     The statement will fail.

    B

     The statement will be executed successfully， and the new time zone will be set for the database.

    C

     The statement will be executed successfully， but the new time zone will be set for the current session.

    D

    The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.


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

  • 第23题：

    多选题
    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）
    A

    In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.

    B

    In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.

    C

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.

    D

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.


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

  • 第24题：

    单选题
    A user named Arren is executing this query：   select table_name，operation，undo_sql  from  flashback_transaction_query t，  （select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123） e  where t.xid = e.xid；   When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem.  Which of the following SQL statements will correct this problem？（）
    A

     GRANT SELECT ANY TRANSACTION TO ARREN

    B

     GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN

    C

     GRANT SELECT_ANY_TRANSACTION TO ARREN

    D

     GRANT FLASHBACK TO ARREN

    E

     GRANT SELECT ANY VIEW TO ARREN


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

相关内容