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

How does rows store in Teradata

1 7302

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

2495

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

TCS,

1 4802

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 8241

What is check constraint?

3 7404

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 6297

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

2241

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 15271

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 11350

what is normalisation?what are its uses?

2273

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

4 7652

Difference between file system and relational database.

1 5981

what do you mean by longblob Data type in MySql?

3 12861

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

Accenture,

12 20740

How many memory layers are in the shared pool?

1 5018

Un-Answered Questions { Databases }

What data structure does mysql use?

1013

How do you declare a variable in pl sql?

1027

What ascii 31?

952

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

What are mysql data types?

1000

explain GROUPBY & HAVING clause with examples.

2291

What do you mean by SQL injection attack?

1066

What is the purpose of a staging area?

What is a fan-out query in SQL Azure?

121

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

908

Explian File steps in ODI?

625

What is BCP? When does it used in sql server 2012?

1061

What is the difference between a database and instance? What is the relation between them?

588

Tell about MOM Tool(Microsoft Operator Manager)?

1914

What is user-defined inline table-valued function?

950

For More Un-Answered { Databases } Questions Click Here