State the properties of Transaction

State the properties of Transaction
by

1 Answer

Answer :

The ACID properties of transaction.

1. Atomicity.

2. Consistency.

3. Isolation.

 4. Durability
by

Related questions

State the use of sequence.

Description : State the use of sequence.

Last Answer : A sequence refers to a database object that is capable of generating unique and sequential integer values. Syntax: Create sequence [increment by num][start with num] [maxvaluenum] [ ... can be used for multiple tables. * Sequence numbers are stored and generated independently of tables

State the use of ‘Like’ Operator.

Description : State the use of ‘Like’ Operator.

Last Answer : The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two operator often used in conjunction with the LIKE operator:  %:The percent sign represents zero, one, or multiple characters  _: The underscore represents a single character.

Describe the use of primary key and unique key constraints with example?

Description : Describe the use of primary key and unique key constraints with example?

Last Answer : There are two Entity constraints: 1.Primary Key constraint 2. Unique Constraint 1. Primary Key constraint: It is use to avoid redundant/duplicate value entry within the row of specified column in ... TABLE PERSONS (P_ID NUM CONSTRAINT P_UK UNIQUE , FIRSTNAME VARCHAR(20), CITY VARCHAR(20) );

Enlist different types of database users.

Description : Enlist different types of database users.

Last Answer : Database users are the one who really use and take the benefits of database. There will be different types of users depending on their need and way of accessing the database. 1. Application Programmers 2. Sophisticated Users 3. Specialized Users 4. Native Users/ Naïve Users

List the types of Cursor.

Description : List the types of Cursor.

Last Answer : Cursor: A cursor is a temporary work area created in the system memory when a SQL statement is executed. Types of Cursor: 1.Implicit Cursor 2.Explicit Cursor

Write syntax to create view.

Description : Write syntax to create view.

Last Answer : Create view as select OR CREATE VIEW name ASSELECT column1, column2.....FROM table_nameWHERE [condition];

The properties necessary to guarantee a reliable transaction in databases and other applications is referred to as _____________ a) BASE b) ACID c) ATOM d) All of the mentioned

Description : The properties necessary to guarantee a reliable transaction in databases and other applications is referred to as _____________ a) BASE b) ACID c) ATOM d) All of the mentioned

Last Answer : ACID

The properties necessary to guarantee a reliable transaction in databases and other applications is referred to as _____________ a) BASE b) ACID c) ATOM d) All of the mentioned

Description : The properties necessary to guarantee a reliable transaction in databases and other applications is referred to as _____________ a) BASE b) ACID c) ATOM d) All of the mentioned

Last Answer : ACID

Point out the correct statement. a) WS-+ services carried over XML messages using the SOAP protocol access remote server applications b) REST stands for Representational State Transfer c) A transaction following the rules of SOAP is considered to be RESTful d) All of the mentioned

Description : Point out the correct statement. a) WS-+ services carried over XML messages using the SOAP protocol access remote server applications b) REST stands for Representational State Transfer c) A transaction following the rules of SOAP is considered to be RESTful d) All of the mentioned

Last Answer : REST stands for Representational State Transfer

State weather the following statement is true or false for EJB. 1. EJB exists in the middle-tier 2. EJB specifies an execution environment 3. EJB supports transaction processing A) 1-true, 2. true, 3. true B) 1- true, 2. false, 3. true C) 1- false, 2- false, 3- false D) 1-true, 2-true, 3-false

Description : State weather the following statement is true or false for EJB. 1. EJB exists in the middle-tier 2. EJB specifies an execution environment 3. EJB supports transaction processing A) 1-true, 2. true, 3. true B) 1- ... false, 3. true C) 1- false, 2- false, 3- false D) 1-true, 2-true, 3-false

Last Answer : A) 1-true, 2. true, 3. true