ADVANCE DBMS
1-Mark
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
2-Marks
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
4-Marks
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