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

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

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

DB Development (113)
SQL PLSQL (3328)
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

How to define an anonymous procedure without variables?

734

How many data types are supported?

806

How to connect to the server with user account: sys?

762

How to define default values for formal parameters?

770

What are the restrictions on external table columns?

770

What privilege is needed for a user to insert rows to tables in another schema?

777

How to loop through data rows in the implicit cursor?

773

How to create additional tablespaces for an new database?

768

How many categories of data types?

743

Can you assign multiple query result rows to a variable?

739

How to use fetch statement in a loop?

761

Can dml statements be used in pl/sql?

783

Can variables be used in sql statements?

751

How to revise and re-run the last sql command?

847

How to process query result in pl/sql?

784

Un-Answered Questions { Databases }

What are primary key and foreign key and how they work?

752

Why foreign key constraint is important?

581

Explain the savepoint statement.

825

How to execute multiple stored procedures at one time in sql server?

693

Is microsoft access pc only?

538

Will the writetext statement activate a trigger?

754

How to add a new column to an existing table in oracle?

829

Explain the various types of concurrency problem?

933

What degree do database administrators need?

377

What is indexing in sql server with example?

706

What is the relation of a user account and a schema?

857

Mention what are the core components of ssrs?

253

What is difference between Datepart() and Datename() in SqlServer?

913

What is a driver in database?

783

What is 2nf and 3nf?

690

For More Un-Answered { Databases } Questions Click Here