On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 25

Q1 | The property of a transaction that persists all the crashes is
  • atomicity
  • durability
  • isolation
  • all of the mentioned
Q2 |                      states that only valid data will be written to the database.
  • consistency
  • atomicity
  • durability
  • isolation
Q3 | Transaction processing is associated with everything below except
  • producing detail summary or exception reports
  • recording a business activity
  • confirming an action or triggering a response
  • maintaining a data
Q4 | The Oracle RDBMS uses the           statement to declare a new transaction start and its properties.
  • begin
  • set transaction
  • begin transaction
  • commit
Q5 |          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
  • consistency
  • atomicity
  • durability
  • isolation
Q6 | In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
  • create package
  • create schema
  • create cluster
  • all of the mentioned
Q7 | In SQL, the CREATE TABLESPACE is used
  • to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
  • to create a database trigger
  • to add/rename data files, to change storage
  • all of the mentioned
Q8 | Which character function can be used to return a specified portion of a character string?
  • instr
  • substring
  • substr
  • pos
Q9 | Which of the following is TRUE for the System Variable $date$?
  • can be assigned to a global variable
  • can be assigned to any field only during design time
  • can be assigned to any variable or field during run time
  • can be assigned to a local variable
Q10 | What are the different events in Triggers?
  • define, create
  • drop, comment
  • insert, update, delete
  • select, commit
Q11 | Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
  • data definition language
  • data manipulation language
  • data described language
  • data retrieval language
Q12 | The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’),
  • 6789
  • 2345
  • 1234
  • 456789
Q13 | Which of the following SQL command can be used to modify existing data in a database table?
  • modify
  • update
  • change
  • new
Q14 |                                provides option for entering SQL queries as execution time, rather than at the development stage.
  • pl/sql
  • sql*plus
  • sql
  • dynamic sql
Q15 | The storage structure which do not survive system crashes are              
  • volatile storage
  • non-volatile storage
  • stable storage
  • dynamic storage
Q16 | For a transaction to be durable, its changes need to be written to                  storage.
  • volatile storage
  • non-volatile storage
  • stable storage
  • dynamic storage
Q17 | The unit of storage that can store one are more records in a hash file organization are
  • buckets
  • disk pages
  • blocks
  • nodes
Q18 | A              file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
  • storage
  • tertiary
  • secondary
  • cluster
Q19 | A file produced by a spreadsheet
  • is generally stored on disk in an ascii text format
  • can be used as is by the dbms
  • all of the mentioned
  • none of the mentioned
Q20 | SDL means                            
  • storage discrete language
  • storage definition language
  • storage definition localisation
  • storage discrete localisation
Q21 | The process of saving information onto secondary storage devices is referred to as
  • backing up
  • restoring
  • writing
  • reading
Q22 | If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
  • flashback
  • rollback
  • both flashback and rollback
  • cannot be done
Q23 | Each modification done in database transaction are first recorded into the
  • harddrive
  • log
  • disk
  • datamart
Q24 | When the transaction finishes the final statement the transaction enters into
  • active state
  • committed state
  • partially committed state
  • abort state
Q25 | The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called
  • batch. exe
  • trans. exe
  • opt. exe
  • edit.exe