Database management system

Write your name, class and roll number.

DBMS means ______________________________________________

Drop table statement

• deletes the table structure only

• deletes the table structure along with the table data

• works whether or not referential integrity constraints would be violated

• is not an SQL statement

Which of the following is not true about the ALTER TABLE statement?

• It can add a new row.

• It can add a new column

• It can modify existing columns

• It can define a default value for the new column

Here which of the following displays the unique values of the column?

SELECT ________ dept_name FROM instructor;

• All

• From

• Distinct

• Name

Which of the following query would display all the students whose first name starts with the character ‘A’?

• select first_name from students where first_name like ‘A%’;

• select first_name from students where first_name like ‘%A’;

• select first_name from students where first_name like ‘%A%’;

• select first_name from students where first_name like ‘A’;

This is an example of ________________

• Data inconsistency

• Data redundancy

• Data security

• Data consistency

In the __________ normal form, a composite attribute is converted to individual attributes

• First Normal Form

• Second Normal Form

• Third Normal Form

• Fourth Normal Form

SELECT * FROM employee WHERE salary>10000 AND dept_id=101;

Which of the following fields are displayed as output?

• Salary, dept_id

• Employee

• Salary

• All the field of employee relation

Which of the following is not a level of data abstraction?

• Physical Level

• Critical Level

• Logical Level

• View Level