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 to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 6264

Explain how RDBMS software deals with deadlocks.

1 4701

what is different between view and sequence?

4 6691

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 4276

waht is meant data independence?

2 7649

when inserting to a table how many rows will be effected using triggers

2 5249

write coding for importing sql data into a word excel...

Oracle,

1 5259

how will u create "n" possible tables in sql...

Oracle,

1 5659

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 4511

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

1 3065

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2 3144

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 21250

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

ABC, HCL,

6 18186

How do you read transaction logs

1 4916

How do you persist objects, permissions in tempdb

1 6775

Un-Answered Questions { Databases }

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2702

What is standby servers? Explain types of standby servers.

1075

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

Is there some bulk load or other way to import a lot of data fast?

931

List the ways in which dynamic sql can be executed?

1083

Does group by remove duplicates?

1112

How to provide default values to function parameters?

1249

Why and when do stored procedure recompile?

1052

what is spatial nonclustered index

1054

Have you used lexical parameters in reports?

What is a coalesce function?

1275

What is acid mean in sql server?

1237

what is bcp? When does it used? : Sql dba

1053

What is a view in sql?

1035

Do we need to rebuild index after truncate?

1128

For More Un-Answered { Databases } Questions Click Here