Free 1z1-071 Questions for Oracle 1z1-071 Exam

Question #1

Which three statements about roles are true?

A. Privileges are assigned to a role using the ALTER ROLE statement.

B. A single user can be assigned multiple roles

C. A role is a named group of related privileges that can only be assigned to a user

D. Roles are assigned to users using the ALTER USER statement

E. A single role can be assigned to multiple users.

F. Roles are assigned to roles using the ALTER ROLE Statement

G. Privileges are assigned to a role using the GRANT statement.

Discussion 0

Correct Answer: B,E,G Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #2

Which statement is true about aggregate functions?

A. Aggregate functions can be nested to any number of levels

B. The MAX and MIN functions can be used on columns with character data types

C. Aggregate functions can be used in any clause of a SELECT statement

D. The AVG function implicitly converts NULLS to zero

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

You execute this command:
TRUNCATE TABIE depts;
Which two are true?

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

B. It always retains the space used by the removed rows.

C. It retains the integrity constraints defined on the table,

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

E. It drops any triggers defined on the table.

F. It retains the indexes defined on the table.

Discussion 0

Correct Answer: C,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

Which two are true about creating tables in an Oracle database?

A. Creating an external table will automatically create a file using the specified directory and file name.

B. A create table statement can specify the maximum number of rows the table will contain.

C. A system privilege is required.

D. The same table name can be used for tables in different schemas.

E. A primary key constraint is manadatory.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #5

Examine the data in the CUST_NAME column of the CUSTOMERS table:
CUST_NAME
---------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

A. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) LIKE 'Mc%'

B. WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) LIKE UPPER('MC%')

C. WHERE SUBSTR(cust_name, INSTR(cust_name,' ') + 1) LIKE 'Mc%' OR 'MC%'

D. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) IN ('MC%','Mc%')

E. WHERE SUBSTR(cust_name, INSTR(cust_name,' ') + 1) LIKE 'Mc%'

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

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

A. SELECT promo_cost, promo_category FROM promotions ORDER BY 1

B. select DISTINCT promo_categoryIl 'has'||promol_cost as COSTS FROM promotions ORDER BY 1:

C. SELECT DISTINCT promo_cost ||'in'IIDISTINCT promo_category promotions ORDER BY1:

D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

E. SELECT promo_category, DISTINCT promo_cost FROM promotiong ORDER BY 2:

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

Examine the data in the INVOICES table:

Examine the data in the CURRENCIES table:
CURRENCY_CODE
-------------
JPY
GPB
CAD
EUR
USD
Which query returns the currencies in CURRENCIES that are not present in INVOICES?

A. SELECT currency_ code FROM currencies
MINUS
SELECT currency_ code FROM invoices;

B. SELECT * FROM currencies
WHERE NOT EXISTS (
SELECT NULL FROM invoices WHERE currency_ code = currency_ code);

C. SELECT * FROM currencies
MINUS
SELECT * FROM invoices;

D. SELECT currency_ code FROM currencies
INTERSECT
SELECT currency_ code FROM invoices;

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The foreign key constraint will be enabled and DEFERRED.

B. The primary key constraint will be enabled and DEFERRED.

C. The primary key constraint will be enabled and IMMEDIATE.

D. The foreign key constraint will be enabled and IMMEDIATE.

E. The foreign key constraint will be disabled.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

BOOK_SEQ is an existing sequence in your schema.
Which two CREATE TABLE commands are valid?

A. CREATE TABLE bookings ( bk_id NUMBER(4),
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT (end_date >= start_date));

B. CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL DEFAULT book_seq.CURRVAL,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);

C. CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.CURRVAL,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT start date);

D. CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL PRIMARY KEY,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);

E. CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.NEXTVAL PRIMARY KEY,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT SYSDATE NOT NULL);

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #10

Examine this query:
SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;
What is returned upon execution?

A. an error

B. 3 rows

C. 8 rows

D. 1 row

E. 0 rows

F. 6 rows

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free 1z1-071 Questions for Oracle Database SQL 1z1-071 Exam as PDF & Practice Test Engine

Download Free Oracle 1z1-071 Demo