Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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

Compare and contrast TRUNCATE and DELETE for a table.

3 7541

Give the reasoning behind using an index.

2 6392

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 3921

What type of index should you use on a fact table?

1 8223

Give two examples of referential integrity constraints.

1 4868

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?

3 15190

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

HCL,

1 8187

What command would you use to create a backup control file?

1 8771

Give the stages of instance startup to a usable state where normal users may access it.

1 5205

How would you go about generating an EXPLAIN plan?

Satyam,

1 4934

How would you go about increasing the buffer cache hit ratio?

2659

Explain an ORA-01555

2 7159

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7779

How would you determine the time zone under which a database was operating?

1 5290

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4472

Un-Answered Questions { Databases }

What are stuff and replace function?

1144

Which command is used to delete a trigger?

1408

What are types of joins?

1032

What is the password of postgres user?

876

What is trigger in salesforce?

1059

How to move a multi-file database?

1093

What happens if a tablespace clause is left off of a primary key constraint clause?

623

What is database mirroring?

1178

What is 'mysqlshow'?

1119

What is difference between unix timestamp and mysql timestamp?

1064

is it possible to pass an object or table to a procedure as an argument?

1182

what is a self join? : Sql server database administration

1124

Is sql scripting language?

1115

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2813

What is csv?

1018

For More Un-Answered { Databases } Questions Click Here