Oracle 1Z0-071 Exam Actual Questions

Name: Oracle Database SQL
Brand: QA4Exam
SKU: 1Z0-071
Price: 30 USD
Availability: InStock
Rating: 4.9 (405 reviews)

The questions for 1Z0-071 were last updated on Oct 2, 2024.

Viewing page 1 out of 64 pages.
Viewing questions 1-5 out of 321 questions

Unlock Access to All 321 Questions & Answers

Question No. 1

Which two are SQL features?

Aproviding graphical capabilities

Bproviding variable definition capabilities.

Cproviding database transaction control

Dprocessing sets of data

Eproviding update capabilities for data in external files

Show Answer

Correct Answer: C, D

Question No. 2

Examine these requirements:

1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.

2. Sort the titles by date of purchase, starting with the most recently purchased book.

Which two queries can be used?

ASELECT book_title FROM books WHERE (price< 500 OR >1000) AND (purchase date< '17-JAN-2007') ORDER BY purchase date DESC;

BSELECT book_title FROM books WHERE (price IN (500, 1000)) AND (purchase date < '17-JAN-2007') ORDER BY purchase_date ASC;

CSELECT book_title FROM books WHERE (price NOT BETWEEN 500 AND 1000) AND (purchase_date< '17-JAN-2007') ORDER BY purchase_date DESC;

DSELECT book_title FROM books WHERE (price BETWEEN 500 AND 1000) AND (purchase_date<'17-JAN-2007') ORDER BY purchase_date;

Show Answer

Correct Answer: A, C

Question No. 3

Which three statements about roles are true?

ARoles are assigned to roles using the ALTER ROLE Statement

BA role is a named group of related privileges that can only be assigned to a user

CRoles are assigned to users using the ALTER USER statement

DA single role can be assigned to multiple users.

EA single user can be assigned multiple roles

FPrivileges are assigned to a role using the ALTER ROLE statement.

GPrivileges are assigned to a role using the GRANT statement.

Show Answer

Correct Answer: D, E, G

Question No. 4

Which two join conditions in a from clause are non-equijoins?

Atablet join table2 ON (table1.column = table2.column) where table2.column LIKE 'A'

Btable1 join table2 on (table1.column between table2.column] and table2.column2)

Ctable1 natural JOIN table2

Dtable1 join table2 using (column1, column2)

Etable1 join table2 ON (table1.column >= table2.column)

Show Answer

Correct Answer: B, E

Question No. 5

Examine the contents of the EMP table:

Examine this query that executes successfully:

What is the result?

AIt will return the six employees earning the highest salaries, in descending order.

BIt will return the five employees earning the highest salaries, in descending order.

CIt will return the five employees earning the lowest salaries, in ascending order.

DIt will return the six employees earning the lowest salaries, in ascending order.

Show Answer

Correct Answer: C

CREATE TABLE EMP

(

ID NUMBER(10),

NAME VARCHAR2(10),

SALARY NUMBER(10)

)

INSERT INTO EMP VALUES (101, 'JOHN', 26000);

INSERT INTO EMP VALUES (102, 'NEENA', 24000);

INSERT INTO EMP VALUES (103, 'DEHAAN', 12000);

INSERT INTO EMP VALUES (104, 'LEX', 17000);

INSERT INTO EMP VALUES (105, 'BILL', 18000);

INSERT INTO EMP VALUES (106, 'DANIEL', 26000);

INSERT INTO EMP VALUES (107, 'BEN', 12000);

INSERT INTO EMP VALUES (108, 'GEORGE', 25000);

SELECT * FROM EMP

ORDER BY SALARY

FETCH FIRST 5 ROWS WITH TIES;

Unlock All Questions for Oracle 1Z0-071 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 321 Questions & Answers