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

I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error :
REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent

6982

am completed mca2011 how get certification in oracle

1 3067

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

Polaris,

3 5821

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

BDI Systems, Google,

2080

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

NIIT,

3 6213

Suppose I want to fire block level sequence before form level, then is it possible?

1 4551

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51447

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

Tech Mahindra,

1 11859

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

Polaris,

2 5612

Can we use bulk collect in oracle forms if yes then how?

1 12845

what are the critical issues you have resloved in your company

Wipro,

2018

how can you move the master database

IBM,

1 4798

What are the critical issues you have resolved in your company

Wipro,

2318

How can you move the master database

IBM,

2099

What is RMS Migrations

Steria,

2446

Un-Answered Questions { Databases }

what is the role of dip user in our database?

2464

What is tableplus?

962

Explain about recursive stored procedures?

854

How do I find the port number for sql server?

1021

How to check your oracle database 10g xe installation?

1053

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

how many type of indexing in database?

1023

What is the function of DML Compiler?

1279

How can we access neo4j interface?

What are different types of database indexes?

1175

Explain the purpose of %type and %rowtype data types?

977

In which files does sql server actually store data?

955

Explain about system database?

1110

What is difference between rank () row_number () and dense_rank () in sql?

1165

What can I use microsoft access for?

869

For More Un-Answered { Databases } Questions Click Here