Oracle transaction online test - oracle transaction practice test

Your proficiency in Oracle Transaction is judged by your performance in the online tests. Reading books after books on Oracle Transaction alone can not help you crack an interview or clear a certification test -you would need to practice with a real time test to do that. Practice with this online test on Oracle Transaction to ensure that you choose the correct answer from very closely related options and finish the test on time.

Online Practice Test > Oracle transaction test

Click here to start Oracle transaction quiz/test
Here are few sample Oracle Transaction  test/quiz questions

Errors discovered during SQL statement execution cause

statement-level rollback
Row-level rollback
Deadlock
both a and b

When a statement is suspended, it results in automatically suspending the transaction

True
False
 

Click here to start Oracle transaction quiz/test  

More Links
Oracle advanced replication

What is replication? Explain its purpose.
Oracle Server supports two different forms of replication: basic and advanced replication. Explain difference between these.
What is the difference between a snapshot and a materialized view?
Describe how to implement basic snapshot replication.
What object types can and cannot be replicated in oracle?
Describe how to monitor replication.............  



Write your comment - Share Knowledge and Experience

Discussion Board
Oracle Transaction Online Test - Oracle Transaction Practice Test

To commit a transaction means making the changes

temporary
Permanent
Rolled back
Parsed


Oracle Transaction Online Test 05-11-2012 08:14 AM

Oracle Transaction Online Test - Oracle Transaction Practice Test

Errors discovered during SQL statement execution cause

statement-level rollback
Row-level rollback
Deadlock
both a and b


Oracle Transaction Online Test 05-11-2012 08:14 AM

Oracle Transaction Online Test - Oracle Transaction Practice Test

When does a statement runs in a resumable mode?

When the client implicitly enables resumable semantics for the session using the ALTER SESSION statement
When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement
When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement
When the client explicitly enables resumable semantics for the session using the CREATE SESSION statement


Oracle Transaction Online Test 05-11-2012 08:14 AM

Oracle Transaction Online Test - Oracle Transaction Practice Test

When a statement is suspended, it results in automatically suspending the transaction

True
False

What is an executable SQL statement?

A statement that can be executed without errors
Statement that generates calls to an instance, including DDL statements only.
Statement that generates calls to an instance including statements only.
Statement that generates calls to an instance, including DML and DDL statements.


Oracle Transaction Online Test 05-11-2012 08:14 AM

More online test

PMP Sample Test
Software Engineering Test
PHP Online Test
DHTML Online Test
CSS Quiz
MySQL Online Test


Career 12-20-2011 04:50 AM

 


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring