Database Management System (DMS)

Multiple Choice Questions (MCQs)

Go To pages -> 0/1/2/3/4/5/6/7

1   A Database Management System (DBMS) is
    (A)   Collection of interrelated data
    (B)   Collection of programs to access data
    (C)   Collection of data describing one particular enterprise
    (D)   All of the above
2   Which of the following is not a level of data abstraction?
    (A)   Physical Level
    (B)   Critical Level
    (C)   Logical Level
    (D)   View Level
3   Disadvantages of File systems to store data is
    (A)   Data redundancy and inconsistency
    (B)   Difficulty in accessing data
    (C)   Data isolation
    (D)   All of the above
4   In an Entity-Relationship Diagram Rectangles represents
    (A)   Entity sets
    (B)   Attributes
    (C)   Database
    (D)   Tables
5   Which of the following is not a Storage Manager Component?
    (A)   Transaction Manager
    (B)   Logical Manager
    (C)   Buffer Manager
    (D)   File Manager
6   Data Manipulation Language enables users to
    (A)   Retrieval of information stored in database
    (B)   Insertion of new information into the database
    (C)   Deletion of information from the database
    (D)   All of the above
7   Which of the following is not a Schema?
    (A)   Database Schema
    (B)   Physical Schema
    (C)   Critical Schema
    (D)   Logical Schema
8   Which of the following is Database Language?
    (A)   Data Definition Language
    (B)   Data Manipulation Language
    (C)   Query Language
    (D)   All of the above
9   Which of the following in not a function of DBA?
    (A)   Network Maintenance
    (B)   Routine Maintenance
    (C)   Schema Definition
    (D)   Authorization for data access
10   Which of the following is a Data Model?
    (A)   Entity-Relationship model
    (B)   Relational data model
    (C)   Object-Based data model
    (D)   All of the above
11   Which of the following represents a relationship among a set of values?
    (A)   A Row
    (B)   A Table
    (C)   A Field
    (D)   A Column
12   Column header is refer as
    (A)   Table
    (B)   Relation
    (C)   Attributes
    (D)   Domain
13   A Relation is a
    (A)   Subset of a Cartesian product of a list of attributes
    (B)   Subset of a Cartesian product of a list of domains
    (C)   Subset of a Cartesian product of a list of tuple
    (D)   Subset of a Cartesian product of a list of relations
14   In mathematical term Table is referred as
    (A)   Relation
    (B)   Attribute
    (C)   Tuple
    (D)   Domain
15   In mathematical term Row is referred as
    (A)   Relation
    (B)   Attribute
    (C)   Tuple
    (D)   Domain
16   _______ allow us to identify uniquely a tuple in the relation.
    (A)   Super key
    (B)   Domain
    (C)   Attribute
    (D)   Schema
17   Minimal Super keys are called
    (A)   Schema keys
    (B)   Candidate keys
    (C)   Domain keys
    (D)   Attribute keys
18   Which of the following is not Modification of the Database?
    (A)   Deletion
    (B)   Insertion
    (C)   Sorting
    (D)   Updating
19   Which of the following is Relation-algebra Operation?
    (A)   Select
    (B)   Union
    (C)   Rename
    (D)   All of the above
20   Which of the following in not Outer join?
    (A)   Left outer join
    (B)   Right outer join
    (C)   Full outer join
    (D)   All of the above
21   Who proposed the relational model?
    (A)   Bill Gates
    (B)   E.F. Codd
    (C)   Herman Hollerith
    (D)   Charles Babbage
22   Set of permitted values of each attribute is called
    (A)   Domain
    (B)   Tuple
    (C)   Relation
    (D)   Schema
23   Which of the following is true regarding Null Value?
    (A)   Null = 0
    (B)   Null <0
    (C)   Null> 0
    (D)   Null<>0
24   Logical design of database is called
    (A)   Database Instance
    (B)   Database Snapshot
    (C)   Database Schema
    (D)   All of the above
25   Snapshot of the dta in the database at a given instant of time is called
    (A)   Database Schema
    (B)   Database Instance
    (C)   Database Snapshot
    (D)   All of the above
