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

How would you determine what sessions are connected and what resources they are waiting for?

2 8766

Describe what redo logs are.

1 5100

How would you force a log switch?

4 13892

Give two methods you could use to determine what DDL changes have been made.

2 11544

What does coalescing a tablespace do?

1 15526

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 7173

Name a tablespace automatically created when you create a database.

5 12713

When creating a user, what permissions must you grant to allow them to connect to the database?

3 8856

How do you add a data file to a tablespace?

3 7930

How do you resize a data file?

2 14116

What view would you use to look at the size of a data file?

3 8914

What view would you use to determine free space in a tablespace?

3 9452

How would you determine who has added a row to a table?

4 11387

How can you rebuild an index?

6 13926

Explain what partitioning is and what its benefit is.

2 7415

Un-Answered Questions { Databases }

What are the types of table?

994

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1608

Enlist the advantages of normalizing database.

1044

What is multi-statement table-value user-defined function?

1009

what are all the common sql function? : Sql dba

1067

what is denormalization? : Sql server database administration

942

How does rowid help in running a query faster?

1428

What is the difference between functions, procedures, and packages in pl/sql?

1067

How do I edit a database in mysql workbench?

928

In what sequence do triggers get fired by oracle forms?

981

What is mysqli_result?

958

What are the advantages of using stored procedures in sql server?

1019

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

158

What have included columns when we talk about sql server indexing?

1050

Is mongodb a key value database?

For More Un-Answered { Databases } Questions Click Here