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.
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.
相关考题：
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > 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.
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? () A. Immediately after the SELECT clauseB. Before the WHERE clauseC. Before the FROM clauseD. After the ORDER BY clauseE. After the WHERE clause
Exhibit: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.
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?() A.B.C.D.
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?() A.B.C.D.
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.
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?() A.B.C.D.
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.
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.AB.BC.CD.DE.E
What is a sub-select statement?A．a select statement that selects a subset of fields in a tableB．a select statement that returns a subset of the data in a tableC．a select statement that appears within another select statementD．a select statement that returns a subset of the constraints on a field
Which two statements about views are true? （）A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in the SELECT statement.E、A view must have aliases defined for the column names in the SELECT statement.
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）A、MANAGER must be a role.B、It allows the MANAGER to pass the specified privileges on to other users.C、It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D、It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E、It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F、It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
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?（）A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating
Where can subqueries be used?（）A、field names in the SELECT statement B、the FROM clause in the SELECT statement C、the HAVING clause in the SELECT statementD、the GROUP BY clause in the SELECT statement E、the WHERE clause in only the SELECT statement F、the WHERE clause in SELECT as well as all DML statements
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）A、Immediately after the SELECT clauseB、Before the WHERE clauseC、Before the FROM clauseD、After the ORDER BY clauseE、After the WHERE clause
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber
单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）A The statement would not execute because table aliases are not allowed in the JOIN clause.B The statement would not execute because the table alias prefix is not used in the USING clause.C The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
单选题You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）A3，2，1，4B2，3，4，1C4，1，3，2D3，2，4，1
单选题Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 AVG(subj1) AND subj2 AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement?（）AThe 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.BThe statement returns an error at the SELECT clause.CThe statement returns an error at the WHERE clause.DThe statement returns an error at the ORDER BY clause.
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
单选题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?（）AAn error is returned.BYou are prompted to enter a new value.CA report is produced that matches the first report produced.DYou are asked whether you want a new value or if you want to run the report based on the previous value.
多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.AUpdatingBViewingCDeletingDInsertingETruncating
单选题In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? （）AImmediately after the SELECT clauseBBefore the WHERE clauseCBefore the FROM clauseDAfter the ORDER BY clauseEAfter the WHERE clause
单选题EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）A Exhibit AB Exhibit BC The query returns no rowsD The query fails because the outer query is retrieving more than one columnE The query fails because both the inner and outer queries are retrieving data from the same table.
多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.FIt allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
单选题Examine the statement： DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）A AB BC CD D