Database Management System-5

Multiple Choice Questions (MCQs)

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

1   Batch processing is appropriate if
    (A)   Large computer system is available
    (B)   Only a small computer system is available
    (C)   Only a few transactions are involved
    (D)   None of the above
2   Large collection of files are called
    (A)   Fields
    (B)   Records
    (C)   Database
    (D)   Sectors
3   Which of the following is not a relational database?
    (A)   dBase IV
    (B)   4th Dimension
    (C)   FoxPro
    (D)   Reflex
4   In order to use a record management system
    (A)   You need to understand the low level details of how information is stored
    (B)   You need to understand the model the record management system uses
    (C)   Bother a and b
    (D)   None of the above
5   Sort/Report generators
    (A)   Are faster than index/report generators
    (B)   Require more disk space than indexed/report generators
    (C)   Do not need to sort before generating report
    (D)   Both a and b
6   If a piece of data is stored in two places in the database, then
    (A)   Storage space is wasted
    (B)   Changing the data in one spot will cause data inconsistency
    (C)   In can be more easily accessed
    (D)   Both and b
7   An audit trail
    (A)   Is used to make backup copies
    (B)   Is the recorded history of operations performed on a file?
    (C)   Can be used to restore lost information
    (D)   None of the above
8   The relational database environment has all of the following components except
    (A)   Users
    (B)   Separate files
    (C)   Database
    (D)   Query languages
9   Database management systems are intended to
    (A)   Eliminate data redundancy
    (B)   Establish relationship among records in different files
    (C)   Manage file access
    (D)   All of the above
10   One approach to standardization storing of data
    (A)   MIS
    (B)   Structured programming
    (C)   CODASYL specification
    (D)   None of the above
11   The language used application programs to request data from the DBMS is referred to as the
    (A)   DML
    (B)   DDL
    (C)   Query language
    (D)   Any of the above
12   The highest level in the hierarchy of data organization is called
    (A)   Data bank
    (B)   Data base
    (C)   Data file
    (D)   Data record
13   Choose the RDBMS which supports full fledged client server application development
    (A)   dBase V
    (B)   Oracle 7.1
    (C)   FoxPro 2.1
    (D)   Ingress
14   Report generators are used to
    (A)   Store data input by a user
    (B)   Retrieve information from files
    (C)   Answer queries
    (D)   Both b and c
15   A form defined
    (A)   Where data is placed on the screen
    (B)   The width of each field
    (C)   Both A and B
    (D)   None of the above
16   The management information system (MIS) structure with one main computer system is called a
    (A)   Hierarchical MIS structure
    (B)   Distributed MIS structure
    (C)   Centralized MIS structure
    (D)   Decentralized MIS structure
17   DBA stands for:
    (A)   Database associated
    (B)   Database administrator
    (C)   Database application
    (D)   None of these
18   DBMS stands for:
    (A)   Database associated
    (B)   Database administrator
    (C)   Database application
    (D)   Database management system
19   Which means a place where data can be stored in a structured manner?
    (A)   CPU
    (B)   Database
    (C)   ALU
    (D)   All of these
20   A database is a complex ______:
    (A)   Data structure
    (B)   Memory
    (C)   Both
    (D)   None
21   The set of data available to the user, the so-called:
    (A)   Start-user data
    (B)   End-user data
    (C)   Database
    (D)   None of these
22   How is describing the end-user data:
    (A)   Memory
    (B)   CPU
    (C)   ALU
    (D)   Data
23   DBMS is to impose a logical and structured organization on:
    (A)   Register
    (B)   Data
    (C)   Memory
    (D)   None of these
24   How many basic operations are performed in DBMS?
    (A)   1
    (B)   2
    (C)   3
    (D)   4
25   Basic operations performed in DBMS are:
    (A)   Management of data in the database
    (B)   Management of user associated with database
    (C)   Both
    (D)   None
26   _____is a collection of programs performing all necessary action associated with a database:
    (A)   Database associated
    (B)   Database administrator
    (C)   Database application
    (D)   Database management system
27   _______is a program or set of program that interacts with the database at some point in its execution:
    (A)   A database system
    (B)   A database application
    (C)   Both
    (D)   None
28   ________is a collection of application programs that interacts with the database along with DBMS:
    (A)   A database system
    (B)   A database application
    (C)   Both
    (D)   None
29   In which services the processes of database management and data management are complementary:
    (A)   Database associated
    (B)   Database administrator
    (C)   Database application
    (D)   Database management system
30   ACID stands for:
    (A)   Atomicity, consistency, isolation, and durability
    (B)   Atomicity, command, integrity, and data
    (C)   Atomicity, control, integrated, and direct
    (D)   None of these
31   A DBMS provides users with the conceptual representation of:
    (A)   Register
    (B)   Data
    (C)   Logical view
    (D)   Physical view
32   Which structure of data clearly is one of the main features of the database approach?
    (A)   Logical view
    (B)   Physical view
    (C)   Both
    (D)   None
