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

How does rows store in Teradata

1 7399

What is the DIF format and when we will use in teradata

2543

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

TCS,

1 4885

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

Intel, Wipro,

3 8397

What is check constraint?

3 7565

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 6402

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2295

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

Satyam,

11 15706

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

Satyam,

8 11634

what is normalisation?what are its uses?

2340

what is the cursor and use of cursor in pl/sql ?

4 7880

Difference between file system and relational database.

1 6075

what do you mean by longblob Data type in MySql?

3 13020

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

Accenture,

12 21312

How many memory layers are in the shared pool?

1 5105

Un-Answered Questions { Databases }

What are key constraints?

1024

What is a function in postgresql?

975

What are the differences between date and timestamp in oracle?

1105

What does dml mean?

1051

What is Cross Join and in which scenario do we use Cross Join?

1069

how to remove the duplicate in odi?

672

What is page in sql server?

999

What does sql stand for?

1059

How to use existing values in update statements using oracle?

1121

What is view? Can we update view

1531

How to change the order of columns in Oracle SQL Plus ?

1116

what are dynamic queries in t-sql? : Transact sql

1072

When should I execute an sp_recompile in sybase?

953

Explain how to close periods in ar. : oracle accounts receivable

1390

How do I restart sql?

1028

For More Un-Answered { Databases } Questions Click Here