Databases Interview Questions
Questions Answers Views Company eMail

What is the difference between DELETE, TRUNCATE, and DROP?

3 661

What are indexes, and what are the different types?

3 554

Explain the concept of normalization.

3 561

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 566

What are triggers, and when would you use them?

3 693

Compare SQL and PL/SQL.

3 278

Do you know the basic structure of PL/SQL?

3 678

What Is a Trigger? How Do You Use It?

3 753

What data types does pl/SQL have?

3 705

Explain the PL/SQL compilation process.

3 619

Tell me what a package consists of.

3 688

What are the benefits of using PL/SQL packages?

3 815

Do you understand the meaning of exception handling?

3 558

Give me some examples of predefined exceptions.

3 944

How to resolve the ORA-39133 error in Oracle?

796


Un-Answered Questions { Databases }

Explain ms sql server reporting services vs crystal reports?

699


Can foreign key be duplicate?

823


What is an index associated with a constraint?

765


Is mongodb a nosql?

1


How to check parameter value in stored procedure sql server?

682


Explain what are the authentication modes in sql server?

704


Does sql server use java?

762


what is the functionality of the function htmlentities? : Sql dba

705


what are savepoint mode and cursor mode properties ?

1


What is a select query statement in oracle?

720


What are the different types of failures that occur in Oracle database?

825


What is foreign key in java?

625


Are null values the same as that of zero or a blank space?

804


What is sql partition function?

824


What is a non clustered primary key?

689