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

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

6922

am completed mca2011 how get certification in oracle

1 2965

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 5674

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,

2021

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 6084

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

1 4462

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51145

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 11777

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 5516

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

1 12773

what are the critical issues you have resloved in your company

Wipro,

1962

how can you move the master database

IBM,

1 4707

What are the critical issues you have resolved in your company

Wipro,

2236

How can you move the master database

IBM,

2044

What is RMS Migrations

Steria,

2395

Un-Answered Questions { Databases }

what are the different levels of database schema?

1124

Can two tables have the same primary key?

1208

Is access being discontinued?

787

What are cursors and when they are useful?

1089

What are the characteristics of database?

894

What is query log in mysql?

981

Explain about SQL server 2005?

974

Is oracle faster than sql server?

953

Explain drop constraint oracle?

1067

How do you truncate?

906

How a table can be created using microsoft access object library (maol)?

1595

What is sqlca in db2?

960

Is mysql port 3306 tcp or udp?

917

How to check the server version in oracle?

1092

What are the disadvantages of primary key and foreign key in SQL?

1116

For More Un-Answered { Databases } Questions Click Here