Free Oracle 1Z0-051 Exam Dumps Questions & Answers

View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: CATEGORIES 5MP Digital Photo Camera's category is Photo Y Box's category is Electronics Envoy Ambassador's category is Hardware Which two queries would give the required output? (Choose two.)

• A.  SELECT prod_name || q'<'s >' || 'category is ' || prod_category CATEGORIES FROM products;
• B.  SELECT prod_name || q'['s ]'category is ' || prod_category CATEGORIES FROM products;
• C.  SELECT prod_name || q'''s category is ' || prod_category CATEGORIES FROM products;
• D.  SELECT prod_name || q'\'s\' || ' category is ' || prod_category CATEGORIES FROM products;

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? (Choose three.)

• A.  INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
• B.  INSERT INTO employees VALUES ( 1000, 'John', NULL);
• C.  INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
• D.  INSERT INTO employees (employee_id) VALUES (1000);
• E.  INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
• F.  INSERT INTO employees VALUES ( NULL, 'John', 'Smith');

Evaluate the following two queries: Exhibit:

Exhibit:

Which statement is true regarding the above two queries?

• A.  Performance would degrade in query 2
• B.  Performance would improve in query 2
• C.  There would be no change in performance
• D.  Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column

Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

• A.  subtraction
• B.  addition
• C.  finding the lowest value
• D.  finding the quotient
• E.  raising to a power

View the Exhibit and examine the structure of the CUSTOMERS table.

NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:

The INSERT statement fails when executed. What could be the reason?

• A.  The VALUES clause cannot be used in an INSERT with a subquery
• B.  The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table
• C.  The WHERE clause cannot be used in a sub query embedded in an INSERT statement
• D.  Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match