Chapter: Basics of DBMS
1.

Which of the following is a Data Model?

A. entity-relationship model
B. relational data model
C. object-based data model
D. all of the above
Answer» D. all of the above
2.

A collection of related data.

A. Information
B. Valuable information
C. Database
D. Metadata
Answer» C. Database
Explanation: A database is a collection of related data that is organized and structured in a way that allows for easy access and manipulation. It typically includes data tables, indices, and other components that are used to store, manage, and retrieve data. A database is a useful tool for storing and managing large amounts of structured data, and it is commonly used in a wide range of applications, including business, finance, healthcare, and more.
3.

DBMS is software.

A. True
B. False
C. none
D. all
Answer» A. True
4.

DBMS manages the interaction between __________ and database.

A. Users
B. Clients
C. End Users
D. Stake Holders
Answer» C. End Users
5.

Which of the following is not involved in DBMS?

A. End Users
B. Data
C. Application Request
D. HTML
Answer» D. HTML
6.

Database is generally __________

A. System-centered
B. User-centered
C. Company-centered
D. Data-centered
Answer» B. User-centered
7.

A characteristic of an entity.

A. Relation
B. Attribute
C. Parameter
D. Constraint
Answer» B. Attribute
8.

The restrictions placed on the data.

A. Relation
B. Attribute
C. Parameter
D. Constraint
Answer» D. Constraint
9.

IMS stands for?

A. Information Mastering System
B. Instruction Management System
C. Instruction Manipulating System
D. Information Management System
Answer» D. Information Management System
10.

A model developed by Hammer and Mc Leod in 1981.

A. SDM
B. OODBM
C. DDM
D. RDM
Answer» A. SDM
11.

Object=_________+relationships.

A. data
B. attributes
C. entity
D. constraints
Answer» C. entity
12.

Duplication of data at several places is called as _______________.

A. Data Inconsistency
B. Data Isolation
C. Atomicity Problem
D. Data Redundance
Answer» D. Data Redundance
13.

Data Redundancy increases the cost of storing and retrieving data.

A. False
B. True
C. none
D. all
Answer» B. True
14.

Which of the information is not redundant.

A. name
B. mobile
C. account-no
D. address
Answer» C. account-no
15.

If in redundant file common fields are not matching then it results in _____________.

A. Data Inconsistency
B. Data Integrity Problem
C. Data Isolation
D. Data Redundancy
Answer» A. Data Inconsistency
16.

It is difficult to access conventional file system than Database System.

A. True
B. False
C. none
D. all
Answer» A. True
17.

An ________ is a set of entities of the same type that share the same properties, or attributes.

A. Entity set
B. Attribute set
C. Relation set
D. Entity model
Answer» A. Entity set
18.

Entity is a _________

A. Object of relation
B. Present working model
C. Thing in real world
D. Model of relation
Answer» C. Thing in real world
19.

The descriptive property possessed by each entity set is _________

A. Entity
B. Attribute
C. Relation
D. Model
Answer» B. Attribute
20.

The function that an entity plays in a relationship is called that entity’s _____________

A. Participation
B. Position
C. Role
D. Instance
Answer» C. Role
21.

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

A. Simple attribute
B. Composite attribute
C. Multivalued attribute
D. Derived attribute
Answer» B. Composite attribute
22.

In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.

A. Desciptive
B. Derived
C. Recursive
D. Relative
Answer» A. Desciptive
23.

_____________ can help us detect poor E-R design.

A. Database Design Process
B. E-R Design Process
C. Relational scheme
D. Functional dependencies
Answer» D. Functional dependencies
24.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A. A many-to-many relationship set
B. A multivalued attribute of an entity set
C. A one-to-many relationship set
D. Both A many-to-many relationship set and A multivalued attribute of an entity set
Answer» D. Both A many-to-many relationship set and A multivalued attribute of an entity set
25.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

A. A many-to-many relationship set
B. A multivalued attribute of an entity set
C. A one-to-many relationship set
D. All of the mentioned
Answer» A. A many-to-many relationship set
26.

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

