Free Oracle 1Z0-051 Exam Dumps Questions & Answers

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)

• A.It releases the storage space used by the table.
• B.An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
• C.You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
• D.You can NOT roll back the deletion of rows after the statement executes.
• E.It does not release the storage space used by the table.
• F.You can roll back the deletion of rows after the statement executes.

You are granted the CREATE VIEW privilege. What does this allow you to do?

• A.Create a sequence view in any schema.
• B.Create a view that is accessible by everyone.
• C.Create a view in your schema.
• D.Create a view in any schema.
• E.Create a table view.
• F.Create a view only of it is based on tables that you created.

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.You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column
• D.An EMP_IMAGE column cannot be included in the ORDER BY clause

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

You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost. You issue the following query: Which statement is true regarding the above query?

• A.It produces an error because an expression cannot be used in the ORDER BY clause.
• B.It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause.
• C.It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause.
• D.It executes and produces the required result.

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC."
Which query gives the required output?

• A.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';
• B.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%');
• C.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');
• D.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc';