最新的Oracle Database: SQL Fundamentals I - 1Z1-051免費考試真題

A. It shows the names of all products in the table

B. It produces an error

C. It shows the names of products whose list price is the second highest in the table.

D. It shown the names of all products whose list price is less than the maximum list price

A. SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing') FROM programs;

B. SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs;

C. SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;

D. SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),'Ongoing') FROM programs;

A. SELECT

B. RENAME

C. UPDATE

D. INSERT

E. DELETE

F. DESCRIBE

A. It returns the highest NOT NULL value in the list for all rows.

B. It can have a maximum of five expressions in a list.

C. It requires that all expressions in the list must be of the same data type.

D. It requires that at least one of the expressions in the list must have a NOT NULL value.

A. The set of statements contains an error and does not work.

B. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

C. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.

D. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

E. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.

F. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

A. It gives the details of promos for which there have been no sales

B. It gives details of product IDs that have been sold irrespective of whether they had a promo or not

C. It gives the details of promos for which there have been sales

D. It gives details of all promos irrespective of whether they have resulted in a sale or not

A. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

B. A subquery can be used only in SQL query statements.

C. Only two subqueries can be placed at one level.

D. A subquery can retrieve zero or more rows.

E. A subquery can appear on either side of a comparison operator.

A. Complex views can be created only on multiple tables that exist in the same schema.

B. Views can be created from tables or other views.

C. Views can be created only from tables.

D. Complex views can be created on multiple tables that exist in the same or different schemas.

E. Only simple views can use indexes existing on the underlying tables.

F. Both simple and complex views can use indexes existing on the underlying tables.

A. Synonyms can be created only for a table

B. A public synonym and a private synonym can exist with the same name for the same table

C. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid

D. Synonyms are used to reference only those tables that are owned by another user

A. It executes successfully but does not give the correct output.

B. It gives an error because the GROUP BY expression is not valid.

C. It executes successfully and gives the correct output.

D. It gives an error because the HAVING clause is not valid.

A. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement

B. It would execute and restrict modifications to only the column specified in the SELECT statement

C. It would not execute because two tables cannot be used in a single UPDATE statement

D. It would not execute because the SELECT statement cannot be used in place of the table name

A. Both queries execute successfully but give different results.

B. Only the first query executes successfully.

C. Both queries execute successfully and give the same result.

D. Only the second query executes successfully.

A. SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

B. SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

C. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

D. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

E. SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

A. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL;

B. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year') FROM DUAL;

C. SELECT TO_DATE(TO_CHAR('11-oct-2007','fmDdspth ''of'' Month, Year')) FROM DUAL;

D. SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year') FROM DUAL;

A. Names of all columns must be identical across all SELECT statements

B. NULL values are not ignored during duplicate checking

C. By default, the output is not sorted

D. The number of columns selected in all SELECT statements need to be the same