A. A many-to-many relationship set
B. A multivalued attribute of an entity set
C. A one-to-many relationship set
D. All of the mentioned
Answer» B. A multivalued attribute of an entity set
27.

Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by

A. Unique-role assumption
B. Unique-key assignment
C. Role intergral assignment
D. None of the mentioned
Answer» A. Unique-role assumption
28.

Designers use which of the following to tune the performance of systems to support timecritical operations?

A. Denormalization
B. Redundant optimization
C. Optimization
D. Realization
Answer» A. Denormalization
29.

In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?

A. Dept name, year->size
B. Year->size
C. Dept name->size
D. Size->year
Answer» A. Dept name, year->size
30.

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

A. Fourth NF
B. BCNF
C. Third NF
D. Second NF
Answer» B. BCNF
31.

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

A. Instance
B. Snapshot
C. Both Instance and Snapshot
D. All of the mentioned
Answer» B. Snapshot
32.

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.

A. Cross-tabs
B. Snapshot
C. Both Cross-tabs and Snapshot
D. All of the mentioned
Answer» A. Cross-tabs
33.

Data Model is collection of conceptual tools for describing -

A. Data
B. All of these
C. Data Schema
D. Consistency Constaints
Answer» B. All of these
34.

Data Models in DBMS are classified into ______ categories.

A. 3
B. 2
C. 5
D. 4
Answer» C. 5
35.

Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]

A. View Level
B. Logical Level
C. Physical Level
D. None of these
Answer» C. Physical Level
36.

Which of the following is example of Object based logical model ?

A. Relational Model
B. Hierarchical Model
C. Network Model
D. Entity Relationship Model
Answer» D. Entity Relationship Model
37.

Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects.

A. functions
B. models
C. None of these
D. entities
Answer» D. entities
38.

Which of the following gives a logical structure of the database graphically?

A. Entity-relationship diagram
B. Entity diagram
C. Database diagram
D. Architectural representation
Answer» A. Entity-relationship diagram
39.

Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality

A. One to many
B. One to one
C. Many to many
D. Many to one
Answer» B. One to one
40.

We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________

A. Diamond , diamond
B. Rectangle, diamond
C. Rectangle, rectangle
D. Diamond, rectangle
Answer» D. Diamond, rectangle
41.

An entity set that does not have sufficient attributes to form a primary key is termed a __________

A. Strong entity set
B. Variant set
C. Weak entity set
D. Variable set
Answer» C. Weak entity set
42.

For a weak entity set to be meaningful, it must be associated with another entity set, called the

A. Identifying set
B. Owner set
C. Neighbour set
D. Strong entity set
Answer» A. Identifying set
43.

If you were collecting and storing information about your music collection, an album would be considered a(n) _____

A. Relation
B. Entity
C. Instance
D. Attribute
Answer» B. Entity
44.

What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

A. Relation
B. Instance
C. Table
D. Column
Answer» B. Instance
Chapter: FIle Structure and Organization
45.

If a piece of data is stored in two places in the database, then

A. Storage space is wasted
B. Changing the data in one spot will cause data inconsistency
C. In can be more easily accessed
D. Storage space is wasted & Changing the data in one spot will cause data inconsistency
Answer» D. Storage space is wasted & Changing the data in one spot will cause data inconsistency
46.

An audit trail ___________

A. Is used to make backup copies
B. Is the recorded history of operations performed on a file
C. Can be used to restore lost information
D. None of the mentioned
Answer» B. Is the recorded history of operations performed on a file
47.

Large collection of files are called ____________

A. Fields
B. Records
C. Database
D. Sectors
Answer» C. Database
48.

Which of the following hardware component is the most important to the operation of a database management system?

A. High resolution video display
B. Printer
C. High speed, large capacity disk
D. Mouse
Answer» C. High speed, large capacity disk
49.

Which of the following is not true of the traditional approach to information processing

A. There is common sharing of data among the various applications
B. It is file oriented
C. Programs are dependent on the file
D. It is inflexible
Answer» A. There is common sharing of data among the various applications
50.

The information about data in a database is called _______

A. Metadata
B. Hyper data
C. Tera data
D. None of the mentioned
Answer» A. Metadata
51.