33   A _____view of data expresses the way a user thinks about data
    (A)   Logical view
    (B)   Physical view
    (C)   Both
    (D)   None
34   A physical view of data refers to the way data is handled at a_____ its storage and retrieval:
    (A)   High level
    (B)   Low level
    (C)   Medium level
    (D)   All of these
35   In logical and physical view of data the set of principles that defines a data model may be divided into how many parts:
    (A)   1
    (B)   2
    (C)   3
    (D)   4
36   In logical and physical view of data the set of principles that defines a data model may be divided into which part:
    (A)   Data definition
    (B)   Data manipulation
    (C)   Data integrity
    (D)   All of these
37   The overall description of a database is called______:
    (A)   Data definition
    (B)   Data manipulation
    (C)   Data integrity
    (D)   Database schema
38   Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid or protect information:
    (A)   Schema
    (B)   Subschema
    (C)   Non-schema
    (D)   None-subschema
39   A data dictionary is a repository that manages _____:
    (A)   Database
    (B)   Memory
    (C)   Metadata
    (D)   All of these
40   Which languages are used to define and query a database?
    (A)   Database
    (B)   Memory
    (C)   Metadata
    (D)   All of these
41   DDL stand for:
    (A)   Data definition language
    (B)   Data description languages
    (C)   Data design languages
    (D)   Database dictionary languages
42   Which are the not most frequently used DDL statements?
    (A)   CREATE
    (B)   DROP
    (C)   ALTER
    (D)   None of these
43   VDL stand for:
    (A)   View data languages
    (B)   View design languages
    (C)   View definition languages
    (D)   View done languages
44   SDL stands for
    (A)   Stand definition languages
    (B)   Storage definition languages
    (C)   Select definition languages
    (D)   System definition languages
45   The DDL is used to specify the_____:
    (A)   Conceptual schemas
    (B)   Internal schemas
    (C)   Both
    (D)   None
46   The SDL is used to specify the_______:
    (A)   Conceptual schemas
    (B)   Internal schemas
    (C)   Both
    (D)   None
47   DML stands for:
    (A)   Data description languages
    (B)   Data design languages
    (C)   Database dictionary languages
    (D)   Data manipulation languages
48   Which is used for data retrieval from the database?
    (A)   DDL
    (B)   DML
    (C)   SDL
    (D)   VDL
49   Which is used to specify the user views and their mappings to the conceptual schema?
    (A)   DDL
    (B)   DML
    (C)   SDL
    (D)   VDL
50   How many types of DML:
    (A)   1
    (B)   2
    (C)   3
    (D)   4
51   What are the types of DML?
    (A)   Low level
    (B)   High level
    (C)   Procedural DML
    (D)   All of these
52   Which is requires a user to specify what data is needed and how to get it:
    (A)   Low level
    (B)   Procedural DML
    (C)   Both
    (D)   None
53   Data is manipulated by procedure calls to subroutines provided by a_____:
    (A)   Data
    (B)   DBMS
    (C)   Register
    (D)   All of these
54   The programming languages are called:
    (A)   Sublanguages
    (B)   Host languages
    (C)   VDL
    (D)   DDL
55   The DML is called:
    (A)   Sublanguages
    (B)   Host languages
    (C)   VDL
    (D)   DDL
56   Which command are included in a general purpose programming languages?
    (A)   DDL
    (B)   DML
    (C)   SDL
    (D)   VDL
57   A database management system is very complex_____:
    (A)   Art
    (B)   Command
    (C)   Languages
    (D)   System
58   How many levels of abstraction in DBMS:
    (A)   2
    (B)   3
    (C)   4
    (D)   5
59   Which are the three levels of abstraction?
    (A)   Physical
    (B)   Logical
    (C)   External
    (D)   All of these
60   How many types of data independence:
    (A)   1
    (B)   2
    (C)   3
    (D)   4
61   Which are the types of data independence?
    (A)   Physical
    (B)   Logical
    (C)   Both
    (D)   All of these
62   Which is the transformation of requests and results between different levels of abstraction?
    (A)   Evaluation
    (B)   Mapping
    (C)   Compiler
    (D)   Precompiler
63   Which mapping exists between the conceptual and internal levels?
    (A)   Conceptual
    (B)   Internal
    (C)   Both
    (D)   None
64   Which mapping exists between the external and conceptual levels?
    (A)   Conceptual
    (B)   Internal
    (C)   Both
    (D)   None
65   The related and interconnected software components of a DBMS are described by the _______
    (A)   Logical architecture
    (B)   Physical architecture
    (C)   Both
    (D)   None
66   Which are the types of physical DBMS architecture can be split:
    (A)   Back end
    (B)   Front end
    (C)   Both
    (D)   None
67   In which end is really just any application that runs on top of the DBMS and acts as a user interface:
    (A)   Back end
    (B)   Front end
    (C)   Both
    (D)   None
