Oracle 1z0-071 Free Exam Question - Money Back Guarantee

Oracle 1z0-071

https://www.realexamcollection.com/oracle/1z0-071-dumps.html

Practice Test

Oracle - 1z0-071

Question #:1 View the Exhibit and examine the description for the SALES and CHANNELS tables.

You issued this SQL statement:

1 of 8

Practice Test

Oracle - 1z0-071

Which statement is true regarding the result? (Choose the best answer.)

A. The statement will fail because the subquery in the VALUES clause is not enclosed within single quotation marks.

B. The statement will fail because a subquery cannot be used in a VALUES clause.

C. The statement will execute and a new row will be inserted in the SALES table.

D. The statement will fail because the VALUES clause is not required with the subquery.

Answer: C

Question #:2 Examine this SQL statement:

Which two are true?

A. The subquery is not a correlated subquery.

B. The subquery is executed before the DELETE statement is executed.

C. The DELETE statement executes successfully even if the subquery selects multiple rows.

D. The subquery is executed for every row in the EMPLOYEES table.

E. All existing rows in the EMPLOYEES table are deleted.

Answer: B D

Question #:3 Which two are true about granting privileges on objects?

2 of 8

Practice Test

Oracle - 1z0-071

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

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

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

D. The owner of an object acquires all object privileges on that object by default.

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

Answer: C D

Explanation References: Question #:4 Examine the business rule: Each student can work on multiple projects and each project can have multiple students.

You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format: STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which two statements are true in this scenario? (Choose two.)

A. The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.

B. The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships.

C. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

D. PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.

E. An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

Answer: B E

Explanation References:

3 of 8

Practice Test

Oracle - 1z0-071

http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html Question #:5 Which two statements are true about transactions in the Oracle Database server?

A. If a session has an uncommitted transaction, then a DDL statement issues a COMMIT before starting a new transaction.

B. An uncommitted transaction commits automatically if the user exists SQL*Plus.

C. Data Manipulation Language (DML) statements always start a new transaction.

D. A user can always see uncommitted updates made by the same user in a different session.

E. A Data Definition Language (DDL) statement does a COMMIT automatically only for the data dictionary updates caused by the DDL. F. A session can always see uncommitted updates made by itself.

Answer: C F

Question #:6 In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.

Evaluate the following query:

What would be the outcome?

A. Abigail PA B. Abigail Pa C. Abigail IS D. An error message Answer: B

4 of 8

Practice Test

Oracle - 1z0-071

Question #:7 You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)

A. Sequences used in the EMPLOYEES table become invalid.

B. If there is an uncommitted transaction in the session, it is committed.

C. All indexes and constraints defined on the table being dropped are also dropped.

D. The space used by the EMPLOYEES table is always reclaimed immediately.

E. The EMPLOYEES table can be recovered using the ROLLBACK command.

F. The EMPLOYEES table may be moved to the recycle bin.

Answer: B C F

Question #:8 View the exhibit and examine the data in the PROJ_TASK_DETAILS table.

The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them.

The BASED_ON column indicates dependencies between tasks.

Some tasks do not depend on the completion of other tasks.

You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of

5 of 8

Practice Test

Oracle - 1z0-071

the employee in charge of the task upon which it depends.

Which query would give the required result? (Choose the best answer.)

A. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.task_id = d.task_id); B. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p FULL OUTER JOIN proj_task_details dON (p.based_on = d.task_id); C. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.based_on = d.task_id); D. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p LEFT OUTER JOIN proj_task_details dON (p.based_on = d.task_id); Answer: D

Question #:9 Examine the data in the CUST_NAME column of the CUSTOMERS table:

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 SUBSTR (cust_name, INSTR (cust_name, ‘’) +1) LIKE ‘Mc%’ B. WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, ‘’)+1)) IN (‘MC%’, ‘Mc%) C. WHERE UPPER (SUBSTR (cust_name, INSTR(cust_name, ‘’)+1)) LIKE UPPER (‘MC%’) D. WHERE SUBSTR (cust_name, INSTR (cust_name, ‘’) +1) LIKE ‘Mc%’ OR ‘MC%’ E. WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, ‘’)+1)) LIKE ‘Mc%’ Answer: A

6 of 8

Practice Test

Oracle - 1z0-071

Question #:10 View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

Evaluate this SQL statement: SELECT TO_CHAR(list_price,'$9,999')

7 of 8

Practice Test

Oracle - 1z0-071

From product_information; Which two statements are true regarding the output? (Choose two.)

A. A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.

B. A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.

C. A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.

D. A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.

Answer: A C

https://www.realexamcollection.com/oracle/1z0-071-dumps.html

8 of 8