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 get help at the sql prompt?

1112

What is sql in oracle?

1061

How run sql*plus commands that are stored in a local file?

1061

What are the types pl/sql code blocks?

1127

What do you think about pl/sql?

1029

Can ddl statements be used in pl/sql?

1142

How to create an array in pl/sql?

1066

How to start oracle sql developer?

1034

How to set up sql*plus output format in oracle?

1037

How to load data with sql*loader?

1048

What is a sql*loader control file?

1262

What is pl/sql language case sensitive?

1120

How to create your own reports in sql developer?

1018

How to avoid using cursors?

1120

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

957

Un-Answered Questions { Databases }

What is sql vs mysql?

1018

What is the difference between inner join and outer join?

996

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2194

What is a package ? What are the advantages of package ?

1091

What is secondary key?

933

What is Set-at-a-time or Set-oriented?

900

What do you mean by Oracle MEDIA RECOVERY?

1226

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1096

What is a key in dbms?

907

What is a candidate key in a database?

888

Is the server accepting tcp ip connections on port 5432?

889

What are Row versions of DataRow?

1028

What is varray in pl sql?

1075

Is postgres distributed?

765

What port does postgresql listen on?

824

For More Un-Answered { Databases } Questions Click Here