Online Access Free 1z1-061 Exam Questions

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 not sorted.
• D.The results are sorted alphabetically.

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

• A.SELECT employees.last_name, departments.department_name,
  departments.location_id FROM employees e, departments D WHERE e.department_id
  = d.department_id;
• B.SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;
• C.SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;
• D.SELECT last_name, department_name, location_id FROM employees , departments ;

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( first_name, last_name) VALUES( 'John', 'Smith');
• B.INSERT INTO employees VALUES ( 1000, 'John', NULL);
• C.INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
• D.INSERT INTO employees (employee_id) VALUES (1000);
• E.INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', '');
• F.INSERT INTO employees VALUES ( NULL, 'John', 'Smith');

View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
Exhibit 1.

Exhibit 2.

Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

• A.It displays prod IDs in the promos with the highest cost in the same time interval.
• B.It displays prod IDs in the promo with the lowest cost.
• C.It displays prod IDs in the promos with the lowest cost in the same time interval.
• D.It displays prod IDs in the promos with cost less than the highest cost in the same time interval.

Examine the structure of the PRODUCTS table:

You want to change the definition of the PRODUCTS table. The PROD_DETAILS column must be changed to allow 4000 characters.
Which statement is valid?

• A.ALTER TABLE productsCHANGE (prod_details VARCHAR2 (4000));
• B.ALTER TABLE productsMODIFY (prod_details CHAR2 (4000));
• C.ALTER TABLE productsMODIFY COLUMN (prod_details CHAR (4000));
• D.ALTER TABLE productsMODIFY (prod_details VARCHAR2 (4000));