1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

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

 2 4929

How to create index-by table in oracle?

 3 5526

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 5627

what is call by value & call by reference ?

Cap Gemini,

2 12470

What is trigger ?

Cap Gemini, SQL,

7 9840

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 64641

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

 1 5213

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

FIC,

3 7818

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

 1 6633

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

 1666

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,

1691

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

Verizon,

4 6959

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 13067

what is procedure in sql?

Millennium, SQL,

2 6191

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

 4 5993

Un-Answered Questions { Databases }

Explain the benefits of user-defined functions?

622

How much does mongodb cost?

1

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

373

Is progress software supports to ( pl/sql )?

635

Name the operator which is used in the query for pattern matching?

590




Explain the designer?

400

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2011

What language does mysql use?

518

What is database bloat?

562

What is pg_hba conf?

526

How do you optimize a query?

632

What is the index requirement in SQL Azure?

80

Explain boyce and codd normal form(bcnf)?

621

How do I find the size of a mysql database?

570

Define master database?

655

For More Un-Answered { Databases } Questions Click Here