Question 1
1
2
3
4
Question 2
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?
DML
TCL
DDL
DCL
Question 3
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?
All privileges - select, insert and delete
Only update
Only select and insert
Only delete and update
22 more questions in this paper
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
More on the DBMS End Term 7 Aug 2022 Set QPB1 paper
The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 7 Aug 2022, in the May 2022 term, set QPB1: 25 questions for 50 marks in 180 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | DBMS End Term 7 Aug 2022 Set QPB1 at a glance |
|---|---|
| Term | May 2022 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 25 |
| Marks | 50 |
| Duration | 180 min |
| MCQ | 16 |
| MSQ | 7 |
| Numerical | 2 |
| Official paper | IIT M FOUNDATION DIPLOMA ENDTERM QPD1 07 Aug 2022 IBA NS |
| Negative marking | No negative marking. |
| Updated |