1. A database can be defined as a structured collection of -

a.     Records

b.     Query

c.     Computer

d.     Knowledge

Ans. A

2. A flat model consists of a –

a.     Single, one-dimensional array of data

b.     Double, one-dimensional array of data

c.     Single, two-dimensional array of data

d.     Single, three-dimensional array of data

Ans. C

3. A network model organizes data using two fundamental constructs –

a.     Branches and models

b.     Records and sets

c.     Records and owner

d.     Records and members

Ans. B

4. A database model defined mathematically in terms predicate logic and set theory is –

a.     Relational model

b.     Flat model

c.     Hierarchical model

d.     Network model

Ans. A

5. If al a relational databases non-key attributes are dependent on all of the key, then the database is considered to meet the criteria for being in the –

a.     First normal form

b.     Second normal form

c.     Third normal form

d.     Fourth normal form

Ans. B

6. The component of a database management system responsible for determining the most efficient way to execute a query is –

a.     Query plan

b.     Query optimize

c.     Composite index

d.     Query

Ans. B

7. Cardinality estimation depends on estimates of the –

a.     Selection factors of predicates in the query

b.     Selection factors of query optimizer

c.     Selection factors of query process

d.     Transitional database management system

Ans A

8. The ratio of the distinct values in the indexed column / columns to the number of records in the table represents the –

a.     Selectivity of an index

b.     Ideal selectivity

c.     Unique indexes

d.     NULL columns

Ans. A

9. Data compression is used to reduce –

a.     Storage and transmission requirement

b.     Storage and query requirement

c.     Query processing

d.     Query sub systems

Ans. A

10. A real world phenomena about which is collected is called –

a.     Entity relation

b.     Entity

c.     Report

d.     Relationship

Ans. B

11. Rules for determining valid values and structures are called.

a.     Entity type

b.     Subclass

c.     Category entity type

d.     Data constraint

Ans. D

12. The set of valid values for an attribute is called –

a.     Primary key

b.     Foreign key

c.     Domain

d.     Associative relationship

Ans. C

13. SSM is an extension and graphic simplification of the –

a.     EER modeling tool

b.     UDT

c.     UDF

d.     Data model

Ans. A

14. A dominant entity type within the scope of the information system is –

a.     Sub class

b.     Special data type

c.     Derived attribute

d.     Base entity

Ans. D

15. Weak entities can alternatively be modeled as a repeating group of –

a.     Employees

b.     Nodes

c.     Attributes

d.     Parent entity

Ans. D

16. An entity type having the or more parent entity type that themselves subclass entity-types within the same classification hierarchy is called –

a.     Shared subclass

b.     Associative subclass

c.     Subclass assistant  

d.     Entity type

Ans. A

17. A category subclass is the result if a multiple ________ from disjoint parent entity-type.

a.     Instance

b.     Inheritance

c.     Category

d.     Hierarchy

Ans. B

18. The union attribute is called a ______ key in the parent entity-type which functions as foreign key to category entity instance.

a.     Classified

b.     Associative

c.     Surrogate

d.     Organization

Ans. B

19. A metadata is defined for –

a.     Relational data

b.     Traditional data

c.     Statistical data

d.     Libraries

Ans. C

20. Metadata is used for ________.

a.     Specification and interpretation of user requests

b.     Specifications and representation of user requests

c.     Characterizing the subject

d.     Managing collection

Ans. A

21. ________ metadata characteristics the subject matter of the document.

a.     Types

b.     Author

c.     Multi

d.     Semantic

Ans. D

22. A metadata that describe relationship to external objects is –

a.     Context

b.     Structural

c.     Semantic

d.     Text

Ans. A

23. MPEG is –

a.     Motive push experts groups

b.     Moving picture experts groups

c.     Mod picture export groups

d.     Man power extended group

Ans. B

24. MPEG-9 recommendations are focused on describing the _________ and structural content of multimedia.

a.     Automated

b.     Version

c.     Object

d.     Semantic

Ans. D


25. Entity-relationship modeling normalization techniques capture only the –

a.     Structural and static relationships of structured data

b.     Shape and size of structured data

c.     Complex and unstructured relationships of structured data

d.     Development and database design

