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

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 10635

what operator performs pattern matching?

2 11727

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 8072

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 18766

Which system tables contain information on privileges granted and privileges obtained

1 7120

Which system table contains information on constraints on all the tables created?

2 7335

what command is used to create a table by copying the structure of another table?

7 14935

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 9767

What is the use of CASCADE CONSTRAINTS?

3 11293

What is the difference between join and union.

3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

27 180768

What is the difference between anonymous block and named blocks?

3 10663

What is user Account in Oracle database ?

2 4862

How will you enforce security using stored procedures ?

2 5926

What are the dictionary tables used to monitor a database spaces ?

2 8708

What are the responsibilities of a Database Administrator ?

3 8104

Un-Answered Questions { Databases }

How to start mysql server?

1072

how can you initialize log miner?

1165

How do I start sql server?

992

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1138

What are the Types of Scd's?

594

Explain “row_number()” in sql server with an example?

1020

Explain how dts is used to extract, transform and consolidate data?

1012

Write short notes on manual refreshes.

2754

What does the base_object_type column shows in the user.triggers data dictionary view?

1059

what is the difference between restoring and recovering?

1026

How is mongodb data stored?

Is natural join and inner join same?

941

What is a sql instance vs database?

1132

How to use copy and concatenate commands in SQL?

1157

Does adding an index lock a table?

972

For More Un-Answered { Databases } Questions Click Here