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 6583

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 6642

what is call by value & call by reference ?

Cap Gemini,

2 13315

What is trigger ?

Cap Gemini, SQL,

7 12086

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 73273

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 8694

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

1 7275

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

1971

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 15499

what is procedure in sql?

Millennium, SQL,

2 7147

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

4 7035

Un-Answered Questions { Databases }

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1026

How to transfer an existing table from one schema to another schema in ms sql server?

981

Which is better Oracle or MS SQL? Why?

6386

What is the depth of triggers?

977

How to convert character strings into numeric values?

1096

how to remove the duplicate in odi?

627

Explain how to convert a report into excel sheet.

Are you doing the updates from within a cursor?

1119

What are procedures in mysql?

951

Which is the best mongodb gui?

What are basic techniques of indexing?

1384

How much does it cost to build a database?

1028

What is rdbms architecture?

913

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1061

What is count * in sql?

997

For More Un-Answered { Databases } Questions Click Here