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 100930

how to u retrieve all tables along with all the data

Satyam,

1 6404

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

2117

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.

1833

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

1741

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 3483

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 76656

what is ORACLE MEMORY STRUCTURES

3 9063

How to find the SGA Size

Baidu, Reliance,

7 24883

How to find the current session sid

Baidu,

3 10080

How can analyze query after generating explain plan ?

Thermotech,

2 8060

What is rule base and cost base optimizer?

Thermotech,

2 8426

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

6 9709

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

8 9476

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

Oracle,

1 12431

Un-Answered Questions { Databases }

What is the execution plan in sql?

1033

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2069

Is Mysql query is case sensitive?

1028

What is a transact-sql statement?

1068

how can you perform lookup range in lookup stage expalin in detail?

1938

How do I connect to a sybase database?

983

What are the differences between blob and clob in oracle?

1090

What is server-level principal?

122

Is mongodb support null values?

How do you write a subquery?

1034

What are databases what are the uses of databases?

922

Explain commit, rollback and savepoint.

1006

What's the difference between 'union' and 'union all' ?

1004

Briefly describe the three types of sql commands.

1005

Is the server accepting tcp ip connections on port 5432?

892

For More Un-Answered { Databases } Questions Click Here