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

Differentiate between pre-select and pre-query?

1125

What is save point in oracle database?

1328

What is hot backup and logical backup?

1073

What is the fastest query method to fetch data from the table?

1382

can you convert or reverse engineer a fmx back to a fmb file?

1187

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1042

Is it possible to execute a dynamic sql from forms?

1085

what are the oracle forms services components include?

1047

Explain how can you use the same lov for 2 columns?

1158

List out the oracle forms configuration files?

1088

what is oracle forms?

1119

Explain how one can iterate through items and records in a specified block?

1165

what is the difference between call_form, new_form and open_form?

1331

what are the new features introduced in oracle form services in 11g release 2?

1049

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1324

Un-Answered Questions { Databases }

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1139

What are the different types of cursor?

1117

How do I find query history in sql server?

960

How to create a new schema in a database?

1171

What is the maximum length of an alert name?

1020

Should you normalize audio?

958

What is shared lock?

916

Explain four layers of abstraction microsoft architectured?

147

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2428

Explain ranking functions?

1074

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2089

how would you enter characters as hex numbers? : Sql dba

1001

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1025

How many types of database languages are?

956

Can we deploy SSRS reports on our personal website?

171

For More Un-Answered { Databases } Questions Click Here