1Z0-071 Exam Questions

Which statement is true regarding the INTERSECT operator?

Which two statements are true regarding the COUNT function? (Choose two.)

View the Exhibit and examine the descriptions of the DEPT and LOCATIOMS tables. You want to update the CITY column of the DEPT table for all the rows with the corresponding value i...

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. ORDER__ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table w...

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

View the Exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two col...

Which three statements are true regarding group functions? (Choose three.)

You execute the following commands: For which substitution variables are you prompted for the input?

Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)

You issue the following command to drop the PRODUCTS table: SQL>DROP TABLE products; What is the implication of this command? (Choose all that apply.)

Which three statements are true reading subquenes?

You are designing the structure of a table in which two columns have the specifications: COMPONENT_ID - must be able to contain a maximum of 12 alphanumeric characters and uniquely...

View the Exhibit and examine the ORDERS table. The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to th...

View the Exhibit and examine the structure of the stores table. You want to display the name of the store along with the address, START_DATE, PROPERTV_PRICE, and the projected prop...

Which statement correctly grants a system privilege?

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD colum...

Evaluate the following SELECT statement and view the exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, statu...

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 custome...

Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, enameVARCHAR2(15), salary NUMBER(...

Which statement is true about transactions?

Examine the structure of the members table: Which query can be used to display the last names and city names only for members from the states MO and MI?

Which two statements are true regarding roles? (Choose two.)

The first DROP operation is performed on PRODUCTS table using the following command: DROP TABLE products PURGE; Then you performed the FLASHBACK operation by using the following co...

See the Exhibit and examine the structure of the PROMOTIONS table: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5...

Evaluate the following SQL query; What would be the outcome?

Which statement is true regarding the default behavior of the ORDER BY clause?

Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

View the exhibit and examine the structure of ORDERS and CUSTOMERS tables. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST...

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table. Evaluate the following CREATE TABLE command: CREATE TABL...

Which task can be performed by using a single Data Manipulation Language (OML) statement?

View the Exhibit and examine the data in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER ID, ORDER_DATE, and the total number of items in each orde...

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. Evaluate the following MERGE statement: MERGE INTO orders_master o USING monthly_orders m ON (o.or...

Which statements are correct regarding indexes? (Choose all that apply.)

View the Exhibit for the structure of the STUDENT and FACULTY tables. You need to display the faculty name followed by the number of students handled by the faculty at the base loc...

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to...

The following are the steps for a correlated subquery, listed in random order: 1) The WHERE clause of the outer query is evaluated. 2) The candidate row is fetched from the table s...

The BOOKS_TRANSACTIONS table exists in your database. Examine the SQL statement: SQL>SELECT * FROM books_transactions ORDER BY 3; What is the outcome on execution?

Examine the business rule: Each student can take up multiple projects and each project can have multiple students. You need to design an Entity Relationship Model (ERD) for optimal...

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables. You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all...

View the Exhibit and examine the structure of the CUSTOMERS table. Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

Which three statements are true about the ALTER TABLE ----DROP COLUMN .....command?

View the Exhibit and examine the description of the PRODUCT_INFORMATION table. Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

Which statement is true about an inner join specified in the WHERE clause of a query?

You want to display the date for the first Monday of the next month and issue the following command: SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'), 'dd "is the first Monday...

Which statement is true regarding external tables?

Which two statements are true about sequences created in a single instance database? (Choose two.)

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: What would be the outcome of the above SQL statement?

Examine the following query: What is the output of this query?

Examine the structure of the members table: What is the outcome?