Free Oracle 1Z0-071 Exam Dumps and 1Z0-071 Exam Questions

Question No: 61

MultipleChoice

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 25 months."

Which where clause can be used?

Options

AWHERE MONTHS_BETWEEN (SYSDATE, start-_date) <= 25

BWHERE ADD_MONTHS (3tart_datO, 25) <= SYSDATE

CWHERE MONTHS_UETWEEN (start_date, SYSDATE) <= 25

DWHERE TO_NUMBER (start_date - SYSDATE) <= 25

Question No: 62

MultipleChoice

Which three statements execute successfully?

A)

B)

C)

D)

E)

F)

G)

Options

AOption A

BOption B

COption C

DOption D

EOption E

FOption F

GOption G

Question No: 63

MultipleChoice

Examine this statement which returns the name of each employee and their manager:

You want to extend the query to include managers with no employees. What must you add before join to do this?

Options

AFULL. OUTER

BLEFT OUTER

CRIGHT OUTER

DCROSS

Question No: 64

MultipleChoice

In your session , the NLS_DATE_FORMAT is DD_MM_YYYY.

There are 86400 seconds in a day.

Examine this result:

Which statement returns this?

Options

ASELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''

BSELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''

CSELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''

DSELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''

ESELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''

Question No: 65

MultipleChoice

Which two statements are true about dropping views?

Options

ARead only views cannot be dropped.

BThe creator of a view to be dropped must have the drop ANY_ VIEW privilege.

CData selected by a view's defining query is deleted from Its underlying tables when the view is dropped.

DViews referencing a dropped view become Invalid.

ECASCADE constraints must be specified when referential integrity constraints on other objects refer to primary or unique keys In the view to be dropped.

Question No: 66

MultipleChoice

Examine this statement:

SELECT cust_id, cust^last_ndma "Last Name"

FROM customers

WHERE country_id --- 10 UNION

SELECT cust_ID_CUST_NO, cust_last_name

PROM customers

WHERE country__id = 30

Identify three order by clauses, any one of which will complete the query successfully.

Options

AORDER BY 2. cust _id

BORDER BY 2,

CORDER BY 'CUST^NO

DORDER BY 'Last Name

EORDER BY CUST_NO

Question No: 67

MultipleChoice

Which three statements are true about external tables?

Options

AThey can be used In queries containing sorts.

BThey can be used in queries containing Joins.

CThey can be indexed.

DDML statements can modify them.

EThey can be temporary tables.

FTheir metadata Is stored In the database.

Question No: 68

MultipleChoice

Examine the data in the NEW_EMPLOYEES table:

Update existing employee details in the EMPLOYEES table with data from the NEW_EMPLOYEES table.

2. Add new employee details from the NEW_EMPLOYEES table to the EMPLOYEES table.

Which statement will do this?

A)

B)

C)

D)

Options

AOption A

BOption B

COption C

DOption D

Question No: 69

MultipleChoice

Examine the description of the CUSTOMERS table:

Which two statements will do an implicit conversion?

Options

ASELECT FROM + customers WHERE TO-CHAR (customer_id) = '0001';

BSELECT FROM + customers WHERE (customer_id) = 0001;

CSELECT FROM + customers WHERE (customer_id) = '0001';

DSELECT FROM + customers WHERE insert_date = DATE '2019-01-01';

ESELECT FROM + customers WHERE insert_date = '01-JAN-19';

Question No: 70

MultipleChoice

Examine these statements:

Which two are true?

Options

ABoth foreign key constraint definition must be removed from the CREATE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

BThe MGR column In the DEPT table will not be able to contain null values.

CThe DEPTNO column in the EMP table will be able to contain null values.

DThe DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement. and the added with an D. ALTER statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

EThe create TABLE EMP statement must precede the create table DEPT statement for all three statements to execute successfully.

FAll three statements execute successfully in the order shown.