Free Oracle 1z0-071 Practice Test & Real Exam Questions, Page 4

Question #37

Which three statements about roles are true?

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

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

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. Privileges are assigned to a role using the GRANT statement.

F. A single user can be assigned multiple roles

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

Discussion 0

Correct Answer: E,F,G Vote an answer

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

Question #38

Which two queries execute successfully?

A. SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;

B. SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;

C. SELECT SYSDATE "INTERRVAL '1' DAY FROM DUAL;

D. SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;

E. select INTERVAL '1' DAY +INTERVAL '1' MONTH FROM DUAL;

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #39

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

A. A primary key constraint is manadatory.

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. Creating an external table will automatically create a file using the specified directory and file name.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #40

Which three statements are true about defining relations between tables in a relational database?

A. Every primary or unique key value must refer to a matching foreign key value.

B. Primary key columns allow null values.

C. Unique key columns allow null values

D. Every foreign key value must refer to a matching primary or unique key value.

E. Foreign key columns allow null values.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #41

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

A. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.

B. The WHERE clause can be used to exclude rows before dividing them into groups.

C. Aggregating functions and columns used in HAVING clauses must be specified in these SELECT list of a query.

D. The WHERE clause can be used to exclude rows after dividing them into groups

E. The HAVING clause can be used with aggregating functions in subqueries.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #42

Examine these statements executed in a single Oracle session:
CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20));
INSERT INTO product VALUES(1,'pen');
INSERT INTO product VALUES (2,'pencil');
INSERT INTO product VALUES(3,'fountain pen');
SAVEPOINT a;
UPDATE product SET pcode=10 WHERE pcode =1;
COMMIT;
DELETE FROM product WHERE pcode =2;
SAVEPOINT b;
UPDATE product SET pcode=30 WHERE pcode =3;
SAVEPOINT c;
DELETE FROM product WHERE pcode =10;
ROLLBACK TO SAVEPOINT b;
COMMIT;
Which three statements are true?

A. The code for pen is 10.

B. There is no row containing fountain pen.

C. The code for fountain pen is 3

D. The code for pen is 1.

E. There is no row containing pen

F. There is no row containing pencil.

Discussion 0

Correct Answer: A,E,F Vote an answer

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

Question #43

Examine this query:
SELECT employee_id,first_name,salary
FROM employees
WHERE hire_date>'&1';
Which two methods should you use to prevent prompting for a hire date value when this query is executed?

A. Use the DEFINE command before executing the query.

B. Store the query in a script and pass the substitution value to the script when executing it.

C. Use the UNDEFINE command before executing the query.

D. Execute the SET VERIFY OFF command before executing the query.

E. Replace'&1' with'&&1' in the query.

F. Execute the SET VERIFY ON command before executing the query.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #44

Which two are true about granting privilege on objects?

A. The owner of an object acquires all object privilege on that object by default

B. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table

C. The WITH GRANT OPTION clause can be used only by DBA users

D. An object privilege can be granted to a role only by the owner of that object

E. An object privilege can be granted to other users only by the owner of that object

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #45

Which two are true about queries using set operators such as UNION?

A. An expression in the first SELECT list must have a column alias for the expression

B. In a query containing multiple set operators INTERSECT always takes precedence over UNION and UNION ALL

C. CHAR columns of different lengths used with a set operator retum a vAacsua mhtoe e equals the longest CHAR value.

D. Queries using set operators do not perform implicit conversion across data type groups (e.g. character, numeric)

E. All set operators are valid on columns all data types.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #46

Examine the data in the ENPLOYEES table:

Which statement will compute the total annual compensation tor each employee?

A. SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * monthly_commission_pct) AS annual_comp FROM employees

B. SECECT last_namo, (menthy_salary + monthly_commission_pct) * 12 AS annual_comp FROM employees;

C. SELCECT last_namo, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp FROM employees

D. SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * NVL (monthly_commission_pct, 0)) AS annual_comp FROM employees

Discussion 0

Correct Answer: D Vote an answer

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

Question #47

Examine the description of EMPLOYEES table:
Which three queries return all rows for which SALARY+COMMISSION is greate than 20000?

A. SELECT * FROM employees WHERE salary+NVL2(commission,commission,0)>=20000;

B. SELECT * FROM employees WHERE salary+NULLF(commission,0)>=20000;

C. SELECT * FROM employees WHERE NVL(salary+commission,0)>==20000;

D. SELECT * FROM employees WHERE NVL2(salary)+commission,salary+commission,

E. SELECT * FROM employees WHERE NVL(salary+commission,0)>=20000;

F. SELECT * FROM employees WHERE salary+NVL(commission,0)>=20000;

Discussion 0

Correct Answer: A,B,F Vote an answer

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

Question #48

Examine this query which executes successfully:
SELECT job, deptno FROM emp
UNION ALL
SELECT job, deptno FROM jobs_ history;
What will be the result?

A. It will return rows from both SELECT statements after eliminating duplicate rows.

B. It will return rows common to both SELECT statements.

C. It will return rows from both SELECT statements including duplicate rows.

D. It will return rows that are not common to both SELECT statements.

Discussion 0

Correct Answer: C Vote an answer

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

Free Oracle 1z0-071 Practice Test & Real Exam Questions

Download Free Oracle 1z0-071 Demo