1Z0-071 Exam Questions

Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORD...

The PRODUCTS table has the following structure. Evaluate the following two SQL statements: SQL>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ' ') FROM products; SQ...

You executed the following CREATE TABLE statement that resulted in an error: SQL> CREATE TABLE employees(emp_id NUMBER(10) PRIMARY KEY, ename VARCHAR2(20), email NUMBER(3) UNIQUE,...

View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last names and credit limits of all customers whose last names start wi...

Evaluate this query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL; What will be the result?

View the Exhibit and examine the structure of the ORDER_ITEMS table. Examine the following SQL statement: SELECT order_id, product_id, unit_price FROM order_items WHERE unit_price...

Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which...

View the exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables. You want to update EMPLOYEES table as follows: Update only those employees who work in Boston o...

You need to calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which two SQL statements would give the required output? (...

The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of th...

View the Exhibit and examine the description for the PRODUCTS and SALES table. PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want to remove...

Which statement is true regarding sub queries?

View the Exhibit and examine the structure of the SALES table. The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold...

Examine the structure of the SHIPMENTS table: You want to generate a report that displays the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one month f...

View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'. You issue the foll...

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME ---------------- Lex De Haan Renske Ladwig Jose Manuel Urman Jason Mallin You want to extract only those...

Examine the structure and data in the PRICE_LIST table: name Null Type ------ --------- ------- PROD_ID NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD_PRICE ---------- ---...

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

Examine the structure of the employees table: There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID. You want to display the name, joining date, and manager for a...

You need to display the first names of all customers from the customers table that contain the character 'e' and have the character 'a' in the second last position. Which query wou...

Examine the following SQL commands: Which statement is true regarding the execution of the above SQL commands?

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

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

View the Exhibit and examine the data in EMP and DEPT tables. In the DEPT table, DEPTNO is the PRIMARY KEY. In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY...

Which three tasks can be performed by DDL statements? (Choose three.)

View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, product_ID, and total price (UNIT_PRICE multiplied by QUANT...

Which two statements are true regarding operators used with subqueries (Choose two.)

Examine the structure of the SHIPMENTS table: You want to generate a report that displays the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one month f...

Examine the structure and data in the PRICE_LIST table: You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PR...

View the Exhibit and examine the data in the PRODUCTS table. Which statement would add a column called PRICE, which cannot contain NULL?

The customers table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of th...

View the Exhibit and examine the structure of the SALES table. The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold...

View the Exhibit and examine the description for the PRODUCTS and SALES table. is a primary key in the PRODUCTS table and foreign key in the SALES table with ON DELETE PROD_ID opti...

Examine the data in the CUST_NAME column of the CUSTOMERS table. You want to extract only those customer names that have three names and display the * symbol in place of the first...

View the Exhibit and examine the structure of the BOOKS table. The BOOKS table contains details of 100 books. Examine the commands executed and their outcome: Which statement is tr...

Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?

View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) "Re...

View the Exhibit and examine the structure of the CUSTOMERS table. CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table. CUSTOMERS nee...

Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query?

View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively. Which two INSERT stateme...

Which two statements are true? (Choose two.)

What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

Examine the command to create the BOOKS table. The BOOK_ID value 101 does not exist in the table. Examine the SQL statement: Which statement is true?

You need to list the employees in DEPARTMENT_ID 20 days in a single row, ordered by HIRE_DATE. Examine the sample output: Which query will provide the required output?

Examine the structure of the DEPARTMENTS table. You execute the following command: Which two statements are true? (Choose two.)

View the exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has e...

You need to display the first names of all customers from the CUSTOMERS table that contain the character `e' and have the character `a' in the second last position. Which query wou...

Examine the data in the ORD_ITEMS table: Evaluate this query: Which statement is true regarding the result?

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)