71 + Interview Questions in Transactions in Database Management Page 1 InterviewSolution

1.	Which statement is true regarding external tables?(a) The default REJECT LIMIT for external tables is UNLIMITED(b) The data and metadata for an external table are stored outside the database(c) ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table(d) The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external tableThe question was posed to me in final exam.The query is from Implementation of Isolation Levels topic in section Transactions of Database Management
Answer» CORRECT ANSWER is (d) The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table For explanation: This will REPLICATE the table as in the select statement.

Discussion

2.	How many types of recovery control techniques:(a) 2(b) 3(c) 4(d) 5This question was addressed to me in an international level competition.This interesting question is from Querying database part 5 in chapter Transactions of Database Management
Answer» RIGHT answer is (a) 2 Easy explanation - RECOVERY means to take the backup DATA while there is a CRASH.

Discussion

3.	Who developed the normalization process:(a) E.F. codd(b) F.F. codd(c) E.E. codd(d) None of the mentionedThe question was asked in an international level competition.Query is from Querying Database in section Transactions of Database Management
Answer» RIGHT option is (a) E.F. codd The BEST EXPLANATION: Normalization helps in improving the QUALITY of the data.

Discussion

4.	The storage structure which do not survive system crashes are ______(a) Volatile storage(b) Non-volatile storage(c) Stable storage(d) Dynamic storageI had been asked this question in an interview.This interesting question is from Storage Structure in section Transactions of Database Management
Answer» Right choice is (a) Volatile STORAGE Best EXPLANATION: Volatile storage, is a COMPUTER memory that requires POWER to maintain the stored information, in other words it needs power to REACH the computer memory.

Discussion

5.	Which of the following SQL command can be used to modify existing data in a database table?(a) MODIFY(b) UPDATE(c) CHANGE(d) NEWThe question was posed to me in unit test.My question is from A Simple Transaction Model topic in chapter Transactions of Database Management
Answer» Correct CHOICE is (B) UPDATE Easy explanation - Syntax : UPDATE table_name SET column1=value1,column2=value2,… WHERE some_column=some_value; .

Discussion

6.	Which of the following is TRUE for the System Variable $date$?(a) Can be assigned to a global variable(b) Can be assigned to any field only during design time(c) Can be assigned to any variable or field during run time(d) Can be assigned to a local variableThis question was posed to me in examination.Question is taken from A Simple Transaction Model topic in portion Transactions of Database Management
Answer» CORRECT choice is (b) Can be assigned to any field only during design time The EXPLANATION is: A database schema of a database system is its structure DESCRIBED in a formal LANGUAGE supported by the database management system and refers to the ORGANIZATION of data as a blueprint of how a database is constructed.

Discussion

7.	Which character function can be used to return a specified portion of a character string?(a) INSTR(b) SUBSTRING(c) SUBSTR(d) POSI had been asked this question during an interview for a job.Enquiry is from A Simple Transaction Model topic in chapter Transactions of Database Management
Answer» Correct CHOICE is (c) SUBSTR Best EXPLANATION: SUBSTR are used to match the PARTICULAR CHARACTERS in a STRING.

Discussion

8.	In SQL, the CREATE TABLESPACE is used(a) To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace(b) To create a database trigger(c) To add/rename data files, to change storage(d) All of the mentionedThe question was asked in exam.Query is from A Simple Transaction Model in chapter Transactions of Database Management
Answer» Correct ANSWER is (a) To create a place in the database for storage of scheme OBJECTS, rollback segments, and naming the DATA files to COMPRISE the tablespace The best I can explain: Triggers are used to initialize the actions for an activity.

Discussion

9.	To delete a database ___________ command is used(a) Delete database database_name(b) Delete database_name(c) drop database database_name(d) drop database_nameI had been asked this question in an international level competition.Asked question is from Querying database part 3 topic in portion Transactions of Database Management
Answer» The CORRECT choice is (c) drop database database_name Easiest EXPLANATION - This will DELETE the database with its STRUCTURE.

Discussion

