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

How to find no of saturdays in a month using single sql ?

2 5815

How to create index-by table in oracle?

3 6740

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 6805

what is call by value & call by reference ?

Cap Gemini,

2 13444

What is trigger ?

Cap Gemini, SQL,

7 12364

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 75042

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 5956

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

FIC,

3 8887

What will happen if we create more indexes on a sysbase iq table?

1 7387

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1 2026

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

TCS,

1 2167

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

Verizon,

4 8350

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 16024

what is procedure in sql?

Millennium, SQL,

2 7325

How create table structure only from tableA to TableB if TableA have some data?

4 7231

Un-Answered Questions { Databases }

Can one drop a column from a table?

1081

What is self contained sub query?

1135

How to remove duplicate rows from table except one?

1077

What are the different subsets of sql?

1642

How raid can influence database performance?

1104

How can we solve concurrency problems?

1116

Can sql servers link to other servers like oracle?

907

please send me oracle pl/sql exp resume. and also faqs...

2564

How to rebuild the master database?

1154

How efficient you are in oracle and SQL server?

1249

what are the advantages of sql ? : Sql dba

1136

Is microsoft getting rid of access?

881

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1851

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2304

what is sql server agent? : Sql dba

1173

For More Un-Answered { Databases } Questions Click Here