Online Access Free 1Z0-051 Exam Questions

Examine the structure proposed for the TRANSACTIONS table:

Which statements are true regarding the creation and storage of data in the above table structure? (Choose all that apply.)

• A.The TRANS_VALIDITY column would give an error.
• B.The CUST_STATUS column would store exactly one character.
• C.The TRANS_VALIDITY column would have a maximum size of one character.
• D.The CUST_STATUS column would give an error.
• E.The CUST_CREDIT_LIMIT column would not be able to store decimal values.
• F.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.

The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2)
Evaluate this SQL statement: SELECT *
FROM PRODUCTS
ORDER BY price, product_name;
What is true about the SQL statement?

• A.The results are sorted numerically and then alphabetically.
• B.The results are sorted numerically.
• C.The results are sorted alphabetically.
• D.The results are not sorted.

Exhibit contains the structure of PRODUCTS table:

Evaluate the following query:

What would be the outcome of executing the above SQL statement?

• A.It produces an error
• B.It shows the names of all products in the table
• 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

When does a transaction complete? (Choose all that apply.)

• A.When a DELETE statement is executed
• B.When a data definition language statement is executed
• C.When a ROLLBACK command is executed
• D.When a PL/SQL anonymous block is executed
• E.When a TRUNCATE statement is executed after the pending transaction

Examine the structure of the EMPLOYEES table:

Which UPDATE statement is valid?

• A.UPDATE employee
  SET first_name = 'John', last_name = 'Smith'
  WHERE employee_id = 180;
• B.UPDATE employee
  SET first_name = 'John'
  AND last_name = 'Smith'
  WHERE employee_id = 180;
• C.UPDATE employees
  SET first_name = 'John',
  SET last_name = 'Smoth'
  WHERE employee_id = 180;
• D.UPDATE employees
  SET first_name = 'John'
  SET last_name = 'Smith'
  WHERE employee_id = 180;