Latest Oracle 1z0-071 Actual Free Exam Questions & Community Discussion, Page 7

Question #79

You must find the number of employees whose salary is lower than employee 110.
Which statement fails to do this?

A. SELECT COUNT (* )
FROM employees
WHERE salary < (SELECT salary FROM employees WHERE employee_id =
110) ;

B. SELECT COUNT (* )
FROM employees e
WHERE e. salary < (SELECT a. salary FROM employees a WHERE e. employee_id = 110);

C. SELECT COUNT (*)
FROM employees
JOIN employees a
ON e. salary< a. salary
WHERE a. employee_id= 110;

D. SELECT COUNT (*)
FROM employees e
JOIN (SELECT salary FROM employees WHERE employee_id= 110) a
ON e. salary< a. salary;

Discussion 0

Correct Answer: B Vote an answer

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

Question #80

Examine the description of the PRODCTS table which contains data:

Which two are true?

A. The PROD_ ID column data type can be changed to VARCHAR2 (2).

B. The EXPIRY DATE column cannot be dropped.

C. The EXPIRY DATE column data type can be changed to TIME STAMP.

D. The PROD NAME column cannot have a DEFAULT clause added to it.

E. The PROD ID column can be renamed.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #81

Which statement falls to execute successfully?

A. SELECT *
FROM employees e
JOIN departments d
ON d.departments_id=90
WHERE e.department_id=d.department_id;

B. SELECT *
FROM employees e
JOIN department d
WHERE e.department_id=d.department_id
AND d.department_id=90;

C. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
WHERE d.department_id=90;

D. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
AND d.department_id=90;

Discussion 0

Correct Answer: B Vote an answer

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

Question #82

Refer to the exhibit.

Which two queries only return CUBE?

A. SELECT shape FROM bricks JOIN boxes ON weight >= min_weight AND weight < max_weight;

B. SELECT shape FROM bricks JOIN boxes ON weight BETWEEN min_weight AND max_weight;

C. SELECT shape FROM bricks JOIN boxes ON NOT (weight > max_weight);

D. SELECT shape FROM bricks JOIN boxes ON weight > min_weight;

E. SELECT shape FROM bricks JOIN boxes ON weight < max_weight;

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #83

Examine this incomplete query:
SELECT DATA'2019-01-01'+<INTERVAL CLAUSE>
FROM DUAL;
Which three clauses can replace<INTERVAL CLAUSE>ti add 22 hours to the date?

A. INTERVAL'11:60'HOUR TO MINUTE

B. INTERVAL '12:00'

C. INTERVAL'0 12'DAY TO HOUR

D. INTERVAL'720'MINUTE

E. INTERVAL'12' HOUR

F. INTERVAL'0,5'DAY

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Question #84

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 that are not common to both select statements.

B. It will return rows both select statements including duplicate rows.

C. It will return rows from both select statements after eliminating duplicate rows.

D. It will return rows common to both select statements.

Discussion 0

Correct Answer: B Vote an answer

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

Question #85

SELECT *
FROM bricks,colors;
Which two statements are true?

A. It returnsthe same rows as SELECT * FROM bricks CROSS JOIN colors.

B. You can add a USING clause with a join condition.

C. You can add an ON clause with a join condition.

D. It returns the number of rows in BRICKS plus the number of rows in COLORS.

E. You can add a WHERE clause with filtering criteria.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #86

Which two statements are true about outer Joins?

A. The outer join operator (+) can be used on both sides of the join condition in an outer join.

B. An outer join is used to retrieve only the rows that do not meet the join condition.

C. The IN operator cannot be used in a condition that Involves an outer join.

D. A condition representing an outer join cannot be linked to another condition using the or logical operator.

E. The outer join operator (+) is used next to the column of the table without the matching rows.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #87

Examine the description of the EMPLOYEES table:

Which two statements will run successfully?

A. SELECT 'The first_name is '''||first_name ||'''' FROM employees ;

B. SELECT 'The first_name is \'' || first_name || '\'' FROM employees;

C. SELECT 'The first_name is '' || first_name || '' FROM employees ;

D. SELECT 'The first_name is '|| first_name|| '' FROM employees;

E. SELECT 'The first_name is ''' ||first_name||''' FROM employees ;

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #88

Which two statements are true about Oracle synonyms?

A. All private synonym names must be unique in the database.

B. A synonym can be created on an object in a package.

C. A synonym has an object number.

D. Any user can create a public synonym.

E. A synonym can have a synonym.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #89

Which two actions can you perform with object privileges?

A. Create roles.

B. Execute a procedure or function in another schema.

C. Set default and temporary tablespaces for a user.

D. Delete rows from tables in any schema except sys.

E. Create FOREIGN KEY constraints that reference tables in other schemas.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #90

The SYSDATE function displays the current Oracle Server date as:
21 -MAY-19
You wish to display the date as:
MONDAY, 21 MAY, 201 9
Which statement will do this?

A. SELECT TO_ CHAR (SYSDATE, ' FMDAY, DDTH MONTH, YYYY') FROM DUAL;

B. SELECT TO_ CHAR (SYSDATE, ' FMDD, DAY MONTH, YYYY') FROM DUAL;

C. SELECT TO _ CHAR (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

D. SELECT TO _ DATE (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

Discussion 0

Correct Answer: C Vote an answer

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

Question #91

which is true about the round,truncate and mod functions>?

A. TRUNC(MOD(25,3),-1) IS INVALID.

B. ROUND(MOD(25,3),-1) IS INVALID

C. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.

D. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.

Discussion 0

Correct Answer: C Vote an answer

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

Oracle 1z0-071 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z0-071 Demo