Databases Interview Questions
Questions Answers Views Company eMail

What is the SQL?????????????????????????????

CMS,

5 4156

What is the Query to print out the individual total number of duplicate row in sql.

TCS,

5 7614

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

1096




How to display the hierarchy of employee and managers without using connect by prior.

1 2261

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

IBM,

1283

how to know the tables in database having foreign key?

2 2466

find the second highest salary of the emp table

6 4336

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 17761

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

900

what is pragma ?

Polaris,

1 5184

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

IBM, Cognizant,

7 4752

What is the Query Optimizer. How you optimize your qeury.

Ericsson,

2 4723

what is an sql server?

1 2472

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 2602

find 2nd highest salary of person using cursor concept?

HCL,

6 6140







Un-Answered Questions { Databases }

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1392


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

533


8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

903


what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?

810


How would you best determine why your MVIEW couldn't FAST REFRESH?

1194






which one is currently in used software cmpanies.

923


1) Does oracle have any table which contain all the exceptions and it's code internally?

659


How to synchronize 2 schema's objects?

1068


what is normalisation?what are its uses?

1123


How to do Data size testing? Who does this testing (Developer or tester)?

1516


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1599


Which is better Oracle or MS SQL? Why?

2644


key flexfield structure

950


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1174


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1102