Examine this statement:SELECT student_...

单项选择题Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）

A. An error is returned.
B. You are prompted to enter a new value.
C. A report is produced that matches the first report produced.
D. You are asked whether you want a new value or if you want to run the report based on the previous value.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 Examine the structure of the EMPLOYEES table:

What is the correct syntax for an inline view?（）

A.
B.
C.
D.

点击查看答案

2.多项选择题In which four clauses can a subquery be used?（）

A. in the INTO clause of an INSERT statement
B. in the FROM clause of a SELECT statement
C. in the GROUP BY clause of a SELECT statement
D. in the WHERE clause of a SELECT statement
E. in the SET clause of an UPDATE statement
F. in the VALUES clause of an INSERT statement

点击查看答案

3.单项选择题 The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?（）

A. SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;
B. SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
C. SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;
D. SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;
E. SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;

点击查看答案

4.单项选择题What is true of using group functions on columns that contain NULL values?（）

A. Group functions on columns ignore NULL values.
B. Group functions on columns returning dates include NULL values.
C. Group functions on columns returning numbers include NULL values.
D. Group functions on columns cannot be accurately used on columns that contain NULL values.
E. Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.

点击查看答案

5.多项选择题 Examine the SQL statement that creates ORDERS table:
CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(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 above SQL statement? （）

A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. composite index on ORDER_ID and ORDER_DATE

点击查看答案

6.单项选择题Which object privileges can be granted on a view?（）

A. none
B. DELETE, INSERT,SELECT
C. ALTER, DELETE, INSERT, SELECT
D. DELETE, INSERT, SELECT, UPDATE

点击查看答案

7.单项选择题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

A. SELECT ename, salary*12 ‘Annual Salary’   FROM employees;
B. SELECT ename, salary*12 “Annual Salary”   FROM employees;
C. SELECT ename, salary*12 AS Annual Salary   FROM employees;
D. SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)   FROM employees

点击查看答案

8.单项选择题What is true about sequences?（）

A. Once created, a sequence belongs to a specific schema.
B. Once created, a sequence is linked to a specific table.
C. Once created, a sequence is automatically available to all users.
D. Only the DBA can control which sequence is used by a certain table.
E. Once created, a sequence is automatically used in all INSERT and UPDATE statements.

点击查看答案

9.单项选择题In which scenario would index be most useful?（）

A. The indexed column is declared as NOT NULL.
B. The indexed columns are used in the FROM clause.
C. The indexed columns are part of an expression.
D. The indexed column contains a wide range of values.

点击查看答案

10.单项选择题 The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%'ESCAPE'\';
B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'\';
D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';

点击查看答案