1. A _________ is an organized collection of data.

a. Database
b. Digital Document
c. Spreadsheet
d. None of the above

Answer ⟵a. Database

2. A ________ is a software package that can be used for creating and

managing databases.
a. Database Management System
b. Basedata Management System
c. Database Manage System
d. None of the above

Answer ⟵a. Database Management System

4. Example of the database ________.

a. Microsoft Access
b. OpenOffice Base
c. MySQL
d. All of the above

Answer ⟵d. All of the above

6. DBMS Stands for __________.

a. Database Management System
b. Database Manage System
c. Data Manage System
d. None of the above

Answer ⟵a. Database Management System

8. A database is an integrated collection of ___________.

a. Data records
b. Files
c. Objects
d. All of the above

Answer ⟵d. All of the above

9. A DBMS enables several user application programs to access the ________

database.
a. Other Database
b. Same Database
c. Both a) and b)
d. None of the above

Answer ⟵b. Same Database

12. Data is stored in multiple tables, which are connected together via a
common field.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above

Answer ⟵b. Relational

14. What are the advantages of database __________.

a. Reduces Data Redundancy
b. Sharing of Data
c. Data Integrity
d. All of the above

Answer ⟵d. All of the above

15. When the same piece of data is stored in two or more locations, it is
called ______________.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above

Answer ⟵a. Data Redundancy

16. _________ prevents creating multiple copies in the database.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above

Answer ⟵a. Data Redundancy

17. __________ means that the data is accurate and consistent in the database.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above

Answer ⟵b. Data Integrity

18. Only authorized users should be allowed to access the database and
their identity should be authenticated using a username and password
known as ________.
a. Data Redundancy
b. Data Consistency
c. Data Security
d. None of the above

Answer ⟵c. Data Security

19. Database Management System automatically takes care of ____________.

a. Data Redundancy
b. Backup and Recovery
c. Data Security
d. None of the above

Answer ⟵b. Backup and Recovery

23. The unique field present in the table is called __________.

a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above

Answer ⟵ a. Primary Key

24. When the primary key is applied on multiple columns is known as
__________.
a. Primary Key
b. Composite Primary Key
c. Foreign Key
d. None of the above

Answer ⟵ b. Composite Primary Key

27. The relationship between two tables where one table has one record
and another table has many records is known as ___________.
a. One-to-Many
b. Many-to-Many
c. Many-to-One
d. None of the above

Answer ⟵ a. One-to-Many

Session 2: Create and Edit Tables Using Wizard & SQL

Commands
28. SQL stands for _____________.
a. Single Query Language
b. Structured Query Language
c. Semantic Query Language
d. None of the above

Answer ⟵ b. Structured Query Language

53. Referential Integrity helps to avoid ____________.

a. If you want to add a record in the related table and if there is no associated
record available in the primary key table.
b. Changing values in a primary if there are any dependent records in the related
table.
c. Deleting records from a primary key table if there are any matching related
records available in the associated table.
d. All of the above

Answer ⟵ d. All of the above

56. What are the different types of relationships which can be created in
table___________.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above

Answer ⟵ d. All of the above

57. ___________ is the relationship, where both the tables must have primary
key columns.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above

Answer ⟵ a. One to One

58. ____________ in this relationship, one of them must have a primary key
column.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above

Answer ⟵ b. One to Many or Many to One

59. A ____________________ is a standard for commands that define the

different structures in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above

Answer ⟵ b. Data Definition Language (DDL)

60. A ______________ is a language that enables users to access and

manipulate data in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above

Answer ⟵ a. Data Manipulation Language (DML)

61. A ____________ is a subset of DML that just deals with information

retrieval.
a. Query Language
b. Structure Language
c. Both a) and b)
d. None of the above

Answer ⟵ a. Query Language

62. A popular data manipulation language is _________________.

a. Structured Query Language
b. Machine Level language
c. Low level language
d. None of the above

Answer ⟵ a. Structured Query Language

63. There are __________ types of Relationships in a table.

a. 2
b. 3
c. 4
d. 5

Answer ⟵ b. 3

84. Data from multiple tables can be stored in _______.

a. Data system
b. Database
c. Datatype
d. None of the above

Answer ⟵ a. Database

1) Which of the following is generally used for performing tasks like creating the structure of the
relations, deleting relation?
 a. DML(Data Manipulation Language)
