Oracle 1Z0-071 Quiz 4 Topic 3 Questions 16-20

Question: 1

Examine this statement:

q1_1Z0-071

On which two columns of the table will an index be created automatically?

ASTATUS

BORDER_ID

CPRODUCT_ID

DSERIAL_NO

EORDER_TOTAL

FORDER_DATE

Show Answer

Question: 2

Which statement fails to execute successfully?

A)

q2_1Z0-071

B)

q2_1Z0-071

C)

q2_1Z0-071

D)

q2_1Z0-071

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 3

Examine this business rule:

Each student can work on multiple projects and each project can have multiple students. _

You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:

STUDEN_ID FIRST_NAMK LASTNAME PROJECT_ID PROJECT_NAME PROJECT_TASK

Which two statements are true?

AThe ER must have a many-to-many relationship between the students and projects entitles tb.it must be resolved Into one-to-many relationships.

BAn associative table must be created with a composite key of student_id and project_id, which is the foreign key linked to the Stand projects entitles.

CSTUDENT_ID must be the primary key In the students entity and foreign key In the projects
entity.

DPORJECTI_ID must be the primary key In the projects entity and foreign key in the students
The ER must have a one-to-many relationship between the students and projects entitles.

Show Answer

Question: 4

Which three; statements are true about built-in data types?

AA char column definition does not require the length to be specified.

BA BFILE stores unstructured binary data In operating system files.

CA varchar2 column definition does not require the length to be specified.

DA varchar2 blank pads column values only if the data stored Is non-numeric and contains no Special characters.

EThe default length for a char column Is always one character.

FA blob stores unstructured binary data within the database.

Show Answer

Question: 5

Which two statements are true about current_timestamp?

AIt returns the same date as CURRENT_date.

BThe time is In the time zone of DBTIMEZONE.

CThe value varies depending on the setting of SESSIONTIMEZONE.

DIt returns a value of data type timestamp.

EIt always returns the same value as SYSTIMESTAMP.

FThe date Is In the time zone of DBTIMEZONE.

Show Answer

Oracle 1Z0-071 Quiz:4 Topic:3 Questions:16-20