black

1Z0-053

单项选择题

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.

相关考题

多项选择题 You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

单项选择题 You have applications that have frequently executed queries， and produce small and static result sets.  You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.  What is the purpose of this configuration？（）

单项选择题 Evaluate the following code：   SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers  WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’；  DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，  ：task_name， ：sql_stmt）；  END；   What is the outcome of this block of code？（）

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064