DBMS MCQ Questions With Answers Set 8

Relational Model in DBMS

Dr.E.F. Codd worked to improve the working of DBMSs to handle large volumes of data. He applied the rules of mathematics to solve the problems of earlier database models. Some important problems were as follows:

• Data Integrity
• Data Redundancy

In a relational model, data is stored in relations. Relation is another term used for table. A table in a database has a unique name that identifies its contents. Each table can be called an intersection of rows and columns. An important property of a table is that the rows are un-ordered. A row cannot be identified by its position in the table. Every table must have a column that uniquely identifies each row in the table. Relation, tuple, attributes, domain, degree, cardinality, relation instance and relation key are the terminology of relation database.

Database mcqs with answers set 8 includes the mcqs of relational database model, basics of relational database model, primary key, attributes, cardinality and candidate key. These database mcqs are very helpful for those who are preparing any computer related PPSC, SPSC, FPSC, KPPSC OR CSS based private or government jobs. Its also very helpful for international students who want to be appear in Oracle certification exams.

DBMS MCQs - Database MCQs With Answers Set 8

1. The columns of a table correspond to _____?
A). Table
B). Record
C). Field
D). Cell
View Answer

2. The foreign key is found in _____ ?
A). Parent table
B). Dependent table
C). Pivot table
D). Index table
View Answer

3. A table must have _____ ?
A). Primary key
B). Secondary key
C). Composite key
D). Sort key
View Answer

4. A two-dimensional table of data is called a _____?
A). Group
B). Set
C). Declaration
D). Relation
View Answer

5. A table is perceived as two-dimensional structure composed of _____?
A). X and y co-ordinates
B). Matrix elements
C). Rows and columns
D). Intersection of data
View Answer

6. A relation is analogous to a _____?
A). File
B). Field
C). Record
D). Row
View Answer

7. A relation is also known as _____?
A). Table
B). Tuple
C). Relationship
D). Attribute
View Answer

8. An attribute is also known as a _____?
A). Table
B). Relation
C). Row
D). Field
View Answer

9. A row of a relation is called a (n) _____?
A). Attribute
B). Entity
C). Tuple
D). Both a and c
View Answer

10. A person, place, thing, event, or condition about which data is kept in the database is called _____?
A). Attribute
B). Field
C). Record
D). Entity
View Answer

11. A category of data or information that describes an entity is called a(n) _____?
A). Attribute
B). Data item
C). Record
D). Tuple
View Answer

12. Which of the following is NOT a general characteristic of relations _____?
A). Each row is unique
B). The order of columns is significant
C). The order of rows is insignificant
D). Columns are all elemental or atomic
View Answer

13. An index can be used to _____?
A). Improve the performance of the database
B). Document the structure of the database itself
C). Reduce data dependency for application programs
D). All
View Answer

14. Which of the following are properties of relations _____?
A). Each attribute has a unique name
B). No two rows in a relation are identical
C). There are no multivalued attributes in a relation
D). All of the above
View Answer

15. A key is _____?
A). A field that identifies only one record
B). The most important field in a record
C). The first field of table
D). None
View Answer

16. Which of the following describes the primary key _____?
A). It must be unique
B). It helps in indexing of a large database
C). It makes sorting quicker
D). All of the above
View Answer

17. Which of the following is NOT a good primary key _____?
A). Social security number
B). Order number
C). Zip code
D). Student ID number
View Answer

18. How many primary keys can a table have _____?
A). One
B). At least one, but not more than two
C). Between 1 and 5
D). No limit
View Answer

19. Which of the following should be a primary key _____?
A). A person's last name
B). An employee's salary
C). A customer's ID number
D). A salesperson's region
View Answer

20. Which field listed below is the most appropriate primary key _____?
A). A person's name
B). A person's street address
C). A person's birth date
D). A person's Social Security Number
View Answer

21. One field or combination of fields for which more than one record may have the same combination of values is called _____?
A). Secondary key
B). Index
C). Composite key
D). Linked key
View Answer

22. A candidate key is _____?
A). Primary key
B). The primary key selected to be the key of a relation
C). An attribute or group of attributes that can be the primary key
D). All
View Answer

23. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a _____?
A). Global key
B). Link key
C). Foreign key
D). None
View Answer

24. A primary key that consists of more than one attribute is called a _____?
A). Foreign key
B). Composite key
C). Multivalued key
D). Global key
View Answer

25. For each attribute of a relation, there is a set of permitted values, called the _____ of that attribute.
A). Domain
B). Set
C). Relation
D). Schema
View Answer

26. A domain is atomic if elements of the domain are considered to be _____ units.
A). Different
B). Constant
C). Indivisbile
D). Divisible
View Answer

27. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
A). Foreign key
B). Candidate key
C). Sub key
D). Super key
View Answer

28. The subset of a super key is a candidate key under what condition?
A). No proper subset is a super key
B). Subset is a super key
C). Each subset is a super key
D). All subsets are super keys
View Answer

29. An attribute in a relation is a foreign key if the _____ key from one relation is used as an attribute in that relation.
A). Candidate key
B). Primary key
C). Super key
D). None of these
View Answer

30. Course(course_id,sec_id,semester). Here the course_id, sec_id and semester are _____ and course is a _____?
A). Relations, Attribute
B). Attributes, Relation
C). Tuple, Attributes
D). Tuple, Relation
View Answer

Read also>->>Database MCQs With Answers Set 6

Read also>->>Database MCQs With Answers Set 7

Read also>->>Database MCQs With Answers Set 9

Read also>->>Database MCQs With Answers Set 10