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 10610

what operator performs pattern matching?

2 11701

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 8047

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

TCS,

3 18746

Which system tables contain information on privileges granted and privileges obtained

1 7096

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

2 7307

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

7 14879

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

2 9742

What is the use of CASCADE CONSTRAINTS?

3 11264

What is the difference between join and union.

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

27 180553

What is the difference between anonymous block and named blocks?

3 10635

What is user Account in Oracle database ?

2 4836

How will you enforce security using stored procedures ?

2 5900

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

2 8680

What are the responsibilities of a Database Administrator ?

3 8072

Un-Answered Questions { Databases }

How do you check sql server is up and running?

1001

What is clause in sql?

1108

Is foreign key should be unique?

767

How to compare the top two records using sql?

1342

What is triggers and its types?

1009

How do you create a foreign key in pgadmin 4?

810

What is replica set in mongodb?

How would you improve throughput in sybase?

970

To do safe backups what is the feature in mongodb that you can use?

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1068

How to delete all rows a table in oracle?

1068

Is not null in sql?

994

How does select query work?

939

What are internal user account in oracle?

1006

What is anonymous block in sql?

1120

For More Un-Answered { Databases } Questions Click Here