Online Access Free Oracle.1z1-071.v2021-12-09.q323 Practice Test (Page 16)

1z1-071 Exam Question 71

Examine the structure of the PROMOTIONS table: (Choose the best answer.)

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?

A.SELECT DISTINCT promo_cost, promo_category FROM promotions

B.SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

C.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1

D.SELECT promo_category, DISTINCT promo_cost FROM promotions

1z1-071 Exam Question 72

Evaluate the following query

What is the correct output of the above query?

A.+25-00, +00-650, +00 11:12:10.123457

B.+00-300, +54-02, +00 11:12:10.123457

C.+25-00, +54-02, +00 11:12:10.123457

D.+00-300, +00-650, +00 11:12:10.123457

1z1-071 Exam Question 73

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.

1z1-071 Exam Question 74

View the Exhibit and examine the structure of the BOOKS table.

The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:

Which statement is true?

A.Both ROLLBACK commands restore the 100 rows that were deleted.

B.Both ROLLBACK commands restore the 101 rows that were deleted.

C.The first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.

D.The first rollback restores the 101 rows that were deleted and the second rollback causes the row was inserted to be deleted and commits the changes.