Opening the paper…

Database Management Systems, End Term

May 2022 term, 7 Aug 2022, Set QPB1

Learning mode

Question 1

+1−0Single correct

Select one option

A.
1
B.
2
C.
3
D.
4

Report a problem

to report a problem with this question.

Choose a question

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 24

Discussion

Submit this paper?

You cannot change your answers after submitting.

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 2

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 2

Save & Next moves to the next question. Answers are saved as you go.
Mark for Review & Next flags the question to come back to. A flagged answer still counts.
Clear Response removes your answer to the question on screen.
The ← and → keys move to the previous and next question.

Figure from the original question paper Consider a relational schema **student**(*roll\_no, name, class*).\ In order to change the data type of *roll\_no*, which of the following category of SQL command is used for this purpose? A role **Department\_Lead** has the privilege of select, insert and delete on all the tables of the database. A new role **Employee1** is created, and the following statement is executed. grant Department\_Lead to Employee1\ What privileges will be inherited by **Employee1**?