Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 71:

  Examine the description of the EMP_DETAILS table given below: Exhibit:

  

  Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two.)

  A. An EMP_IMAGE column can be included in the GROUP BY clause
  B. You cannot add a new column to the table with LONG as the data type
  C. An EMP_IMAGE column cannot be included in the ORDER BY clause
  D. You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column
  B. You cannot add a new column to the table with LONG as the data type
  C. An EMP_IMAGE column cannot be included in the ORDER BY clause

• Question 72:

  Evaluate the following SQL statement:

  SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30;

  Which ORDER BY clause are valid for the above query? (Choose all that apply.)

  A. ORDER BY 2,1
  B. ORDER BY CUST_NO
  C. ORDER BY 2,cust_id
  D. ORDER BY "CUST_NO"
  E. ORDER BY "Last Name"
  A. ORDER BY 2,1
  C. ORDER BY 2,cust_id
  E. ORDER BY "Last Name"

• Question 73:

  Which constraint can be defined only at the column level?

  A. UNIQUE
  B. NOT NULL
  C. CHECK
  D. PRIMARY KEY
  E. FOREIGN KEY
  B. NOT NULL

• Question 74:

  What is true about updates through a view?

  A. You cannot update a view with group functions.
  B. When you update a view group functions are automatically computed.
  C. When you update a view only the constraints on the underlying table will be in effect.
  D. When you update a view the constraints on the views always override the constraints on the underlying tables.
  A. You cannot update a view with group functions.

• Question 75:

  Examine the structure of the EMPLOYEES table:

  

  Which UPDATE statement is valid?

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

• Question 76:

  You need to create a table named ORDERS that contain four columns:

  1.

  an ORDER_ID column of number data type

  2.

  a CUSTOMER_ID column of number data type

  3.

  an ORDER_STATUS column that contains a character data type

  4.

  a DATE_ORDERED column to contain the date the order was placed.

  When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead.

  Which statement accomplishes this?

  A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
  B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
  C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
  D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
  E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
  F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
  B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

• Question 77:

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

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

• Question 78:

  View the Exhibit and examine the data in the EMPLOYEES table.

  

  You want to generate a report showing the total compensation paid to each employee to date. You issue the following query:

  

  What is the outcome?

  A. It generates an error because the alias is not valid.
  B. It executes successfully and gives the correct output.
  C. It executes successfully but does not give the correct output.
  D. It generates an error because the usage of the ROUND function in the expression is not valid.
  E. It generates an error because the concatenation operator can be used to combine only two items.
  C. It executes successfully but does not give the correct output.

• Question 79:

  View the Exhibit and examine the structure and data in the INVOICE table.

  

  Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.)

  A. inv_amt ='0255982' : requires explicit conversion
  B. inv_date > '01-02-2008' : uses implicit conversion
  C. CONCAT(inv_amt,inv_date) : requires explicit conversion
  D. inv_date = '15-february-2008' : uses implicit conversion
  E. inv_no BETWEEN '101' AND '110' : uses implicit conversion
  D. inv_date = '15-february-2008' : uses implicit conversion
  E. inv_no BETWEEN '101' AND '110' : uses implicit conversion

• Question 80:

  Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.)

  A. It locks only the columns specified in the SELECT list.
  B. It locks the rows that satisfy the condition in the SELECT statement.
  C. It can be used only in SELECT statements that are based on a single table.
  D. It can be used in SELECT statements that are based on a single or multiple tables.
  E. After it is enforced by a SELECT statement, no other query can access the same rows until a COMMIT or ROLLBACK is issued.
  B. It locks the rows that satisfy the condition in the SELECT statement.
  D. It can be used in SELECT statements that are based on a single or multiple tables.