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 do I list the available tables in a database I'm querying?

4 7372

How to count the number of duplicate items in a table?

3 8621

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 5568

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

GE,

1 5456

Is it possible to create tables in stored procedures using a variable for the table name?

2 5706

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 6458

How do I compare two values when one value(data type) is char and the other is an integer?

3 8651

What are the pros and cons of creating extended stored procedures?

1 5598

Is it possible to delete duplicate rows in a table without using a temporary table ?

TCS,

12 25771

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 6629

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 8550

how to know Who Is Blocking Your SQL Server?

4 12658

How to Get the last identity value used

4 8968

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 5364

How to Run a Query on a Remote SQL Server?

2 8498

Un-Answered Questions { Databases }

What does pl sql stand for?

1122

What is a flashback query and when should it be used?

Is mongodb scalable?

How many parts of a pl sql block are optional?

1139

What is the difference between oracle and postgresql?

956

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

What do you mean by field in sql?

1087

Does postgresql run on the cloud?

1154

Explain the terms database and dbms. Also, mention the different types of dbms.

912

What is the difference between count () and rowcount ()?

1034

How to set up sql*plus output format in oracle?

1042

What are the filtered indexes?

1041

Why fastload support to empty table?

1699

What is offset in sql query?

1126

Give an example of SQL injection attack ?

1013

For More Un-Answered { Databases } Questions Click Here