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?()
第1题:
A.
B.
C.
D.
第2题:
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?()
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
第3题:
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
第4题:
What is a sub-select statement?
A.a select statement that selects a subset of fields in a table
B.a select statement that returns a subset of the data in a table
C.a select statement that appears within another select statement
D.a select statement that returns a subset of the constraints on a field
第5题:
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?()
第6题:
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().
第7题:
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?()
第8题:
The statement would not execute because table aliases are not allowed in the JOIN clause.
The statement would not execute because the table alias prefix is not used in the USING clause.
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
第9题:
The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
The statement returns an error at the SELECT clause.
The statement returns an error at the WHERE clause.
The statement returns an error at the ORDER BY clause.
第10题:
An error is returned.
You are prompted to enter a new value.
A report is produced that matches the first report produced.
You are asked whether you want a new value or if you want to run the report based on the previous value.
第11题:
Immediately after the SELECT clause
Before the WHERE clause
Before the FROM clause
After the ORDER BY clause
After the WHERE clause
第12题:
MANAGER must be a role.
It allows the MANAGER to pass the specified privileges on to other users.
It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
第13题:
A.
B.
C.
D.
第14题:
A.
B.
C.
D.
第15题:
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?()
A.A
B.B
C.C
D.D
E.E
第16题:
Which two statements about views are true? ()
第17题:
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()
第18题:
Where can subqueries be used?()
第19题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第20题:
3,2,1,4
2,3,4,1
4,1,3,2
3,2,4,1
第21题:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.
第22题:
Updating
Viewing
Deleting
Inserting
Truncating
第23题:
Exhibit A
Exhibit B
The query returns no rows
The query fails because the outer query is retrieving more than one column
The query fails because both the inner and outer queries are retrieving data from the same table.
第24题:
A
B
C
D