DataBase Management System

Database Basic

⛪ Computer Science and Engineering > DataBase Management System

A Database Management System (DBMS) is an integrated set of programs used to create and maintain a database. The main objective of a DBMS is to provide a convenient and effective method of defining, storing, retrieving and manipulating the data contained in the database. ➲ Database Basic - Quiz

Q 1: Which of these is an advantage of database systems?

  • A Data abstraction
  • B Program-data independence
  • C Centralized data management
  • D All of these

Q 2: The information about data in a database is called

  • A Tera data
  • B Metadata
  • C Hyper data
  • D None of these

Q 3: The users who query and update the database by invoking some already-written application programs are known as

  • A System analysts
  • B Na
  • C Special users
  • D Sophisticated users

Q 4: The person who has the central control over data and application programs is

  • A DBA
  • B System analysts
  • C Database designer
  • D None of these

Q 5: Which of these individuals plays an important role in defining and maintaining a database for an organization?

  • A Application programmer
  • B System analyst
  • C Database administrator
  • D Both (a) and (b)

Q 6: Which of the following levels deals with the physical representation of the database on the computer?

  • A Internal level
  • B Conceptual level
  • C External level
  • D None of these

Q 7: Which of the following levels of abstraction deals with the user's view of the database?

  • A External level
  • B Conceptual level
  • C Physical level
  • D None of these

Q 8: The process of transforming the requests and results between various levels of DBMS architecture is known as

  • A Mapping
  • B Scheming
  • C Viewing
  • D None of these

Q 9: The ability to change the conceptual schema without affecting the external schemas or application programs is known as

  • A Program-data independence
  • B Logical data independence
  • C Physical data independence
  • D Data abstraction

Q 10: Which of these is not a representational data model?

  • A Entity-relationship model
  • B Network data model
  • C Hierarchical data model
  • D Relational data model

Q 11: Which of these is not a feature of the hierarchical model?

  • A Organizes the data in a tree-like structure
  • B Root node does not have any parent
  • C Parent node can have any number of child nodes
  • D Child node can have any number of parent nodes

Q 12: The

  • A Object-oriented data model
  • B Object-relational data model
  • C Semistructured data model
  • D None of these

Q 13: The type of data structure that is used in a relational model is

  • A Table
  • B Tree
  • C Graph
  • D None of these

Q 14: Which of these DBMS languages is employed by end users and programmers to manipulate data in the database?

  • A Data definition language
  • B Data presentation language
  • C Data manipulation language
  • D Data translation language

Q 15: The

  • A Data dictionary
  • B Data table
  • C Data record
  • D None of these

Q 16: In a

  • A Heterogeneous
  • B Homogeneous
  • C Centralized
  • D Client/Server

Q 17:

What is the correct sequence of these phases of database design and implementation process?

(i) Conceptual database design

(ii) Requirement collection and analysis

(iii) Physical database design

(iv) Testing and evaluation

  • A ii, i, iii and iv
  • B i, ii, iii and iv
  • C ii, iii, i and iv
  • D i, ii, iv and iii