Name of the Chapter-DATABASE MANAGEMENT
Sl. Question: Learning Objective
No
1. A data ________ is a restriction or limitation to ensure accuracy and Understanding
reliability of data in database
(A) Constraint
(B) Dictionary
(C) Query
(D) None of these
2. A _________is a type of command that retrieves data from a database Understanding
on a server
(A) Constraint
(B) Dictionary
(C) Query
(D) None of these
3. RDBMS stands for Knowledge
(A) Relational Database Management System
(B) Rotational Database Management System
(C) Reliable Database Management System
(D) None of these
4. An attribute or set of attributes that is used to uniquely identify a Understanding
record in a database table is called
(A) A primary key
(B) An identifier
(C) A tuple
(D) None of the above
5 A primary key consisting of more than one attribute is called Creation
(A)Composite Primary Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
6. Each row of data in a relation(table) is called Understanding
(A) attribute
(B) tuple
(C) domain
(D) None of these
7. Column headings in a relation are referred as Understanding
(A) attributes
(B) tuples
(C) domains
(D) None of these
8. ______________ is a set of values from which an attribute can take a Understanding
value in each row
(A) Attribute
(B) Tuple
, (C) Domain
(D) None of these
9. The number of attributes in a relation is called the ___________ of Understanding
the relation
(A)Degree
(B) Cardinality
(C) Domain
(D) None of these
10. The number of tuples in a relation is called the ___________ of the Understanding
relation
(A)Degree
(B) Cardinality
(C) Domain
(D) None of these
11. A _________ is used to represent the relationship between two Application
relations. (A)Composite Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
12. An attribute or set of attributes that can be served as a primary key of Understanding
a relation is called
(A)Service Key
(B)Foreign Key
(C)Candidate Key
(D)None of these
13. A candidate key that is not the primary key is called Understanding
(A)Composite Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
14. In relational model, tables are called Understanding
(A) Domains
(B) Relations
(C) Tuples
(D) None of these
15 ___________ can take NULL values in it Knowledge
(A)Primary Key
(B)Foreign Key
(C)Both Primary Key and Foreign Key
(D)None of these
Answers
Multiple Choice question
,Q.No.1 (A) Constraint
Q.No.2 (C) Query
Q.No.3 (A)Relational Database Management System
Q.No.4 (A) A primary key
Q.No.5 (A)Composite Primary Key
Q.No.6 (B) tuple
Q.No.7 (A) attributes
Q.No.8 (C) Domain
Q.No.9 (A)Degree
Q.No.10 (B) Cardinality
Q.No.11 (B)Foreign Key
Q.No.12 (C)Candidate Key
Q.No.13 (C)Alternate Key
Q.No.14 (B) Relations
Q.No.15 (B)Foreign Key
MCQ QUESTIONS
Sl. Question: Learning
No Objective
1 A relational database consists of a collection of Knowledge
(A) Tables
(B) Fields
(C) Records
(D) Keys
2 A/An ____________ in a table represents a logical relationship among a set of Knowledge
values.
(A) Attribute
(B) Key
(C) Tuple
(D) Entry
3 The term _________ is used to refer to a record in a table. Knowledge
(A) Attribute
(B) Tuple
(C) Field
(D) Instance
4 The term _________ is used to refer to a record in a table. Knowledge
, (A) Attribute
(B) Tuple
(C) Field
(D) Instance
5 Which of the following attributes cannot be considered as a choice for primary Understanding
key?
(A) Id
(B) License Number
(C) Dept_Id
(D) Street
6 An attribute in a relation is a foreign key if it is the ___________ key in any other Knowledge
relation.
(A) Candidate
(B) Primary
(C) Super
(D) Sub
7 Consider the table with structure as : Understanding
Student (ID, name, dept_name, tot_cred)
In the above table, which attribute will form the primary key?
(A) Name
(B) Dept
(C) Total_credits
(D) ID
8 Which one of the following is commonly used to define the overall design of the Knowledge
database?
(A) Application program
(B) Data definition language
(C) Schema
(D) Source code
9 Which of the following keys is generally used to represents the relationships Understanding
between the tables?
(A) Primary key
(B) Foreign key
Sl. Question: Learning Objective
No
1. A data ________ is a restriction or limitation to ensure accuracy and Understanding
reliability of data in database
(A) Constraint
(B) Dictionary
(C) Query
(D) None of these
2. A _________is a type of command that retrieves data from a database Understanding
on a server
(A) Constraint
(B) Dictionary
(C) Query
(D) None of these
3. RDBMS stands for Knowledge
(A) Relational Database Management System
(B) Rotational Database Management System
(C) Reliable Database Management System
(D) None of these
4. An attribute or set of attributes that is used to uniquely identify a Understanding
record in a database table is called
(A) A primary key
(B) An identifier
(C) A tuple
(D) None of the above
5 A primary key consisting of more than one attribute is called Creation
(A)Composite Primary Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
6. Each row of data in a relation(table) is called Understanding
(A) attribute
(B) tuple
(C) domain
(D) None of these
7. Column headings in a relation are referred as Understanding
(A) attributes
(B) tuples
(C) domains
(D) None of these
8. ______________ is a set of values from which an attribute can take a Understanding
value in each row
(A) Attribute
(B) Tuple
, (C) Domain
(D) None of these
9. The number of attributes in a relation is called the ___________ of Understanding
the relation
(A)Degree
(B) Cardinality
(C) Domain
(D) None of these
10. The number of tuples in a relation is called the ___________ of the Understanding
relation
(A)Degree
(B) Cardinality
(C) Domain
(D) None of these
11. A _________ is used to represent the relationship between two Application
relations. (A)Composite Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
12. An attribute or set of attributes that can be served as a primary key of Understanding
a relation is called
(A)Service Key
(B)Foreign Key
(C)Candidate Key
(D)None of these
13. A candidate key that is not the primary key is called Understanding
(A)Composite Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
14. In relational model, tables are called Understanding
(A) Domains
(B) Relations
(C) Tuples
(D) None of these
15 ___________ can take NULL values in it Knowledge
(A)Primary Key
(B)Foreign Key
(C)Both Primary Key and Foreign Key
(D)None of these
Answers
Multiple Choice question
,Q.No.1 (A) Constraint
Q.No.2 (C) Query
Q.No.3 (A)Relational Database Management System
Q.No.4 (A) A primary key
Q.No.5 (A)Composite Primary Key
Q.No.6 (B) tuple
Q.No.7 (A) attributes
Q.No.8 (C) Domain
Q.No.9 (A)Degree
Q.No.10 (B) Cardinality
Q.No.11 (B)Foreign Key
Q.No.12 (C)Candidate Key
Q.No.13 (C)Alternate Key
Q.No.14 (B) Relations
Q.No.15 (B)Foreign Key
MCQ QUESTIONS
Sl. Question: Learning
No Objective
1 A relational database consists of a collection of Knowledge
(A) Tables
(B) Fields
(C) Records
(D) Keys
2 A/An ____________ in a table represents a logical relationship among a set of Knowledge
values.
(A) Attribute
(B) Key
(C) Tuple
(D) Entry
3 The term _________ is used to refer to a record in a table. Knowledge
(A) Attribute
(B) Tuple
(C) Field
(D) Instance
4 The term _________ is used to refer to a record in a table. Knowledge
, (A) Attribute
(B) Tuple
(C) Field
(D) Instance
5 Which of the following attributes cannot be considered as a choice for primary Understanding
key?
(A) Id
(B) License Number
(C) Dept_Id
(D) Street
6 An attribute in a relation is a foreign key if it is the ___________ key in any other Knowledge
relation.
(A) Candidate
(B) Primary
(C) Super
(D) Sub
7 Consider the table with structure as : Understanding
Student (ID, name, dept_name, tot_cred)
In the above table, which attribute will form the primary key?
(A) Name
(B) Dept
(C) Total_credits
(D) ID
8 Which one of the following is commonly used to define the overall design of the Knowledge
database?
(A) Application program
(B) Data definition language
(C) Schema
(D) Source code
9 Which of the following keys is generally used to represents the relationships Understanding
between the tables?
(A) Primary key
(B) Foreign key
