This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Integrity Constraints”. 1. Which of the following is not an integrity constraint? a) not null b) unique c) identical d) check 2. What is the function of the not null constraint? a) It prevents illegal data from being entered into the database b) … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Views and Transactions”. 1. What is a view? a) An brief description of the schema diagram. b) A relation that is not a part of the schema but is a virtual relation c) Any relation that is a part of the schema d) … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Join Expressions”. 1. The on condition appears at the _______ of the join expression a) Beginning b) End c) Between d) The on condition is not related to join expression 2. What is the difference between a join and an outer join operation? … Read more
This set of RDBMS Interview Questions and Answers focuses on “Modification of Database”. 1. Insert the appropriate key word in the blank in the query ( A is a relation) delete ______ A where P < 5; a) all b) from c) with d) in 2. How many relations can a delete command operate on? … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Nested SubQueries”. 1. What is a subquery? a) A subquery is a select-from-where expression that is nested within another query b) A subquery is any query that is nested within another query c) A subquery is a relation that is externally specified which … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Aggregate Functions”. 1. Which of the following is not a built in aggregate function in SQL? a) avg b) max c) total d) count 2. Observe the given SQL query and choose the correct option. SELECT branch_name, COUNT (DISTINCT customer_name) FROM depositor, account … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Set Operations”. 1. What is the function of the union operation? a) It combines the results of any two different queries b) It combines the results of two different queries which have the same set of attributes in the select clause c) It … Read more
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> 2. Which of the following keywords is used beside … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “SQL Data Definition”. 1. Which of the following information does an SQL DDL not specify? a) The schema for each relation b) The integrity constraints c) The operations on the tuples d) The security and authorization information for each relation 2. Which of … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Introduction to the Relational Model”. 1. Choose the correct statement regarding superkeys a) A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple b) A superkey is a tuple or a set of multiple tuples that … Read more
