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 6096

Explain how RDBMS software deals with deadlocks.

1 4588

what is different between view and sequence?

4 6443

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 4182

waht is meant data independence?

2 7513

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

2 5133

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

Oracle,

1 5110

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

Oracle,

1 5575

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 4393

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

2998

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 3005

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

6 20862

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 17909

How do you read transaction logs

1 4803

How do you persist objects, permissions in tempdb

1 6692

Un-Answered Questions { Databases }

How to generate create view script on an existing view?

992

where can you add custom error messages to sql server? : Sql server administration

1127

Why merge statement is used inside the database?

1110

How is data stored in postgresql?

848

How many databases should a dba manage?

659

How do we get field details of a table?

982

Is mongodb free to use?

Which is better access or excel?

865

What is the role of building blocks like nodes, relationships, properties and labels in neo4j?

What is an example of a delimiter?

933

What are queries in dbms?

937

What is metadata in mongodb?

How can you find dead processes?

545

how would you improve etl (extract, transform, load) throughput?

1033

What is the purpose of ms access?

823

For More Un-Answered { Databases } Questions Click Here