This set of Advanced Database Management System focuses on Structure of Relational Databases MCQs (Multiple Choice Questions and Answers ).
1. Lets consider the account table .it has three column headers; account-number, branch-name and balance. Following the terminology of relational model, these headers can be referred as what?
- Tuple
- Attribute
- Column
- Row
2. For each attribute in the table, there is set of permitted values, called the _____of that Attribute.
- Tuple
- Domain
- Column
- Row
Let’s consider the account table .it has three column headers; account-number, branch-name and balance. For the attribute branch-name, for example, the domain is the set of all branch names.
3. The mathematical terms relation and tuples are referred to as?
- Table and Domain
- Table and Key
- Table and Row
- Table and Column
4. Which of the following describe the logical design of the database?
- Database instance
- Database Schema
- Relation Schema
- Relation Instance
When we talk about the database, we must differentiate between the database schema which is logical design of the database and a database instance which is a snapshot of the data in the database at a given instant in time.
5. Which of the following describe the snapshot of the data in the database at a given instant in time?
- Database instance
- Database Schema
- Relation Schema
- Relation Instance
When we talk about the database, we must differentiate between the database schema which is logical design of the database and a database instance which is a snapshot of the data in the database at a given instant in time.
6. Which of the following describes the relation name (table name), attributes, and their names?
- Database instance
- Database Schema
- Relation Schema
- Relation Instance
Relation schema defines the design and structure of the relation like it consists of the relation name, set of attributes. every attribute would have an associated domain. In General, A relation schema consists of a list of attributes and their corresponding domains.
For Example, Branch is relation and the Relation schema is Branch-Schema=(branch-name, branch-city, assets)
7. __________ is the snapshot of the relation at a particular time. It consists of the data which is present inside the relation at a particular instance of time. Duplicate row entries are not allowed in the _____. Though in SQL, duplicate rows are allowed in the table.
- Database instance
- Database Schema
- Relation Schema
- Relation Instance
8. A Database schema, along with primary key and foreign key dependencies, can be depicted pictorially by _________
- Database Diagram
- ER Diagram
- Schema Diagrams
- Relation Schema
Do not get confuse a schema diagram m with an E-R Diagram, In particular, ER diagrams do not show foreign key attributes explicitly, Whereas Schema diagram show them explicitly.
9. Which of the following statements stands true? I.A Relational database consists of collection of AttributesII.A Relational Database consists of collections of TablesIII.A relational Database consists of collections of ColumnsIV.A relational Database consists of collections of Rows
- I and II
- I and III
- II only
- IV only
A relational database consists of collections of tables, each of which is assigned a unique name
10. A___ in a table represents a relationship among a set of values.
- Row
- Column
- Attribute
- All of the above
A row in a table represents a relationship among a set of values. Since a table is a collections of such relationships.