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 6601

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

eicc,

2 31465

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 6695

what is the architechure of sybase ASE?

ocbc,

2 17258

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

2 11383

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

4 11835

what is difference between foreign key and reference key

AZTEC, Infosys,

3 42332

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 16375

Un-Answered Questions { Databases }

Tell me the phases a transaction has to undergo?

979

What is blob and text in mysql?

1182

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2110

What is the sql query to display the current date?

1064

Explain the commands in sql server?

1056

What is default password for mysql?

878

Does sql server use t sql?

1040

Is foreign key unique?

1014

Can I create users through internet explorer in oracle 10g?

1108

why the Ctl file u put only in bin folder why not in other folder

2067

What is RMS migrations?

2153

What are the features of openedge features?

1040

Why do we backup Active Directory ?

1056

How to bring a tablespace offline?

1085

How can you find dead processes?

550

For More Un-Answered { Databases } Questions Click Here