Ans. A

26. Image documents are represented as unstructured data actually a bit or _______ string.

a.     Grammar

b.     Pixel

c.     Semantic

d.     Content

Ans. B

27. Graphic models are easier for a human reader to interpret and check for completeness and correctness than _____ model.

a.     List

b.     Relational

c.     Semantic

d.     Hierarchical

Ans. A

28. Basic entity-relationship modeling and normalization techniques capture only the –

a.     Modeling of complex and unstructured data types

b.     Structure and static relationships of structured data

c.     Dynamic and complex relationship of structured data

d.     Concept of modeled data

Ans. B

29. An MV attribute structure can be defined as –

a.     Ordered or unordered sets

b.     Mismanaged sets

c.     Multivalued sets

d.     Combinational sets

Ans. A

30. VDT can be used either in the select or –

a.     AND clause

b.     WHERE clause

c.     LOCATE clause

d.     LIKE clause

Ans. B

31. A meta-data can be implement as standard atomic –

a.     Attributes and relationships

b.     Database management

c.     Query assumption

d.     Title attribute

Ans. A

32. An OR-DB for web-site maintenance can be developed using –

a.     Term proximity

b.     Similar documents

c.     Metadata elements

d.     Synonym concepts

Ans. C

33. A standard proposal for handling synonyms is to use a thesaurus to –

a.     Select terms to expand the user query

b.     Ignore terms to expand the user query

c.     Select terms to concise the user query

d.     Use the terms of select query

Ans. A

34. An image query is analyzed using.

a.     Query composer

b.     Query signature

c.     Query analyzer

d.     Query comparator

Ans. B

35. Content based retrieval of streamed media relies on the ability to chunk the stream into preferably.

a.     Segmented meaningful parts

b.     Image parts

c.     Scene files

d.     Semantically meaningful parts

Ans. D

36. Semantic heterogeneity is inherent between the creators and users of all kinds of –

a.     Documents

b.     Media data collection

c.     User query

d.     System retrieval

Ans. B

37. Attribute based context and structural medata includes –

a.     Creator, dates

b.     Title, caption

c.     Color, texture

d.     Query, signature


Ans. A


38. Textual queries use –

a.     User based images

b.     Textual image

c.     Query formulation

d.     Term-based specification of the designed image

Ans. D

39. Visual descriptors are used to form the basis for one or more –

a.     Image signatures that can be indexed

b.     Query signs

c.     Storage processes

d.     Shapes within an image

Ans. A

40. An image is basically a long string of –

a.     Grid cells

b.     Pixels

c.     Histograms

d.     Colors

Ans. B


41. Shape identification is the most difficult challenge to image analysis since it relies on.

a.     Isolation of the different objects

b.     Police images of faces and fingerprints

c.     Normalizing the objects size and rotation

d.     Selection of procedures

Which of the above facts are true –

A.     a, d

B.     b, c

C.    a, c

D.    a, b

Ans. C

42. Relational database management system have been constructed to manage the –

a.     Structured data

b.     Data found in administrative systems

c.     Specialized data

d.     Relational data

Which of the above facts are correct –

A.     a, c

B.     b, c

C.    a, b

D.    a, d

Ans. C

43. One of the criticism of first generation object-oriented database management systems was their lack of –

a.     Declarative query

b.     OODBMS relation

c.     Media data

d.     Query with capability

Which of the above facts are correct –

A.     a, b

B.     b, d

C.    a, d

D.    c, d


Ans. C


44. Relational query optimization depends on knowledge of the physical storage of data which is –


a.     Readily available

b.     Problematic

c.     With query optimizer

d.     Access path


Which of the above facts are correct –


A.     a, c

B.     a, d

C.    a, b

D.    c, d


Ans. A


45. Efficiency of a query can be measured by –


a.     Response time

b.     Execution time

c.     Execution sequence

d.     Correctness


Which of the above satisfies the statement.


A.     a, c

B.     b, d

C.    c, d

D.    a, d


Ans. D


46. The most obvious problems using a standard SQL3 system for text search include the –


a.     List of terms

b.     Lack of utilization of the document structure

c.     Dependency on the serial search

d.     Similar documents


Which of the above facts are correct –


