Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Databases Interview Questions
Questions Answers Views Company eMail

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

Oracle,

2012

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 5679

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

Techno Labs,

2 4184

how to copy only distinct data into another table which is not already exist in database?

Spectra,

2 4447

difference between function and procedure

Cognizant, HCL, TCS, Theorem,

3 5515

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

IBM,

1592

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

IBM,

1796

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

HSBC,

2 8132

How to fetch records from a partitioned table?

HSBC,

2 8194

How many triggers can be implemented for a table?

HSBC,

3 7209

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

CG,

2 4632

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

HSBC,

2 7691

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

HSBC,

5 13912

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

Synechron, TCS,

2 5068

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

Oracle,

1 3218


Un-Answered Questions { Databases }

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059


Explain the collation?

1149


What is restrict in sql?

1181


How do I kill a query in postgresql?

1193


How to verify a user name with sqlcmd tool?

1122


What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1941


What is gpt format?

993


How to add an address record into adventureworkslt?

1030


What privilege is needed for a user to insert rows to tables in another schema?

1064


How can you use check constraints for self referential integrity?

1020


How would you differentiate between cluster and grid?

1


What is limit in dbms?

1115


What is the example of procedure?

979


What is join view in sql?

990


Explain what are synonyms used for?

1098