b. Query
c. Relational Schema
d. DDL(Data Definition Language)

Answer: D

Explanation: The term "DDL" stands for Data Definition Language, used to perform all other
essential tasks such as deleting relation and related schemas in defining the structure relation.

2) Which of the following provides the ability to query information from the database and insert
tuples into, delete tuples from, and modify tuples in the database?

a. DML(Data Manipulation Language)

b. DDL(Data Definition Language)
c. Query
d. Relational Schema

Answer: A

Explanation: The term "DML" stands for the Data Manipulation Language used to perform the
required changes in the relation's values.

6) What do you mean by one to many relationships?

a. One class may have many teachers

b. One teacher can have many classes
c. Many classes may have many teachers
d. Many teachers may have many classes

Answer: B

Explanation: We can understand the "one to many" relationship as a teacher who may have
more than one class to attend.

9) A Database Management System is a type of _________software.

a. It is a type of system software

b. It is a kind of application software
c. It is a kind of general software
d. Both A and C
Answer: A

Explanation: The DBMS (or Database Management System) is a kind of system software used for
several operations such as creating tables/databases, storing data, managing databases. It also
allows modifying the data stored in the database as well.

16) Which one of the following refers to the copies of the same data (or information) occupying the
memory space at multiple places.

a. Data Repository
b. Data Inconsistency
c. Data Mining
d. Data Redundancy

Answer: D

Explanation: The data redundancy generally occurs whenever more than one copy of the exact
same data exists in several different places. Sometimes it may cause data inconsistency, which can
result in an unreliable source of data or information that is not good for anyone.

17) Which one of the following refers to the "data about data"?

a. Directory
b. Sub Data
c. Warehouse
d. Meta Data

Answer: D

Explanation: The Mata Data refers to the type of data that describes the other data or
information.

A general file or document is nothing more than a sequence of bytes that contains information
like file name, file size, and date & time when the document was created or modified.

To understand it in more details, consider the following example:

For a common music file, the metadata may include the singer's name, the year it was released,
and the lyrics, etc.

18) Which of the following refers to the level of data abstraction that describes exactly how the data
actually stored?
 a. Conceptual Level
b. Physical Level
c. File Level
d. Logical Level

Answer: B

Explanation: Data abstraction means displaying or sharing only the data that is needed and
hiding from all other data until it is necessary to share it. However, the data abstraction level that
describes how the data was actually stored in the user's machine (or system) is known as the
Physical level. Therefore the correct answer is B.

19) To which of the following the term "DBA" referred?

a. Data Bank Administrator

b. Database Administrator
c. Data Administrator
d. None of the above

Answer: B

Explanation: The term "DBA" refers to the Database Administrator that manages the whole
database and updates the database on a regular basis. In short, the database administrator has
the responsibility of the whole database and to maintain it in an optimal & stable state.

20) In general, a file is basically a collection of all related______.

a. Rows & Columns

b. Fields
c. Database
d. Records

Answer: D

Explanation: Whenever we have some related data, information or records, we collect all those
related data (or records), put them together, store them in one place, and give that collection a
name that is known as a file.

21) The term "Data" refers to:

a. The electronic representation of the information( or data)

 b. Basic information
c. Row Facts and figures
d. Both A and C

Answer: C

Explanation: In general, the term "data" refers to the row facts and figure, whereas the
information referred to as the data, which is really important for someone or a particular person.
Therefore the correct answer is C.

22) Rows of a relation are known as the _______.

a. Degree
b. Tuples
c. Entity
d. All of the above

Answer: D

Explanation: In SQL, the relation is represented by a table, and a table is a collection of rows and
columns. Therefore the collection of rows & columns is called the table, whereas a table is known
as the relation in the SQL. So in a relation (or we can say table), rows are called the tuples. So, the
correct answer will be tuples.

24) Which one of the following is a type of Data Manipulation Command?

a. Create
b. Alter
c. Delete
d. All of the above

Answer: C

Explanation: In data manipulation language, the command like select, insert, update, and delete
is used to manipulate the information (or data, records), for example create a table, update table
delete table, etc. Therefore the correct answer is C.

25) Which of the following command is a type of Data Definition language command?

a. Create
b. Update
 c. Delete
d. Merge

Answer: A

Explanation: The Data definition language is generally used to maintain or define the structure
of the database. For example, creating a table, drop table, alter table. In short, we can say that the
command of data definition languages is used to work on the table's schemas inside the
database.

