Tuesday, August 13, 2013

DBMS MCQ 01


  1. DBA stands for:

    1. Database associated
    2. Database administrator
    3. Database application
    4. None of these

  1. DBMS stands for:

    1. Database associated
    2. Database administrator
    3. Database application
    4. Database management system

  1. Which means a place where data can be stored in a structured manner:

    1. CPU
    2. Database
    3. ALU
    4. All of these

  1. A database is a complex ______:

    1. Data structure
    2. Memory
    3. Both
    4. None

  1. The set of data available to the user, the so-called:

    1. Start-user data
    2. End-user data
    3. Database
    4. None of these

  1. How is describing the end-user data:

    1. Memory
    2. CPU
    3. ALU
    4. Data

  1. DBMS is to impose a logical and structured organization on:

    1. Register
    2. Data
    3. Memory
    4. None of these

  1.  How many basic operation performed in DBMS:

    1. 1
    2. 2
    3. 3
    4. 4

  1.  Basic operation performed in DBMS are:
    1. Management of data in the database
    2. Management of user associated with database
    3. Both
    4. None
  2.  _____is a collection of programs performing all necessary action associated with a database:

    1. Database associated
    2. Database administrator
    3. Database application
    4. Database management system

  1. _______is a program or set of program that interacts with the database at some point in its execution:

    1. A database system
    2. A database application
    3. Both
    4. None

  1. ________is a collection of application programs that interacts with the database along with DBMS:

    1. A database system
    2. A database application
    3. Both
    4. None

  1. In which services the processes of database management and data management are complementary:

    1. Database associated
    2. Database administrator
    3. Database application
    4. Database management system

  1. ACID stands for:
    1. Atomicity, consistency, isolation, and durability
    2. Atomicity, command, integrity, and data
    3. Atomicity, control, integrated, and direct
    4. None of these
  2.  A DBMS provides users with the conceptual representation of:

    1. Register
    2. Data
    3. Logical view
    4. Physical view

  1. Which structure of data clearly is one of the main features of the database approach:

    1. Logical view
    2. Physical view
    3. Both
    4. None

  1. A _____view of data expresses the way a user thinks about data

    1. Logical view
    2. Physical view
    3. Both
    4. None

  1. A physical view of data refers to the way data is handled at a_____ its storage and retrieval:

    1. High level
    2. Low level
    3. Medium level
    4. All of these

  1. In logical and physical view of data the set of principles that defines a data model may be divided into how many parts:

    1. 1
    2. 2
    3. 3
    4. 4

  1. In logical and physical view of data the set of principles that defines a data model may be divided into which part:

    1. Data definition
    2. Data manipulation
    3. Data integrity
    4. All of these

  1. The overall description of a database is called______:

    1. Data definition
    2. Data manipulation
    3. Data integrity
    4. Database schema

  1. Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid or protect information:

    1. Schema
    2. Subschema
    3. Non-schema
    4. None-subschema

  1. A data dictionary is a repository that manages _____:

    1. Database
    2. Memory
    3. Metadata
    4. All of these

  1. Which languages are used to define and query a database:

    1. Database
    2. Memory
    3. Metadata
    4. All of these

  1. DDL stand for:

    1. Data definition language
    2. Data description languages
    3. Data design languages
    4. Database dictionary languages

  1. Which are the not most frequently used DDL statements:

    1. CREATE
    2. DROP
    3. ALTER
    4. None of these

  1. VDL stand for:
    1. View data languages
    2. View design languages
    3. View definition languages
    4. View done languages
  2. SDL stands for
    1. Stand definition languages
    2. Storage definition languages
    3. Select definition languages
    4. system definition languages
  3. The DDL is used to specify the_____:

    1. Conceptual schemas
    2. Internal schemas
    3. Both
    4. None

  1. The  SDL is used to specify the_______:

    1. Conceptual schemas
    2. Internal schemas
    3. Both
    4. None

  1. DML stands for:
    1. Data description languages
    2. Data design languages
    3. Database dictionary languages
    4. Data manipulation languages
  2. Which is used for data retrieval from the database:

    1. DDL
    2. DML
    3. SDL
    4. VDL

  1.  Which is used to specify the user views and their mappings to the conceptual schema:

    1. DDL
    2. DML
    3. SDL
    4. VDL

  1. How many types of DML:

    1. 1
    2. 2
    3. 3
    4. 4

  1. What are the types of DML:

    1. Low level
    2. High level
    3. Procedural DML
    4. All of these


  1.  Which is requires a user to specify what data is needed and how to get it:

    1. Low level
    2. Procedural DML
    3. Both
    4. None

  1. Data is manipulated by procedure calls to subroutines provided by a_____:

    1. Data
    2. DBMS
    3. Register
    4. All of these

  1. The programming languages is called:

    1. Sublanguages
    2. Host languages
    3. VDL
    4. DDL

  1.  The DML is called:

    1. Sublanguages
    2. Host languages
    3. VDL
    4. DDL

  1. Which command are included in a general purpose programming languages:

    1. DDL
    2. DML
    3. SDL
    4. VDL

  1. A database management system are very complex_____:

    1. Art
    2. Command
    3. Languages
    4. System

  1. How many levels of abstraction in DBMS:

    1. 2
    2. 3
    3. 4
    4. 5

  1. Which are the three levels of abstraction:

    1. Physical
    2. Logical
    3. External
    4. All of these

  1. How many types of data independence:

    1. 1
    2. 2
    3. 3
    4. 4

  1. Which are the types of data independence:

    1. Physical
    2. Logical
    3. Both
    4. All of these


  1. Which is the transformation of requests and results between different levels of abstraction:

    1. Evaluation
    2. Mapping
    3. Compiler
    4. Precompiler

  1. Which mapping exists between the conceptual and internal levels:

    1. Conceptual
    2. Internal
    3. Both
    4. None

  1. Which mapping exists between the external and conceptual levels:

    1. Conceptual
    2. Internal
    3. Both
    4. None

  1. The related  and interconnected software components of a DBMS are described by the _______:

    1. Logical architecture
    2. Physical architecture
    3. Both
    4. None

  1. Which are the types of physical DBMS architecture can be split :

    1. Back end
    2. Front end
    3. Both
    4. None

  1. In which end is really just any application that runs on top of the DBMS and acts as a user interface:

    1. Back end
    2. Front end
    3. Both
    4. None

  1. Data are stored in________ as database:

    1. Data files
    2. Data dictionary
    3. Database
    4. Data administrator

  1. RAD stands for:
    1. Rotate application development
    2. Register application development
    3. Related  application development
    4. Rapid application development
  2. DA stands for:

    1. Data administrator
    2. Database active
    3. Define application
    4. All of these

  1. Which is the person responsible for overall control f the database system:

    1. DDL
    2.  DBMS
    3. DBA
    4. SDL

  1. DBA stands for:
    1. Database maintenance
    2. Database administrator
    3. Database backup
    4. Database designer
  2. Transaction is an action used to perform some manipulation on data stored in the____:

    1. Memory
    2. Record
    3. Database
    4. All off these

  1. How many features of a DBMS which provide a number of advantages for data management:

    1. 1
    2. 3
    3. 5
    4. 7

  1. Which is a DBMS keeps back-up copies of the database:

    1. Backup
    2. Recovery
    3. Both
    4. None

  1. In which the database can be restored up to the last consistent state after the system failure:

    1. Backup
    2. Recovery
    3. Both
    4. None

  1. Which are the not user in End-user:

    1. Naïve users
    2. Casual users
    3. Sophisticated user
    4. All of these

  1. Which are the not features of a DBMS which provide a number of advantages for data management:

    1. DML
    2. DDL
    3. SDL
    4. None of these

  1. Minimal data redundancy means improved _________:

    1. Data independence
    2. Data consistency
    3. Data integration
    4. Data sharing

  1. Who access the database occasionally and have different needs each time:

    1. Naïve users
    2. Casual users
    3. Sophisticated user
    4. All of these

  1. Who interact with the system without writing a program:

    1. Naïve users
    2. Casual users
    3. Sophisticated user
    4. All of these

  1. Who interact with the system by invoking one of the permanent application program:

    1. Naïve users
    2. Casual users
    3. Sophisticated user
    4. All of these

  1. The main interface that a native user uses is a form interface using___:

    1. DDL
    2. GUI
    3. OLAP
    4. DML

  1. The provision of _______ is a major objective for database system:

    1. Data independence
    2. Data consistency
    3. Data integration
    4. Data sharing

  1. Who is requested to carry out various operation, such as insert, delete, update and retrieval vwiours on the database by the user:

    1. DBA
    2. DBMS
    3. DBS
    4. DDL

  1. ____ is a translates into low-level instruction that a query processor understands:

    1.  DBA
    2. DBMS
    3. DBS
    4. DDL

  1. Retrieval of data is done by using a ____:

    1. Stack
    2. Query
    3. Linked list
    4. All of these

  1. DML is a languages by which user accesses or manipulates the ________:

    1. Data model
    2. Data consistency
    3. Data integration
    4. Data sharing

  1. Which is the central component of the DBMS software that can also be termed as the database control system:

    1. Data consistency
    2. Data integration
    3. Data sharing
    4. Data manager

  1. Which is stored information about description of data in the database:

    1. Data files
    2. Data dictionary
    3. Database
    4. Data administrator

  1. After conversion of high level queries into low level commands for file access and is called compiled_____:

    1. DDL
    2. DML
    3. SDL
    4. VDL

  1. Which is installs, configures, troubleshoots and maintains a database system:

    1. DBA
    2. DDL
    3. DML
    4. SDL

  1. Which is incorporated to create an appropriate physical database that is transformed by a logical data model:

    1. SDL
    2. VDL
    3. Both
    4. None

  1. SQL stands for:
    1. System query language
    2. Sequential query language
    3. Sets query languages
    4. None of these
  2. CSV stands for:
    1. Command system values
    2. Comma system values
    3. Command separated values
    4. Comma separated values
  3. PDF stands for:
    1. Physical data format
    2. Portable document format
    3. Physical document format
    4. Portable data format
  4.  XML stands for:
    1. Xtensible markup languages
    2. Xtensible memory languages
    3. Both
    4. None
  5. BLOB stands for:
    1. Binary languages Objects
    2. Bit large Objects
    3. Binary low objects
    4. Binary large objects
  6. Which is refers to the collection of related data values or items called fields:
    1. Record
    2. Record blocking
    3. Fixed-length record
    4. Variable-length record
  7. Every record in the same size in bytes the file is constituted of_____:
    1. Record
    2. Record blocking
    3. Fixed-length record
    4. Variable-length record
  8. _________ is the records in the file are of different sizes:
    1. Record blocking
    2. Fixed-length record
    3. Variable-length record
    4. None of these
  9. In which circumstances not variable-length record occur:

    1. Mixed files
    2. Repeating field
    3. Both
    4. None

  1. The block containing the record is the unit of data transferred between the________:
    1. Main memory and The disk
    2. Data and Memory
    3. Data and Disk
    4. All of these
  2. Who is the unit of data transferred:

    1. The memory
    2. The data
    3. The user
    4. The block

  1.  _____is a collection of all occurrences of similar types of records:

    1. Data
    2. Data item
    3. File
    4. All of these

  1. How many types of recodes in a file-based system:

    1. 2
    2. 4
    3. 6
    4. 8

  1.  Which are is not type of recodes in a file-based system:

    1. Logical records
    2. Physical records
    3. Both
    4. None

  1. Which contain information about a file needed by system programs for accessing file records:

    1. File blocks
    2. File operations
    3. File headers
    4. None of these

  1. The file operations can be divided into how many categories:

    1. 1
    2. 2
    3. 3
    4. 4

  1. _____ take into account only such records that are valid:

    1. Algorithm
    2. Searching algorithm
    3. Flow chart
    4. All of these

  1.  ______ file organization is vital for ensuring the most efficient access of files and records:

    1. File blocks
    2. File operations
    3. File headers
    4. File organization

  1. New records are placed at the end of the file it is referred to as____:

    1. Heap file
    2. Pile file
    3. Both
    4. None

  1. The field which is used to order the file is referred to as ________:

    1. Sorted field
    2. Ordering field
    3. Both
    4. None

  1. Binary search accesses _____ blocks:

    1. Log(b)
    2. Log2(b)
    3. 2log(b)
    4. Log(2b)

  1. Which provides precise partition between abstract characteristics of the data type and its implementation specifications:

    1. Data
    2. Data item
    3. File
    4. Data abstraction

  1. ODBS stands for:
    1. Off data base connection
    2. Open data base connection
    3. Oriented data base connection
    4. All of these
  2. DDL stands for:
    1. Decode data languages
    2. Data define languages
    3. Database define languages
    4. Define data languages
  3.  SOA stands for:
    1. Services oriented abstraction
    2.  System oriented abstraction
    3. Services oriented architecture
    4. All of these
  4.  ADSL stands for:
    1. Acquired data system line
    2. Asymmetric digital subscribe line
    3. Asymmetric digital subscribe languages
    4. Acquired data system languages
  5. Which services are insulated by abstraction from the fundamental physical data:

    1. DDL
    2. ODBC
    3. SOA
    4. ADSL

  1. EII stand for:
    1. Enterprise information integration
    2. End information integration
    3. Enterprise input information
    4. None of these
  2. ______ is another name given to data integration when use in the management context:

    1. EII
    2. IEI
    3. GUI
    4. SUI

  1. LAV  stands for:

    1. Logical as view
    2. Local as view
    3. Land as view
    4. Last as view

  1. GAV stands for:

    1. Global as view
    2. Global as verify
    3. Both
    4. None

  1. ETL stands for:
    1. End transforming and loudening
    2. Extracting transforming and loading
    3. Extracting transforming and languages
    4.  End transforming and languages
  2. GSM stands for:

    1. Global source mapping
    2. Global system map
    3. Global system master
    4. Global system mode

  1. Which are the accepted ways for modeling such correspondence:

    1. LAV
    2. GAV
    3. Both
    4. None

  1. CDI stands for:
    1. Computer data input
    2. Code data input
    3. Computer data integration
    4. Computer data information
  2. How many structure used in ontology based on data integration application are explained:

    1. 1
    2. 2
    3. 3
    4. 4

  1. ______ is the commercial application of data integration:

    1. EII
    2. IEI
    3. GUI
    4. SUI

  1. ANSI stands for:
    1. Analyst national system institute
    2. Analog   national system institute
    3. Analyst national standards  institute
    4. American national standards institute
  2. SPARC stands for:
    1. System planning and requirements
    2. Standards planning and requirements
    3. Both
    4. None

No comments: