Databases Interview Questions
Questions Answers Views Company eMail

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 5596

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

JPMorgan Chase,

9 13447

what is DTS what are tasks available

Wipro,

1 3028

Normalization and denormalization

Wipro,

3 5565

Diffrent types of function

Wipro,

1 3847

diffrence between function and procedure

Wipro,

5 5767

diffrence between Cluster Index and non Cluster Index

Wipro,

3 5077

System variable and temporary variables

Wipro,

1700

optimization techinques

Wipro,

2187

user defined datatypes

Wipro,

1 3887

What is bulk collections?

2 6374

what is External tables? explain with examples

TCS,

2 12518

what is difference between decode and case function?

2 8975

what is the link between suppliers and banks in ap module in oracle apps? And also query?

Polaris,

2011

In oracle 10g export, import if we declare rows=y/n what would be the output?

Value Labs,

2390


Un-Answered Questions { Databases }

What is mysql community edition?

506


What are internal user account in oracle?

563


what are the advantages of sql ? : Sql dba

537


explain the advantages and disadvantages of stored procedure? : Sql dba

525


What are the differences between a primary key and foreign key?

558






Is full outer join same as cross join?

495


What is the difference between a primary key and a composite key?

408


How do you delete duplicate records in sql server?

500


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

560


how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

534


What is character varying in postgres?

439


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

545


How do I change my passwords (database, LDAP, and so on) without causing an outage?

590


I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

1965


What is the difference between mongodb and mysql?

5