28) In a relation database, every tuples divided into the fields are known as the______.

a. Queries
b. Domains
c. Relations
d. All of the above

Answer: B

Explanation: In a database, the number of rows inside a table is known as tuples, and if we
further divide those tuples (or rows) into those fields, they become the domains. So the correct
answer will be B.

30) In the relational table, which of the following can also be represented by the term "attribute"?

a. Entity
b. Row
c. Column
d. Both B &C

Answer: C

Explanation: In the database, the number of rows inside a table is called the tuples, and the
numbers of columns are known as the attributes. Therefore the correct answer is C.

32) Which of the following is used in the application programs to request data from the database
management system?

a. Data Manipulation language

b. Data Definition Language
c. Data Control Language
 d. All of the above

Answer: A

Explanation: To fetch data from the database management system, generally, the "select"
statement is used. Therefore, the Data Manipulation Language is used in the application
programs while requesting the data from the database management system.

37) The database management system can be considered as the collection of ______ that enables us to
create and maintain the database.

a. Translators
b. Programs
c. Keys
d. Language activity

Answer: B

Explanation: The Database management system can also considered as the set of programs that
enables users to create and maintain the database.

39) Which of the following refers collection of the information stored in a database at a specific time?

a. Independence
b. Instance of the database
c. Schema
d. Data domain

Answer: B

Explanation: The collection of data (or information) stored in a database at a particular moment
is known as the instance of the database. Therefore the correct answer is B.

40) The term "SQL" stands for

a. Standard query language

b. Sequential query language
c. Structured query language
d. Server-side query language

Answer: C
Explanation: The term "SQL" stands for the structured query language, which is one of the most
widely, used programming languages for relational databases. It can also be used for managing
and organizing data in all sorts of systems in which different data relationships exist. Therefore
the correct answer is C.

41) The term "Data independence" refers to____

a. Data is defined separately and not included in the programs

b. Programs are not dependent on the logical attributes of the data
c. Programs are not dependent on the physical attributes of the data
d. Both B & C

Answer: d

Explanation: The term "Data independence" refers that the program should not be dependent
on either the logical attributes of data or physical attributes of data.

43) Which one of the following refers to the total view of the database content?

a. Conceptual view
b. Physical view
c. Internal view
d. External view

Answer: A

Explanation: The conceptual view refers to the total view of the content available in the
database. Therefore the correct answer is A.

44) For what purpose the DML is provided?

a. Addition of new structure in the database

b. Manipulation & processing of the database
c. Definition of the physical structure of the database system
d. All of the above

Answer: B

Explanation: The term "DML" refers to the data manipulation language, which is commonly used
to perform basic operations such as insert data, delete, and update data in a database. So the
correct answer will be B.
46) The architecture of a database can be viewed as the ________

a. One level
b. Two-level
c. Three-level
d. Four level

Answer: C

Explanation: A database's architecture can be viewed as the three levels of abstraction that are
named as the internal level, external level, and the conceptual level. Therefore the correct answer
is C.

47) In the relation model, the relation are generally termed as ________

a. Tuples
b. Attributes
c. Rows
d. Tables

Answer: D

Explanation: In the relation model, the relations are also referred to as the tables because the
relations are considered as the technical name of the table. So the correct answer is D.

48) The Database Management Query language is generally designed for the _____

a. Support end-users who use English like commands

b. Specifying the structure of the database
c. Support in the development of the complex applications software
d. All of the above

Answer: D

Explanation: The database management query language is generally designed by keeping in

mind that it must support the end-users who are familiar with the English-like commands. It
should also boost the process of development of the complex applications software and helps in
specifying the structure of the database.
50) Which of the following levels is considered as the level closed to the end-users?

a. Internal Level
b. External Level
c. Conceptual Level
d. Physical Level

Answer: B

Explanation: The database's external level is the one and only level that is considered the closest
level to the end-users. So the correct answer will be the B.

53) Which one of the following is commonly used to define the overall design of the database?

a. Application program
b. Data definition language
c. Schema
d. Source code

Answer: C

Explanation: In order to define the overall design of the database, generally, the schema is used.
Therefore the correct answer is C.

1. DBMS stands for ______

(a) Database Administrator System

(b) Database Management System
(c) Database Basic Management System
(d) Data Basic Management System
Answer:Option (b)
2. What is the full name of the DBA?

