Question 1

Examine this business rule:

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

You must decide an Entity Relationship (ER) model for optional data storage and allow generating reports in

this format:

STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which

two statements are true?

Options :

A :

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.

B :

The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.

C :

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

D : The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.

E :

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

Answer: A,B

Question 2

Examine the description of the PRODCTS table which contains data:

Which two are true?

Options :

A : The PROD ID column can be renamed.

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

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

D : The EXPIRY DATE column cannot be dropped.

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

Answer: A,C

Question 3

Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

Options :

A : SELECT join_date FROM employees WHERE join_date > ’10-02-2018’;

B : SELECT salary + ‘120.50’ FROM employees;

C : SELECT SUBSTR(join_date, 1, 2) – 10 FROM employees;

D : SELECT join_date + ‘20’ FROM employees;

E : SELECT join_date || ‘ ‘ || salary FROM employees;

Answer: D

Question 4

Which two statements cause changes to the data dictionary?

Options :

A : DELETE FROM scott. emp;

B : GRANT UPDATE ON scott. emp TO fin manager;

C : AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

D : TRUNCATE TABLE emp:

E : SELECT * FROM user_ tab._ privs;

Answer: B,D

Question 5

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

Options :

A :

A table can have only one primary key but multiple foreign keys.

B :

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

C :

Primary key and foreign key constraints can be defined at both the column and table level.

D :

Only the primary key can be defined the column and table level.

E :

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.

F :

The foreign key columns and parent table primary key columns must have the same names.

G :

A table can have only one primary key and one foreign key.

Answer: A,C,E