10.	SDL means _____________(a) Storage Discrete Language(b) Storage Definition Language(c) Storage Definition Localisation(d) Storage Discrete LocalisationThis question was addressed to me in an internship interview.I would like to ask this question from Storage Structure in section Transactions of Database Management
Answer» RIGHT ANSWER is (b) Storage Definition Language To EXPLAIN: It specifies internal SCHEMA and also mapping between two schemas.

Discussion

11.	A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.(a) Storage(b) Tertiary(c) Secondary(d) ClusterThe question was posed to me in quiz.I want to ask this question from Storage Structure in portion Transactions of Database Management
Answer» The CORRECT choice is (d) Cluster Best explanation: With a cluster FILE SYSTEM, the failure of a COMPUTER in the cluster does not make the file system UNAVAILABLE.

Discussion

12.	Which of the following is not the function of client?(a) Compile queries(b) Query optimization(c) Receive queries(d) Result formatting and presentationI have been asked this question in quiz.The question is from Querying database part 3 topic in division Transactions of Database Management
Answer» Correct OPTION is (b) Query OPTIMIZATION For explanation: Query optimization is used to IMPROVE quality.

Discussion

13.	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(a) Batch. Exe(b) Trans. Exe(c) Opt. Exe(d) Edit.ExeThis question was posed to me during an interview.My doubt is from Transaction Atomicity and Durability topic in section Transactions of Database Management
Answer» Correct ANSWER is (c) Opt. Exe Best EXPLANATION: TRANSACTIONS has to be MANAGED by the executable files.

Discussion

14.	__________ states that only valid data will be written to the database.(a) Consistency(b) Atomicity(c) Durability(d) IsolationI have been asked this question during an online exam.My doubt stems from Transaction Concept topic in division Transactions of Database Management
Answer» Right CHOICE is (a) Consistency To explain: If for some REASON, a transaction is executed that violates the DATABASE’s consistency rules, the entire transaction will be rolled back and the database will be RESTORED to a state consistent with those rules.

Discussion

15.	A transaction is delimited by statements (or function calls) of the form __________(a) Begin transaction and end transaction(b) Start transaction and stop transaction(c) Get transaction and post transaction(d) Read transaction and write transactionThe question was asked at a job interview.Question is taken from Transaction Concept in chapter Transactions of Database Management
Answer» The correct CHOICE is (a) BEGIN transaction and END transaction The explanation is: The transaction CONSISTS of all operations executed between the begin transaction and end transaction.

Discussion

16.	How many types of insertion anomalies:(a) 1(b) 2(c) 3(d) 4I had been asked this question in examination.Asked question is from Querying Database topic in section Transactions of Database Management
Answer» Right ANSWER is (B) 2 Best explanation: Insertion anomaly is due to confusion in DATA deletion or insertion.

Discussion

17.	The database design prevents some data from being represented due to _______(a) Deletion anomalies(b) Insertion anomalies(c) Update anomaly(d) None of the mentionedThe question was asked in exam.My question is taken from Querying Database topic in chapter Transactions of Database Management
Answer» Right option is (b) Insertion anomalies The best EXPLANATION: Insertion ANOMALY is DUE to confusion in data DELETION or insertion.

Discussion

18.	McFadden has defined normalization in his which book___________(a) Database modern management(b) Management database of modern(c) Modern database management(d) Database managementThe question was posed to me in a national level competition.The origin of the question is Querying Database in chapter Transactions of Database Management
Answer» Correct CHOICE is (C) MODERN database management Best explanation: SQL-99 is the most recent version of STANDARD SQL prescribed by the ANSI.

Discussion

19.	The unit of storage that can store one are more records in a hash file organization are(a) Buckets(b) Disk pages(c) Blocks(d) NodesI had been asked this question by my school teacher while I was bunking the class.My doubt stems from Storage Structure topic in portion Transactions of Database Management
Answer» Correct CHOICE is (a) Buckets Explanation: Buckets are used to store ONE or more records in a hash FILE ORGANIZATION.

Discussion

