Databases Interview Questions
Questions Answers Views Company eMail

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

ESS,

1 4549

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

ESS,

1777

aht is the difference b/w network & hierarchial & relational dbms????

1751

what is ora 600?

1 3805

how will I find the first 5 highest salaried employees in each dept in oracle.

IBM,

22 26655

how will I find the duplicate rows count from employees tablein oracle.

2 4789

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 5759

how to take backup bcp out for a column in table in sql server?

1614

what is cardinality

CSC,

3 5089

How many types of trigger can be used in a table at a time ?

7 9744

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3774

how to clone 9i Database on to 10g Database.

1805

How to create Drill down report?

ABB, ESS, Infosys,

1674

How to call a report from Forms?

5 11415

why use cursors?

Oracle,

5 10790


Un-Answered Questions { Databases }

What is the process of normalization?

528


How to create a new table in a given schema?

632


What is the difference between internal & external schema?

302


What things to be taken in consideration for lookup fields?

488


What is a database lookup?

551






What is trigger types of trigger?

527


Is resultset an interface?

537


What is model database? : sql server architect

444


Name the different triggers associated with oracle forms having a master-detail relationship.

472


How to override dml statements with triggers?

553


Does union all remove duplicates?

593


What is data modeling and Reterminal integrity?

1459


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

526


What can I use instead of microsoft access?

421


What is implicit cursor in pl sql?

516