Database Systems MCQ

Test your knowledge with important Database Systems MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Database Systems MCQs on Bissoy. Bissoy App

• In SQL, which command is used to remove a stored function from the database?
  ক

  REMOVE FUNCTION

  খ

  DELETE FUNCTION

  গ

  DROP FUNCTION

  ঘ

  ERASE FUNCTION

  ঙ

  None of the above
• Which of the following is not the responsibility of the utilities component of DBMS software?
  ক

  creating the physical and logical designs

  খ

  removing flagged records for deletion

  গ

  creating and maintaining the data dictionary

  ঘ

  monitoring performance

  ঙ

  None of the above
• Which command is used to select distinct subject (SUB) from the table (BOOK)?
  ক

  SELECT ALL FROM BOOK

  খ

  SELECT DISTINCT SUB FROM BOOK

  গ

  SELECT SUB FROM BOOK

  ঘ

  All of the above

  ঙ

  None of the above
• Which of the following is not an advantage of the data-base approach?
  ক

  elimination of the data redundancy

  খ

  ability to associate related data

  গ

  increased security

  ঘ

  program/data independence

  ঙ

  All of the above are advantages
• What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
  ক

  DASD

  খ

  FMS

  গ

  EMMS

  ঘ

  DBMS

  ঙ

  None of the above
• Which of the following is not true of the traditional approach to information processing?
  ক

  There is common sharing of data among the various applications

  খ

  It is file-oriented

  গ

  Programs are dependent on the files

  ঘ

  It is inflexible

  ঙ

  All of the above are true
• Which language has recently become the de-facto standard for interfacing application programs with relational database system?
  ক

  Oracle

  খ

  SQL

  গ

  dBASE

  ঘ

  4GL

  ঙ

  None of the above
• Which of the following is a type of DBMS software?
  ক

  database manipulation language

  খ

  query language

  গ

  utilities

  ঘ

  report writer

  ঙ

  All of the above
• In SQL, which command is used to select data in rows and column from one or more tables?
  ক

  CHOOSE

  খ

  SELECT

  গ

  LIST

  ঘ

  BROWSE

  ঙ

  None of the above
• Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
  ক

  report writer

  খ

  query language

  গ

  data manipulation language

  ঘ

  transaction log

  ঙ

  None of the above
• Which of the following is a serious problem of file management systems?
  ক

  difficult to update

  খ

  lack of data independence

  গ

  data redundancy

  ঘ

  program dependence

  ঙ

  All of the above
• In SQL, which command(s) is(are) used to redefine an index's future storage allocation
  ক

  ALTER INDEX

  খ

  REDEFINE INDEX

  গ

  MODIFY INDEX

  ঘ

  DO INDEX

  ঙ

  None of the above
• When performing a look-up operation using a form
  ক

  you enter the search value into the form

  খ

  you look at each form sequentially until you see the one you want

  গ

  you type the key in an entry line, and the correct form is displayed

  ঘ

  All of the above

  ঙ

  None of the above
• In SQL, which command is used to create a database user?
  ক

  ADD USER TO DATABASE

  খ

  MK USER

  গ

  CREATE USER

  ঘ

  All of the above

  ঙ

  None of the above
• A computer file contains several records. What does each record contain?
  ক

  Bytes

  খ

  Words

  গ

  Fields

  ঘ

  Database

  ঙ

  None of the above
• Which of the following is not characteristic of a relational database model?
  ক

  tables

  খ

  treelike structure

  গ

  complex logical relationships

  ঘ

  records

  ঙ

  None of the above
• In SQL, which command(s) is(are) used to create a synonym for a schema object?
  ক

  CREATE SCHEMA

  খ

  CREATE SYNONYM

  গ

  CREATE SAME

  ঘ

  All of the above

  ঙ

  None of the above
• A race condition occurs when
  ক

  Two concurrent activities interact to cause a processing error

  খ

  two users of the DBMS are interacting with different files at the same time

  গ

  both (a) and (b)

  ঘ

  All of the above

  ঙ

  None of the above
• Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
  ক

  DEFINE TABLE

  খ

  MODIFY TABLE

  গ

  ALTER TABLE

  ঘ

  All of the above

  ঙ

  None of the above
• Which command(s) is(are) used to redefine a column of the table in SQL ?
  ক

  ALTER TABLE

  খ

  DEFINE TABLE

  গ

  MODIFY TABLE

  ঘ

  All of the above

  ঙ

  None of the above
• Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
  ক

  COMPILE PROCEDURE

  খ

  ALTER PROCEDURE

  গ

  MODIFY PROCEDURE id) All of the above

  ঘ

  None of the above

  ঙ

  None of the above
• What name is given to the collection of facts, items of information or data which are related in some way?
  ক

  Database

  খ

  Directory information

  গ

  Information tree

  ঘ

  Information provider

  ঙ

  None of the above
• In SQL, which command is used to changes data in a table?
  ক

  UPDATE

  খ

  INSERT

  গ

  BROWSE

  ঘ

  APPEND

  ঙ

  None of the above
• In SQL, which command is used to add a column/integrity constraint to a table
  ক

  ADD COLUMN

  খ

  INSERT COLUMN

  গ

  MODIFY TABLE

  ঘ

  ALTER TABLE

  ঙ

  None of the above
• When you have finished entering information into a form
  ক

  the template is written to the data file

  খ

  the contents of the form are written to the data file

  গ

  the contents of the form can be printed

  ঘ

  All of the above

  ঙ

  None of the above
• In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
  ক

  ALTER TRIGGERS

  খ

  ALTER TABLE

  গ

  MODIFY TRIGGERS IN TABLE

  ঘ

  All of the above

  ঙ

  None of the above
• Which of the following is true of a network structure?
  ক

  It is a physical representation of the data

  খ

  It allows a many-to-many relationship

  গ

  It is conceptually simple

  ঘ

  It will be the dominant data base of the future

  ঙ

  None of the above
• A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
  ক

  Specialized file

  খ

  Log file

  গ

  Master file

  ঘ

  Update file

  ঙ

  None of the above
• Which command is used to remove a table from the database in SQL?
  ক

  DELETE TABLE

  খ

  DROP TABLE

  গ

  ERASE TABLE

  ঘ

  UNATTACH TABLE

  ঙ

  None of the above
• When using a database management system, the first thing that you must do is to
  ক

  create a database file

  খ

  activate file editor

  গ

  load the software into your micro¬computer

  ঘ

  keep a floppy disk in readiness

  ঙ

  None of the above