1Z0-071 Exam Questions

You execute the SQL statement: What is the outcome?

Evaluate the following CREATE TABLE commands: CREATE_TABLE orders (ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER (4) ); CREATE TABLE ord_items (ord...

Examine the structure of the PROGRAMS table: Which two SQL statements would execute successfully?

View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all custom...

Examine these SQL statements that are executed in the given order: What will be the status of the foreign key EMP_MGR_FK?

View the Exhibit and examine the structure in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 O...

View the Exhibit and examine the description for the SALES and CHANNELS tables. (Choose the best answer.) You issued this SQL statement: Which statement is true regarding the resul...

View the Exhibit and examine the description of the ORDERS table. Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.)

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

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. Examine this query which must select the employee IDs of all the employees who have held the job...

You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set t...

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. Evaluate this SQL statement: SELECT TO_CHAR (list_price, '$9,999') From product_information; Which two st...

Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)

Examine the structure of the ORDERS table: (Choose the best answer.) You want to find the total value of all the orders for each year and issue this command: SQL> SELECT TO_CHAR(or...

View the Exhibit and examine the structure of the ORDER_ITEMS table. You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_IT...

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate this SQL statement: ALTER TABLE emp DROP COLUMN firs...

View the exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)

Which two statements best describe the benefits of using the WITH clause? (Choose two.)

Which three statements are true regarding subqueries? (Choose three.)

Which two statements are true regarding single row functions? (Choose two.)

View the Exhibit and examine the structure of the ORDERS table. You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 1...

You must display details of all users whose username contains the string 'ch_'. Which query generates the required output? (Choose the best answer.)

Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three.)

View the Exhibit and examine the data in the PRODUCTS table. You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices...

Examine the structure of the EMPLOYEES table. You must display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would provide the correct output...

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

Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)

You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)

View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.) The PROJ_TASK_DETAILS table stores information about project tasks and the relation...

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.) In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table....

View the exhibit and examine the description of the EMPLOYEES table. (Choose two.) You executed this SQL statement: SELECT first_name, department_id, salary FROM employees ORDER BY...

Examine the structure of the SALES table. Examine this statement: Which two statements are true about the SALES1 table? (Choose two.)

Examine this SELECT statement and view the Exhibit to see its output: SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM use...

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

Which two statements are true regarding working with dates? (Choose two.)

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.) You executed this UPDATE statement: Which statement is true regarding the execu...

View the Exhibit and examine the structure of the PRODUCTS table. You must display the category with the maximum number of items. You issue this query: What is the result?

Examine the structure of the MEMBERS table: (Choose the best answer.) Examine the SQL statement: SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would...

View and Exhibit and examine the structure and data in the INVOICE table. Which two statements are true regarding data type conversion in query expressions? (Choose two.)

Examine the structure of the EMPLOYEES table. You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salar...

Examine the structure of the PROMOTIONS table: (Choose the best answer.) Management requires a report of unique promotion costs in each promotion category. Which query would satisf...

You must create a table for a banking application. One of the columns in the table has these requirements: 1: A column to store the duration of a short team loan 2: The data should...

Examine the structure of the CUSTOMERS table: (Choose two.) CUSTNO is the PRIMARY KEY. You must determine if any customers' details have been entered more than once using a differe...

Which two are the minimal requirements for a self-join? (Choose two.)

Examine the SQL statement used to create the TRANSACTION table. SQL > CREATE TABLE transaction (trn_id char(2) primary key, Start_date date DEFAULT SYSDATE, End_date date NOT NULL)...

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

A subquery is called a single-row subquery when _______.

You must write a query that prompts users for column names and conditions every time it is executed. The user must be prompted only once for the table name. Which statement achieve...

Which three statements are true regarding single-row functions? (Choose three.)