(a) Database Administrator

(b) Database Admin
(c) Database Application
(d) Database Analyst
Option (a)
Answer:
3. _______ is the collection of the interrelated data and set of the program to access them.
 (a) Programming Language
(b) Database
(c) Data Structure
(d) Database Management System
Answer:Option (d)
4. Before the use of the DBMS info was stored in the ________

(a) Data System

(b) Cloud Storage
(c) File System
(d) Amazon
Option (c)
Answer:
5. A database is the complex type of the _______

(a) Application
(b) Data Structure
(c) Manager
(d) File
Answer: Option (b)
6. The ability to change the conceptual schema without affecting the external schemas or application programs is known ____________.

(a) Program Data Independence

(b) Physical Data Independence
(c) Logical Data Independence
(d) Data Abstraction

Answer: Option (c)

7. Which of these DBMS languages is employed by end users and programmers to manipulate data in the database?

(a) Data Translation Language

(b) Data Definition Language
(c) Data Presentation Language
(d) Data Manipulation Language

Answer: Option (d)

8. Which of these is not an advantage of database systems?

(a) Data Redundancy

(b) Program Data Independence
(c) Centralized Data Management
 (d) Data Abstraction

Answer: Option (d)

9. Which type of users query and update the database by invoking some already written application programs?

(a) Naive Users

(b) Sophisticated Users
(c) Special Users
(d) System Analysts

Answer: Option (a)

10. The information about data in a database is called _______.

(a) Hyper data

(b) Tera data
(c) Metadata
(d) Bigdata

Answer: Option (c)

11. In the architecture of a database system external level is the __________

(a) Physical level

(b) Logical level
(c) Conceptual level
(d) View level

Answer: Option (d)

12. Architecture of the database can be viewed as

(a) Two levels

(b) Three levels
(c) Four levels
(d) One level
Option (b)
Answer:
13. An advantage of the database management approach is

(a) Data is dependent on programs

(b) Data redundancy increases
(c) Data is integrated and can be accessed by multiple programs
(d) Easy to use
Answer: Option (c)
14. Data independence means

(a) Data is defined separately and not included in programs

 (b) Programs are not dependent on the physical attributes of data
(c) Programs are not dependent on the logical attributes of data
(d) Both programs are not dependent on the physical attributes of data & programs are not dependent on the logical attributes of data

Answer: Option (d)

15. Which is not the Applications of the database system?

(a) Sales
(b) Accounting
(c) Banking and finance
(d) Calculation based website or apps

Answer: Option (d)

16. DBMS is ________

(a) A collection of the data only

(b) A collection of interrelated data and set of programs to access those data
(c) A collection of the program
(d) A collection of the software

Answer: Option (b)

17. Which of the following is the disadvantage of the file processing system?

(a) Data Redundancy

(b) Easy to use
(c) No trained staff required
(d) Low cost

Answer: Option (a)

18. Redundancy means

(a) Uniqueness
(b) Duplication
(c) Weakness
(d) Slowness

Answer: Option (b)

19. Concurrent access means

(a) Accessing system by only single user at a time

(b) Accessing System by more than one user one by one
(c) Accessing system by more than one user at a time (simultaneously)
(d) Accessing system by single only

Answer: Option (c)

20. How many levels are therer in data abstraction?
 (a) One
(b) Two
(c) Three
(d) Four

Answer: Option (c)

21. Arrange the following levels of Data abstraction from lowest level to highest level (Logical, View, Physical)

(a) Physical, Logical, View

(b) View, Logical, Physical
(c) View, Physical, Logical
(d) Physical, View, Logical

Answer: Option (a)

22. Which level of abstraction describe How data are actuly stored?

(a) Physical
(b) Logical
(c) External
(d) View

Answer: Option (a)

23. Which level of abstraction describe What data are actuly stored?

(a) Physical
(b) Logical
(c) External
(d) View

Answer: Option (b)

24. How many different types of Database users?

(a) Two
(b) Four
(c) Three
(d) One

Option (b)
Answer:
25. Which users is unsophisticated users?

(a) Naive
(b) Sophisticated
(c) Application Programming
(d) Specialized

Answer: Option (a)

26. Which user can intract with system without writing Application Programming?

(a) Naive User

(b) Sophisticated User
(c) Application Programer
(d) Specialized User

Answer: Option (b)

