in Education by
The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties. (a) BEGIN (b) SET TRANSACTION (c) BEGIN TRANSACTION (d) COMMIT The question was asked during a job interview. I want to ask this question from Transaction Concept topic in division Transactions of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Correct option is (b) SET TRANSACTION Best explanation: Commit is used to store all the transactions.

Related questions

0 votes
    In JavaScript, object is a container of properties and functions. Properties are identified by ____ and behavior is ... , functions 3. attributes, variables 4. functions, variables...
asked Feb 24, 2021 in Technology by JackTerrance
+1 vote
    In JavaScript, object is a container of properties and functions. Properties are identified by ____ and behavior is ... , functions 3) attributes, variables 4) functions, variables...
asked Oct 9, 2020 in Technology by JackTerrance
0 votes
0 votes
    ____ is a hard disk interface that uses parallel signal to transfer data and information Select the correct answer from above options...
asked Dec 1, 2021 in Education by JackTerrance
0 votes
    ____ symbol is used to start any formula (function) in excel calculations . 1. equal 2. plus 3. multiplication 4. sigma Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
    How can you start a JTA transaction from a Servlet deployed on JBoss?...
asked Jun 5, 2021 in Technology by JackTerrance
0 votes
    New bitcoins are released every time a transaction is verified. A. True B. False...
asked Nov 30, 2022 in Education by JackTerrance
0 votes
    What are the uses of Start, Duration and Delay options? tom Show Select the correct answer from above options...
asked Dec 19, 2021 in Education by JackTerrance
0 votes
    What are the uses of Start, Duration and Delay options? tom Show Select the correct answer from above options...
asked Dec 18, 2021 in Education by JackTerrance
0 votes
    What is sub query and its properties?...
asked Nov 9, 2020 in Technology by Editorial Staff
0 votes
    A transaction commits as soon as its commit log record is written to stable storage at the primary and ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    For a transaction to be durable, its changes need to be written to ________ storage. (a) Volatile storage ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A transaction may not always complete its execution successfully. Such a transaction is termed (a) Aborted ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A transaction commits as soon as its commit log record is written to stable storage at the primary site. ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The __________ requires that each transaction Ti executes in two or three different phases in its lifetime ... topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
...