Database Management Systems (DBMS)
In computer science, Transaction refers to which of the following?
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “In computer science, Transaction refers to which of the following?”
The accepted answer is D. A sequence of one or more database operations executed as a single logical unit of work.. In computer science Transaction refers to which of the following is answered by A sequence of one or more database operations executed as a single logical unit of work option D Option A The process of organizing database tables to reduce data redundancy and improve data integrity does not match the stem it is a near-miss used to catch incomplete recall of A sequence of one or more database operations executed as a single logical unit of work Option B A stored procedure that automatically executes in response to certain events on a table does not match the stem it is a near-miss used to catch incomplete recall of A sequence of one or more database operations executed as a.
- A. The process of organizing database tables to reduce data redundancy and improve data integrity.
Why not A: “The process of organizing database tables to reduce data redundancy and improve data integrity.” is not correct. The accepted answer is D. A sequence of one or more database operations executed as a single logical unit of work.. In computer science Transaction refers to which of the following is answered by A sequence of one or more database operations executed as a single logical unit of work option D Opt
- B. A stored procedure that automatically executes in response to certain events on a table.
Why not B: “A stored procedure that automatically executes in response to certain events on a table.” is not correct. The accepted answer is D. A sequence of one or more database operations executed as a single logical unit of work.. In computer science Transaction refers to which of the following is answered by A sequence of one or more database operations executed as a single logical unit of work option D Opt
- C. A virtual table based on the result of a stored SQL query.
Why not C: “A virtual table based on the result of a stored SQL query.” is not correct. The accepted answer is D. A sequence of one or more database operations executed as a single logical unit of work.. In computer science Transaction refers to which of the following is answered by A sequence of one or more database operations executed as a single logical unit of work option D Opt
- D. A sequence of one or more database operations executed as a single logical unit of work. ✓
Correct answer
D. A sequence of one or more database operations executed as a single logical unit of work.
Explanation
In computer science Transaction refers to which of the following is answered by A sequence of one or more database operations executed as a single logical unit of work option D Option A The process of organizing database tables to reduce data redundancy and improve data integrity does not match the stem it is a near-miss used to catch incomplete recall of A sequence of one or more database operations executed as a single logical unit of work Option B A stored procedure that automatically executes in response to certain events on a table does not match the stem it is a near-miss used to catch incomplete recall of A sequence of one or more database operations executed as a.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Identify the correct definition of Database index.
- Which statement correctly explains Entity-Relationship (ER) diagram?
- The concept in which a database structure that improves the speed of data retrieval operations on a table is b...
- Which concept is defined as follows: the process of intentionally introducing redundancy into a database to im...
- What is the function or purpose of SQL JOIN?
- What is Denormalization primarily used for?