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),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
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
Q2 |                      states that only valid data will be written to the database.
Q3 | Transaction processing is associated with everything below except
Q4 | The Oracle RDBMS uses the           statement to declare a new transaction start and its properties.
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.
Q6 | In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
Q7 | In SQL, the CREATE TABLESPACE is used
Q8 | Which character function can be used to return a specified portion of a character string?
Q9 | Which of the following is TRUE for the System Variable $date$?
Q10 | What are the different events in Triggers?
Q11 | Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
Q12 | The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’),
Q13 | Which of the following SQL command can be used to modify existing data in a database table?
Q14 |                                provides option for entering SQL queries as execution time, rather than at the development stage.
Q15 | The storage structure which do not survive system crashes are              
Q16 | For a transaction to be durable, its changes need to be written to                  storage.
Q17 | The unit of storage that can store one are more records in a hash file organization are
Q18 | A              file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
Q19 | A file produced by a spreadsheet
Q20 | SDL means                            
Q21 | The process of saving information onto secondary storage devices is referred to as
Q22 | If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
Q23 | Each modification done in database transaction are first recorded into the
Q24 | When the transaction finishes the final statement the transaction enters into
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
Previous Next