Online Access Free 1z0-071 Exam Questions

Examine this statement:
SELECT last name
FROM employees
ORDER BY CASE WHEN salary = (SELECT MAX(salary) FROM employees)
THEN 'A'
ELSE last_ name
END ,last_name DESC;
Which two statements are true?

• A.The names of employees earning the maximum salary will appear first in an unspecified order.
• B.All remaining employee names will appear in ascending order.
• C.The names of employees earning the maximum salary will appear first in descending order.
• D.All remaining employee names will appear in descending order.
• E.All remaining employee names will appear in an unspecified order.
• F.The names of employees earning the maximum salary will appear first In ascending order.

SELECT *
FROM bricks,colors;
Which two statements are true?

• A.You can add an ON clause with a join condition.
• B.You can add a WHERE clause with filtering criteria.
• C.It returns the number of rows in BRICKS plus the number of rows in COLORS.
• D.You can add a USING clause with a join condition.
• E.It returnsthe same rows as SELECT * FROM bricks CROSS JOIN colors.

In the PROMOTIONS table, the PROMO_BEGTN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?

• A.TO_DATE(PROMO_BEGIN_DATE * 5) will return a date
• B.PROMO_BEGIN_DATE-SYSDATE will return a number.
• C.TO_NUMBER(PROMO_BEGIN_DATE)-5 will return number
• D.PROMO_BEGIN_DATE-SYSDATE will return an error.
• E.PROMO_BEGIN_DATE-5 will return a date.

Examine this query:
SELECT employee_id,first_name,salary
FROM employees
WHERE hire_date>'&1';
Which two methods should you use to prevent prompting for a hire date value when this query is executed?

• A.Replace'&1' with'&&1' in the query.
• B.Execute the SET VERIFY OFF command before executing the query.
• C.Use the DEFINE command before executing the query.
• D.Execute the SET VERIFY ON command before executing the query.
• E.Store the query in a script and pass the substitution value to the script when executing it.
• F.Use the UNDEFINE command before executing the query.

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

• A.A table can have only one primary key and one foreign key.
• B.Primary key and foreign key constraints can be defined at both the column and table level.
• C.Only the primary key can be defined the column and table level.
• D.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.
• E.A table can have only one primary key but multiple foreign keys.
• F.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.
• G.The foreign key columns and parent table primary key columns must have the same names.