68   Data are stored in________ as database:
    (A)   Data files
    (B)   Data dictionary
    (C)   Database
    (D)   Data administrator
69   RAD stands for:
    (A)   Rotate application development
    (B)   Register application development
    (C)   Related application development
    (D)   Rapid application development
70   DA stands for:
    (A)   Data administrator
    (B)   Database active
    (C)   Define application
    (D)   All of these
71   Which is the person responsible for overall control of the database system?
    (A)   DDL
    (B)   DBMS
    (C)   DBA
    (D)   SDL
72   DBA stands for:
    (A)   Database maintenance
    (B)   Database administrator
    (C)   Database backup
    (D)   Database designer
73   Transaction is an action used to perform some manipulation on data stored in the____:
    (A)   Memory
    (B)   Record
    (C)   Database
    (D)   All of these
74   How many features of a DBMS which provide a number of advantages for data management:
    (A)   1
    (B)   3
    (C)   5
    (D)   7
75   Which is a DBMS keeps back-up copies of the database:
    (A)   Backup
    (B)   Recovery
    (C)   Both
    (D)   None
76   In which the database can be restored up to the last consistent state after the system failure:
    (A)   Backup
    (B)   Recovery
    (C)   Both
    (D)   None
77   Which are the not user in End-user:
    (A)   Naïve users
    (B)   Casual users
    (C)   Sophisticated user
    (D)   All of these
78   Which are the not features of a DBMS which provide a number of advantages for data management:
    (A)   DML
    (B)   DDL
    (C)   SDL
    (D)   None of these
79   Minimal data redundancy means improved _________:
    (A)   Data independence
    (B)   Data consistency
    (C)   Data integration
    (D)   Data sharing
80   Who access the database occasionally and have different needs each time:
    (A)   Naïve users
    (B)   Casual users
    (C)   Sophisticated user
    (D)   All of these
81   Who interact with the system without writing a program?
    (A)   Naïve users
    (B)   Casual users
    (C)   Sophisticated user
    (D)   All of these
82   Who interact with the system by invoking one of the permanent application programs?
    (A)   Naïve users
    (B)   Casual users
    (C)   Sophisticated user
    (D)   All of these
83   The main interface that a native user uses is a form interface using___:
    (A)   DDL
    (B)   GUI
    (C)   OLAP
    (D)   DML
84   The provision of _______ is a major objective for database system:
    (A)   Data independence
    (B)   Data consistency
    (C)   Data integration
    (D)   Data sharing
85   Who is requested to carry out various operations, such as insert, delete, update and retrieval on the database by the user?
    (A)   DBA
    (B)   DBMS
    (C)   DBS
    (D)   DDL
86   ____ is a translates into low-level instruction that a query processor understands:
    (A)   DBA
    (B)   DBMS
    (C)   DBS
    (D)   DDL
87   Retrieval of data is done by using a ____:
    (A)   Stack
    (B)   Query
    (C)   Linked list
    (D)   All of these
88   DML is a language by which user accesses or manipulates the ________:
    (A)   Data model
    (B)   Data consistency
    (C)   Data integration
    (D)   Data sharing
89   Which is the central component of the DBMS software that can also be termed as the database control system?
    (A)   Data consistency
    (B)   Data integration
    (C)   Data sharing
    (D)   Data manager
90   Which is stored information about description of data in the database?
    (A)   Data files
    (B)   Data dictionary
    (C)   Database
    (D)   Data administrator
91   After conversion of high level queries into low level commands for file access and is called compiled_____:
    (A)   DDL
    (B)   DML
    (C)   SDL
    (D)   VDL
92   Which is installs, configures, troubleshoots and maintains a database system:
    (A)   DBA
    (B)   DDL
    (C)   DML
    (D)   SDL
93   Which is incorporated to create an appropriate physical database that is transformed by a logical data model?
    (A)   SDL
    (B)   VDL
    (C)   Both
    (D)   None
94   SQL stands for:
    (A)   System query language
    (B)   Sequential query language
    (C)   Sets query languages
    (D)   None of these
95   CSV stands for:
    (A)   Command system values
    (B)   Comma system values
    (C)   Command separated values
    (D)   Comma separated values
96   PDF stands for:
    (A)   Physical data format
    (B)   Portable document format
    (C)   Physical document format
    (D)   Portable data format
97   XML stands for:
    (A)   Xtensible markup languages
    (B)   Xtensible memory languages
    (C)   Both
    (D)   None
98   BLOB stands for:
    (A)   Binary languages Objects
    (B)   Bit large Objects
    (C)   Binary low objects
    (D)   Binary large objects
99   Which is refers to the collection of related data values or items called fields:
    (A)   Record
    (B)   Record blocking
    (C)   Fixed-length record
    (D)   Variable-length record
100   Every record in the same size in bytes the file is constituted of_____:
    (A)   Record
    (B)   Record blocking
    (C)   Fixed-length record
    (D)   Variable-length record

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

Back to Top