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

How to define an anonymous procedure without variables?

1031

How many data types are supported?

1033

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

979

How to define default values for formal parameters?

992

What are the restrictions on external table columns?

1001

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

963

How to loop through data rows in the implicit cursor?

1021

How to create additional tablespaces for an new database?

976

How many categories of data types?

942

Can you assign multiple query result rows to a variable?

935

How to use fetch statement in a loop?

980

Can dml statements be used in pl/sql?

1026

Can variables be used in sql statements?

984

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

1107

How to process query result in pl/sql?

1069

Un-Answered Questions { Databases }

What is first normal form in dbms?

915

What are cursors in ms sql server?

1119

What are tables and fields?

982

Explain a data segment?

1024

what is the difference between $message and $$message? : Sql dba

952

What is a oracle database?

1002

What the different components in replication and what is their use?

919

How to select an oracle system id (sid)?

1022

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1380

What are the several methods to enter data in ms access 2013?

772

How do I kill a query in postgresql?

1023

Â Explain what is sql override for a source taLle in a mapping?

953

Explain atomicity?

983

How can you find out how many users are currently logged into the database? How can you find their operating system id?

489

Is sqlexception checked or unchecked?

927

For More Un-Answered { Databases } Questions Click Here