Technology Questions

Q:

What is locking ? what are the advantages of locking?

Answer

Locking is a mechanism to ensure data integrity while allowing maximum concurrent access to data. It is used to implement concurrency control when multiple users access table to manipulate its data at the same time.


Advantages :


- Avoids deadlock conditions


- Avoids clashes in capturing the resources

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2975
Q:

Embedded SQL is which of the following?

A) The process of making an application capable of generating specific SQL code on the fly. B) Hard-coded SQL statements in a trigger.
C) Hard-coded SQL statements in a program language such as Java. D) Hard-coded SQL statements in a procedure.
 
Answer & Explanation Answer: C) Hard-coded SQL statements in a program language such as Java.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 2973
Q:

What is the BEST WAY to write test cases?

Answer

1) List down usecases (taken from business cases) from function specs. For each use case write a test case and categorize them into sanity tests, functionality, GUI, performance etc. Then for each test case, write its workflow. 


2) For a GUI application - make a list of all GUI controls. For each control start writing test cases for testing of the control UI, functionality (impact on the whole application), negative testing (for incorrect inputs), performance etc. 


 

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2970
Q:

What is difference between ARP and RARP?

Answer

The address resolution protocol(ARP) is used to associate the 32 bit IP address with the 48 bit physical address, used by a host or a router to find the physical address of another host on its network by sending a ARP query packet that includes the IP address of the receiver.


The reverse address resolution protocol (RARP) allows a host to discover its Internet address when it knows only its physical address.

Report Error

View answer Workspace Report Error Discuss

0 2969
Q:

Name and explain the type of locks?

Answer

There are three types of lock, namely:


Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.


Update – This lock is more lenient. It permits the program to read and change the locked space.


Exclusive – This lock restricts all users from accessing the locked space.

Report Error

View answer Workspace Report Error Discuss

0 2964
Q:

What is WHEN-Database-record trigger?

Answer

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Report Error

View answer Workspace Report Error Discuss

2 2964
Q:

Why do we need wrapper classes in Java?

Answer

Dealing with primitives as objects is easier at times. Most of the objects collection store objects and not primitive types. Many utility methods are provided by wrapper classes. To get these advantages we need to use wrapper classes. As they are objects, they can be stored in any of the collection and pass this collection as parameters to the methods.


 


Features of the Java wrapper Classes:


- Wrapper classes convert numeric strings into numeric values.


- The way to store primitive data in an object.


- The valueOf() method is available in all wrapper classes except Character


- All wrapper classes have typeValue() method. This method returns the value of the object as its primitive type.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2961
Q:

Exlpain STL.

Answer

STL stands for Standard Template Library. It is a library of container templates approved by the ANSI committee for inclusion in the standard C++ specification.

Report Error

View answer Workspace Report Error Discuss

Subject: C++

0 2960