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 6686

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

eicc,

2 31614

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 6839

what is the architechure of sybase ASE?

ocbc,

2 17430

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

2 11485

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

4 12007

what is difference between foreign key and reference key

AZTEC, Infosys,

3 42534

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 16710

Un-Answered Questions { Databases }

How can I check that whether automatic statistic update is enabled or not?

1108

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

What is the difference between for xml raw and for xml auto?

1112

What are the properties of the transaction?

1069

What are the different subsets of sql?

1646

How can we solve concurrency problems?

1120

how to start mysql server? : Sql dba

1260

How can you append an identity column to a temporary table?

1065

What is the difference between case version and decode version?

1104

What is the current mysql version?

1095

Equi join and non equi join is possible with sql server?

1127

Why and when do stored procedure recompile?

1052

How to enter binary string literals in ms sql server?

1235

What are the steps in creating a database?

1005

what is bcp? When does it used? : Sql dba

1053

For More Un-Answered { Databases } Questions Click Here