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 7423

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

1 2554

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

TCS,

1 4895

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 8435

What is check constraint?

3 7606

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 6423

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

2302

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 15805

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 11680

what is normalisation?what are its uses?

1 2358

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

4 7915

Difference between file system and relational database.

1 6091

what do you mean by longblob Data type in MySql?

3 13044

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

Accenture,

12 21409

How many memory layers are in the shared pool?

1 5116

Un-Answered Questions { Databases }

What is the latest version of postgresql?

946

Have you created fact table and dimension tables?

696

Are you familiar with user exits in reports?

What are the different types of subquery?

1226

How to convert numeric expression data types using the cast() function?

1142

Explain system functions or built-in functions? What are different types of system functions?

1055

What are the two main functions of queries in databases?

1518

what are all the common sql function? : Sql dba

1121

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8221

What is standby servers? Explain types of standby servers.

1067

How to connect php with different port numbers?

1171

What are the types of database explain each of them briefly?

1044

What is a coalesce function?

1275

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

How do I find query history in sql server?

1018

For More Un-Answered { Databases } Questions Click Here