摘要：
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 阅读全文