1Z0-071 Exam Questions

Which three statements are true about Data Manipulation Language (DML)? (Choose three.)

Examine the description of the BOOKS table: The table has 100 rows. Examine this sequence of statements issued in a new session: Which two statements are true? (Choose two.)

Which three are true about privileges and roles? (Choose three.)

Examine this query: Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)

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

Which three statements are true about defining relations between tables in a relational database? (Choose three.)

You execute this command: Which two are true? (Choose two.)

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Which three statements are true about Structured Query Language (SQL)? (Choose three.)

Evaluate these commands which execute successfully: Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Which two statements are true about INTERVAL data types? (Choose two.)

Which two statements are true about the DUAL table? (Choose two.)

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

Which two are true about the WITH GRANT OPTION clause? (Choose two.)

Examine the description of the EMPLOYEES table: Which query requires explicit data type conversion?

Examine this partial command: Which two clauses are required for this command to execute successfully? (Choose two.)

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

Examine the description of the TRANSACTIONS table: Which two SQL statements execute successfully? (Choose two.)

Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)

Examine this description of the PRODUCTS table: Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode. Which three commands execute su...

Which two statements are true about transactions in the Oracle Database server? (Choose two.)

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement: Whi...

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Which three actions can you perform on an existing table containing data? (Choose three.)

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

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

Which two statements are true about the SET VERIFY ON command? (Choose two.)

Which two statements are true about the rules of precedence for operators? (Choose two.)

Examine this statement: What is returned upon execution?

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Which three are true about system and object privileges? (Choose three.)

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promoti...

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

Which two statements are true about substitution variables? (Choose two.)

Which three statements are true about inner and outer joins? (Choose three.)

Examine the description of the PRODUCTS table: Which three queries use valid expressions? (Choose three.)

Which three statements are true about the DESCRIBE command? (Choose three.)

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query produces output for C...

Examine this SQL statement: Which two are true?

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transactions complete thereby co...

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type co...

The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the...

Examine this query: SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL; What is the result?

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

Which three are true about the CREATE TABLE command? (Choose three.)

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output?

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

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

Which two statements are true regarding a SAVEPOINT? (Choose two.)