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 6663

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

eicc,

2 31557

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 6788

what is the architechure of sybase ASE?

ocbc,

2 17368

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

2 11440

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

4 11947

what is difference between foreign key and reference key

AZTEC, Infosys,

3 42460

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 16597

Un-Answered Questions { Databases }

What is the load plans? And how to create for the load plans?

723

How is query injection and how to handle it in mongodb?

What is server-level principal?

122

Can we have two clustered index on a table?

1085

What is the importance of a recovery model?

1098

How do I start sql server 2016?

954

Can we use redis as database?

1038

Is redis in memory database?

1055

What is the maximum line size that dbms_output can handle?

1258

How to list all tables in your schema?

1123

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

611

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2180

what is acid property in database? : Sql dba

1073

What flow of MSExcel in odi?

634

How many types of synonyms in Oracle?

1183

For More Un-Answered { Databases } Questions Click Here