A5. Identify week entity in the following scenario: Students registered in a particular course section of a specific course.

A. Course Section B. Course C. Student D. Register A6.

Assume that there were 5 conditions and the first condition is having 3 alternatives, second condition is having 4 alternatives and the remaining conditions are having 2 alternatives then, there would be a maximum of how many columns available in a Decision table?

A. 24 B. 32 C. 120 D. 96 A7.

If you are developing a software for online shopping, then which decision table you will create to implement your logic?

A. Table consists of seller behavior B. Table consists of workers salary C. Table consists of Discount rules D. Table consists of workers commission

A8. The SQL used by front-end application programs to request data from the DBMS by using __________________.

A. DDL B. DML C. DCL D. SCL

A9. Which of the following is true about removing rows from a table?

A. No rows are deleted if you omit the WHERE clause.

B. You cannot delete rows based on values from another table.

C. You cannot delete rows from table

D. You remove existing rows from a table using the DELETE statement

A10. Consider the following schema STUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, MS_subject, percentage_of_marks); Which of the following query would display names of all the students whose MS_subject is English and percentage_of_marks more than 70, or MS_subject is French and percentage_of_marks more than 70?

A. select first_name, last name from students where MS_subject = English or MS_subject = French and percentage_of_marks > 70;

B. select first_name, last name from students where (MS_subject = English or MS_subject = French ) and percentage_of_marks > 70;

C. select first_name, last name from students where (MS_subject = English or MS_subject = French and percentage_of_marks > 70);

D. select first_name, last name from students where (MS_subject = English) or MS_subject = French and percentage_of_marks > 70;