Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

Amazon,

1895

What is the difference between primary key, foreign key and candidate key?

Ernst Young,

1109

Difference between rowid and rownum in SQL?

Virtusa,

1 1858

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 2703

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

923

What is the Difference Primary key and Unique Key

HCL,

1000

How many types of km's?

Infosys, Tech Mahindra,

584

Un-Answered Questions { Databases }

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

How many types of database triggers exist?

1133

Can I partition any table in sybase ?

987

Explain what is log shipping?

1136

What are different types of data models available? Explain with example?

1101

In which language oracle has been developed?

1073

What if we write return in procedure?

1428

What do we mean by record group in oracle forms?

1073

What is olr?

What are sql procedures?

1022

How many rows we can insert in a mysql table?

963

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1048

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

617

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2105

What is an inner join?

982

For More Un-Answered { Databases } Questions Click Here