Computer Science – Database Management –Multiple Choice Questions with Answers – Assertion & Reason Type Questions with Answers - 78 Pages – Helpful for Students and Teachers
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
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller kbzone. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.99. You're not tied to anything after your purchase.
