Q.1
Insert the appropriate key word in the blank in the query ( A is a relation)
  • a) all
  • b) from
  • c) with
  • d) in
Q.2
How many relations can a delete command operate on?
  • a) 0
  • b) 1
  • c) 2
  • d) Infinitely many
Q.3
What is the result of the following query? DELETE FROM student WHERE marks < (SELECT avg(marks) FROM student);
  • a) The query deletes all the tuples whose marks are greater than the average marks
  • b) The query deletes all the tuples whose marks are less than the average marks
  • c) The query deletes all the values under the marks attribute which are less than the average
  • d) The query is syntactically wrong and does not execute
Q.4
What is the format of entering date into a database while inserting data into it?
  • a) YYYY-MM-DD
  • b) “YYYY-MM-DD”
  • c) ‘YYYY-MM-DD’
  • d) “DD-MM-YYYY”
Q.5
Choose the correct option regarding the following query INSERT INTO course ('CS-, 'course name', 'any' , 5);
  • a) Data is inserted into the course relation
  • b) Data is not inserted into the course relation due to incorrect specification
  • c) Data is inserted into the CS-67 relation
  • d) Data is not inserted due to the incorrect use of syntax
Q.6
To change a value in a tuple without changing all the values in the tuple, we use the _____ statement
  • a) insert
  • b) insert some
  • c) update
  • d) alter
Q.7
What does the following query do? UPDATE student SET marks = marks*1.10;
  • a) It increases the marks of all the students by 10%
  • b) It decreases the marks of all the students by 90%
  • c) It increases the marks of all the students by 110%
  • d) It is syntactically wrong
Q.8
State true or false: We cannot write a where clause under an update command
  • a) True
  • b) False
Q.9
Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause
  • a) where
  • b) with
  • c) set
  • d) end
Q.10
Which of the following cannot be used to modify the data in a database
  • a) update
  • b) insert
  • c) delete
  • d) drop
0 h : 0 m : 1 s