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

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 5857

What are Lexical Parameters.How They are used in Reports 6i

eicc,

2 30149

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 5438

what is the architechure of sybase ASE?

ocbc,

2 15584

Which is best Subquery (or) joins in sql server? explain why

2 10255

IN Vs OR operator which is best to use sql server.

4 10231

what is difference between foreign key and reference key

AZTEC, Infosys,

3 40607

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

CGCI,

8 13926

Un-Answered Questions { Databases }

What is database migration in mysql?

512

Give me a SQL Query to find out the second largest company?

683

How can I see all tables in sql?

533

Explain the working of foreign key?

538

What is a mutating table error and how can you get around it?

529

Does the order of columns in update statements matter?

470

Why is sharding used?

541

What is oracle real application clusters?

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1634

What is the benefit of normalization?

581

What is it’s similarity with sql server?

143

Why do we use sqlite?

518

What is rs.exe utility?

118

Difference between vat and property class.

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

546

For More Un-Answered { Databases } Questions Click Here