Hello Friends,this particular section is well focused on the Frequently asked;DBMS Multiple Choice Questions with Answers in the various competitive exam. the set of questions are very basic and easily understandable by reader.we have kept the question hardness level to very basic.
PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE
1. In case of entity integrity, the primary key may be
- not Null
- Null
- both Null & not Null.
- any value.
A. not Null
2. The language used in application programs to request data from the DBMS is referred to as the
- DML
- DDL
- VDL
- SDL
A. DML
3. A logical schema
- is the entire database.
- is a standard way of organizing information into accessible parts.
- describes how data is actually stored on disk.
- both (A) and (C)
A. is the entire database.
4. Related fields in a database are grouped to form a
- data file.
- data record.
- menu
- bank
B. data record.
5. The database environment has all of the following components except:
- users
- separate files.
- database
- database administrator.
A. users
6. The language which has recently become the defacto standard for interfacing application programs with relational database system is
- Oracle
- SQL
- DBase
- 4GL
B. SQL
7. In the architecture of a database system external level is the
- physical level.
- logical level.
- conceptual level
- view level.
D. view level.
8. An entity set that does not have sufficient attributes to form a primary key is a
- strong entity set.
- weak entity set.
- simple entity set.
- primary entity set.
B. weak entity set.
9. In a Hierarchical model records are organized as
- Graph
- List
- Links
- Tree
D. Tree
10. In an E-R diagram attributes are represented by
- rectangle
- square
- ellipse
- triangle
C. ellipse