27. Which of the following is/are task of DBA?

(a) Schema Defination

(b) Granting of authorization for data access
(c) Schema of Physical Organization Modification
(d) All

Answer: Option (d)

28. Which of the following is not a Storage Manager Component?

(a) Transaction Manager

(b) Logical Manager
(c) Buffer Manager
(d) File Manager

Answer: Option (b)

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

(a) External schema

(b) Physical schema
(c) Conceptual schema
(d) Internal schema
Answer:
Option (a)
30. Which of the following terms does refer to the correctness and completeness of the data in a database?

(a) Data model

(b) Data independence
(c) Data integrity
(d) Data security

Option (c)
Answer:
31. Which of the following is/are disadvantages of Database Management System?

(A) Cost of Hardware and Software

(B) Reduce data redundancy

 (C) Remove data inconsistency

(a) A
(b) B
(c) C
(d) B and C

Answer: Option (a)

32. Either all of its operations are executed or none is called _________

(a) Consistency
(b) Isolation
(c) Atomicity
(d) Durablity

Answer: Option (c)

33. When data is processed, organized, structured or presented in a given context so as to make it useful, it is called ______

(a) Superdata
(b) Cleandata
(c) Information
(d) Database

Answer: Option (c)

34. _____________ is an information repository which contains metadata.

(a) Data warehouse

(b) Data dictionary
(c) Database
(d) System
Answer: Option (b)
36. Lowest level of 3 level ANSI SPARC architecture is ________

(a) Internal Level

(b) Conceptual Level
(c) View Level
(d) External Level
Option (a)
Answer:
37. ___________ level deals with physical storage of data.

(a) Internal
(b) External
 (c) View
(d) Conceptual
Option (a)
Answer:
38. Conceptual level is also know as ____________

(a) Physical Level

(b) View level
(c) Intenal level
(d) Logical level
Option (d)
Answer:
39. External level is also known as ___________

(a) Physical level

(b) Internal level
(c) View level
(d) Conceptual level
Option (c)
Answer:
40. The process of hiding irrelevant details from user is called ____________

(a) Data abstraction

(b) Mapping
(c) Data clapping
(d) Data binding
Answer: Option
(a)
41. Process of transforming requests and results between the three levels is called _____________

(a) Data abstraction

(b) Data moving
(c) Mapping
(d) Data translating
Answer: Option (c)
42. Ability to modify a schema definition in one level without affecting a schema definition in the next higher level is called ________

(a) Data Binding

(b) Data Abstraction
(c) Mapping
(d) Data Independence

Answer: Option (d)

43. ___________ is the ability to modify the physical schema without requiring any change in logical (conceptual) schema and application programs

(a) Logical Data Independence

(b) Physical Data Independence
(c) View Data Independence
(d) External Data Independence

Answer: Option (b)

44. Modifications at the internal levels are occasionally necessary to _____________

(a) Decrease data in database

(b) Increase data in database
(c) Improve performance
(d) Increase space

Answer: Option (c)

45. ____________ is the ability to modify the conceptual schema without requiring any change in application programs.

(a) Physical Data Independence

(b) Logical data independence
(c) View Data Independence
(d) External Data Independence

Answer: Option (b)

46.Modification at the logical levels is necessary whenever __________________________

(a) we need to reduce data in database

(b) we need to increase space
(c) we need to improve performance
(d) the logical structure of the database is changed.

Answer: Option (d)

47. The collection of information stored in the database at particular moment is called instance.

(a) True
(b) False

Answer:Option (a)
48. Instances are changed frequently.

(a) True
(b) False

Option (a)
Answer:
49. The overall design of database is called database schema.
 (a) True
(b) False

Answer: Option (a)

50. Schemas are changed frequently.

(a) True
(b) False

Option (b)
Answer:
51. Example of Naive User is ___________.

(a) Software developers

(b) Application Programmers
(c) Clerk in bank
(d) DBA

Answer: Option (c)

52. A user who write software using tools such as Java, .Net, PHP etc. is _________________

(a) End Users

(b) Application Programmers
(c) Sophisticated Users
(d) DBA
Option (b)
Answer:
53. Which of following is/are DBMS tools

(A) MS SQL Server

(B) Oracle

(C) .NET

(D) Android

(E) My SQL

(a) Only A and B

(b) Only A, B and E
(c) Only B and C
(d) Only C and D
Option (b)
Answer:
54. Which one of the following is not an DBMS tool.
 (a) SQLite
