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

3 6122

Explain how RDBMS software deals with deadlocks.

1 4598

what is different between view and sequence?

4 6453

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 4202

waht is meant data independence?

2 7522

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

2 5147

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

Oracle,

1 5122

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

Oracle,

1 5587

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 4405

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

3008

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

1 3023

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

6 20894

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 17938

How do you read transaction logs

1 4808

How do you persist objects, permissions in tempdb

1 6701

Un-Answered Questions { Databases }

How do I know if localdb is running?

964

What is difference between sql and mysql?

1144

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1874

What is ole activation style property?

What are the differences between char and varchar data types?

1121

What are different functions in sql?

957

What is mongodb and why we use?

If no size is defined while creating the database, what size will the database have?

1006

What is the port number for postgresql?

905

Do you know what are various aggregate functions that are available?

1146

Describe the difference between embedded and dynamic sql.

1096

Enlist some predefined exceptions?

1071

Explain table partitioning in sybase.

935

What is an ndf file?

1004

Distinguish between nested subquery and correlated subquery?

1057

For More Un-Answered { Databases } Questions Click Here