Top 1000+ Database Subject Mcqs Pdf Download Set No 08

written by Assad Javaid | May 27, 2021

351.A top-to-bottom relationship among the items in a database is established by a :

  1. Network schema
  2. Relational schema
  3. Hierarchical schema
  4. All

352.The level of data abstraction which describes how the data is actually stored is :

  1. conceptual level
  2. physical level
  3. file level
  4. none of these

 353.Collection of information stored in a database at a particular moment is :

  1. View
  2. instance
  3. schema
  4. none

 354.The syntax of a user query is verified by :

  1. query optimizer
  2. DBA
  3. parser
  4. none

 355.A data model is :

  1. Used to describe structure of a database
  2. Both [A] and [B]
  3. Set of basic operations on the database
  4. None

356. In a hierarchical database, a hashing function is used to locate the :

  1. Root
  2. Collisions
  3. Primary key
  4. Duplicate records

357.Between the users and the database itself, a DBMS will act as :

  1. barrier
  2. interface
  3. referee
  4. obstacle

358.Which of these is not a database object ?

  1. index
  2. sequence
  3. cursor
  4. trigger

359. Which one of the following is not an object-based logical model ?

  1. The binary model
  2. The info logical model
  3. The entity-relational model
  4. None of these

360.Which one of the following design is both software and hardware independent ?

  1. Logical
  2. Physical
  3. Conceptual
  4. None

 361.Object based data models are used in describing the abstraction of the following level :

  1. Only physical
  2. Conceptual and view
  3. Physical and conceptual
  4. None

362.A schema describes :

  1. All
  2. Record Relationship
  3. Data Elements
  4. Record and files

363.An abstraction concept for building composite object from their component object is called :

  1. Specialization
  2. Normalization
  3. Aggregation
  4. Generalization

 364.Manager’s salary details are hidden from the employee. This is :

  1. Physical level data hiding
  2. External level data hiding
  3. None of these
  4. Conceptual level data hiding

365. Which one is an incorrect statement about a view ?

  1. All
  2. view is derived from other tables
  3. It can be updated like a table
  4. DROP VIEW is used to dispose it

366.Which one is lowest level data model ?

  1. A physical data model
  2. logical data model
  3. external data model
  4. none

 367.Which of these is not TRUE in case of responsibilities of Database Administrator (DBA) ?

  1. Acquiring hardware and software resources
  2. Authorizing access to database
  3. Data entry in to the database
  4. All

368. In order to use a DBMS, it is important to understand :

  1. the physical schema
  2. all subschema that the system supports
  3. one subschema
  4. both [A] and [B]

369.Data items grouped together for storage purposes are called a :

  1. record
  2. title
  3. list
  4. string

370.A computer file contains several records. What does each record contain ?

  1. Bytes
  2. Words
  3. Fields
  4. Database

371.A report generator is used to :

  1. update files
  2. print files on paper
  3. data entry
  4. all

372. Data are :

  1. Raw facts and figures
  2. Information
  3. Electronic representation of facts
  4. None

 373.Data processing cycle consists of :

  1. Input cycle and output cycle
  2. Input cycle, output cycle and processing cycle
  3. Output cycle and processing cycle
  4. None

374.Top level manager uses :

  1. A Internal information only
  2. External information only
  3. Both [A] and [B]
  4. None

  375.DBMS is used to :

  1. Eliminate data redundancy
  2. Maintain data integrity
  3. Establish relationships among different files
  4. All

376.A large computer information system maintains many different computer files. Which amongst them is called a perpetual file ?

  1. A Specialized fileB
  2. Log file
  3. Master file
  4. Update file

378.Which of the following types of information is used by the top level managers ?

  1. Both [A] and [B]
  2. Operational information
  3. Technical information
  4. Strategic information

379.Which is not a DBMS package?

  1. Unify
  2. Ingress
  3. IDMS
  4. All are DBMS packages

380.Which of the following types of information is used by the top level managers ?

  1. Operational information
  2. Technical information
  3. Both [A] and [B]
  4. Strategic information

381.Which is a DBMS package?

  1. Unify
  2. Ingress
  3. IDMS
  4. DBMS packages

382.The data dictionary tells the DBMS ?

  1. What files are in the database
  2. All
  3. What attributes are possessed by the data
  4. What these files contain

383.An association between students and courses is :

  1. 1:1 relationship
  2. 1:M relationship
  3. M:M relationship
  4. None

 384.The database environment has all of the following components except :

  1. users
  2. separate files
  3. database
  4. database administrator

385.The key to a cost-effective data input operation is :

  1. OCR equipment
  2. validity checks
  3. validation
  4. employee motivation

386.complex entities can be constructed using the following operation :

  1. SUM
  2. Union
  3. Aggregation
  4. Collection

387.The logical data structure with a one-to-many relationship is a :

  1. network
  2. tree
  3. C chain
  4. relationship

388.Which of the following is an example for network database ?

  1. IDBS
  2. Ingress
  3. Oracle
  4. DBMS
  5. Option

 389.Which of the following is a hierarchical database ?

  1. Oracle
  2. DBII
  3. Ingress
  4. SYSTEM2000

390.Which of the following is not an element of Database ?

  1. Schema objects
  2. Indexes
  3. Tables
  4. Database Administrator

 391.Data processing comprises of :

  1. Capturing of data
  2. Storing of data
  3. Updating and retrieving data
  4. All

392.Embedded pointer provides :

  1. a secondary access path
  2. a physical record key
  3. an inverted index
  4. all

393. File is the collection of all related :

  1. Database
  2. Records
  3. Fields
  4. File

394.The distinguishable parts of a record are called :

  1. files
  2. data
  3. fields
  4. database

395.A view of a database that appears to an application program is known as :

  1. schema
  2. subschema
  3. virtual table
  4. None of these

396.Primitive operations common to all record management systems include :

  1. Print
  2. Sort
  3. Look-up
  4. All

 397.Administrative supervision of database activities is the responsibility of the :

  1. Database administrator
  2. DP Manager
  3. DB Manager
  4. DP Administrator

398.Administrative supervision of database activities is the responsibility of the :

  1. Database administrator
  2. DP Manager
  3. DB Manager
  4. DP Administrator

399.The set of all possible values of data items is called :

  1. Domain
  2. Attribute
  3. Tuples
  4. None

 400.Model based on user’s requirements is :

  1. Logical model
  2. Physical model
  3. Conceptual model
  4. None

 401.A hierarchical data model is :

  1. Partially ordered
  2. Not ordered
  3. Totally ordered
  4. Concept of ordering does not appear

<Previous Page

Take Quiz No 08

Next Page >