Skip to main content

Healthcare Systems Article Category

Medical Factors Which make it The most effective  just by Sejal Kakadiya  Medicine and health agencies with now consentrate on top quality, charge together with great satisfaction health of their solutions. These are typically that support beams which a lot of these agencies redefine the direction they trade. The following really results in thrilled clients.  How come Serious Treatment Direction Can be a Trend Inside Medicine and health Sector  just by Steven Orange  A whole lot of North american healthcare systems' options are generally about that direction together with procedure with serious circumstances. Direction with serious health conditions which include diabetes, excessive circulation demand, cardiovascular disease, together with hypothyroidism can be a vital component of easiest treatment healthcare provider's succeed. Inside standard product, that general practitioner spots someone on an automobile accident with treatment, inspects that condition ...

Solved MCQ on Oracle Distributed Transaction set-3


1) A mechanism which ensures that simultaneous execution of more than one transaction does not lead to any database inconsistencies is called .................. mechanism.

A. transaction control

B. transaction management

C. concurrency parallelism

D. concurrency control


2) The transaction wants only to read the data item of mode is called as .......

A. Exclusive Mode

B. Shared Mode

C. Inclusive Mode

D. Unshared Mode


3) Any execution of a set of transactions is called as its .........

A. non-serial schedule

B. serial schedule

C. schedule

D. interleaved schedule


4) ............ is program or set of program that interacts with the database at some point in its execution.

A. A database system

B. A database application

C. Both

D. none


5) .......... component of a database is responsible for ensuring atomicity and durability.

A. recovery management

B. concurrency control

C. storage management

D. query evaluation engine


6) The activity of ensuring atomicity in the presence of Transaction aborts is called ..........

A. transaction control

B. transaction management

C. transaction recovery

D. concurrency control


7) A .............is a set of rules that state when a transaction may lock or unlock each of the data items in the database

A. concurrency control

B. transaction control

C. validation control

D. locking protocol


8) ..................  is a collection of programs performing all necessary action associated with a database.

A. Database associated

B. Database administrator

C. Database application

D. Database management system


9) Which protocol permits release of exclusive locks only at the end of transaction?

A. Graph based protocol

B. Strict two phase locking protocol

C. Two phase locking protocol

D. Rigorous Two phase locking protocol


10) The activity of providing Durability of the transaction is called .....

A. database control

B. transaction management

C. transaction recovery

D. database recovery


11) Which protocol allows a transaction to lock a new data item only if that transaction has not yet unlocked data item?

A. Graph based protocol.

B. Strict two phase locking protocol

C. Two phase locking protocol

D. Time stamp ordering scheme


12) .......... is a collection of application programs that interacts with the database along with DBMS.

A. A database system

B. A database application

C. Database administration

D. Data system


13) ........ ensures that once transaction completes successfully, the results of the operations become permanent.

A. serializability

B. synchronizability

C. atomicity

D. durability


14) A ....... contains information for undoing or redoing all the actions performed by the transactions.

A. save point

B. log

C. node

D. commit_point


15) A ............. is a unit of program execution that accesses and possibly updates various data items.

A. DBMS

B. monitor

C. transaction

D. transistor


16) Transaction is an action used to perform some manipulation on data stored in the ........

A. Memory

B. Record

C. Database

D. All of these


17) A transaction is terminated if it has ........

A. aborted

B. committed

C. running state

D. aborted or committed


18) The two possible communication errors are, Lost messages and .......

A. Network Partitions

B. Lost acknowledgement

C. Timeout

D. log error


19) The only way to undo the effects of a committed transaction is to execute a .......

A. committed transaction

B. compensating transaction

C. supplementary transaction

D. update query


20) In .........., one or more users/programs attempt to access the same data at the same time.

A. concurrency

B. transaction control

C. locking

D. two phase locking

Answers:

1) D. concurrency control
2) B. Shared Mode
3) C. schedule
4) B. A database application
5) A. recovery management
6) C. transaction recovery
7) D. locking protocol
8) D. Database management system
9) B. Strict two phase locking protocol
10) D. database recovery
11) C. Two phase locking protocol
12) A. A database system
13) D. durability
14) B. log
15) C. transaction
16) C. Database
17) C. running state
18) A. Network Partitions
19) B. compensating transaction
20) A. concurrency


Related Posts

For other more Multiple Choice Questions (MCQs): Click Here

Comments

Popular posts from this blog

Solved MCQ on Fundamental of C Language set-7

1) 'C' allows a three way transfer of control with the help of A. Unary Operator B. Relational Operator C. Ternary Operator D. Comparison Operator 2) Operators have hierarchy. It is used to know which operator .... A. is most important B. is used first C. is faster D. operators on large numbers 3) The statement that transfers control to the beginning of the loop is called .. A. break statement B. exit statement C. continue statement D. goto statement 4) C programming language was developed by .. A. Dennis Ritche B. Ken Thompson C. Bill Gates D. Peter Norton 5) The value that follows the keyword CASE may only be A. constants B. variable C. number D. semicolon 6) In a C language 'a' represents ... A. a digit B. an integer C. a character D. a word 7) The statement which is used to terminate the control from the loop is A. break B. continue C. goto D. exit 8) The continue command cannot be used with .... A. for B. switch C. do D. while 9) A self contained block of statement...

How to create a Simple calculator Using HTML and JavaScript

Here are the steps to create a simple calculator using HTML and JavaScript which can evaluate simple arithmetic on integer numbers. Two types of inputs text and button are used here on a table within a form element and OnClick event was used to insert button values on the screen or to evaluate the numbers. Steps to create a Simple calculator Using HTML and JavaScript 1. At first Insert a <form> element within <body> tag. 2. Create a table using <table> .....</table> tag. 3. Insert two types of Input text and button within table data of table row using <tr><td>....</td></tr> tag. 4. Assign OnClick event for all the buttons having numbers and arithmetic operators. 5. Give blank value for Clear(C) button. 6. Use eval() function to evaluate the numbers on OnClick event of equal to sign button. Full HTML code for a Simple HTML calculator <html> <head></head> <body> <h3>Simple Calculator</h3> <br/> <...

How to Show Pop Up Window Using JavaScript

You can show pop up window By using JavaScript window.open() method which loads specified URL into a new or existing window and returns the window object that represents that window. The window.open() method takes four optional arguments which are URL of the window, Window name, attributes of window, the boolean value to replace or not the current window. Syntax: window.open("windowname.html", "New Window", "width=width in pixel, height=height in pixel, status=yes or no, resizable=yes or no"); The first argument of window.open() method allows to display given URL in the new window. If the argument is omitted, the special blank-page URL:about:blank is used. The second argument of window.open() method is a string which specifies a window name. If the argument is omitted, the special name "_blank" is used which opens a new, unnamed window. The third optional argument of window.open() method is a comma-separated list of size and features attributes f...