Top 1000+ Database Subject Mcqs Pdf Download Set No 17

Print/Downlaod pdf

801.Which of the following most certainly implies the need for an entire table to implement?

  1. A binary relationship
  2. A recursive relationship
  3. A ternary relationship          
  4. An identifying relationship               

802.Which of the following constraints enforces entity integrity?

  3. CHECK
  4. NOT NULL                

803.Which of the following is not true about relational tables?

  1. Column values are of the same kind.
  2. Each row is unique.
  3. Each column must have a unique name.
  4. The sequence of rows is significant.             

804..In a conceptual model for a university, what type of relationship exists between Grade and Student entities?

  1. 1:M         
  2. M:M
  3. Ternary     

805.Controlling redundancy in a database management system DOES NOT help to

  1. avoid duplication
  2. avoid unauthorized access to data                  
  3. avoid unnecessary wastage of storage space
  4. avoid inconsistency among data        

806.Which of the following is INCORRECT with respect to file systems?

  1. At the physical level, pointer or hashed address scheme may be employed to provide a certain degree
  2. of data independence at the user level.
  3. Some physical organizations use pointers to record blocks to locate records on disk.
  4. A logical record is concerned with efficient storage of information in the secondary storage devices.
  5. The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file.                    –

807.Which of the following functions are NOT performed by a database administrator?

  1. Planning, designing and implementing database systems
  2. Establishing standards and procedures for database systems
  3. Communicating with database users   
  4. Allocation of storage locations and data structure         

808.Select the correct statement about the ANSI/SPARC architecture.

  1. The conceptual level is a level of indication between the internal level and the external level.  
  2. The internal level in a database system will definitely be relational.
  3. Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.
  4. The external level is not concerned with individual user perceptions, while the conceptual level is   concerned with a community user perception.                      

809.Which of the following is a correct way to implement one-to-many relationship while designing tables?

  1. by splitting the data into two tables with primary key and foreign key relationships
  2. using a junction table with the keys from both the tables forming the composite primary key of the   
  3. junction table.
  4. by splitting each table into three
  5. as a single table and rarely as two tables with primary and foreign key relationship

810.Which of the following is not a benefit of normalization?

  1. Minimize insertion anomalies
  2. Minimize deletion anomalies
  3. Minimize updating anomalies
  4. Maximize redundancy                   

811.Consider the following relation R and its sample data. Consider that these are the only rows for the given relation

Which of the following statements is NOT correct?

A. The functional dependency Employee No, Project No -> Department No holds over R.

B. The functional dependency Employee No, Department No -> Project No holds overR.

C. The functional dependency Employ -> Department No holds over R.

D. The functional dependency Project No -> Department No holds over R                 

812.The Entity Relation Model?

  1. Entities, Relationships and Process
  2. Entities and Relationships     
  3. Relationships
  4. Entities                      

813.As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE ?

  1. foreign key
  2. index
  3. primary key
  4. determinant               

814.User rights information is stored in

  1. Physical database
  2. Logical database
  3. Catalog         
  4. Buffer

815.The data model which describes how the data is actually stored is :

  1. external model
  2. internal model
  3. logical model
  4. none of these

816.Data about data is normally termed as :

  1. Directory
  2. meta data
  3. data bank
  4. none

817.The scheme for hierarchical database is :

  1. a graph
  2. a tree
  3. a B-tree

 818.none which one is an example for network database ?

  1. Unify
  2. Ingress
  3. IDMS
  4. None

819.One of the following is a valid record-based data model :

  1. Object-oriented model
  2. Entity-relationship model
  3. None
  4. Relational model

820.In an object-oriented model, one object can access data of another object by passing :

  1. Message
  2. Instance variable
  3. Variable
  4. None of these

821.SET concept is used in :

  1. Hierarchical model
  2. Network model
  3. Relational model
  4. None

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

  1. schema
  2. subschema
  3. virtual table
  4. none

823.Choose the DBMS, which supports full-fledged client server application development ?

  1. Oracle 7.1
  3. FoxPro 2.1
  4. Ingress

824.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

825.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

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

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

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

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

 829.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

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

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

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

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

832.Which of these is not a database object ?

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

833. 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

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

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

 835.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

836.A schema describes :

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

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

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

 838.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

839. 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

840.Which one is lowest level data model ?

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

 841.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

842. 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]

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

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

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

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

845.A report generator is used to :

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

846.Data are :

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

 847.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

848.Top level manager uses :

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

  849.DBMS is used to :

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

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

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