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

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

2 5701

How to create index-by table in oracle?

3 6578

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 6641

what is call by value & call by reference ?

Cap Gemini,

2 13313

What is trigger ?

Cap Gemini, SQL,

7 12082

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 73240

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

1 5832

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

FIC,

3 8693

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

1 7274

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

1970

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,

2093

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

Verizon,

4 8145

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 15494

what is procedure in sql?

Millennium, SQL,

2 7146

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

4 7033

Un-Answered Questions { Databases }

Working with TLogs

1832

What is an artificial (derived) primary key?

613

What is an agent and What are the types of agents?

632

How can you set the threshold at which sql server will generate keysets asynchronously?

986

Explain the main features of couchdb?

What is database transaction?

872

What is Extended user-defined?

959

Why are cursors used?

1122

When to use null data driven subscription?

206

What are the packages in pl sql?

1009

Explain the difference between numeric and decimal data types in sybase.

884

How to create a dml trigger using create trigger statements?

1033

What is data type in sql?

959

What is index fragmentation in ms sql server?

1082

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

603

For More Un-Answered { Databases } Questions Click Here