1Z0-061 Exam Questions

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? (Choose two.)

View the Exhibit and examine the structure of the PRODUCTS table. You want to display the category with the maximum number of items. You issue the following query: SQL>SELECT COUNT...

View the Exhibit and examine the structure of the PRODUCTS tables. You want to generate a report that displays the average list price of product categories where the average list p...

View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: SQL> SELECT prod_id FROM costs WHERE promo_id IN (SELECT prom...

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables. Evaluate the following SQL command: SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limi...

Which of these is a defining characteristic of a complex view, rather than a simple view? (Choose one or more correct answers.)

Consider these three statements: create view v1 as select department_id,department_name,last_name from departments join employees using (department_id); select department_name,last...

Study this view creation statement: create view dept30 as select department_id,employee_id,last_name from employees where department_id=30 with check option; What might make the fo...

There is a simple view SCOTT.DEPT_VIEW on the table SCOTT.DEPT. This insert fails with an error: SQL> insert into dept_view values('SUPPORT','OXFORD'); insert into dept_view values...

What are distinguishing characteristics of a public synonym rather than a private synonym? (Choose two correct answers.)

Consider these three statements: create synonym s1 for employees; create public synonym s1 for departments; select * from s1; Which of the following statements is correct? (Choose...

A view and a synonym are created as follows: create view dept_v as select * from dept; create synonym dept_s for dept_v; Subsequently the table DEPT is dropped. What will happen if...

A sequence is created as follows: create sequence seq1 maxvalue 50; If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen? (Choose the best a...

You create a sequence as follows: create sequence seq1 start with 1; After selecting from it a few times, you want to reinitialize it to reissue the numbers already generated. How...

Study the following exhibit: Assuming that the sequence SEQ1 was created with the option ORDER and INCREMENT BY set to 1, what value will be returned by the final SELECT statement?...

A UNIQUE constraint on a column requires an index. Which of the following scenarios is correct? (Choose one or more correct answers.)

This statement will fail: create unique bitmap index on employees(department_id,hire_date); Why? (Choose the best answer.)

You have created an index with this statement: create index ename_i on employees(last_name,first_name); How can you adjust the index to include the employees' birthdays, which is a...