Showing posts with label Database Interview Question With Answer. Show all posts
Showing posts with label Database Interview Question With Answer. Show all posts

How many places to the right of the decimal can be stored in a CURRENCY data field?

›
The CURRENCY data type can store up to four places to the right of the decimal.

What is the highest value that can be stored in a BYTE data field?

›
The highest value that can be stored in a BYTE field is 255. or from -128 to 127. Byte is a set of Bits that represent a single character. ...

Write SQL query

›
Question : In the domain table we have status as a numeric value from 01 to 04 and we  have text definition of these values in the design d...

What is transaction? In terms of Database

›
A. A transaction is a collection of applications code and database manipulation code bound into an indivisible unit of execution. it consist...

What are the main components of Database management systems?

›
The database management system software includes components for storage management, concurrency control, transaction processing, database m...

What is query optimization?

›
Query optimization is the part of the query process in which the database system compares different query strategies and chooses the one wit...
4 comments:

What Oracle lock modes do you know?

›
Oracle has two lock modes: shared or exclusive. Shared locks are set on database resources so that many transactions can access the resource...

What is Oracle locking?

›
Oracle uses locking mechanisms to protect data from being destroyed by concurrent transactions.

Which of the following statements are Data Manipulation Language commands?

›
A. INSERT B. UPDATE C. GRANT D. TRUNCATE E. CREATE

How you will create a column alias? (Oracle 8i)

›
The AS keyword is optional when specifying a column alias. You must enclose the column alias in double quotes when the alias contains a spac...

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

›
You use the MINUS operator to return all rows from one query except where duplicate rows are found in a second query. The UNION operator ret...

How Oracle executes a statement with nested subqueries?

›
When Oracle executes a statement with nested subqueries,it always executes the innermost query first. This query passes its results to the n...