Database management systems - basics and ER modelling quiz

Database management system quiz - DBMS quiz with answers - DBMS multiple choice questions - DBMS basics quiz - DBMS interview questions - ER modelling quiz in DBMS - ER modelling in Database interview questions

QUIZ

1. _________ attribute can uniquely identify a record (row/tuple) in a table (relation).
(a) Partial key	(b) Candidate key
(c) Foreign key	(d) All of the above
2. Which of the following is used to logically connect a table with the other?
(a) Super key	(b) Candidate key
(c) Unique key	(d) Primary key
3. One driver drives one or more cars, and one car is driven by one or more drivers. What type of relationship is this?
(a) One-to-one	(b) One-to-many
(c) Many-to-one	(d) Many-to-many
4. A customer can have one or more vehicles and a vehicle is owned by exactly one customer. What type of relationship exists between customer and vehicle?
(a) One-to-one from customer to vehicle	(b) One-to-many from customer to vehicle
(c) Many-to-one from customer to vehicle	(d) Many-to-many from customer to vehicle
5. A cricket player can play for exactly one team, and a team can consist of several players. What type of relationship exists between team and player from team to player?
(a) One-to-one	(b) One-to-many
(c) Many-to-one	(d) Many-to-many
6. __________ schema defines the view(s) of a relation to the end users.
(a) Conceptual schema	(b) External schema
(c) Physical schema	(d) Logical schema
7. What type of relationship would exist between Tourist entity set and Passport entity set?
(a) One-to-one	(b) One-to-many
(c) Many-to-one	(d) Many-to-many
8. If a strong entity set A of an ER diagram contains a multi-valued attribute, then which one of the following is true?
(a) Reducing A into relation must not contain that multi-valued attribute	(b) A separate relation has to be created for multi-valued attribute
(c) A cannot be in 1NF, if that multi-valued attribute is included with A.	(d) All of them are TRUE
9. An author can write many books, in turn, a book can be written by at most one author. What type of relationship would exist between Author and Book entity sets?
(a) One-to-one from Book to Author	(b) One-to-many from Author to Book
(c) Many-to-one from Book to Author	(d) Both (b) and (c)
10. A candidate key is a key _____________ .
(a) that uniquely identify any rows in a table.	(b) that is redundant
(c) that cannot uniquely identify any rows in a table.	(d) None of the above

Go to ER modeling quiz page

Go to QUIZZ in Database / DBMS / Advanced DBMS page

DBMS General - Quiz

Relational Database Design Quiz

1. In the relational modes, what do we mean by the term “Cardinality”?

Number of tuples
Number of attributes
Number of tables
Number of constraints

2. In relational algebra, Cartesian product is a ___________ operator?

Unary operator
Binary operator
Ternary operator
None of the above

3. Which of the following is an example of procedural language?

Relational calculus
Relational algebra
SQL
All of the above

4. ODBC stands for _________ .

Object Database Connectivity
Open Database Connectivity
Oracle Database Connectivity
Orient Database Connectivity

5. A database schema can be defined using which of the following languages?

DML
DCL
DDL
TCL

6. ________ is used as the defacto standard language to interact with the database.

SQL
DDL
NoSQL
None of the above

7. A Cartesian product of two relations is the same as their union. TRUE/FALSE.

TRUE
FALSE

8. Data independence means

Data is defined separately and not included in programs
Programs are not dependent on the physical attributes of data
Programs are not dependent on the logical attributes of data
Both B and C

9. Which of the following is used to represent the relationships between two relations (tables)?

Primary key
Secondary key
Foreign key
Surrogate key

10. The file organization that provides very fast access to any arbitrary record of a file is ___ .

Hashed file
Unordered file
Ordered file
Clustered file

Score =

Correct answers:

Entity Relationship Model Quiz

Relational model and Normalization Quiz

1. Cardinality in an ER or UML diagram can specify lower and upper limits to numbers of participants in a relationship. TRUE / FALSE?

