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

4 7537

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

3 8717

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 5671

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 5540

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

2 5803

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 6532

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

3 8766

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

1 5678

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

TCS,

12 26164

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 6722

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

2 8631

how to know Who Is Blocking Your SQL Server?

4 12813

How to Get the last identity value used

4 9099

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

1 5442

How to Run a Query on a Remote SQL Server?

2 8613

Un-Answered Questions { Databases }

Explain primary key and foreign key constraints?

1097

Is drop table faster than truncate?

1052

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

1017

What does select count (*) mean in sql?

1076

How to find the service pack installed? : sql server database administration

1065

How do I set a primary key in access 2007?

827

What do you understand by integration services in sql server?

1003

What happens if you delete a table that is used by a view?

1064

How to select 10 records from a table?

1208

What is maximum table size in mysql?

992

What are all the different normalizations?

1078

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

1003

What is difference between mysqli and pdo?

1006

Why c++ used in clipper?

959

Mention what does plv msg allows you to do?

1164

For More Un-Answered { Databases } Questions Click Here