Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

• A.First normal form
• B.Second normal form
• C.Fourth normal form
• D.Third normal form

Comment: *

Name: *

Email: *

Verification: *

Examine the business rule:
Each student can take up 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?

• A.PROJECT_ID must be the primary key in the projects entity and foreign key in the STUDENTS entity.
• B.An associative table must be created with a composite key of STUDENT_ID andPROJECT_ID; which is the foreign key linked to theSTUDENTSandPROJECTSentities.
• C.The ERD must have a1:M relationship between the students and projects entitles.
• D.The ERD must have a M:M relationship between the students and projects entities that must be resolved into 1:M relationships.
• E.STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the projects entity.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result? (Choose two.)

• A.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
• B.The values in all columns would be returned in descending order.
• C.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
• D.The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
• E.The values in the FIRST_NAME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

• A.Self-join
• B.Left outer-join with self-join
• C.Subquery
• D.Right outer-join with self-join
• E.Full outer-join with self-join

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDERSand ORDER_ITEMStables.
ORDER_IDis the primary key in the ORDERStable. It is also the foreign key in the ORDER_ITEMStable wherein it is created with the ON DELETE CASCADEoption.
Which DELETEstatement would execute successfully?

• A.DELETE order_id
  FROM orders
  WHERE order_total < 1000;
• B.DELETE orders o, order_items i
  WHERE o.order_id = i.order_id;
• C.DELETE
  FROM orders
  WHERE (SELECT order_id
  FROM order_items);
• D.DELETE orders
  WHERE order_total < 1000;

Comment: *

Name: *

Email: *

Verification: *