Database Management System Set 25
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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