MCQGeeks
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Rdbms
Rdbms Interview
Quiz 1
Solution
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
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page