Databases Interview Questions
Questions Answers Views Company eMail

Enlist some predefined exceptions?

588

What do you mean by query optimization?

552

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

581

What do you mean by stored procedures? How do we use it?

529

Difference between truncate, delete and drop commands?

561

How do you add a column to a table?

606

What is a table?

569

What is the syntax to add a record to a table?

579

What is the mutating table and constraining table?

563

How to select random rows from a table?

529

What are properties of the transaction?

562

Why is %isopen always false for an implicit cursor?

574

What is normalization? How many normalization forms are there?

556

When do we use triggers?

591

What are the possible values for the boolean data field?

527


Un-Answered Questions { Databases }

Explain timestamp?

594


How to convert numeric expression data types by assignment operations?

523


What is transactional trigger property?

1


Which is faster truncate or drop?

564


Explain the stored procedure?

643






how to drop an existing index in mysql? : Sql dba

543


what are the properties and different types of sub-queries? : Sql dba

510


What are triggers in mysql?

496


hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

1950


What is Lock table in SQL?

1007


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2068


What is a livelock?

562


What is a trigger and types of a trigger?

572


What is parameter substitution in sql?

531


What are summary column and placeholder column in reports?

1