TRUE
FALSE

2. An Attribute domain is a set of values that might be assigned to an attribute. TRUE/FALSE?

TRUE
FALSE

3. An entity that is existence-dependent on some other entity type is strong entity . TRUE/FALSE?

TRUE
FALSE

4. A Candidate key is an attribute or set of attributes that uniquely identifies individual occurrences of an entity type. TRUE/FALSE?

TRUE
FALSE

5. Degree of a relationship is always 1. TRUE/FALSE?

TRUE
FALSE

6. Relationships can’t have attributes . TRUE/FALSE?

TRUE
FALSE

7. A Composite key is a candidate key that consists of two or more attributes . TRUE/FALSE?

TRUE
FALSE

8. An ER diagram’s purpose is to support a user’s perception of the data and conceal the technical aspects associated with database design . TRUE/FALSE?

TRUE
FALSE

9. Entity Relationship diagram aims to facilitate database design. TRUE/FALSE?

TRUE
FALSE

10. In a one-to-many relationship, the entity that is on the one side of the relationship is called a parent entity. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers:

Structured Query Language Quiz

Relational model and Normalization Quiz

1. In a CREATE TABLE statement, each column/attribute must have a data type associated with it. TRUE / FALSE?

TRUE
FALSE

2. Referential integrity ensures that a value stored in the foreign key attribute matches a primary key attribute in the referred table. TRUE/FALSE?

TRUE
FALSE

3. A view is part of the external schema and is considered as an acceptable way to offer simpler tables with customized attribute names to the user. TRUE/FALSE?

TRUE
FALSE

4. A view can be referred to like a table in a SELECT. TRUE/FALSE?

TRUE
FALSE

5. Besides a shorthand reference to the table throughout the query, using an alias makes the query run much faster as a result. TRUE/FALSE?

TRUE
FALSE

6. Deleting from a view that is based on a natural join of its base tables is acceptable. TRUE/FALSE?

TRUE
FALSE

7. If both NOT NULL and UNIQUE integrity constraints are defined on an attribute, the designation implies that the attribute is a candidate key. TRUE/FALSE?

TRUE
FALSE

8. An INSERT requires the input values sequence to match the attribute sequence when the attributes are specified in the INSERT statement. TRUE/FALSE?

TRUE
FALSE

9. The SQL SELECT statement includes the sequence of steps to exectue a query besides the operations that the server uses to answer the query. TRUE/FALSE?

TRUE
FALSE

10. Triggers provide a mechanism to monitor specific changes to a table and perform additional actions based on the altered data. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers:

Three levels in database system architecture quiz

Relational model and Normalization Quiz

1. The layout of the data within the disk file system is found at the logical/conceptual level. TRUE / FALSE?

TRUE
FALSE

2. There is exactly one schema at the conceptual level for a database. TRUE/FALSE?

TRUE
FALSE

3. There is exactly one schema at the external level of a database. TRUE/FALSE?

TRUE
FALSE

4. A user’s access to the database can be limited by the schema at the external level. TRUE/FALSE?

TRUE
FALSE

5. The indexing schemes for each table is found at the external level. TRUE/FALSE?

TRUE
FALSE

6. The mappings between the levels provides for program-data independence. TRUE/FALSE?

TRUE
FALSE

7. The mapping between the external and logical levels provides various views to the users. TRUE/FALSE?

TRUE
FALSE

8. The levels in the architecture in sequence is logical-external-physical. TRUE/FALSE?

TRUE
FALSE

9. A physical schema is typically derived from the logical schema. TRUE/FALSE?

TRUE
FALSE

10. An Entity-Relationship model will map most closely to the logical schema. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers:

Quiz on normalization and functional dependency 6

Relational model and Normalization Quiz

1. Functional dependency analysis helps in the normalization of a relational schema. TRUE / FALSE?

TRUE
FALSE

2. Normalization attempts to reduce redundant information that are stored as part of a relation. TRUE/FALSE?

