1Z0-071 Exam Questions

The SQL statements executed in a user session are as follows: Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose...

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. You want to see the product names and the date of expiration of warranty for all the products, if the p...

Examine the description of the PRODUCT_DETAILS table: Which two statements are true? (Choose two.)

Which two are true about the data dictionary? (Choose two.)

Which three statements are true about views in an Oracle Database? (Choose three.)

Examine the data in the CUST_NAME column of the CUSTOMERS table: You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the...

Which three are true about the MERGE statement? (Choose three.)

Which three actions can you perform only with system privileges? (Choose three.)

Which three are true about multitable INSERT statements? (Choose three.)

Examine the description of the SALES table: The SALES table has 55,000 rows. Examine this statement: Which two statements are true? (Choose two.)

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Examine the description of the CUSTOMERS table: CUSTNO is the PRIMARY KEY. You must determine if any customers' details have been entered more than once using a different CUSTNO, b...

The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully? (Choose two.)

Examine these statements executed in a single Oracle session: Which three statements are true? (Choose three.)

Which three are true about dropping columns from a table? (Choose three.)

You issued this command: Which three statements are true? (Choose three.)

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months...

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

View the Exhibit and examine the description of the tables. You execute this SQL statement: Which three statements are true? (Choose three.)

Examine the description of the CUSTOMERS table: You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Wh...

Examine this SQL statement: Which two are true? (Choose two.)

What is true about non-equijoin statement performance? (Choose two.)

Which three statements are true about multiple row subqueries? (Choose three.)

In which three situations does a new transaction always start? (Choose three.)

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

Examine this statement: What is returned upon execution?

Examine the description of the PRODUCT_INFORMATION table: Which query retrieves the number of products with a null list price?

Which statement is true about aggregate functions?

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

Which two commands execute successfully? (Choose two.) - MANAGER is an existing role with no privileges or roles. - EMP is an existing role containing the CREATE TABLE privilege. -...

Which statement is true about the INTERSECT operator used in compound queries?

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

You execute this query: What is the result?

Which two are true about granting privileges on objects? (Choose two.)

Which statement is true about TRUNCATE and DELETE?

In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about expressions using PROMO_BEGI...

Which two statements are true about Oracle synonyms? (Choose two.)

Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from...

Examine this query: SELECT 2 FROM DUAL d1 CROSS JOIN DUAL d2 CROSS JOIN DUAL d3; What is returned upon execution?

The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER (8, 2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price, `$9,999') FROM product_information; Which...

Examine the description of the BOOKS_TRANSACTIONS table: Examine this partial SQL statement: SELECT * FROM books_transactions Which two WHERE conditions give the same result? (Choo...

Which two statements are true about a self join? (Choose two.)

You create a table by using this command: CREATE TABLE rate_list (rate NUMBER(6,2)); Which two are true about executing statements? (Choose two.)

Examine these SQL statements which execute successfully: Which two statements are true after execution? (Choose two.)

Which two statements are true about conditional INSERT ALL? (Choose two.)

Examine the description of the EMPLOYEES table: Which query is valid?

Which three statements are true about performing Data Manipulation Language (DML) operations on a view in an Oracle Database? (Choose three.)

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)