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

What is a trigger?

4 8462

What is a view?

6 9600

What is an Index?

Yardi Software,

3 9856

What are the types of indexes available with SQL Server?

Standard Bank,

2 8159

What is the basic difference between clustered and a non-clustered index?

Infogain,

9 38511

What are cursors?

8 11533

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 19085

Which TCP/IP port does SQL Server run on?

2 10073

From where can you change the default port?

3 7118

Can you tell me the difference between DELETE & TRUNCATE commands?

15 25646

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 10393

What is the use of DBCC commands?

NA,

4 9484

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

2587

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 4830

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 29992

Un-Answered Questions { Databases }

How many subqueries can be nested in a statement?

1042

What is substitution variable?

1100

Explain each trigger related to mouse.

Which process writes data from data files to database buffer cache?

644

What do you mean by entity type?

1129

What is materialized view in sql?

961

What do you understand by intent locks?

1063

Explain differences between web edition and business edition?

119

Explain table?

1178

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2502

How to copy the tables, schema and views from one sql server to another?

1112

Which is better Oracle or MS SQL? Why?

5045

How do I connect to a mysql database?

977

How to encrypt data between dialogs?

1176

What is the relation between database and instance?

703

For More Un-Answered { Databases } Questions Click Here