A.     a, b

B.     a, d

C.    b, c

D.    c, d


Ans. C


47. Information retrieval systems provide –


a.     Search for text

b.     Retrieval function

c.     Query concepts

d.     Information tracks


The right statements are –


A.     a, d

B.     a, b

C.    a, c

D.    b, d


Ans. C


48. There are three strategies for storing LOBs in an or – DB.


a.     Embedded in a column of the defining relation

b.     Scattered all over the database

c.     Stored on an external medium

d.     Embedded storage in the defined relations


The right facts are –


A.     a, b

B.     a, c

C.    c, d

D.    a, d


Ans. B


49. A data warehouse is –


a.     Subject-oriented

b.     Non-volatile

c.     Data mining

d.     Summarized data


The right facts are –


A.     a, c

B.     a, d

C.    c, d

D.    a, b


Ans. D


50. In normalized data warehouse is –


a.     General reflection of database

b.     Grouped table of subject area

c.     In third normal form

d.     Collection of facts


Which of the above facts are correct –


A.     a, d

B.     a, b

C.    b, c

D.    c, d


Ans. C


51. Data Dredging is the ______ of the data for any ________.


a.     Printing & development

b.     Scanning & relationship

c.     Criticizing & change

d.     Chance & practice


Ans. B


52. Data mining identifies _________ within data that go beyond simple ________.


a.     Trends & analysis

b.     Prediction & analysis

c.     Knowledge & recognition

d.     Discover & activity


Ans. A


53. Cross validation is a common approach to ________ the _______ of a model generated via data mining.


a.     Predict & timeliness

b.     Expose & outlook

c.     Evaluate & fitness

d.     Describe & reliability


Ans. C


54. Sequential pattern mining functions are quite ________ and can be used to _______ the set of customers.


a.     Powerful & detect

b.     Similar & accelerate

c.     Few & approach

d.     Exclusive & update


Ans. A


55. A cluster is a ________ of objects grouped together because of their _______.


a.     Group & diversity

b.     Technique & familiarity

c.     Set & proximity

d.     Member & similarity


Ans. C


56. State true / false –


a.     Clustering according to similarity is a concept which appears in many disciplines

b.     Many data mining application make use of clustering according to similarity.

c.     Segmentation in database are the processes of collecting a data set

d.     Clustering can’t be used for data analysis


Which of the above are true –


A.     a, b

B.     a, d

C.    a, c

D.    b, c


Ans. A


57. Deduction is a ______ to infer information that is a _______ consequences of the information in database.


a.     Induction & physical

b.     Mark & conceptual

c.     Technique & logical

d.     Behavior & normal


Ans. C


58. Decision trees are simple _______ representation and they classif examples to a ________ number of classes.


a.     Knowledge & finite

b.     Layout & infinite

c.     Knowledge & infinite

d.     Layout & finite


Ans. A


59. Induction has been described as the ______ to infer _______ that is generalized from the database.


a.     Technique & information

b.     Way & communication

c.     Way & technique

d.     Information & data


Ans. A


60. Neural networks use a set of ________ elements ________ to neurons in the brain.


a.     Node & similar

b.     Fixed & dissimilar

c.     Fixed & analogous

d.     Processing & analysis


Ans. D










61. Processing elements in neural network are _______ in a _______ that can identify ______ in a _______ once it is exposed to it.


a.     Disconnected, hub, entity & database

b.     Interconnected, network, pattern & data

c.     Overlapped, topology, layout & DBMS

d.     Interconnected, network, database & pattern


Ans. B


62. OLAP applications are quite different from _________ applications which consists of a large _______ of _______ simple ________.


a.     OLTP, number, relatively & transactions

b.     Number, relatively, OLTP & transactions

c.     Transactions, OLTP, number, relatively

d.     Relatively, OLTP, number, transaction


Ans. A


63. OLAP ______ have the _______ for storing ______ data in a _______ form.


a.     Servers, multidimension, relational & expanded

b.     Servers, mean, multidimensional & compressed

c.     Data, ability, relational & network

d.     Database, relation, splitted & report    


Ans. B


64. Data visualization makes it possible for the _______ to gain a _______, more ________ understanding of the data and as such can work well along side _________.


