An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command：   SQL>CREATE INDEX ord_custname_ix ON orders（custname）；   The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.  Which is the most efficient method of performing this task？（）

You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

单选题查看答案

Which two operations can be performed on an external table（）

多选题查看答案

The table contains a million rows for zonewise analysis in the DSS system. DML operations areperformed very rarely on the table. You decide to prepare an index on the ZONE column to enhance theperformance of the queries on the ZONE column.  Which type of index would you select in this scenario（）

单选题查看答案

EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table？（）

单选题查看答案

You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the  Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table.  How does this change affect the index？（）

单选题查看答案

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

单选题查看答案

You issue this SQL command to perform an online backup of the USER_DATA tablespace：ALTER TABLESPACE user_data BEGIN BACKUP；Next， you issue an operating system command to back up user_data01.dbf， the file that belongs to the USER_DATA tablespace. You then experience an instance failure.  Which three statements are true？（）

多选题查看答案

Given： Which code， inserted at line 15， creates an instance of the Point class defined in Line？（）

单选题查看答案

Given：  Which code， inserted at line 15， creates an instance of the Point class defined in Line？（）

单选题查看答案

Given： If an instance of class Beagle is created，then Serialized，then deSerialized， what is the result？（）

单选题查看答案