摘要：
You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committin 阅读全文
摘要：
Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A.Avoid coding 阅读全文
摘要：
User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans;While the drop table operation is in progress, user 阅读全文
摘要：
User SCOTT executes the following command on the EMP table but has not issued COMMIT,ROLLBACK, or any data definition language (DDL) command:SQL> SELE 阅读全文
摘要：
You suspect unauthorized data manipulation language (DML) operations on a particular table. Youwant to track users who are performing the transactions 阅读全文
摘要：
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users:CREATE OR REPLACE PROCE 阅读全文
摘要：
Which two statements are true regarding a PL/SQL package body? (Choose two.)A.It cannot be created without a package specification.B.It cannot invoke 阅读全文
摘要：
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and f 阅读全文
摘要：
Which three statements are correct about temporary tables? (Choose three.)A.Indexes and views can be created on temporary tables.B.Both the data and t 阅读全文
摘要：
You executed this command to create a temporary table:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20 阅读全文
摘要：
What can you achieve by implementing reverse key index?A.Reverse the bytes of each column indexed including the row ID.B.Store a bitmap for each key v 阅读全文
摘要：
Which two statements are true regarding B-tree index? (Choose two.)A.The leaf blocks in the index are doubly linked.B.The leaf node stores a bitmap fo 阅读全文
摘要：
Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?A.An update in a leaf row takes pl 阅读全文
摘要：
The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table:ERROR at line 1:ORA-00060: deadlock detected 阅读全文
摘要：
View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. 阅读全文
摘要：
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable 阅读全文
摘要：
You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a lon 阅读全文