1Z0-071 Exam Questions
419 real 1Z0-071 exam questions with expert-verified answers and explanations. Page 3 of 9.
- Question #105
You execute the SQL statement: What is the outcome?
- Question #106
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...
- Question #107
Examine the structure of the PROGRAMS table: Which two SQL statements would execute successfully?
- Question #108
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...
- Question #109
Examine these SQL statements that are executed in the given order: What will be the status of the foreign key EMP_MGR_FK?
- Question #110
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...
- Question #111
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...
- Question #112
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.)
- Question #113
Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)
- Question #114
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...
- Question #115
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...
- Question #116
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...
- Question #117
Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)
- Question #118
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...
- Question #119
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...
- Question #120
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...
- Question #121
View the exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)
- Question #122
Which two statements best describe the benefits of using the WITH clause? (Choose two.)
- Question #123
Which three statements are true regarding subqueries? (Choose three.)
- Question #124
Which two statements are true regarding single row functions? (Choose two.)
- Question #125
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...
- Question #126
You must display details of all users whose username contains the string 'ch_'. Which query generates the required output? (Choose the best answer.)
- Question #127
Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three.)
- Question #128
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...
- Question #129
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...
- Question #130
Which two statements are true regarding subqueries? (Choose two.)
- Question #131
Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
- Question #132
Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)
- Question #133
You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)
- Question #134
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...
- Question #135
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....
- Question #136
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...
- Question #137
Examine the structure of the SALES table. Examine this statement: Which two statements are true about the SALES1 table? (Choose two.)
- Question #138
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...
- Question #139
Which two statements are true regarding constraints? (Choose two.)
- Question #140
Which two statements are true regarding working with dates? (Choose two.)
- Question #141
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...
- Question #142
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?
- Question #143
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...
- Question #144
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.)
- Question #145
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...
- Question #146
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...
- Question #147
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...
- Question #148
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...
- Question #149
Which two are the minimal requirements for a self-join? (Choose two.)
- Question #150
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)...
- Question #151
Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
- Question #152
A subquery is called a single-row subquery when _______.
- Question #153
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...
- Question #154
Which three statements are true regarding single-row functions? (Choose three.)