A data dictionary is a special file that contains?

A. The names of all fields in all files
B. The data types of all fields in all files
C. The widths of all fields in all files
D. All of the mentioned
Answer» D. All of the mentioned
52.

A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

A. Metadata
B. Catalog
C. Log
D. Dictionary
Answer» A. Metadata
53.

Relational schemas and other metadata about relations are stored in a structure called the ____________

A. Metadata
B. Catalog
C. Log
D. Data Dictionary
Answer» D. Data Dictionary
54.

___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

A. Database
B. Instance
C. Tablespace
D. Segment
Answer» B. Instance
55.

A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

A. Tablespace
B. Segments
C. Extents
D. Blocks
Answer» A. Tablespace
56.

A tablespace is further broken down into ________

A. Tablespace
B. Segments
C. Extents
D. Blocks
Answer» B. Segments
57.

__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

A. Tablespace
B. Segment
C. Extent
D. Block
Answer» C. Extent
58.

________ is the smallest unit of allocation in an Oracle database.

A. Database
B. Instance
C. Tablespace
D. Database Block
Answer» D. Database Block
59.

An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.

A. Database dictionary
B. Dictionary table
C. Data dictionary
D. Dictionary
Answer» C. Data dictionary
60.

A data dictionary is created when a __________ created.

A. Instance
B. Segment
C. Database
D. Dictionary
Answer» C. Database
61.

An Oracle object type has two parts the _________ and__________

A. Instance and body
B. Segment and blocks
C. Specification and body
D. Body and segment
Answer» C. Specification and body
62.

A(n) _________ can be used to preserve the integrity of a document or a message.

A. Message digest
B. Message summary
C. Encrypted message
D. None of the mentioned
Answer» A. Message digest
63.

A hash function must meet ________ criteriA:)

A. Two
B. Three
C. Four
D. None of the mentioned
Answer» B. Three
64.

What is the main limitation of Hierarchical Databases?

A. Limited capacity (unable to hold much datA:)
B. Limited flexibility in accessing data
C. Overhead associated with maintaining indexes
D. The performance of the database is poor
Answer» B. Limited flexibility in accessing data
65.

The property (or set of properties) that uniquely defines each row in a table is called the:

A. Identifier
B. Index
C. Primary key
D. Symmetric key
Answer» C. Primary key
66.

The separation of the data definition from the program is known as:

A. Data dictionary
B. Data independence
C. Data integrity
D. Referential integrity
Answer» B. Data independence
67.

The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?

A. Hierarchical
B. Network
C. Object oriented
D. Relational
Answer» A. Hierarchical
68.

The database design that consists of multiple tables that are linked together through matching data stored in each table is called

A. Hierarchical database
B. Network database
C. Object oriented database
D. Relational database
Answer» D. Relational database
69.

The association role defines:

A. How tables are related in the database
B. The relationship between the class diagram and the tables in the database
C. The tables that each attribute is contained
D. Which attribute is the table’s primary key
Answer» A. How tables are related in the database
70.

The purpose of an N-Ary association is:

A. To capture a parent-child relationship
B. To deal with one to many relationships
C. To deal with relationships that involve more than two tables
D. To represent an inheritance relationship
Answer» C. To deal with relationships that involve more than two tables
71.

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

A. Clustered index
B. Structured index
C. Unstructured index
D. Nonclustered index
Answer» A. Clustered index
72.

Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

A. Nonclustered
B. Secondary
C. All of the mentioned
D. None of the mentioned
Answer» C. All of the mentioned
73.

An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.

A. Index entry
B. Index hash
C. Index cluster
D. Index map
Answer» A. Index entry
74.

In a _______ clustering index, the index record contains the search-key value and a
pointer to the first data record with that search-key value and the rest of the records will be in
the sequential pointers.

A. Dense
B. Sparse
C. Straight
D. Continuous
Answer» A. Dense
75.

In a __________ index, an index entry appears for only some of the search-key values.

A. Dense
B. Sparse
C. Straight
D. Continuous
Answer» A. Dense
76.

Incase the indices values are larger, index is created for these values of the index. This is called