TRUE
FALSE

3. Redundancy is at the root of insertion and deletion anomalies in a relational database. TRUE/FALSE?

TRUE
FALSE

4. A null value has exactly one interpretation, ie., one meaning. TRUE/FALSE?

TRUE
FALSE

5. A functional dependency is a relationship between an attribute "Y" and a determinant (1 or more other attributes) such that for a given value of a determinant the value of the attribute Y is uniquely defined. TRUE/FALSE?

TRUE
FALSE

6. Functional dependencies can be found out algorithmically (automatically) by analysis of the relation. No semantic analysis is required. TRUE/FALSE?

TRUE
FALSE

7. In practical terms, we want non-key attributes to be functionally dependent on the primary key in any relation. TRUE/FALSE?

TRUE
FALSE

8. Transitivity of functional dependencies means that if a →b and a→c then c→b. TRUE/FALSE?

TRUE
FALSE

9. Decomposition of functional dependencies would mean that if a→bc then a→b and a→c. TRUE/FALSE?

TRUE
FALSE

10. Functional dependencies are reflexive, i.e., if a →b then b →a. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers:

Relational model and Normalization Quiz 5

Relational model and Normalization Quiz

1. One or more columns of a composite primary (a primary key that comprises of more than one attribute) key can be allowed to have NULL values. TRUE / FALSE?

TRUE
FALSE

2. A foreign key of any table must refer to the primary key of its base table. TRUE/FALSE

TRUE
FALSE

3. The value of a foreign key attribute A of table R that refers to table S cannot be NULL if which of the following holds?

If attribute A is part of a primary key attribute in R
If attribute A refers the primary key of S
If attribute A is UNIQUE
If either a or b or both holds

4. An attribute must contain only values consistent with the defined data format of that particular attribute is called

Entity integrity
Referential integrity
User-defined integrity
Column integrity

5. The __________ property ensures that any instance of the original relation can be identified from corresponding instances of the smaller relations.

Lossless-join
Lossy-join
Both a and b
None of the above

6. In a functional dependency AB --> C, which of the following is true?

A is Determinant of C
B is Determinant of C
Both A and B together Determine C
All of the above

7. Which of the following is also called as Subset dependencies?

Entity integrity constraints
Referential integrity constraints
User-defined integrity constraints
Column integrity constraints

8. The determinant of a functional dependency refers to the attribute, or group of attributes, on the left-hand side of the arrow.

TRUE
FALSE

9. Assume a set of functional dependencies F = {Regno Name --> Gender, Regno --> Department, Regno --> Gender, Name --> Branch}. Here, Regno Name --> Gender is,

Gender is fully funcionally dependent on Regno and Name
Gender is partially funcionally dependent on Regno and Name
Name and branch together form the primary key
None of the above

10. _____________ ensure that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation.

Referential integrity constraints
Weak entity sets
Entity integrity constraints
None of the above

Score =

Correct answers:

DBMS Basics and ER Model Quiz 7

Entity-Relationship Modeling Quiz 1

1. In a Entity-Relationship data model, an entity becomes a(n) _____________

Attribute
Table
Constraint
Column

2. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

Procedural DML
Non-Procedural DML
Procedural DDL
Non-Procedural DDL

3. Which of the following data model is widely applied in many real world database applications?

Network model
Relational model
Hierarchical model
None of the above

4. The logical design of the database is database __________, a snapshot of the data in the database at a given instant in time is database ________.

Instance, Schema
Relation, Schema
Relation, Domain
Schema, Instance

5. The tuples (records) of the relations (tables) can be of ________ order.

Any
Ascending
Sorted
Descending

6. Which of the following is the collection of interrelated data and set of program to access them?

Data structure
Database
DBMS
Programming Language

7. Database management systems are intended to

Eliminate data redundancy
Establish relationships among records in different files
Manage file access
All of the above

