Black Friday Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Oracle 1z0-071 Exam Made Easy: Step-by-Step Preparation Guide

Questions 11

Which two are true about granting object privileges on tables, views, and sequences?

Options:

A.

DELETE can be granted on tables, views, and sequences.

B.

REFERENCES can be grantrd only on tables.

C.

INSERT can be granted only on tables and sequences.

D.

SELECT can be granted on tables, views, and sequences.

E.

ALTER can be granted only on tables and sequences.

Buy Now
Questions 12

Which two statements are true about INTERVAL data types

Options:

A.

INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

B.

The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

C.

INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

D.

The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

E.

INTERVAL DAY TO SECOND columns support fractions of seconds.

F.

INTERVAL YEAR TO MONTH columns support yearly intervals.

Buy Now
Questions 13

Examine this data in the EMPLOYERS table:

1z0-071 Question 13

Which statement will execute successfully?

Options:

A.

SELECT dept_id, MAX (Last_name), SUM (salary) FROM employees GROUP BY dept_id

B.

SELECT dept_id, LENGTH (last_name), SUM (salary) FROM employees GROUP BY dept_id

C.

SELECT dept_id, STDDEV (last_name), SUM (salary) FROM employees GROUP BY dept_id

D.

SELECT dept_id, INSTR (last_name,'A'), SUM (salary) FROM employees GROUP BY dept_id

Buy Now
Questions 14

Examine this SQL statement:

SELECT cust_id, cus_last_name "Last Name"

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

Options:

A.

ORDERBY 2, 1

B.

ORDER BY "CUST_NO"

C.

ORDER BY 2,cust_id

D.

ORDER BY CUST_NO

E.

ORDER BY "Last Name"

Buy Now
Questions 15

Which two statements are true about Oracle databases and SQL?

Options:

A.

Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.

B.

The database guarantees read consistency at select level on user-created tablers.

C.

When you execute an UPDATE statement, the database instance locks each updated row.

D.

A query can access only tables within the same schema.

E.

A user can be the owner of multiple schemas In the same database.

Buy Now
Questions 16

Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined?

Options:

A.

Insert statements can always be done on a table through a view.

B.

The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

C.

Delete statements can always be done on a table through a view.

D.

Views cannot be used to add rows to an underlying table If the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

E.

Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the primary key columns are not referenced in the defining query of the view.

F.

Views cannot be used to add or modify rows in an underlying table If the defining query of the view contains the DISTINCT keyword.

Buy Now
Questions 17

Examine this query:

SELECT INTERVAL '100' MONTH DURATION FROM DUAL;

What will be the output?

Options:

A.

DURATION

+08-04

B.

DUFATION

+100

C.

DURATION

+08

D.

an error

Buy Now
Questions 18

Which two statements are true about * TABLES views?

Options:

A.

You must have SELECT privileges on a table to view it in ALL TABLES.

B.

You must have SELECT privileges on a table to view it in DBA TABLES.

C.

USER TABLES displays all tables owned by the current user.

D.

All TABLES displays all tables owned by the current user.

E.

You must have SELECT privileges on a table to view it in USER TABLES.

F.

All users can query DBA TABLES successfully.

Buy Now
Questions 19

You execute this command:

TRUNCATE TABLE dept;

Which two are true?

Options:

A.

It drops any triggers defined on the table.

B.

It retains the indexes defined on the table.

C.

It retains the integrity constraints defined on the table.

D.

A ROLLBACK statement can be used to retrieve the deleted data.

E.

It always retains the space used by the removed rows.

F.

A FLASHBACK TABLE statement can be used to retrieve the deleted data.

Buy Now
Questions 20

Examine the description of the EMPLOYEES table:

1z0-071 Question 20

You write this failing statement:

SELECT dept_no AS department_id, MAX (salary) As max_sal

FROM employees

WHERE salary >10000

GROUP BY department_id

ORDER BY max_sal;

Which clause causes the error?

Options:

A.

ORDER BY

B.

WHERE

C.

GROUP BY

D.

SELECT

Buy Now
Exam Code: 1z0-071
Exam Name: Oracle Database 12c SQL
Last Update: Dec 12, 2024
Questions: 326

PDF + Testing Engine

$164.99
$66

Testing Engine

$124.99
$50

PDF (Q&A)

$104.99
$42

Oracle Free Exams

Oracle Free Exams
Examstrack offers comprehensive free resources and practice tests for Oracle exams.