20.	Identify the characteristics of transactions(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedThe question was posed to me during an internship interview.My question is from Transaction Concept in section Transactions of Database Management
Answer» CORRECT choice is (d) All of the mentioned Easy EXPLANATION - Because of the above three properties, TRANSACTIONS are an ideal way of structuring INTERACTION with a DATABASE.

Discussion

21.	DBMS periodically suspends all processing and synchronizes its files and journals through the use of(a) Checkpoint facility(b) Backup facility(c) Recovery manager(d) Database change logThis question was posed to me in quiz.My question is from Transaction Atomicity and Durability topic in chapter Transactions of Database Management
Answer» Right answer is (a) Checkpoint facility Easiest explanation - DBMS periodically suspends all PROCESSING and synchronizes its FILES and journals though the use ofCheck POINT facility.

Discussion

22.	Which of the following are the process of selecting the data storage and data access characteristics of the database?(a) Logical database design(b) Physical database design(c) Testing and performance tuning(d) Evaluation and selectingThis question was addressed to me in an interview.My doubt stems from Storage Structure in section Transactions of Database Management
Answer» The CORRECT option is (B) Physical database DESIGN The best I can EXPLAIN: Physical database design is the PROCESS of selecting the data storage and data access characteristics of the database.

Discussion

23.	What are the different events in Triggers?(a) Define, Create(b) Drop, Comment(c) Insert, Update, Delete(d) Select, CommitThis question was addressed to me during an online exam.My doubt stems from A Simple Transaction Model in section Transactions of Database Management
Answer» Right choice is (c) Insert, Update, Delete The BEST explanation: A database trigger is a procedural CODE that is automatically executed in response to CERTAIN EVENTS on a PARTICULAR table or view in a database.

Discussion

24.	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(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedThis question was addressed to me in an interview for internship.Query is from Transaction Concept topic in chapter Transactions of Database Management
Answer» Correct option is (c) Isolation Best explanation: Even THOUGH multiple TRANSACTIONS may EXECUTE CONCURRENTLY, the system guarantees that, for every pair of transactions Ti and Tj, it appears to Ti that either Tj finished execution before Ti STARTED or Tj started execution after Ti finished.

Discussion

25.	Which is the duplication of computer operations and routine backups to combat any unforeseen problems:(a) Concurrency(b) Deadlock(c) Backup(d) RecoveryI have been asked this question in examination.I'm obligated to ask this question of Querying database part 5 topic in chapter Transactions of Database Management
Answer» The CORRECT answer is (d) Recovery The explanation is: Recovery MEANS to TAKE the BACKUP DATA while there is a crash.

Discussion

26.	In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?(a) CREATE PACKAGE(b) CREATE SCHEMA(c) CREATE CLUSTER(d) All of the mentionedThe question was asked in class test.Query is from A Simple Transaction Model in chapter Transactions of Database Management
Answer» The CORRECT ANSWER is (b) CREATE SCHEMA Easy explanation - A database schema of a database system is its structure described in a formal language supported by the database management system and REFERS to the ORGANIZATION of data as a blueprint of how a database is CONSTRUCTED.

Discussion

27.	____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.(a) Procedure(b) Trigger(c) Curser(d) None of the MentionedThe question was posed to me in semester exam.I need to ask this question from Querying database part 3 topic in portion Transactions of Database Management
Answer» The CORRECT answer is (b) Trigger The explanation is: Triggers are used to INITIATE an ACTION to take PLACE.

Discussion

28.	Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?(a) Data Definition Language(b) Data Manipulation Language(c) Data Described Language(d) Data Retrieval LanguageI got this question by my college director while I was bunking the class.This interesting question is from A Simple Transaction Model topic in section Transactions of Database Management
Answer» Correct choice is (a) Data Definition Language The BEST I can EXPLAIN: DDL are USED to define schema and table CHARACTERS.

Discussion

29.	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) Only 1(b) Only 2(c) Both 1 and 2 individually(d) Either 1 or 2The question was asked in class test.Question is from Transaction Concept in division Transactions of Database Management
Answer» RIGHT option is (c) Both 1 and 2 individually Explanation: The term transaction refers to a collection of operations that FORM a SINGLE logical unit of work.

Discussion

30.	Which of the following is the original purpose of SQL?(a) To specify the syntax and semantics of SQL data definition language(b) To specify the syntax and semantics of SQL manipulation language(c) To define the data structures(d) All of the mentionedThe question was asked by my college director while I was bunking the class.This intriguing question comes from Transactions as SQL Statements topic in section Transactions of Database Management
Answer» CORRECT option is (d) All of the mentioned Easy explanation - READ committed is used to commit the default read operation.

Discussion

31.	Problems occurs if we don’t implement a proper locking strategy(a) Dirty reads(b) Phantom reads(c) Lost updates(d) Unrepeatable readsThe question was asked during an interview.This key question is from Transactions as SQL Statements topic in portion Transactions of Database Management
Answer» RIGHT choice is (d) Unrepeatable reads The BEST explanation: In a concurrent execution of these TRANSACTIONS, it is intuitively clear that they conflict, but this is a conflict not captured by our simple model. This situation is referred to as the PHANTOM phenomenon, because a conflict may exist on “phantom” data.

Discussion

32.	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.(a) CHECK, FOREIGN KEY(b) DELETE, FOREIGN KEY(c) CHECK, PRIMARY KEY(d) PRIMARY KEY, FOREIGN KEYI have been asked this question in homework.My query is from Transactions as SQL Statements topic in division Transactions of Database Management
Answer» The correct ANSWER is (a) CHECK, FOREIGN KEY For EXPLANATION: Check and foreign constraints are USED to constraint the table DATA.

Discussion

33.	Which is a bottom-up approach to database design that design by examining the relationship between attributes:(a) Functional dependency(b) Database modeling(c) Normalization(d) DecompositionThis question was posed to me in semester exam.The origin of the question is Querying Database topic in division Transactions of Database Management
Answer» RIGHT OPTION is (C) Normalization Explanation: Normalization HELPS in improving the quality of the data.

Discussion

34.	_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.(a) Serializability(b) Atomicity(c) Isolation(d) Time stampingI have been asked this question in unit test.My doubt is from Transaction Atomicity and Durability in division Transactions of Database Management
Answer» Correct ANSWER is (c) Isolation Best explanation: Isolation MEANS that data USED during the execution of a transaction can’t be used by a SECOND transaction until the first ONE is completed.

Discussion

35.	Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:(a) Concurrency(b) Deadlock(c) Backup(d) RecoveryThe question was asked in an international level competition.The origin of the question is Querying database part 5 topic in section Transactions of Database Management
Answer» The correct ANSWER is (b) DEADLOCK The best explanation: Deadlock will stop further PROCESSING.

Discussion

36.	Which is primarily the result of a thorough understanding of information about an enterprise:(a) Data(b) Database(c) Database design(d) Data modelingI got this question by my college professor while I was bunking the class.I'm obligated to ask this question of Querying Database in division Transactions of Database Management
Answer» The CORRECT answer is (d) DATA modeling The best EXPLANATION: Data modelling DESIGNS the data in a secured manner.

Discussion

37.	A file produced by a spreadsheet(a) is generally stored on disk in an ASCII text format(b) can be used as is by the DBMS(c) all of the mentioned(d) none of the mentionedThis question was posed to me by my school principal while I was bunking the class.This key question is from Storage Structure topic in section Transactions of Database Management
Answer» The CORRECT choice is (a) is generally stored on disk in an ASCII TEXT FORMAT The BEST explanation: ASCII text format uses the STANDARD text file for the changing the value.

Discussion

38.	SNAPSHOT is used for (DBA)(a) Synonym(b) Tablespace(c) System server(d) Dynamic data replicationThe question was posed to me during an interview for a job.The query is from Transactions as SQL Statements topic in portion Transactions of Database Management
Answer» CORRECT choice is (d) DYNAMIC data replication For explanation: Snapshot gets the INSTANCE of the DATABASE at that time.

Discussion

39.	E.F.Codd developed the normalization process in the which early:(a) 1969(b) 1970(c) 1971(d) 1972I have been asked this question by my college director while I was bunking the class.My question is taken from Querying Database in section Transactions of Database Management
Answer» Correct answer is (B) 1970 The BEST explanation: Normalization HELPS in improving the QUALITY of the data.

Discussion

40.	______________ requires that data should be made available to only authorized users.(a) Data integrity(b) Privacy(c) Security(d) None of the MentionedThis question was addressed to me in class test.I'd like to ask this question from Querying database part 3 in division Transactions of Database Management
Answer» The correct OPTION is (c) Security The BEST explanation: Some ALGORITHMS may be USED for the security.

Discussion

41.	If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by(a) Flashback(b) Rollback(c) Both Flashback and Rollback(d) Cannot be doneI got this question in an interview for job.This interesting question is from Transaction Atomicity and Durability topic in chapter Transactions of Database Management
Answer» Right choice is (d) Cannot be done The BEST I can explain: Once committed the changes cannot be ROLLED BACK.

Discussion

42.	When SQL statements are embedded inside 3GL, we call such a program as(a) Nested query(b) Nested programming(c) Distinct query(d) Embedded SQLThis question was posed to me in exam.My query is from A Simple Transaction Model in section Transactions of Database Management
Answer» Right choice is (d) EMBEDDED SQL Best explanation: SQL-99 is the most RECENT VERSION of STANDARD SQL PRESCRIBED by the ANSI.

Discussion

43.	Database security helps organizations to protect data from _____(a) Internal users(b) External users(c) Non-external users(d) Non internal usersI have been asked this question in my homework.The query is from Querying database part 5 topic in section Transactions of Database Management
Answer» RIGHT choice is (b) EXTERNAL users The best EXPLANATION: External users are the people who do not INVOLVE in the processing of the database.

Discussion

44.	Which are types of recovery control techniques:(a) Deferred update(b) Immediate update(c) All of the Mentioned(d) None of the MentionedThis question was posed to me at a job interview.Question is from Querying database part 5 topic in division Transactions of Database Management
Answer» The correct answer is (c) All of the Mentioned Easiest EXPLANATION - Recovery MEANS to TAKE the backup data while there is a CRASH.

Discussion

45.	Optimization basically related to the Rewrite module is termed as_______(a) Semantic query optimization(b) Global query optimization(c) All of the Mentioned(d) None of the MentionedThe question was asked by my college director while I was bunking the class.My question is based upon Querying database part 5 topic in portion Transactions of Database Management
Answer» Right OPTION is (a) SEMANTIC query optimization The BEST explanation: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.

Discussion

46.	The ________________ is essentially used to search for patterns in target string.(a) Like Predicate(b) Null Predicate(c) In Predicate(d) Out PredicateThis question was addressed to me in unit test.This key question is from Querying database part 3 topic in portion Transactions of Database Management
Answer» Right answer is (a) LIKE Predicate Easy explanation - Like matches the PATTERN with the QUERY.

Discussion

47.	_______________ joins are SQL server default(a) Outer(b) Inner(c) Equi(d) None of the MentionedThis question was posed to me during an online exam.This key question is from Querying database part 3 in section Transactions of Database Management
Answer» The CORRECT CHOICE is (b) Inner The best I can EXPLAIN: Inner query joins only the rows that are MATCHING.

Discussion

48.	Which of the following is an atomic sequence of database actions?(a) Transaction(b) Concurrency(c) Relations(d) All of the mentionedI have been asked this question in quiz.This key question is from Transaction Atomicity and Durability topic in division Transactions of Database Management
Answer» Right option is (a) TRANSACTION Explanation: Transaction is a collection of OPERATIONS that provides single LOGICAL function in DATABASE.

Discussion

49.	A transaction may not always complete its execution successfully. Such a transaction is termed(a) Aborted(b) Terminated(c) Closed(d) All of the mentionedI got this question in an interview for internship.Question is from Transaction Atomicity and Durability in portion Transactions of Database Management
Answer» CORRECT ANSWER is (a) Aborted Easy explanation - If we are to ENSURE the ATOMICITY property, an aborted transaction must have no effect on the state of the DATABASE.

Discussion

50.	Which of the following statements is/are not true for SQL profiler?(a) Enables you to monitor events(b) Check if rows are being inserted properly(c) Check the performance of a stored procedure(d) ALL of the mentionedThis question was addressed to me at a job interview.Enquiry is from Transactions as SQL Statements in section Transactions of Database Management
Answer» The correct answer is (C) Check the PERFORMANCE of a stored procedure Easy explanation - READ committed is used to COMMIT the default read operation.

Discussion

Explore topic-wise InterviewSolutions in .

How many types of recovery control techniques:(a) 2(b) 3(c) 4(d) 5This question was addressed to me in an international level competition.This interesting question is from Querying database part 5 in chapter Transactions of Database Management

Who developed the normalization process:(a) E.F. codd(b) F.F. codd(c) E.E. codd(d) None of the mentionedThe question was asked in an international level competition.Query is from Querying Database in section Transactions of Database Management

The storage structure which do not survive system crashes are ______(a) Volatile storage(b) Non-volatile storage(c) Stable storage(d) Dynamic storageI had been asked this question in an interview.This interesting question is from Storage Structure in section Transactions of Database Management

Which of the following SQL command can be used to modify existing data in a database table?(a) MODIFY(b) UPDATE(c) CHANGE(d) NEWThe question was posed to me in unit test.My question is from A Simple Transaction Model topic in chapter Transactions of Database Management

Which character function can be used to return a specified portion of a character string?(a) INSTR(b) SUBSTRING(c) SUBSTR(d) POSI had been asked this question during an interview for a job.Enquiry is from A Simple Transaction Model topic in chapter Transactions of Database Management

Which of the following is not the function of client?(a) Compile queries(b) Query optimization(c) Receive queries(d) Result formatting and presentationI have been asked this question in quiz.The question is from Querying database part 3 topic in division Transactions of Database Management

__________ states that only valid data will be written to the database.(a) Consistency(b) Atomicity(c) Durability(d) IsolationI have been asked this question during an online exam.My doubt stems from Transaction Concept topic in division Transactions of Database Management

How many types of insertion anomalies:(a) 1(b) 2(c) 3(d) 4I had been asked this question in examination.Asked question is from Querying Database topic in section Transactions of Database Management

The database design prevents some data from being represented due to _______(a) Deletion anomalies(b) Insertion anomalies(c) Update anomaly(d) None of the mentionedThe question was asked in exam.My question is taken from Querying Database topic in chapter Transactions of Database Management

Identify the characteristics of transactions(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedThe question was posed to me during an internship interview.My question is from Transaction Concept in section Transactions of Database Management

What are the different events in Triggers?(a) Define, Create(b) Drop, Comment(c) Insert, Update, Delete(d) Select, CommitThis question was addressed to me during an online exam.My doubt stems from A Simple Transaction Model in section Transactions of Database Management

Problems occurs if we don’t implement a proper locking strategy(a) Dirty reads(b) Phantom reads(c) Lost updates(d) Unrepeatable readsThe question was asked during an interview.This key question is from Transactions as SQL Statements topic in portion Transactions of Database Management

SNAPSHOT is used for (DBA)(a) Synonym(b) Tablespace(c) System server(d) Dynamic data replicationThe question was posed to me during an interview for a job.The query is from Transactions as SQL Statements topic in portion Transactions of Database Management

E.F.Codd developed the normalization process in the which early:(a) 1969(b) 1970(c) 1971(d) 1972I have been asked this question by my college director while I was bunking the class.My question is taken from Querying Database in section Transactions of Database Management

When SQL statements are embedded inside 3GL, we call such a program as(a) Nested query(b) Nested programming(c) Distinct query(d) Embedded SQLThis question was posed to me in exam.My query is from A Simple Transaction Model in section Transactions of Database Management

Database security helps organizations to protect data from _____(a) Internal users(b) External users(c) Non-external users(d) Non internal usersI have been asked this question in my homework.The query is from Querying database part 5 topic in section Transactions of Database Management

Which are types of recovery control techniques:(a) Deferred update(b) Immediate update(c) All of the Mentioned(d) None of the MentionedThis question was posed to me at a job interview.Question is from Querying database part 5 topic in division Transactions of Database Management

_______________ joins are SQL server default(a) Outer(b) Inner(c) Equi(d) None of the MentionedThis question was posed to me during an online exam.This key question is from Querying database part 3 in section Transactions of Database Management

Which of the following is an atomic sequence of database actions?(a) Transaction(b) Concurrency(c) Relations(d) All of the mentionedI have been asked this question in quiz.This key question is from Transaction Atomicity and Durability topic in division Transactions of Database Management