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 at Bissoy

• A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
  ক

  tables

  খ

  relations

  গ

  tuple

  ঘ

  both (a) and (b)

  ঙ

  None of the above
• The database administration function includes
  ক

  application programming

  খ

  computer operations management

  গ

  database access planning

  ঘ

  All of the above

  ঙ

  None of the above
• 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
• The master list of an indexed file
  ক

  is sorted in ascending order

  খ

  contains only a list of keys and record numbers

  গ

  has a number assigned to each record

  ঘ

  both (b) and (c)

  ঙ

  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
• The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
  ক

  a tree file

  খ

  an indexed file

  গ

  a hashed file

  ঘ

  a sequential file

  ঙ

  None of the above
• Queries to a database
  ক

  are written in English

  খ

  can use aggregate functions like SUM and COUNT

  গ

  both (a) and (b)

  ঘ

  All of the above

  ঙ

  None of the above
• A logical schema
  ক

  is the entire database

  খ

  is a standard way of organizing information into accessible parts

  গ

  describes how data is actually stored on disk

  ঘ

  All of the above

  ঙ

  None of the above
• It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
  ক

  Database

  খ

  Table

  গ

  Record

  ঘ

  Flat File

  ঙ

  None of the above
• Data encryption techniques are particularly useful for
  ক

  reducing storage space requirements

  খ

  improving data integrity

  গ

  protecting data in data communication systems

  ঘ

  All of the above

  ঙ

  None of the above
• A data dictionary doesn't provide information about:
  ক

  where data is located

  খ

  the size of the disk storage device

  গ

  It allows a many-to-many relationship

  ঘ

  It is conceptually simple

  ঙ

  It will be the dominant data base of the future
• 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
• Batch processing is appropriate if
  ক

  a large computer system is available

  খ

  only a small computer system is available

  গ

  only a few transactions are involved

  ঘ

  All of the above

  ঙ

  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
• In SQL, the CREATE TABLE is used
  ক

  to create a table, defining its columns, integrity constrains, and storage allocation

  খ

  to add a column/integrity constraint to a table

  গ

  to redefine a column

  ঘ

  to change a table's storage characteristics

  ঙ

  All of the above
• 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
• A form can be used to
  ক

  modify records

  খ

  delete records

  গ

  format printed output

  ঘ

  All of the above

  ঙ

  None of the above
• A file that is organized in uniform format is formally referred to as a _____ or a database file.
  ক

  Document

  খ

  Database

  গ

  Record

  ঘ

  Structured data file

  ঙ

  None of the above
• A list in alphabetical order
  ক

  is in descending order

  খ

  is in ascending order

  গ

  is the result of a sort operation

  ঘ

  both (b) and (c)

  ঙ

  None of the above
• In SQL, the _____ command is used to recompile a view
  ক

  COMPILE VIEW

  খ

  DEFINE VIEW

  গ

  CREATE VIEW

  ঘ

  ALTER VIEW

  ঙ

  None of the above
• A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
  ক

  One-to-one relationship

  খ

  One-to-many relationship

  গ

  Many-to-one relationship

  ঘ

  Many-to-many relationship

  ঙ

  None of the above
• Related fields in a data base are grouped to form
  ক

  data file

  খ

  data record

  গ

  menu

  ঘ

  bank

  ঙ

  None of the above
• Versatile report generators can provide
  ক

  Columnar totals

  খ

  Subtotals

  গ

  Calculations

  ঘ

  All of the above

  ঙ

  None of the above
• The activity of a file
  ক

  is a low percentages of number of records added or deleted from a file

  খ

  if high, reduces processing efficiency for sequential and nonsequential files

  গ

  is a measure of the percentage of existing records updated during a run

  ঘ

  refers to how closely the files fits into the allocated

  ঙ

  None of the above.
• Data items grouped together for storage purposes are called a
  ক

  record

  খ

  title

  গ

  list

  ঘ

  string

  ঙ

  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
• Embedded pointer provide
  ক

  a secondary access path

  খ

  a physical record key

  গ

  an inverted index

  ঘ

  All of the above

  ঙ

  None of the above
• The _____ command is used to allocates an extent for the table in SQL
  ক

  MODIFY ALLOCATES

  খ

  MODIFY TABLE

  গ

  ALTER TABLE

  ঘ

  REDEFINE TABLE

  ঙ

  None of the above