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

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 9855

How would you go about increasing the buffer cache hit ratio? 0. Explain the difference between a hot backup and a cold backup and the benefits associated with each 1. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database? 2. How do you switch from an init.ora file to a spfile? 3. Explain the difference between a data block, an extent and a segment. 4. Give two examples of how you might determine the structure of the table DEPT. 5. Where would you look for errors from the database engine? 6. Compare and contrast TRUNCATE and DELETE for a table. 7. Give the reasoning behind using an index. 8. Give the two types of tables involved in producing a star schema and the type of data they hold. 9. What type of index should you use on a fact table? 10. Give two examples of referential integrity constraints. 11. A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? 12. Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each. 13. What command would you use to create a backup control file? 14. Give the stages of instance startup to a usable state where normal users may access it. 15. What column differentiates the V$ views to the GV$ views and how? 16. How would you go about generating an EXPLAIN plan?

2 5976

can ms access be used in a website instead of sql server?

3 9266

mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?

1 4051

how to repair a table in mysql?

2 4564

what is the advantage of stored procedures, triggers and indexing in mysql

1 4627

maximum size of a database in mysql?

2 4907

how many fields can be updated using set in a mysql query?

1 3472

how many table created when we create a table in mysql?

3 5676

how many ways we can get the current date in mysql?

2 5031

what is mysql optimization in brief?

2368

How do we switch from init.ora file to asp file?

2 4200

what is trigger

CarrizalSoft Technologies, NIIT,

1 4873

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1943

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

BPO, Excel, Wipro,

9 17640

Un-Answered Questions { Databases }

What are the six database objects?

920

List some of the rules that apply to creating and using a ‘view’

889

How to write a query with a right outer join in ms sql server?

921

Why mongodb is faster?

What is schema in sql?

958

What is query in rdbms?

932

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

970

Please explain what is “asynchronous” communication in sql server service broker?

944

How oracle handles dead locks?

1077

How would you extract DDL of a table without using a GUI tool?

2495

What is the difference between subquery and correlated query?

1071

What is the difference between local variables and global variables?

1129

Is postgres a database?

828

What purpose does the model database server?

1106

How can you see all indexes defined for a table?

1128

For More Un-Answered { Databases } Questions Click Here