RDBMS Questions and Answers – Basic Operations

This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Basic Operations”.

1. Which of the following syntax of the basic query is correct?
a) select <relation> from <attribute>
b) select <attribute> from <elation>
c) select <tuple> from <relation>
d) select <tuple> from <attribute>
View Answer

2. Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?
a) all
b) not unique
c) notnull
d) include
View Answer

3. Which of the following logical connectives is not included in SQL?
a) and
b) or
c) nor
d) not
View Answer

4. The where clause is a predicate involving attributes of the relation in the ______ clause.
a) select
b) from
c) with
d) none of the mentioned
View Answer

5. select distinct dept_name
from institute;

What does the above query do?
a) It gives all the tuples having a distinct dept_name
b) It gives the dept_name attribute values of all tuples without repetition
c) It gives all the dept_name attribute of all the tuples
d) It gives all the tuples having a null value under the dept_name attribute
View Answer

6. What does the following query do?
select name, ID, branch
from student, department
where student.branch = department.branch;
a) It gives all values of name, ID, branch from both the relations only if all those attributes are present in both
b) It gives all values of name, ID, branch from their respective relations
c) It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same
d) It gives the values of name, ID, branch from their respective relations where all the values are matching with each other
View Answer

7. The ________ clause is used to list the attributes desired in the result of a query
a) select
b) from
c) where
d) create
View Answer

8. If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be?
a) The natural join of both the relations
b) The left outer join of both the relations
c) A syntactical error
d) The Cartesian product of both the relations
View Answer

9. State true or false: Multiple conditions in the where clause are separated by a “,”
a) True
b) False
View Answer

10. What does the natural join operation do?
a) It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations
b) It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations
c) It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations
d) None of the mentioned
View Answer

11. Observe the following query and choose the correct option.
select name, ID
from student natural join department natural join section
a) The query is syntactically wrong because there is no where clause
b) The query is syntactically wrong because there are more than one attributes in the select clause
c) The query is syntactically wrong because more than one relations are included in the natural join operation
d) The query is correct
View Answer

12. Which keyword is used to rename a relation in a query?
a) rename
b) as
c) is
d) to
View Answer

13. While operating with strings, what does “_ _ _%” match with?
a) A string of three letters
b) A string of at least three letters
c) A string of three words
d) A string of at least three words
View Answer

Sanfoundry Global Education & Learning Series – RDBMS.

To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]