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

Oracle (3253)
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 is ora 24313?what is the procedure to exclude that error?

2614

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

Amdocs,

3 9373

how to find 5th row ?

10 17635

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 24232

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1926

What is the difference between a Table and a View?

3 6969

what is difference between sql plus and sql*plus? (not sql and sql plus).

3944

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 11645

where we have to use ON clause and where we have to use USING clause in JOINS

2 4318

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

Wipro,

1895

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

Wipro,

2176

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

Wipro,

2 6493

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

Wipro,

2 4920

3. Display all the client numbers in the ORDER table. Remove duplicates.

Wipro,

1 4460

4. Display the order number and client number from the ORDER table. Output the result in the format. Client ordered

Wipro,

1 4816

Un-Answered Questions { Databases }

How do you know if your mysql server is alive?

1134

How to shrink a database?

1029

What is the use of concat() in mysql?

1049

What do you understand by index hunting?

1206

How to update a root password.

1004

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2610

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1034

What are the different types of modules in oracle forms?

1055

Is sql a scripting language?

1088

What is the difference between cartesian product and cross join?

907

What is number function in sql?

1020

How you can minimize the deadlock situation?

1089

How can I compare two mysql databases?

1025

Define cross join in sql server joins?

1080

What is primary key in ms access 2007?

902

For More Un-Answered { Databases } Questions Click Here