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

Oracle (3253)
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 rename an index?

1124

What is the scope of a local variable?

1122

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

1031

How to initialize variables with default values?

1307

How to define a variable of a specific record type?

1116

What is an external table?

1081

What are named parameters?

1145

How to connect to a remote server?

1189

What are the predefined tablespaces in a database?

1141

What happens if you use a wrong connect identifier?

1140

How to login to the server without an instance?

1214

How to manage transaction isolation level?

1055

How to export several tables together?

1105

How to import one table back from a dump file?

1085

How to start your 10g xe server from command line?

1127

Un-Answered Questions { Databases }

how to take backup bcp out for a column in table in sql server?

2144

what is spatial nonclustered index

1037

How can we create the complete backup of data in the oracle.

2200

Enlist the various transaction phases.

1102

What is a nested table and how is it different from a normal table?

1107

Which is better join or subquery?

1190

What is exporting and importing utility?

1143

What do you mean by oracle database?

601

Explain oracle 12c new features for developers?

1125

Can we create table inside stored procedure?

1014

Compare in and exists?

963

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2580

How do I view tables in mysql?

1028

what are cursors? : Sql server database administration

1105

How do I spool in oracle?

1063

For More Un-Answered { Databases } Questions Click Here