Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What are the two panes that Appear in the design time pl/sql ?

1 3668

What are three panes that appear in the run time pl/sql interpreter?

1 3813

How can a cross product be created?

1 4366

What is an user exit used for?

1 3848

What are the three types of user exits available ?

1 4845

How can I message to passed to the user from reports?

1 3800

What is the basic structure of PL/SQL ?

6 12045

What are the components of a PL/SQL block ?

3 12694

What are the datatypes a available in PL/SQL ?

2 7193

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 12824

What is difference between % ROWTYPE and TYPE RECORD ?

2 22611

What is PL/SQL table ?

6 11368

What is a cursor ? Why Cursor is required ?

3 13598

Explain the two type of Cursors ?

Hi Caliber IT,

8 19542

What are the PL/SQL Statements used in cursor processing ?

4 10327

Un-Answered Questions { Databases }

What is foreign key in access?

862

What is difference between two tier and three tier?

869

What is break?

1203

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2038

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1896

What is the difference between raid 5 and raid 10? Which is better for oracle?

598

What is the use of floor function in sql server?

1095

Define Joins?

1037

How to create an identity column?

1232

What language does mysql use?

915

Why does sql studio use a single registered database repository? : sql server management studio

1013

Do you know concepts and capabilities of sql server?

1072

What is the reports view in oracle sql developer?

1000

How much ram do I need for mongodb?

What is the stored procedure?

1019

For More Un-Answered { Databases } Questions Click Here