A. Pointed index
B. Sequential index
C. Multilevel index
D. Multiple index
Answer» C. Multilevel index
77.

A search key containing more than one attribute is referred to as a _________ search key.

A. Simple
B. Composite
C. Compound
D. Secondary
Answer» B. Composite
78.

Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

A. Loading
B. Bulk insertion
C. Bulk loading
D. Increase insertion
Answer» C. Bulk loading
79.

While inserting the record into the index, if the search-key value does not appear in the index.

A. The system adds a pointer to the new record in the index entry
B. The system places the record being inserted after the other records with the same searchkey values
C. The system inserts an index entry with the search-key value in the index at the appropriate position
D. None of the mentioned
Answer» C. The system inserts an index entry with the search-key value in the index at the appropriate position
80.

A collection of data designed to be used by different people is called a/an

A. Organization
B. Database
C. Relationship
D. Schema
Answer» B. Database
81.

Which of the following is the oldest database model?

A. Relational
B. Deductive
C. Physical
D. Network
Answer» D. Network
82.

Which of the following schemas does define a view or views of the database for particular users?

A. Internal schema
B. Conceptual schema
C. Physical schema
D. External schema
Answer» D. External schema
83.

Which of the following are the process of selecting the data storage and data access characteristics of the database?

A. Logical database design
B. Physical database design
C. Testing and performance tuning
D. Evaluation and selecting
Answer» B. Physical database design
84.

Which of the following terms does refer to the correctness and completeness of the data in a database?

A. Data security
B. Data constraint
C. Data independence
D. Data integrity
Answer» D. Data integrity
85.

A table can be logically connected to another table by defining a

A. Super key
B. Candidate key
C. Primary key
D. Unique key
Answer» C. Primary key
86.

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

A. Consistent state
B. Parallel state
C. Durable state
D. Inconsistent state
Answer» D. Inconsistent state
87.

Ensuring isolation property is the responsibility of the

A. Recovery-management component of the DBMS
B. Concurrency-control component of the DBMS
C. Transaction-management component of the DBMS
D. Buffer management component in DBMS
Answer» B. Concurrency-control component of the DBMS
Chapter: Relational Modal
88.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

A. Relational
B. Structural
C. Procedural
D. Fundamental
Answer» C. Procedural
89.

For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigmA:)

A. Predicates, relation
B. Relation, Predicates
C. Operation, Predicates
D. Relation, Operation
Answer» A. Predicates, relation
90.

The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

A. Union
B. Set-difference
C. Difference
D. Intersection
Answer» B. Set-difference
91.

In precedence of set operators, the expression is evaluated from

A. Left to left
B. Left to right
C. Right to left
D. From user specification
Answer» B. Left to right
92.

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

A. Candidate key
B. Sub key
C. Super key
D. Foreign key
Answer» C. Super key
93.

Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

A. NAME
B. ID
C. CITY
D. CITY, ID
Answer» B. ID
94.

A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

A. Rows
B. Key
C. Attribute
D. Fields
Answer» B. Key
95.

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
B. Primary
C. Super
D. Sub
Answer» B. Primary
96.

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________

A. Referential relation
B. Referencing relation
C. Referenced relation
D. Referred relation
Answer» C. Referenced relation
97.

The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

A. Referential relation
B. Referencing relation
C. Referenced relation
D. Referred relation
Answer» C. Referenced relation
98.

A _________ integrity constraint requires that the values appearing in specified attributes
of any tuple in the referencing relation also appear in specified attributes of at least one tuple in
the referenced relation.

A. Referential
B. Referencing
C. Specific
D. Primary
Answer» A. Referential
99.

A relational database consists of a collection of

A. Tables
B. Fields
C. Records
D. Keys
Answer» A. Tables
100.

A ________ in a table represents a relationship among a set of values.

A. Column
B. Key
C. Row
D. Entry
Answer» C. Row
Tags
Question and answers in DataBase Management System (DBMS), DataBase Management System (DBMS) multiple choice questions and answers, DataBase Management System (DBMS) Important MCQs, Solved MCQs for DataBase Management System (DBMS), DataBase Management System (DBMS) MCQs with answers PDF download