(b) MongoDB
(c) PHP
(d) Oracle
Answer: Option (c)

Data and information are essentially the same thing.

a. True
b. False

ANSWER: False

Data processing can be as simple as organizing data to reveal patterns.

a. True
b. False

ANSWER: True

Data is the result of processing raw facts to reveal its meaning.

a. True
b. False

ANSWER: False

When data are entered into a form and saved, they are placed in the underlying
database as knowledge.

a. True
b. False

ANSWER: False

Data constitute the building blocks of information.

a. True
b. False

ANSWER: True
Metadata describe the data characteristics and the set of relationships that links
the data found within the database.

a. True
b. False

ANSWER: True

The only way to access the data in a database is through the DBMS.

a. True
b. False

ANSWER: True

Database programming languages receive all application requests and translate

them into the complex operations required to fulfill those requests.

a. True
b. False

ANSWER: False

The DBMS reveals much of the database’s internal complexity to the application
programs and users.

a. True
b. False

ANSWER: False

One disadvantage of the DBMS is that it increases the risk of data security
breaches.

a. True
b. False

ANSWER: False

An operational database is sometimes referred to as an enterprise database.

a. True
b. False
 ANSWER: False

A data warehouse can store data derived from many sources.

a. True
b. False

ANSWER: True

The same data might be simultaneously structured and unstructured depending

on the intended processing.

a. True
b. False

ANSWER: True

Corporations use only structured data.

a. True
b. False

ANSWER: False

Field refers to a collection of related records.

a. True
b. False

ANSWER: False

Data anomaly is defined as the condition in which all of the data in the database
are consistent with the real-world events and conditions.

a. True
b. False

ANSWER: False

Structural dependence exists when it is possible to make changes in the file

structure without affecting the application program’s ability to access the data.

a. True
 b. False

ANSWER: False

An advantage of database systems is that you needn’t perform frequent updates

and apply latest patches.

c. True
d. False

ANSWER: False

Structural dependence exists when it is possible to make changes in the file

structure without affecting the application program’s ability to access the data.

a. True
b. False

ANSWER: False

One disadvantage of a database system over previous data management

approaches is increased costs.

a. True
b. False

ANSWER: True

One advantage of a database system over previous data management

approaches is that the database system is considerably less complex.

a. True
b. False

ANSWER: False

End-user data is ……………………..

a. knowledge about the end users

b. raw facts of interest to the end user
c. information about a specific subject
d. accurate, relevant and timely information
 ANSWER: b

……………provide a description of the data characteristics and the set of

relationships that link the data found within the database.

a. Queries
b. End-user
c. data Metadata
d. Schemas

ANSWER: c

………………….. serve as the intermediary between the user and the database.

a. DBMSs
b. Metadata
c. End-user data
d. Programming languages

ANSWER: a

The database structure in a DBMS is stored as a …………………

a. single file
b. collection of files
c. set of key/value pairs
d. collection of queries

ANSWER: b

A(n)…………….might be written by a programmer or it might be created through a

DBMS utility program.

a. query
b. operating syste
c. database management system
d. application

ANSWER: d

The response of the DBMS to a query is the ………………

 a. ad hoc query
b. ad hoc response
c. query result set
d. integrated view of the data

ANSWER: c

Which of the following refers to the situation where different versions of the
same data are stored at different places because they weren’t updated
consistently?

a. Data query
b. Data integrity
c. Data dictionary
d. Data redundancy

ANSWER: d

The term……………… refers to an organization of components that define and reg

ulate the collection,storage,management and use of data within a database
environment.

a. structured data
b. transaction
c. management system
d. database system

ANSWER: d

……………… is the result of processing raw data to reveal its meaning.

ANSWER: Information

………….is data about data through which the end-user data are integrated and
managed.

ANSWER: Metadata

A(n)……………… is a collection of programs that manages the database structure a

nd
controls access to the datastoredin the database.

ANSWER: DBMS (database management system)database management

system (DBMS)database management systemDBMS58.

A(n)…………….. is a specific request issued to the DBMS for data manipulation.

ANSWER: query

………………..exists when it is possible to make changes in the data storage

characteristics without affecting an applicationprogram’s ability to access data.

ANSWER: Data independence

…………………exists when the same data are stored unnecessarily at different

places.

ANSWER: Data redundancy