单选题Evaluate this SQL statement: What will happen if you remove all the parentheses from the calculation?（）AThe value displayed in the CALC_VALUE column will be lower.BThe value displayed in the CALC_VALUE column will be higher.CThere will be no differenc

第1题：

第2题：

第3题：

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); What 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 at 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.

第4题：

Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）

• A、0
• B、1
• C、0.00
• D、An error statement

第5题：

Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）

• A、17000.00
• B、17000*****
• C、****170.00
• D、**17000.00
• E、an error statement

第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题：

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

• A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
• B、Define the new column as NOT NULL with a default value of ’Undefined.’
• C、Define the new column as NULL. Use application logic to enforce the data constraint.
• D、Define the new column as NULL with a default value of ’Undefined.’

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

• A、A check constraint on the EMPLOYEE table
• B、A unique constraint on the EMPLOYEE table WORKDEPT column
• C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
• D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

第15题：

Evaluate this SQL statement: e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation?（）

• A、The value displayed in the CALC_VALUE column will be lower.
• B、The value displayed in the CALC_VALUE column will be higher.
• C、There will be no difference in the value displayed in the CALC_VALUE column.
• D、An error will be reported.

第16题：

Which two statements about sequences are true? （）

• A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
• B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
• C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
• D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
• E、If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
• F、You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

第17题：

Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  

• A、 It executes successfully but partition pruning cannot happen for this partition key.
• B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
• C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
• D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

第18题：

You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）

• A、Removing column from the available list in the report wizard. 
• B、Removing the column from the displayed list in the report wizard. 
• C、Changing the display width of a column in the report wizard. 
• D、Adding a column to both the available list and displayed list in the report wizard. 
• E、Removing a column in the live previewer. 

第19题：

第20题：

第21题：

第22题：

第23题：