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

51.	The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints(a) 6789(b) 2345(c) 1234(d) 456789This question was posed to me in an interview.My doubt stems from A Simple Transaction Model in division Transactions of Database Management
Answer» Correct choice is (b) 2345 The EXPLANATION is: SUBSTR are USED to match the particular characters in a string.

Discussion

52.	Optimization that is basically related to the rewriter module is termed as__________(a) Semantic query optimization(b) Global query optimization(c) All of the Mentioned(d) None of the MentionedThe question was posed to me in unit test.My enquiry is from Querying database part 5 topic in section Transactions of Database Management
Answer» RIGHT OPTION is (a) Semantic query optimization Explanation: SQL-99 is the most recent VERSION of standard SQL PRESCRIBED by the ANSI.

Discussion

53.	Which is a duplicate copy of a file program that is stored on a different storage media than the original location:(a) Concurrency(b) Deadlock(c) Backup(d) RecoveryThe question was asked in an interview for internship.Query is from Querying database part 5 in division Transactions of Database Management
Answer» RIGHT answer is (C) BACKUP Explanation: Backup is required to TAKE all the DATA.

Discussion

54.	Which of the following fixed database roles can add or remove user IDs?(a) db_accessadmin(b) db_securityadmin(c) db_setupadmin(d) db_sysadminI got this question during an interview.My query is from Transactions as SQL Statements topic in section Transactions of Database Management
Answer» The correct OPTION is (a) db_accessadmin Easy EXPLANATION - The database can be accessed by ASSIGNING the ROLES.

Discussion

55.	Copying files to secondary or specific devices is known as ______(a) Retrieve(b) Backup(c) Recovery(d) DeadlockThe question was posed to me in class test.I'd like to ask this question from Querying database part 5 in division Transactions of Database Management
Answer» RIGHT CHOICE is (b) BACKUP Explanation: Backup is REQUIRED to take all the DATA.

Discussion

56.	Which s essential a business problem not a data problem:(a) Data(b) Database(c) Database design(d) All of the mentionedI have been asked this question in an international level competition.I'd like to ask this question from Querying Database topic in division Transactions of Database Management
Answer» The correct CHOICE is (c) Database design The BEST explanation: SQL-99 is the most RECENT version of STANDARD SQL prescribed by the ANSI.

Discussion

57.	Each modification done in database transaction are first recorded into the(a) Harddrive(b) Log(c) Disk(d) DatamartI got this question in an interview.This is a very interesting question from Transaction Atomicity and Durability topic in division Transactions of Database Management
Answer» The CORRECT CHOICE is (b) Log The best EXPLANATION: After commit is ISSUED the data are STORED in a database and stored in drive.

Discussion

58.	Storage devices like tertiary storage, magnetic disk comes under(a) Volatile storage(b) Non-volatile storage(c) Stable storage(d) Dynamic storageI had been asked this question by my school principal while I was bunking the class.This interesting question is from Storage Structure topic in division Transactions of Database Management
Answer» RIGHT option is (B) Non-volatile storage Best explanation: Information RESIDING in NONVOLATILE storage survives system CRASHES.

Discussion

59.	By default sql server has ___________ isolation level(a) READ COMMITTED(b) READ UNCOMMITTED(c) SERIALIZABLE(d) REPEATABLE READThis question was posed to me at a job interview.I'd like to ask this question from Transactions as SQL Statements in portion Transactions of Database Management
Answer» The CORRECT ANSWER is (a) READ COMMITTED Easiest EXPLANATION - Read committed is used to commit the DEFAULT read operation.

Discussion

60.	If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called(a) Consistent state(b) Parallel state(c) Atomic state(d) Inconsistent stateI had been asked this question in exam.My question is from Transaction Atomicity and Durability in division Transactions of Database Management
Answer» Right OPTION is (d) INCONSISTENT state Best explanation: If the state of the database no LONGER reflects a REAL state of the world that the database is supposed to capture, then such a state is called in a consistent state.

Discussion

61.	When the transaction finishes the final statement the transaction enters into(a) Active state(b) Committed state(c) Partially committed state(d) Abort stateThis question was addressed to me by my school principal while I was bunking the class.This question is from Transaction Atomicity and Durability topic in division Transactions of Database Management
Answer» RIGHT answer is (c) PARTIALLY committed state To explain: The commit STATEMENT has to be issued to ENTER into committed state.

Discussion

62.	The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.(a) BEGIN(b) SET TRANSACTION(c) BEGIN TRANSACTION(d) COMMITThe question was asked during a job interview.I want to ask this question from Transaction Concept topic in division Transactions of Database Management
Answer» CORRECT option is (b) SET TRANSACTION Best explanation: Commit is USED to store all the transactions.

Discussion

63.	The property of a transaction that persists all the crashes is(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedI have been asked this question at a job interview.This intriguing question originated from Transaction Concept topic in chapter Transactions of Database Management
Answer» The correct CHOICE is (B) Durability Explanation: After a transaction completes SUCCESSFULLY, the changes it has MADE to the DATABASE persist, even if there are system failures.

Discussion

64.	Which of the following has “all-or-none” property?(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedThe question was posed to me in an internship interview.This interesting question is from Transaction Concept topic in portion Transactions of Database Management
Answer» The correct choice is (a) Atomicity Best explanation: Either all OPERATIONS of the TRANSACTION are reflected PROPERLY in the database, or none are.

Discussion

65.	Isolation of the transactions is ensured by(a) Transaction management(b) Application programmer(c) Concurrency control(d) Recovery managementThe question was asked during an internship interview.My doubt is from Transactions as SQL Statements in chapter Transactions of Database Management
Answer» The CORRECT ANSWER is (c) Concurrency control Best explanation: ACID properties are the properties of TRANSACTIONS.

Discussion

66.	Which of the following is not a property of transactions?(a) Atomicity(b) Concurrency(c) Isolation(d) DurabilityThe question was posed to me in examination.The query is from Transactions as SQL Statements topic in portion Transactions of Database Management
Answer» The correct answer is (d) Durability Easiest EXPLANATION - ACID PROPERTIES are the properties of TRANSACTIONS.

Discussion

67.	Which is the process of breaking a relation into multiple relations:(a) Functional dependency(b) Database modeling(c) Normalization(d) DecompositionI had been asked this question in unit test.The question is from Querying Database topic in division Transactions of Database Management
Answer» Correct OPTION is (d) Decomposition To EXPLAIN: SQL-99 is the most RECENT version of standard SQL PRESCRIBED by the ANSI.

Discussion

68.	____________ is a combination of two of more attributes used as a primary key(a) Composite Key(b) Alternate Key(c) Candidate Key(d) Foreign KeyI got this question in an online interview.I want to ask this question from Querying database part 3 in section Transactions of Database Management
Answer» The CORRECT option is (a) Composite Key The best explanation: Primary KEYS TOGETHER form the composite key.

Discussion

69.	Which of the following is the oldest database model?(a) Relational(b) Hierarchical(c) Physical(d) NetworkThis question was posed to me by my school principal while I was bunking the class.I'd like to ask this question from Storage Structure topic in portion Transactions of Database Management
Answer» The correct CHOICE is (d) Network Best explanation: Network model has DATA stored in a HIERARCHICAL network FLOW.

Discussion

70.	For a transaction to be durable, its changes need to be written to ________ storage.(a) Volatile storage(b) Non-volatile storage(c) Stable storage(d) Dynamic storageThe question was asked during an online interview.This question is from Storage Structure in chapter Transactions of Database Management
Answer» Right option is (c) Stable storage Easy EXPLANATION - Similarly, for a transaction to be ATOMIC, log records need to be WRITTEN to stable storage before any changes are MADE to the database on disk.

Discussion

71.	Transaction processing is associated with everything below except(a) Producing detail summary or exception reports(b) Recording a business activity(c) Confirming an action or triggering a response(d) Maintaining a dataThe question was asked in an interview for internship.My enquiry is from Transaction Concept in division Transactions of Database Management
Answer» The correct OPTION is (c) Confirming an action or triggering a response Explanation: Collections of operations that form a single logical UNIT of work are called TRANSACTIONS.

Discussion

Explore topic-wise InterviewSolutions in .

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints(a) 6789(b) 2345(c) 1234(d) 456789This question was posed to me in an interview.My doubt stems from A Simple Transaction Model in division Transactions of Database Management

Which of the following fixed database roles can add or remove user IDs?(a) db_accessadmin(b) db_securityadmin(c) db_setupadmin(d) db_sysadminI got this question during an interview.My query is from Transactions as SQL Statements topic in section Transactions of Database Management

Copying files to secondary or specific devices is known as ______(a) Retrieve(b) Backup(c) Recovery(d) DeadlockThe question was posed to me in class test.I'd like to ask this question from Querying database part 5 in division Transactions of Database Management

Which s essential a business problem not a data problem:(a) Data(b) Database(c) Database design(d) All of the mentionedI have been asked this question in an international level competition.I'd like to ask this question from Querying Database topic in division Transactions of Database Management

Each modification done in database transaction are first recorded into the(a) Harddrive(b) Log(c) Disk(d) DatamartI got this question in an interview.This is a very interesting question from Transaction Atomicity and Durability topic in division Transactions of Database Management

By default sql server has ___________ isolation level(a) READ COMMITTED(b) READ UNCOMMITTED(c) SERIALIZABLE(d) REPEATABLE READThis question was posed to me at a job interview.I'd like to ask this question from Transactions as SQL Statements in portion Transactions of Database Management

The property of a transaction that persists all the crashes is(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedI have been asked this question at a job interview.This intriguing question originated from Transaction Concept topic in chapter Transactions of Database Management

Which of the following has “all-or-none” property?(a) Atomicity(b) Durability(c) Isolation(d) All of the mentionedThe question was posed to me in an internship interview.This interesting question is from Transaction Concept topic in portion Transactions of Database Management

Isolation of the transactions is ensured by(a) Transaction management(b) Application programmer(c) Concurrency control(d) Recovery managementThe question was asked during an internship interview.My doubt is from Transactions as SQL Statements in chapter Transactions of Database Management

Which of the following is not a property of transactions?(a) Atomicity(b) Concurrency(c) Isolation(d) DurabilityThe question was posed to me in examination.The query is from Transactions as SQL Statements topic in portion Transactions of Database Management

Which is the process of breaking a relation into multiple relations:(a) Functional dependency(b) Database modeling(c) Normalization(d) DecompositionI had been asked this question in unit test.The question is from Querying Database topic in division Transactions of Database Management

____________ is a combination of two of more attributes used as a primary key(a) Composite Key(b) Alternate Key(c) Candidate Key(d) Foreign KeyI got this question in an online interview.I want to ask this question from Querying database part 3 in section Transactions of Database Management

Which of the following is the oldest database model?(a) Relational(b) Hierarchical(c) Physical(d) NetworkThis question was posed to me by my school principal while I was bunking the class.I'd like to ask this question from Storage Structure topic in portion Transactions of Database Management