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,

1445

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

4 3993

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 3084

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

Spectra,

2 3422

difference between function and procedure

Cognizant, HCL, TCS, Theorem,

3 4165

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,

1175

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,

1284

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 6701

How to fetch records from a partitioned table?

HSBC,

2 6401

How many triggers can be implemented for a table?

HSBC,

3 5757

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 3442

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 6468

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

HSBC,

5 11350

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 3954

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 2328


Un-Answered Questions { Databases }

How to connect Azure federated root database and apply federation in entity framework?

87


Data structure used to implements a menu:

605


What is dml with example?

490


how to determine the service pack currently installed on sql server? : Sql server database administration

536


What is a benefit of using an after insert trigger over using a before insert trigger?

483






what are the acid properties in dbms?

501


How many types of keys are there in sql?

531


What is isnull() operator?

542


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1838


How to create additional tablespaces for an new database?

550


how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1787


How can a single instance environment be converted into rac environment and how will they be different?

1


Why do we need different type of parameter?

531


what are triggers? : Sql server database administration

481


List out some features of neo4j database?

1