managing-multiuser-databases database question and answers -Page 3

CuriousTab

CuriousTab

C Programming C# Programming C++ Programming Database Java Programming Networking

Biochemical Engineering Biochemistry Biotechnology Chemical Engineering Civil Engineering Computer Science Digital Electronics Electrical Engineering Electronics Electronics and Communication Engineering Mechanical Engineering Microbiology Technical Drawing

Current Affairs General Knowledge

Data Interpretation Logical Reasoning Non Verbal Reasoning Verbal Ability Verbal Reasoning

AIEEE Bank Exams CAT GATE IIT JEE TOEFL

Analyst Bank PO Database Administrator IT Trainer Network Engineer Project Manager Software Architect

Managing Multiuser Databases problems

1. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
Options
A. True
B. False

Correct Answer: True

2. A point of synchronization between the database and the transaction log is generally referred to as a stop point.
Options
A. True
B. False

Correct Answer: False

3. A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Options
A. True
B. False

Correct Answer: False

4. A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.
Options
A. True
B. False

Correct Answer: True

5. The overall responsibility of the DBA is to facilitate the development and use of the database.
Options
A. True
B. False

Correct Answer: True

6. When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Options
A. True
B. False

Correct Answer: True

7. The size of the lock is referred to as the lock granularity.
Options
A. True
B. False

Correct Answer: True

8. An ACID transaction is one that is atomic, consistent isolated, and durable.
Options
A. True
B. False

Correct Answer: True

9. A durable transaction is one in which all committed changes are permanent.
Options
A. True
B. False

Correct Answer: True

10. An exclusive lock locks the item from change but not from read.
Options
A. True
B. False

Correct Answer: False

First 2 3

More in Database:

Advanced SQL Data and Database Administration Data Modeling with ER Model Data Models into Database Designs Data Warehousing Database Design Using Normalization Database Processing for BIS Database Redesign Distributed Databases ER Model and Business Rules Introduction to Database Introduction to SQL JDBC, Java Server Pages, and MySQL Logical Database Design Managing Databases with Oracle Managing Multiuser Databases Modeling Data in the Organization Object-Oriented Data Modeling Object-Oriented Database ODBC, OLE DB, ADO, and ASP Physical Database Design SQL for Database Construction SQL Server 2000 The Client-Server Database The Database Development Process The Database Environment The Internet Database Environment The Relational Model and Normalization XML and ADO.NET

Aptitude

Time and Distance
Volume and Surface Area
Problem on Trains
Permutation and Combination

Engineering

Civil Engineering
Computer Science
Mechanical Engineering
Technical Drawing

Programming

C Programming
C# Programming
C++ Programming
Java Programming

Reasoning

Logical Reasoning
Non Verbal Reasoning
Verbal Ability
Verbal Reasoning

Links

About Us
Contact Us
Privacy Policy
Sitemap

Social

Copyright �CuriousTab. All rights reserved.