database important mcqs | database important mcqs for all test

   

You can do quick preparation of database tests. We have divided the test into  section . Each section contains 30 mcqs with answers . Test 1 includes important mcqs related to database , database environment, ER model and Semantic Object Model . Test 2 includes mcqs  related normalization, Conversion of E-R model to database ,sql and concurrency and security .Test 3 includes the important mcqs related ODBC, object oriented database , MS Access. In the end of article you can get pdf of all tests . 

Test 1 

• A set of related files created and managed by a database management system is called ________

              a)field    b)Record     c)Database     Data warehouse

• ____________is a software that controls the organization, storage , retrieval , security and integrity of data in a database . 

             a)Default     b)Information system     c)Data warehouse     d)DBMS

• Which of the following is handled by the DBMS  .

             a)Data integrity     b)Data Security     c)Data Independence     d)All of the above

• All records in a file have the same __________

             a)content     b)Structure     c)Key value     d)None

• Choose the item that represents bad design in a database . 

              a)Data security     b)Data redundancy     c)Data independence     d)Data maintenance

• For database development , most important web-related technology in  recent years is

             a)FTP     b)HTTP     c)XML     d)All

• Which of the following is not one of the three Schemas used in the ANSI/SPARC.

             a)External     b)Internal     c)Implementation     d)Conceptual 

• Which of three schemas used in three-schema model represents how users view database ? 

             a)External     b)Internal     c)Implementation     d)Conceptual

• The older logical database model that organizes data in a treelike structure is .

             a)Hierarchical     b)Network     c)Relational     d)Object

• Which of the following is not a major area for the database administrator .

             a)Planning     b)Programming     c)Implementation     d)Security 

• Properties that describe the entity's characteristics are called 

             a)Entity     b)Attribute     c)Identifier     d)Relationship

• Attributes that name , or identify, entity instances are called

            a)Entity     b)Attribute     c)Identifier     d)Relationship

• Which of the following refers to an entity that logically depends on another entity ? 

            a)Weak Entity     b)Strong Entity     c)ID-dependent Entity     d)Dependent 

• IN an E-R diagram, a rectangle represents 

             a)Entity class     b)Weak entity     c) Relationship     d)Attribute 

• In an E-R diagram , a ellipse represents .

             a)Entity class     b)Weak entity     c) Relationship     d)Attribute 

• The degree of a relationship refers to the 

             a)Number of entities     b)Max Cardinality     c)min Cardinality     d)Number of attributes

• Depending on the system being modelled , a relationship can have ? entities 

            a)One     b)Two     c) Three     d) All

1. Which type of attribute is composed of other attributes ?

            a)Simple     b) Meta     c)Group     d)Compound

1. The term 'semantic' means .

            a)Data     b)Meaning     c)Attribute     d)Detailed

• Combinations of composite and compound objects are known as ___________object.

            a)hybrid object     b)Association     c)Sub-type     d)Arch-type

• Attributes which have a single element are called __________attribute.

            a)Simple      b)group    c) Semantic object     d)paired 

• The set of an attribute's specific values is called.

            a)Identifier     b)Domain     c)Enumerated list     d)Attribute

• The process of developing a set of object diagrams is . 

            a)Sequential     b)Iterative     c)Parallel     d)Singular

• Which are the three types of domains ? 

            a)group,compound and association     b)simple , group and semantic     c)compound ,hybrid                       and  association 

• One or more object attributes that the users employ to identify object instances is called . 

            a) Group identifiers     b)Object identifiers     c)Compound Identifiers    d) Domain