Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is the purpose of using pl/sql?

1164

How do you declare a user-defined exception?

1038

How exception is different from error?

1034

What is the difference between syntax error and runtime error?

1152

What are pl/sql exceptions? Tell me any three.

1 1332

What will you get by the cursor attribute sql%rowcount?

1051

What are the two virtual tables available at the time of database trigger execution?

1239

What are the two different parts of the pl/sql packages?

1116

What are the advantages of stored procedure?

1019

Which command is used to delete a trigger?

1356

What is cursor and why it is required?

1217

Explain the savepoint statement.

1112

How many types of cursors are available in pl/sql?

1129

What are the most important characteristics of pl/sql?

1186

What happens when a trigger is associated to a view?

934

Un-Answered Questions { Databases }

What is the difference between sga and pga?

640

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

865

What is explicit mode in sql server?

1077

how mysql optimizes distinct? : Sql dba

1091

Can we use update in sql function?

1079

What, if a table has one column defined as TIMESTAMP?

1024

What is the difference between media recovery & crash recovery?

Is sqlite faster than mysql?

962

What is erd?

1026

What is denormalization in a database?

1080

What is the security principal at the server level that represents your session?

1029

What is mysqli_result?

963

Why is mysql used?

952

What is oracle database 10g express edition?

1142

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2260

For More Un-Answered { Databases } Questions Click Here