26   Which of the following is not Unary operation?
    (A)   Select
    (B)   Project
    (C)   Rename
    (D)   Union
27   Which of the following is not binary operation?
    (A)   Union
    (B)   Project
    (C)   Set Difference
    (D)   Cartesian product
28   Which of the following is correct regarding Aggregate functions?
    (A)   It takes a list of values and returns a single values as result
    (B)   It takes a list of values and returns a list of values as result
    (C)   It takes a single value and returns a list of values as result
    (D)   It takes a single value and returns a single value as result
29   The Primary key must be
    (A)   Non Null
    (B)   Unique
    (C)   Option A or B
    (D)   Option A and B
30   A command to remove a relation from an SQL database
    (A)   Delete table
      (B)   Drop table
      (C)   Erase table
      (D)   Alter table
    31   Which of the following is not an Aggregate function?
      (A)   Min
      (B)   Max
      (C)   Select
      (D)   Avg
    32   The attribute that can be divided into other attributes is called
      (A)   Simple Attribute
      (B)   Composite Attribute
      (C)   Multi-valued Attribute
      (D)   Derived Attribute
    33   In an Entity-Relationship Diagram “Ellipses” represents
      (A)   Attributes
      (B)   Weak entity set
      (C)   Relationship sets
      (D)   Multi-valued attributes
    34   In an Entity-Relationship Diagram “Diamonds” represents
      (A)   Attributes
      (B)   Multi-valued attributes
      (C)   Weak entity set
      (D)   Relationship sets
    35   What are ACID properties of Transactions?
      (A)   Atomicity, Consistency, Isolation, Database
      (B)   Atomicity, Consistency, Isolation, Durability
      (C)   Atomicity, Consistency, Inconsistent, Durability
      (D)   Automatically, Concurrency, Isolation, Durability
    36   If every non-key attribute is functionally dependent on the primary key, the relation will be in
      (A)   First Normal Form
      (B)   Second Normal Form
      (C)   Third Normal Form
      (D)   Fourth Formal Form
    37   Database locking concept is used to solve the problem of
      (A)   Lost Update
      (B)   Uncommitted Dependency
      (C)   Inconsistent Data
      (D)   All of the above
    38   UML is stands for
      (A)   Universal Modeling Language
      (B)   Unified Modeling Language
      (C)   United Modeling Language
      (D)   Uni Modeling Language
    39   Data Manipulation Language (DML) is not to
      (A)   Create information table in the Database
      (B)   Insertion of new information into the Database
      (C)   Deletion of information in the Database
      (D)   Modification of information in the Database
    40   Which of the following in true regarding Referential Integrity?
      (A)   Every primary-key value must match a primary-key value in an associated table
      (B)   Every primary-key value must match a foreign-key value in an associated table
      (C)   Every foreign-key value must match a primary-key value in an associated table
      (D)   Every foreign-key value must match a foreign-key value in an associated table
    41   Which of the following option is use to retrieval of data?
      (A)   Stack
      (B)   Data Structure
      (C)   Linked list
      (D)   Query
    42   ODBC stands for ______
      (A)   Offline database connection
      (B)   Oriented database connection
      (C)   Open database connection
      (D)   None of above
    43   Which algebra is widely used in DBMS?
      (A)   Relational algebra
      (B)   Arithmetic algebra
      (C)   Both
      (D)   None
    44   Which of the following is a unary operation?
      (A)   Selection operation
      (B)   Generalized selection
      (C)   Primitive operation
      (D)   Projection operation
    45   Which SQL Query is use to remove a table and all its data from the database?
      (A)   Create Table
      (B)   Alter Table
      (C)   Drop Table
      (D)   None of these
    46   In precedence of set operators the expression is evaluated from:
      (A)   Left to Left
      (B)   Left to Right
      (C)   Right to Right
      (D)   Right to Left
    47   In DBMS FD stands for _______
      (A)   Facilitate data
      (B)   Functional data
      (C)   Facilitate dependency
      (D)   Functional dependency
    48   How many types of keys in Database Design?
      (A)   Candidate key
      (B)   Primary key
      (C)   Foreign key
      (D)   All of these
    49   Which of the following is based on Multi Valued Dependency?
      (A)   First
      (B)   Second
      (C)   Third
      (D)   Fourth
    50   Which of the following is the structure of the Database?
      (A)   Table
      (B)   Schema
      (C)   Relation
      (D)   None of these
    51   The minimal set of super key is called
      (A)   Primary key
      (B)   Secondary key
      (C)   Candidate key
      (D)   Foreign key
    52   A relation that has no partial dependencies is in which normal form
      (A)   First
      (B)   Second
      (C)   Third
      (D)   BCNF
    53   A functional dependency between two or more non-key attributes is called
      (A)   Transitive dependency
      (B)   Partial transitive dependency
      (C)   Functional dependency
      (D)   Partial functional dependency
    54   A logical description of some portion of database that is required by a user to perform task is called as
      (A)   System View
      (B)   User View
      (C)   Logical View
      (D)   Data View
    55   ______________ is a classical approach to database design?
      (A)   Left – Right approach
      (B)   Right – Left approach
      (C)   Top – Down approach
      (D)   Bottom – Up approach
    56   _____________ refers to the correctness and completeness of the data in a database?
      (A)   Data security
      (B)   Data integrity
      (C)   Data constraint
      (D)   Data independence
    57   A table that displays data redundancies yields ____________ anomalies
      (A)   Insertion
      (B)   Deletion
      (C)   Update
      (D)   All of the above
    58   A lock that allows concurrent transactions to access different rows of the same table is known as a
      (A)   Field-level lock
      (B)   Row-level lock
      (C)   Table-level lock
      (D)   Database-level lock
    59   A type of query that is placed within a WHERE or HAVING clause of another query is called
      (A)   Super query
      (B)   Sub query
      (C)   Master query
      (D)   Multi-query
    60   A transaction completes its execution is said to be
      (A)   Saved
      (B)   Loaded
      (C)   Rolled
      (D)   Committed
    61   In the relational model, cardinality is termed as:
      (A)   A number of tuples
      (B)   A number of attributes
      (C)   A number of tables
      (D)   A number of constraints
    62   Relational calculus is a
      (A)   Procedural language
      (B)   Non-procedural language
      (C)   Data definition language.
      (D)   High- IeveI language
    63   The view of total database content is
      (A)   Conceptual view
      (B)   Internal view
      (C)   External view
      (D)   Physical View
    64   Cartesian product in relational algebra is
      (A)   A Unary operator
      (B)   A Binary operator
      (C)   A Ternary operator
      (D)   Not defined
    65   DML is provided for
      (A)   Description of the logical structure of a database
      (B)   The addition of new structures in the database system
      (C)   Manipulation g’ processing of the database
      (D)   Definition of a physical structure of the database system
    66   ‘AS’ clause is used in SQL for
      (A)   Selection operation
      (B)   Rename operation
      (C)   Join operation
      (D)   Projection operation
    67   ODBC stands for
      (A)   Object Database Connectivity
      (B)   Oral Database Connectivity
      (C)   Oracle Database Connectivity
      (D)   Open Database Connectivity
    68   Architecture of the database can be viewed as
      (A)   Two levels
      (B)   Four levels
      (C)   Three levels
      (D)   One level
    69   In a relational model, relations are termed as
      (A)   Tuples
      (B)   Attributes
      (C)   Ta ales
      (D)   Rows
    70   The database schema is written in
      (A)   HLL
      (B)   DML
      (C)   DDL
      (D)   DCL
    71   In the architecture of a database system external level is the
      (A)   Physical level
      (B)   Logical level
      (C)   Conceptual level
      (D)   View level
    72   An entity set that does not have sufficient attributes to form a primary key is a
      (A)   Strong entity set
      (B)   Weak entity set
      (C)   Simple entity set
      (D)   Primary entity set
    73   In Hierarchical model records are organized as
      (A)   Graph
      (B)   List
      (C)   Links
      (D)   Tree
    74   In an E-R diagram attributes are represented by
      (A)   Rectangle
      (B)   Square
      (C)   Ellipse
      (D)   Triangle
    75   In case of entity integrity, the primary key maybe
      (A)   Not Null
      (B)   Null
      (C)   Both Null & not Null
      (D)   Any value
    76   The language used in application programs to request data from the DBMS is referred to as the
      (A)   DML
      (B)   DDL
      (C)   VDL
      (D)   SDL
    77   A logical schema
      (A)   Is the entire database
      (B)   Is a standard way of organizing information into accessible parts
      (C)   Describes how data is actually stored on disk
      (D)   Both A and C
    78   Related fields in a database are grouped to form a
      (A)   Data file
      (B)   Data record
      (C)   Menu
      (D)   Bank
    79   The database environment has all of the following components except:
      (A)   Users
      (B)   Separate files
      (C)   Database
      (D)   Database administrator
    80   The language which has recently become the defacto standard for interfacing application programs with relational database system is
      (A)   Oracle
      (B)   SQL
      (C)   DBase
      (D)   4GL
    81   The way a particular application views the data from the database that the application uses is a
      (A)   Module
      (B)   Relational model
      (C)   Schema
      (D)   Subschema
    82   In an E-R diagram an entity set is represented by a
      (A)   Rectangle
      (B)   Ellipse
      (C)   Diamond box
      (D)   Circle
    83   A report generator is used to
      (A)   Update files
      (B)   Print files on paper
      (C)   Data entry
      (D)   Delete files
    84   The property/properties of a database is/are:
      (A)   It is an integrated collection of logically related records
      (B)   It consolidates separate files into a common pool of data records
      (C)   Data stored in a database is independent of the application programs using it
      (D)   All of the above
    85   The DBMS language component which can be embedded in a program is
      (A)   The data definition language (DDL)
      (B)   The data manipulation language (DML)
      (C)   The database administrator (DBA)
      (D)   A query language
    86   A relational database developer refers to a record as
      (A)   Criteria
      (B)   A relation
      (C)   A tuple
      (D)   An attribute
    87   The relational model feature is that there
      (A)   Is no need for primary key data
      (B)   Is much more data independence than some other database models
      (C)   Are explicit relationships among records
      (D)   Are tables with many dimensions
    88   Conceptual design
      (A)   Is a documentation technique
      (B)   Needs data volume and processing frequencies to determine the size of the database
      (C)   Involves modeling independent of the DBMS
      (D)   Is designing the relational model
    89   The method in which records are physically stored in a specified order according to a key field in each record is
      (A)   Hash
      (B)   Direct
      (C)   Sequential
      (D)   All of the above
    90   A subschema expresses
      (A)   The logical view
      (B)   The physical view
      (C)   The external view
      (D)   All of the above
    91   Count function in SQL returns the number of
      (A)   Values
      (B)   Distinct values
      (C)   Groups
      (D)   Columns
    92   Which one of the following statements is false?
      (A)   The data dictionary is normally maintained by the database administrator
      (B)   Data elements in the database can be modified by changing the data dictionary
      (C)   The data dictionary contains the name and description of each data element
      (D)   A data dictionary is a tool used exclusively by the database administrator
    93   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)   None of the above
    94   A DBMS query language is designed to
      (A)   Support end-users who use English-like commands
      (B)   Support in the development of complex applications software
      (C)   Specify the structure of a database
      (D)   All of the above
    95   Transaction processing is associated with everything below except
      (A)   Producing detail, summary, or exception reports
      (B)   Recording a business activity
      (C)   Confirming an action or triggering a response
      (D)   Maintaining data
    96   It is possible to define a schema completely using
      (A)   VDL and DDL
      (B)   DDL and DML
      (C)   SDL and DDL
      (D)   VDL and DML
    97   The method of access which uses key transformation is known as
      (A)   Direct
      (B)   Hash
      (C)   Random
      (D)   Sequential
    98   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 B and C
    99   The statement in SQL which allows changing the definition of a table is
      (A)   Alter
      (B)   Update
      (C)   Create
      (D)   Select
    100   E-R model uses this symbol to represent a weak entity set?
      (A)   Dotted rectangle
      (B)   Diamond
      (C)   Doubly outlined rectangle
      (D)   None of these

Go To pages -> 0/1/2/3/4/5/6/7

Back to Top