网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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
考题
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.
考题
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
考题
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
考题
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 tab2B.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)
考题
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.
考题
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 i1A、1, 2, 3, 3B、1, 2, 2, 4C、1, 2, 3, 3, 6D、1, 2, 2, 5, 6
考题
Which of the following will begin a new unit of work?（）A、The CONNECT statementB、The first FETCH of a cursorC、The BEGIN TRANSACTION statementD、The first executable SQL statement
考题
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.
考题
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
考题
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
考题
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 checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
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 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.
考题
单选题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 i1A
1, 2, 3, 3B
1, 2, 2, 4C
1, 2, 3, 3, 6D
1, 2, 2, 5, 6
考题
单选题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.
考题
多选题Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）AYou can find information about only active transactions from the viewBYou can find information about read only transactions from the viewCYou require the SELECT ANY TRANSACTION system privilege to access the viewDYou can find information about both active and committed transactions from the viewEYou require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view
考题
单选题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.
考题
多选题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（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL *Loader.DNew data conforms to the constraint， but existing data is not checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题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
考题
单选题Which of the following will begin a new unit of work?（）A
The CONNECT statementB
The first FETCH of a cursorC
The BEGIN TRANSACTION statementD
The first executable SQL statement
考题
多选题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（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题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
考题
单选题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 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 createdB
Each time the REFRESH VIEW v1 statement is executedC
Each time an SQL statement is executed against view V1D
Only the first time an SQL statement is executed against view V1
考题
多选题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？（）AIn SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.BIn SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.CIn 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.DIn 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.
考题
单选题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.
考题
单选题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 ARRENB
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC
GRANT SELECT_ANY_TRANSACTION TO ARREND
GRANT FLASHBACK TO ARRENE
GRANT SELECT ANY VIEW TO ARREN
热门标签
最新试卷
