Online Access Free 1z0-061 Exam Questions

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.

Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category || to_char(promo_cost)"code"
FROM promotions
ORDER BY code;
SQL>SELECT DISTINCT promo_category || promo_cost "code"
FROM promotions
ORDER BY 1;
Which statement is true regarding the execution of the above queries?

• A.Only the first query executes successfully.
• B.Only the second query executes successfully.
• C.Both queries execute successfully and give the same result.
• D.Both queries execute successfully but give different results.

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

• A.&
• B.&&
• C.PROMPT
• D.ACCEPT

Which two statements are true regarding subqueries?

• A.There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.
• B.Only two subqueries can be placed at one level.
• C.A subquery can be used only in SQL query statements.
• D.A subquery can retrieve zero or more rows.
• E.A subquery can appear on either side of a comparison operator.

Which two statements about sub queries are true? (Choose two.)

• A.A sub query CANNOT be used in an SQL query statement that uses group functions.
• B.When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.
• C.A sub query should retrieve only one row.
• D.Sub queries CANNOT be nested by more than two levels.
• E.A sub query can be used only in SQL query statements.
• F.A sub query can retrieve zero or more rows.

You need to design a student registration database that contains several tables storing academic information.
The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.
You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?

• A.CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));
• B.CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));
• C.CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));
• D.CREATE TABLE student_grades (student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY students(student_id));