a.     Data mining, intuitive, analyst & deeper

b.     Intuitive, data mining, analyst & deeper

c.     Analyst, intuitive, deeper & data mining

d.     Analyst, deeper, intuitive data mining


Ans. D


65. The easiest way of introducing _________ in the _______ model Is to use ________ relational database and ________ front on to it that shall allow fuzzy querying to the database.


a.     Fuzziness, database, classical & formulate

b.     Database, classical, formulate & fuzziness 

c.     Classical, fuzziness, formulate & database

d.     Fuzziness, database, formulate & classical


Ans. A


66. Software components which are typically necessary for building a distributed database are –


a.     Data processor

b.     User processor

c.     Network transparency

d.     DDB

e.     Operating system support


Which of the above are true –


A.     a, b, c

B.     b, e

C.    a, b, d

D.    d, e


Ans. C


67. The data processor consists of three elements –


a.     Local query optimizer

b.     Distributed execution monitor

c.     Local recovery manager

d.     Run-time support processor


Which of the above are true –


A.     a, b

B.     a, c

C.    c, d

D.    a, b


Ans. B


68. Match the following for a transaction-processing framework.


a. Atomicity                                                                           1. Database from one consistent state to another

b. Consistency preservation                                              2. Not inferring with by any other transaction executing currently

c. Isolation                                                                             3. Either all or none of the transactions operations are performed

d. Durability                                                                          4. Once a transaction has committed


A.     a-4, b-1, c-2, d-3

B.     a-3, b-2, c-3, d-1

C.    a-1, b-4, c-1, d-2

D.    a-2, b-3, c-4, d-4


Ans. D


69. Failure can be classified as –


a.     Transaction failure

b.     Fund failure

c.     Media failure

d.     State failure

e.     Frame failure

f.      Communication failure


A.     a, c, f

B.     a, b, e

C.    a, c, e, f

D.    a, e


Ans. A


70. The biased protocol is based on a ________ similar to that of the majority ________. The _______ maintains a _________ manager at each site.


a.     Model, protocol, system & lock

b.     Lock, protocol, model & system

c.     System, protocol, lock & model

d.     Model, lock, system & protocol


Ans. A


71. Match the facts related to uncertainty –



a. Fuzziness                                                                         1. Dissonance

b. Discard                                                                              2. Haziness

c. Non-specific                                                     3. Unclear

d. Ambiguity                                                                         4. Diversity


A.     a-3, b-2, c-1, d-4

B.     a-2, b-1, c-4, d-3 

C.    a-4, b-3, c-1, d-2

D.    a-3, b-2, c-4, d-1


Ans. B


72. Which of the statements are true –


1. There are number of relational operation in addition to join

2. The flexibility of DBMS doesn’t allow programmers to write queries

3. The dimensional model is a specialized adaptation of the relational model

4. Fourth normal form is an extension of BCNF for functional and multivalued dependencies

5. In an OLAP query dimensions are not chosen


a.     1, 3, 5

b.     1, 3, 4

c.     1, 2, 5

d.     3, 4


Ans. B


73. The _______ model is a specialized ________ of the ________ model used to represent data in ________.


a.     Data warehouses, dimensional, adaptation, relational

b.     Relational, adaptation, dimensional, data warehouse

c.     Dimensional, adaptation, relational, data warehouses

d.     Dimensional, data warehouses, adaptation, operations


Ans. C


74. Which of the following are not true about database models.


1. Post-relational databases could not be considered as a sub-set of object databases

2. A cascading rollback occurs in database system when a transactions fails

3. Data from multiple table can combined into one

4. A data query can’t get any data item fetched


a.     1, 2, 4

b.     1, 4,

c.     2, 4

d.     1, 2, 3


Ans. B


75. Match the following –


a. Master / slave replication                                               1. Two or more replicas

b. Quorum                                                                                             2. Read / write result is calculated

c. Multimaster                                                                       3. Query

d. Database                                                                                          4. All write request


A.     a-4, b-2, c-1, d-3

B.     a-2, b-3, c-1, d-4

C.    a-3, b-2, c-1, d-4

D.    a-1, b-2, c-4, d-3


Ans. A