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 10619

what operator performs pattern matching?

2 11710

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 8054

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

TCS,

3 18758

Which system tables contain information on privileges granted and privileges obtained

1 7099

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

2 7314

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

7 14901

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

2 9745

What is the use of CASCADE CONSTRAINTS?

3 11275

What is the difference between join and union.

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

27 180637

What is the difference between anonymous block and named blocks?

3 10650

What is user Account in Oracle database ?

2 4846

How will you enforce security using stored procedures ?

2 5914

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

2 8688

What are the responsibilities of a Database Administrator ?

3 8078

Un-Answered Questions { Databases }

How do we select distinct values from a table?

930

What is memory optimized table?

1049

Explain what is the function of sql server agent windows service?

1001

What are inbuilt functions in sql?

1069

What is concept of dbms?

916

Is microsoft access part of office?

871

can an order by clause be used in a creation of a view?

1185

How is image stored in database?

1050

What xml support does the sql server extend?

1019

Is access better than excel?

918

How do you run a trace?

908

What is 2nf example?

1001

Explain transaction server explicit transaction?

936

Why do we need cursor in pl sql?

1138

What type of database is sql?

1031

For More Un-Answered { Databases } Questions Click Here