dbms quiz kitsw

In SQL, which command is used to add new rows to a table?

• Alter

• Insert

• create

• drop

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

• critical level

• view level

• physical level

• logical level

SELECT title

FROM teacher

WHERE fees <= 200000 AND fees >= 80000;

We can replace this query by which of these?

• SELECT title

  FROM teacher

  WHERE fees BETWEEN 200000 AND 80000;

• SELECT title

  FROM staff

  WHERE fees BETWEEN 80000 AND 200000;

• SELECT title

  FROM staff

  WHERE fees <= 80000 AND fees >=200000;

• SELECT title

  FROM teacher

  WHERE fees BETWEEN 80000 AND 200000;

Keys involved in relationship between tables is called

• primary key

• super key

• Foreign key

• none

DDL stands for

• 1. Database Definition Level

• None of the above

• 1. Data Definition Language

• Data device latency

………. keyword is used to find the number of values in a column.

• sum

• count

• total

• average

Write a query to find the names of employees of Firstname field that begin with ‘S’ from Employee table

Do we plan this type of exam in every week of our lab

• yes

• no

Write an SQL query to find the maximum, minimum, and average salary of the employees from Employee table

List the record of all the employees in decreasing value of their salary from Employee table