单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does th

第1题：

第2题：

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

• A、MERGE
• B、INSERT
• C、UPDATE
• D、ADD
• E、ENTER
• F、You cannot enter the phone numbers for the existing employee records.

第3题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第4题：

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

• A、MERGE
• B、INSERT
• C、UPDATE
• D、ADD
• E、ENTER
• F、You cannot enter the phone numbers for the existing employee records.

第5题：

Which two statements are true regarding the USING and ON clauses in table joins?（）

• A、Both USING and ON clauses can be used for equijoins and nonequijoins 
• B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
• C、The ON clause can be used to join tables on columns that have different names but compatible data types 
• D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

第6题：

The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）

• A、Column definitions cannot be altered to add DEFAULT values.
• B、A change to the DEFAULT value affects only subsequent insertions to the table.
• C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
• D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two statements are true regarding the USING clause in table joins?（）

• A、It can be used to join a maximum of three tables 
• B、It can be used to restrict the number of columns used in a NATURAL join 
• C、It can be used to access data from tables through equijoins as well as nonequijoins 
• D、It can be used to join tables that have columns with the same name and compatible data types

第14题：

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

• A、 Drop the table.
• B、 Partition the table.
• C、 Truncate the table.
• D、 Add a column to the table.
• E、 Rename a column in the table.

第15题：

You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

• A、Restart the database instance and run the job
• B、Truncate the Certkiller STAFF table and run the job
• C、Delete all rows from the Certkiller STAFF table and run the job
• D、Increase the size of the USERStablespacethe and run the job
• E、Increase the size of the database default permanenttablespaceand run the job

第16题：

You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

• A、 column sizes
• B、 column data types
• C、 PCTFREE
• D、 projected number of row
• E、 PCTUSED

第17题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第18题：

You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）

• A、Ensure that the child column and the parent column have the same names.
• B、Ensure that the child table and the parent table have the same names.
• C、Ensure that the child column and the parent column have the same data types.
• D、Ensure that each row in the child table has a corresponding row in the parent table.
• E、Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：