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 6587

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

eicc,

2 31437

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 6670

what is the architechure of sybase ASE?

ocbc,

2 17226

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

2 11361

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

4 11804

what is difference between foreign key and reference key

AZTEC, Infosys,

3 42288

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 16321

Un-Answered Questions { Databases }

How can be determining the size of the log files?

584

How many file formats are supported to export data?

1220

Explain the importance of .pll extension in oracle?

1013

What is VDL (View Definition Language)?

1007

What is difference between database and schema?

995

What is 'cross join'? Or what is cartesian product?

879

What is an Oracle index?

1655

Define entity set.

919

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2440

What are the different types of data tables?

901

How to edit table in sql server 2017?

930

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1931

Explain left outer join and right outer join?

1043

How can i Relate Tables in SSIS

1081

What is the partitioning method?

1021

For More Un-Answered { Databases } Questions Click Here