1Z0-071 Exam Questions

Examine the description of the MEMBERS table: Examine the partial query: SELECT city, last_name LNAME FROM members ...; You want to display all cities that contain the string AN. T...

You execute this command: ALTER TABLE employees SET UNUSED (department_id) Which two are true? (Choose two.)

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1) Be stored in a format supporting date arithmetic without using...

The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR. Which two WHERE conditions demonstrate the correct usage of conversi...

Examine the description of the PROMOTIONS table: You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

Table ORDER_ITEMS contains columns ORDER_TO, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these SQL statements: Statement 1: Statement 2: Which two statements are true? (C...

Examine the description of the EMPLOYEES table: Examine this query: Which line produces an error?

Which two are true about savepoints? (Choose two.)

Examine the data in the EMPLOYEES table. Which statement will compute the total annual compensation for each employee?

Examine the description of the ORDER_ITEMS table: Examine this incomplete query: Which two can replace <clause> so the query completes successfully? (Choose two.)

Examine the data in the PRODUCTS table: Examine these queries: Which queries generate the same output?

The SYSDATE function displays the current Oracle Server date as: 21-MAY-19 You wish to display the date as: MONDAY, 21 MAY, 2019 Which statement will do this?

Which two are SQL features? (Choose two.)

Examine this statement which returns the name of each employee and their manager: You want to extend the query to include employees with no manager. What must you add before JOIN t...

Which two are true about scalar subquery expressions? (Choose two.)

Examine this partial statement: Which is true?

You have the privileges to create any type of synonym. Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?

Examine this data in the EMPLOYEES table: Which statement will execute successfully?

Examine the description of the EMPLOYEES table: Which two statements will run successfully? (Choose two.)

A session's NLS_DATE_FORMAT is set to DD Mon YYYY. Which two queries return the value 1 Jan 2019?

No-user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)?

Examine the description of the ORDERS table: Examine the description of the INVOICES table: Examine this query: Which three rows will it return? (Choose three.)

Which three are key components of an Entity Relationship Model? (Choose three.)

Which two are true about external tables that use the ORACLE_DATAPUMP access driver? (Choose two.)

Examine the description of the CUSTOMERS table: Which two SELECT statements will return these results (Choose two.):

Which statement is true about TRUNCATE and DELETE?

Which three statements are true about external tables? (Choose three.)

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

Examine these statements and results: How many rows are retrieved by the last query?

Which three statements about roles are true? (Choose three.)

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

Table HR.EMPLOYEES contains a row where the EMPLOYEE_ID is 109. User ALICE has no privileges to access HR.EMPLOYEES. User ALICE starts a session. User HR starts a session and succe...

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

Which two will execute successfully? (Choose two.)

User HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges. User SCOTT has CREATE SESSION, CREATE TABLE and UNLIMITED TABLESPACE privileges. HR successfully e...

Examine these statements: Which two are true? (Choose two.)

Which two statements are true about dropping views? (Choose two.)

You need to allow user ANDREW to: 1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table. 2. GRANT that permission to other users. Which statement will do this?

Which two are true about using constraints? (Choose two.)

Which two are true? (Choose two.)

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

Which two are true? (Choose two.)

Which two statements are true about TRUNCATE and DELETE? (Choose two.)

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 2...

Which three are true about scalar subquery expressions? (Choose three.)

You own table DEPARTMENTS, referenced by views, indexes, and synonyms. Examine this command which executes successfully: DROP TABLE departments PURGE; Which three statements are tr...

Which is true about the ROUND, TRUNC and MOD functions?

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

Which two are true about unused columns? (Choose two.)

Which two are true about the precedence of operators and conditions? (Choose two.)