DBMS Ex 1

Match SQL language with SQL commands

1)DDL i)Revok, Grant

2)DML ii)rename a table

3)TCL iii)insert, update

4)DCL iv)rollback , commit

• 1-iii,2-i,3-ii,4-iv

• 1-iii,2-ii,3-iv,4-i

• 1-ii,2-iii,3-iv,4-i

• 1-i,2-iii,3-ii,4-iv

In existing table, ALTER TABLE statement is used to

• Add columns

• Add constraints

• Delete columns

• Delete constrains

• All the above

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

• DELETE FROM table_name;

• DELETE TABLE table_name;

• DROP TABLE table_name;

• None

Correct syntax query syntax to drop a column from a table is

• DELETE COLUMN column_name;

• DROP COLUMN column_name;

• ALTER TABLE table_name DROP COLUMN column_name;

• None is correct.

Which command is used for removing a table and all its data from the database:

• Create command

• Drop table command

• Alter table command

• All of the mentioned

Which Symbol means "All"

• *

• &

• %

• !

Which is the correct query to delete the rows of employees whose exp is less than 10.

• DELETE * FROM EMP WHERE EXP<10;

• DELETE FROM EMP;

• DELETE FROM EMP WHERE EXP<10;

• DELETE FROM EMP WHERE EXP>10;

Question 2

How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

• select first_name,last_name,hire_date, from employee;

• select first_name,last_name and hire_date from employees;

• Select first_name,last_name& hire_date from employees;

• select first_name,last_name,hire_date from employees;

SELECT statement is a ...............in SQL

• Data Control Language(DCL)

• Transcation Control language(TCL)

• Data Manipulation language(DML)

• Data Definition language(DDL)

What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;

• Missing an AND
• Table name
• Capitalize action
• None of these