This set of RDBMS test focuses on “Decomposition Using Functional Dependencies”. 1. An instance of a relation that satisfies all real world constraints is known as? a) Proper relation b) Ideal relation c) Perfect relation d) Legal relation 2. If K → R then K is said to be the _______ of R a) Candidate … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Features of Good Relational Designs”. 1. Which of the following is not a feature of a good relational design? a) Specifying primary keys b) Specifying foreign keys c) Preserving integrity constraints d) Allowing redundancy of attributes 2. The dependency rules specified by the … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Extended ER Features”. 1. The process of designating sub groupings within the entity set is called as _______ a) Specialization b) Division c) Aggregation d) Finalization 2. State true or false: Specialization can be applied only once a) True b) False 3. Which … Read more
This set of RDBMS Interview Questions and Answers for Experienced people focuses on “Reduction to Relational Schema”. 1. For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema a) First attribute b) Primary key c) Foreign key d) None of the mentioned 2. … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Entity Relationship Diagrams”. 1. Which of the following symbols represent entity sets in an ER diagram? a) Divided rectangles b) Diamonds c) Lines d) Undivided rectangles 2. Which of the following symbols represent relationship sets in an ER diagram a) Divided rectangles b) … Read more
This set of RDBMS Questions and Answers for Experienced people focuses on “Entity Relationship Model”. 1. The _________ of the entity set is an actual collection of entities belonging to that entity set. a) Extension b) Intention c) Description d) Availability 2. A ___________ is an association among several entities. a) Relationship b) Association c) … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Relational Algebra”. 1. Which of the following is not a relational algebra function? a) Select b) Project c) Manipulate d) Union 2. The select operation’s function in relational algebra is identical to the _______ clause in SQL a) where b) from c) select … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “OLAP”. 1. What is the full form of OLAP? a) Online Application Programming b) Online Application Processing c) Online Analytical programming d) Online Analytical Processing 2. Data that can be modelled as dimension attributes and measure attributes are called ___________ a) Mono-dimensional data … Read more
This set of RDBMS Interview Questions and Answers for freshers focuses on “Accessing Sql from a Programming Language”. 1. Which of the following is/are a function of dynamic SQL? a) Allowing a program to construct an SQL query in a character string b) Submitting the query c) Retrieving the result into the program variables a … Read more
This set of RDBMS Questions and Answers for Freshers focuses on “Sql Data Types and Schemas”. 1. Which of the following is not a valid Date and Time data type? a) date b) time c) datestamp d) timestamp 2. What is a timestamp? a) A combination of date and time with date first b) A … Read more
