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 to retrieve daily sal from emp table in oracle 10g

Infosys,

2 6956

What is SQL Profiler and the use of it?

247Customer,

2 5046

What are SQL Jobs, please mention the use of it and how to create them.

247Customer,

1 4710

What are steps required to ENTER DATA INTO DWH?

2 7844

define primary key & secondary key?

2 17437

Write a query to find second highest salary of an employee.

27 28128

which language is used to develop the oracle........?

Infosys,

4 13337

What are the different types of joins and explain them briefly.

3 11815

what is the output of this query selet * from employee where 1=2 ??

11 18589

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 8895

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 13973

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7409

What is the order in which the SQL query is executed? list them in order.

CarrizalSoft Technologies, CTS, Oracle,

5 11845

Can Having clause be used without Group by clause?

CarrizalSoft Technologies, CSC, CTS,

6 43363

difference between truncate and delete ,drop?

3 7349

Un-Answered Questions { Databases }

Write a query to count the number of rows of a table in mysql.

937

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1049

What is a data directory?

952

What is the difference between indexing and hashing?

1179

How do I remove a user from mysql?

994

What are the types of subqueries?

1060

How to define and use table alias names in oracle?

950

What is the main function of microsoft access?

900

What do you mean by erd and its main elements? Explain with example.

842

What is the size of mysql database?

946

How to login to the server without an instance?

1169

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

994

How to convert a string to a date in oracle database?

1058

What is delimiter in pl sql?

1064

How To see all the tables from a database of mysql server.

1080

For More Un-Answered { Databases } Questions Click Here