8. ________________defines the database schema, Interacts continuously with users, defines integrity and security checks, defines procedures for backup and recovery

Sophisticated User
Naïve User
DBA
Application Programmer

9. The number of tuples in a relation is called __________ of a relation.

Cardinality
Degree
Tuple
Key

10. The number of attributes (columns) in a relation is called __________ of a relation.

Cardinality
Degree
Tuple
Key

Score =

Correct answers:

DBMS Basics and ER Model Quiz 6

Entity-Relationship Modeling Quiz 1

1. According to the levels of data abstraction, the schema at the intermediate level is called

Logical schema
Physical schema
Subschema
Conceptual schema

2. It is an abstraction through which relationships are treated as higher level entities

Generalization
Specialization
Aggregation
Inheritance

3. ___________ creates the metadata.

DML compiler
DML pre-processor
DDL interpreter
Query interpreter

4. When an E-R diagram is mapped to tables, the representation of which of the followig is redundant?

Weak entity sets
Weak relationship sets
Strong entity sets
Strong relationship sets

5. In an ER diagram, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect?

Operationally, if X is deleted, so is Y
Operationally, if Y is deleted, so is X
Existence is dependent on Y
Operationally, if X is deleted, and remains the same

6. Which of the following can be considered as one of the reasons to model data?

Understand each user’s perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above

7. In an ER Diagram, the concept total participation is represented by which of the following components?

Dashed lines between entity set and relationship set
Double lines between entity set and relationship set
Single line between entity set and relationship set
Solid line between entity set and relationship set

8. Relations (tables) that are produced by proper application of ER model will always be in

1NF
2NF
3NF
BCNF

9. "Manager salary details are hidden from the employee". Which of the following you can relate to this statement?

External level data hiding
Physical level data hiding
Conceptual level data hiding
None of the above

10. Which of the following two files are used during the operation of the DBMS?

Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language

Score =

Correct answers:

Normalization and Functional Dependency - Quiz

1. A relationship R connecting entity sets E and F has referential integrity from E to F, i.e., the edge connecting R and F has an arrow directed towards F. Which of the following statements may be true?

R is one-one from E to F
R is many-one from E to F
Choice 2 only
Both choices 1 and 2

2. A relation with two attributes A and B satisfies the functional dependency A → B. Then the functional dependency B → A also holds in the relation.

TRUE
FALSE

3. A relation R(A,B,C) satisfies the functional dependencies A → B, A → C, and B → A. Then, we can say that R is in BCNF.

TRUE
FALSE

4. A relation R(A,B,C) satisfies the functional dependencies A → B, A → C, and B → A. Which of the following are valid candidate keys?

A
B
Both choices 1 and 2
A alone

5. Which of the following sentences are true??

4NF implies BCNF
4NF implies 3NF
3NF implies 4NF
Both choices 1 and 2

6. Assume that we have the following four records in a relation R(A, B, C): (1,2,3), (4,2,3), (5,3,3), and (5,3,4). Which of the following FDs does not hold on R?

BC → A
B → C
C → B
All of the above

7. For a relation R1(A,C,B,D,E), with dependencies A → B, and C → D which of the following is the candidate key?

{ABC}
{ACE}
{ADE}
{ABE}

8. The closure of set of attributes is said to be a set of ____________.

Functional Dependencies
Attributes
Keys
Multivalued Attributes

9. {A1, A2, …, An}+ is the set of all attributes of R if and only if A1, A2, …, An is a _______________ for R.

Prime attribute
Closure attributes
Super key
All of the above

10. Assume that the following set of FDs A → B, B → C, C → A, D → E, E → D are holding on a relation R(A,B,C,D,E). Which of the following sets of tuples satisfy this.

a1 b1 c1 d1 e1, a1 b1 c1 d2 e2
a1 b1 c1 d1 e1, a1 b2 c1 d2 e2
a1 b1 c1 d1 e2, a1 b1 c1 d2 e2
None of the above

Score =

Correct answers: