Some data storage and transfer media have fixed-length physical records.  When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data：   1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas   Which two statements can you use to load the data into the EMP table？（）

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

单选题查看答案

ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

单选题查看答案

Given： If some sort of exception is thrown at line 34， which output is possible？（）

单选题查看答案

You need to restore some files from a file system. The file system was backed up from a snapshot.  Which command will correctly restore these files？（）

单选题查看答案

In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information.  What action would you take to achieve this task（）

单选题查看答案

In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.  Whataction would you take to achieve this task（）

单选题查看答案

The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason？（）

单选题查看答案

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

单选题查看答案

As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM， you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data （you do not have advanced SAN mirroring technology available to you， unfortunately）.  Which of the following commands would create a disk group that would offer the maximum in data redundancy？（）

单选题查看答案