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

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 101050

how to u retrieve all tables along with all the data

Satyam,

1 6425

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2125

i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.

1845

hello to all i want code for like this site "Submit Question" page.please give answers thanks.

1761

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 3501

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 76842

what is ORACLE MEMORY STRUCTURES

3 9080

How to find the SGA Size

Baidu, Reliance,

7 24933

How to find the current session sid

Baidu,

3 10106

How can analyze query after generating explain plan ?

Thermotech,

2 8088

What is rule base and cost base optimizer?

Thermotech,

2 8443

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 9742

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 9513

What is difference b/w Credit memo and Adjustment in AR.

Oracle,

1 12452

Un-Answered Questions { Databases }

What is ISAM?

1134

What is a database in healthcare?

941

Do you know sql server 2008 introduces automatic auditing?

997

What is use of mysql?

941

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1183

How to get current date in postgresql?

996

Are resultset updatable?

973

what are rollup and cube in t-sql? : Transact sql

1119

What happen when an index does not fit into ram?

is it possible to pass an object or table to a procedure as an argument?

1147

Can we perform backup restore operation on tempdb? : sql server database administration

1014

What is delimiter in pl sql?

1070

Explain the different types of backups available in sql server? : sql server database administration

939

How do you create a database in microsoft access?

900

List some features of neo4j databases?

For More Un-Answered { Databases } Questions Click Here