Databases Interview Questions
Questions Answers Views Company eMail

For web applications from which version of Oracle is suitable?

1 4652

What are the main diff. between oracle 7.3 and oracle 8i?

1 4501

What is mutating table?

Saama Tech,

11 62035

How to call DDL statements from pl/sql?

5 31316

How to perform a loop through all tables in pl/sql?

Evosys, MBT,

4 14760

How to maintain the history of code changes of pl/sql?

3 13430

what are Dynamic SQL statements?

9 23158

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 13996

What is pl/sql and what is it used for?

4 13566

what is constraining table?

2 12730

How pl/sql source code can be protected?

3 9762

What is the result, when NULL is compared with NULL?

TCS,

22 45208

What can be a size of a pl/sql block? Is there any limit?

2 11666

what are %TYPE and %ROWTYPE? what is the difference?

ICICI, Saama Tech, Sail,

7 45752

How to set the time zone for MySQL to particular country time?

2716


Un-Answered Questions { Databases }

Is mysql a server or database?

466


What is a trigger oracle?

553


Which table is left in join?

511


Mention the differences between unique key and primary key

465


Do I need a report server to run reports in my application?

104






When we should use and scope of @@identity?

532


Explain entity set?

581


What does partition mean in database?

503


Can we have multiple index on a table?

446


What are sql objects?

531


Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

458


What is the difference RDBMS and Graph Database?

620


What is the native system stored procedure to execute a command against all databases?

529


What is the role of binary large object in informix?

49


Explain 5nf?

518