DBMS -TRANSACTIONS MCQs
- With regards to transaction processing, any DBMS should be capable of:
- What is ACID properties of Transactions
- Database locking concept is used to solve the problem of
- A lock that allows concurrent transactions to access different rows of the same table is known as a
- A transaction completes its execution is said to be
- A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set
- The deadlock state can be changed back to stable state by using _____________ statement
- What are the ways of dealing with deadlock
- When transaction Ti requests a data item currently held by Tj
- When transaction Ti requests a data item currently held by Tj
- The deadlock in a set of transaction can be determined by
- A deadlock exists in the system if and only if the wait-for graph contains a ___________
- Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
- __________ rollback requires the system to maintain additional information about the state of all the running transactions
- Which of these is data type long literal
- Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read
- A transaction for which all committed changes are permanent is called
- In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed
- Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction
- A transaction may not always complete its execution successfully. Such a transaction is termed
- Transaction processing is associated with everything below except
- Transaction management ensures ____________ and __________ properties
- ____________ is an interface between low level database and application program
- Which of the following are functions of Database Manager
- Who detects the failure of the system and restore the database to consistent state
- A traditional data administrator performs which of the following roles
- Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally
- Which of the following is the preferred way to recover a database after a system failure
- Concurrency control is important for which of the following reasons
- A shared lock allows which of the following types of transactions to occur
- Locking may cause which of the following problems
- Performance analysis and tuning is which of the following
- Which of the following could cause data to be unavailable
- The transaction log includes which of the following
- Which of the following is part of an administrative policy to secure a database
- If both data and database administration exist in an organization, the database administrator is responsible for which of the following
- Which of the following is true concerning open-source DBMS
- A data warehouse administrator is concerned with which of the following
- Poor data administration can lead to which of the following
- Backward recovery is which of the following
- Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time
- In database management system, the executing process or executing program which considers the updating or reading of records stored in database is called
- The application of database management system in air flight seat booking in a way that one seat is accessed by only one clerk for customer reservation is classified as
- Collections of operations that form a single logical unit of work are called __________
- The “all-or-none” property is commonly referred to as _________
- Which of the following is a property of transactions
- Execution of translation in isolation preserves the _________ of a database
- Which of the following is not a property of a transaction
- Which of the following systems is responsible for ensuring durability
- Which of the following systems is responsible for ensuring isolation?
- State true or false: Information residing in the volatile storage does not usually survive system crashes
- A transaction that has not been completed successfully is called as _______
- Which of the following is not a transaction state
- The execution sequences in concurrency control are termed as ________
- The scheme that controls the interaction between executing transactions is called as _____
- I and J are _________ if they are operations by different transactions on the same data item, and at least one of them is a write operation
- lIf a schedule S can be transformed into a schedule S’ by a series of swaps of non-conflicting instructions, then S and S’ are
- A schedule is __________ if it is conflict equivalent to a serial schedule
- The set of ________ in a precedence graph consists of all the transactions participating in the schedule
- A ___________of the transactions can be obtained by finding a linear order consistent with the partial order of the precedence graph
- State true or false: If I = read(Q) and J = read(Q) then the order of I and J does not matter
- State true or false: If I = read(Q) and J = write(Q) then the order of I and J does not matter
- Which of the following is the most expensive method
- A transaction that performs only one operation is called as a _________
- The phenomenon in which one failure leads to a series of transaction rollbacks is called as ________
- State true or false: Every cascadeless schedule is also recoverable
- A ___________ is one where, for each pair of transactions Ti and Tj such that Tj reads a data item previously written by Ti , the commit operation of Ti appears before the commit operation of Tj
- State true or false: Transactions can only run serially
- Which of the following are the advantages of transaction concurrency
- The average time for a transaction to be completed after it has been submitted is called as __________
- If a schedule is equivalent to a serial schedule, it is called as a _________
- Which of the following is not a type of a schedule
- Which of the following is a transaction isolation level as specified by SQL standard
- State true or false: Serializable level may allow both serializable and non-serializable executions
- ________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction
- ________ allows only committed data to be read, but does not require repeatable reads
- ___________ allows uncommitted data to be read
- State true or false: All the isolation levels disallow dirty writes
- When is a timestamp allotted
- In ___________ isolation each transaction is given its own version of the database
- What is the disadvantage of locking
- Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?
- A transaction is delimited by statements (or function calls) of the form __________
- Identify the characteristics of transactions
- Which of the following has “all-or-none” property
- The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as
- The property of transaction that persists all the crashes is
- __________ states that only valid data will be written to the database
- The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties
- ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed
- In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
- Which character function can be used to return a specified portion of a character string
- Which of the following is TRUE for the System Variable $date$
- What are the different events in Triggers?
- The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints
- Which of the following SQL command can be used to modify existing data in a database table?
- When SQL statements are embedded inside 3GL, we call such a program as
- _______________ provides option for entering SQL queries as execution time, rather than at the development stage
- Each modification done in database transaction are first recorded into the
- _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed
- Which of the following is not a state in transaction
- _______________ joins are SQL server default
- The ________________ is essentially used to search for patterns in target string
- Which of the following is/are the Database server functions
- To delete a database ___________ command is used
- ____________ is a combination of two of more attributes used as a primary key
- Which of the following is not the function of client
- ____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified
- ______________ requires that data should be made available to only authorized users
- Some of the utilities of DBMS are _____________
- ____________ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement
- Which is essential a business problem not a data problem
- Which is primarily the result of a thorough understanding of information about an enterprise:
- McFadden has defined normalization in his which book___________
- The database design prevents some data from being represented due to _______
- How many types of insertion anomalies:
- Who developed the normalization process:
- E.F.Codd developed the normalization process in the which early:
- Which is the process of breaking a relation into multiple relations:
- Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:
- Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
- Which is a duplicate copy of a file program that is stored on a different storage media than the original location:
- Which is duplication of computer operations and routine backups to combat any unforeseen problems:
- Optimization that is basically related to the rewriter module is termed as__________
- Optimization basically related to the Rewrite module is termed as_______
- Database security helps organizations to protect data from _____
- Copying files to secondary or specific devices is known as ______
- How many types of recovery control techniques:
- Which are types of recovery control techniques:
- Which server can joins the indexes when only multiple indexes combined can cover the query:
- In concurrency control policy the the lock is obtained on
- A concurrency-control policy such as this one leads to ______ performance, since it forces transactions to wait for preceding transactions to finish before they can start
- __________ are used to ensure that transactions access each data item in order of the transactions’ ____ if their accesses conflict
- EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?
- In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
- Which statement is true regarding external tables
- A non-correlated subquery can be defined as ______
- Evaluate the following SQL statements in the given order
- What would be the outcome of the below query?
- Which of the following is not a property of transactions
- SNAPSHOT is used for (DBA)
- Isolation of the transactions is ensured by
- Constraint checking can be disabled in existing _______________ and _____________ constraints so that any data you modify or add to the table is not checked against the constraint
Database
(d).Dynamic data replication
need an explanation for this answer? contact us directly to get an explanation for this answer