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 use old values to define new values in update statements in ms sql server?

1290

Does index speed up select statements?

1023

What happens if time-only values are provided as date and time literals?

1027

Is the order of columns in the set clause important in ms sql server?

981

How to find the login name linked to a given user name?

1028

How to rename databases in ms sql server?

1216

How to select all columns of all rows from a table with a select statement in ms sql server?

1130

How to create a dml trigger using create trigger statements?

1048

How to set database to be read_only in ms sql server?

1022

What is the simplest way to create a new database in ms sql server?

1019

How to connect ms access to sql servers through odbc?

1045

How to add an address record into adventureworkslt?

1001

How to select some specific rows from a table in ms sql server?

1021

How to create a new schema in a database?

1166

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1000

Un-Answered Questions { Databases }

What are the steps to insert a table?

960

What do you mean by cdb and pdb in oracle 12c?

1071

What is the openxml statement in sql server?

1088

When would you use a before or after trigger?

921

What is java sql drivermanager?

1110

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1035

What is dcl in sql?

980

What are the operators in sql?

1040

Mention what is the plv (pl/vision) package offers?

1119

Show the cursor attributes of pl/sql.

1062

What is the basic form of sql query?

958

Explain data warehousing in sql server?

1064

What is acid properties?

1119

Explain what is the use of custom fields in report?

942

In which phase of mload can I use .filler?

943

For More Un-Answered { Databases } Questions Click Here