Oracle认证最新试题
（单选题）
Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）
（多选题）
Which four are valid Oracle constraint types? （）
（单选题）
Given: What is the result？（）
（单选题）
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
（单选题）
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
（单选题）
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
（单选题）
NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracle‟s order of precedence: （） a. Default setting b. Client environment variable c. Explicit ALTER SESSION statement d. Inside SQL function e. Server initialization parameter
（单选题）
What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?（）
（单选题）
Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）
（单选题）
The EMPLOYEE tables has these columns: You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）
（多选题）
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）
（单选题）
You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）
（单选题）
Which view provides information on the backup status of the datafiles in the database？（）
（单选题）
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）
（单选题）
Given: Which code, inserted at line 4, guarantees that this program will output [1, 2]（）?
（多选题）
Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?（）
（多选题）
View the Exhibit1， which shows the options that are selected to create the user SL_REP. View the Exhibit2 andexamine the contents of DATABASE_PROPERTIES. Which two statements are true regarding this 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> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）
（单选题）
View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCEroles and no individual system privileges. The SL_REP user executes this command to create a table:SQL> CREATE TABLE orders(oid number(6), odate date, ccode number(4), oamt number(10,2))TABLESPACE purchase_space; The PURCHASE_SPACE tablespace already exists in the database. Which statement describes the effect ofthe command（）
（单选题）
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）
