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


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,

1453

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

 4 4031

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 3109

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

Spectra,

2 3445

difference between function and procedure

Cognizant, HCL, TCS, Theorem,

3 4198

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,

1181

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,

1297

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 6734

How to fetch records from a partitioned table?

HSBC,

2 6435

How many triggers can be implemented for a table?

HSBC,

3 5793

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 3465

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 6498

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

HSBC,

5 11421

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 3986

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 2347

Un-Answered Questions { Databases }

What are the commands you'd issue to show the explain plan for "select * from dual"?

1719

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

641

What does the update command do?

603

What is gis data?

408

What do you mean by merge in oracle and how can we merge two tables?

565




21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609

you need to add parameters to a query in ms access database. How would you do that?

473

how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?

81

How to tell firebird to only accept conections from xyz host or network?

516

Can we use loop in sql?

521

Explain the terms database and dbms. Also, mention the different types of dbms.

486

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

581

What are the properties of the relational tables?

483

How do you modify a trigger?

513

Explain what is mysql?

575

For More Un-Answered { Databases } Questions Click Here