1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

Compare and contrast TRUNCATE and DELETE for a table.

 3 6169

Give the reasoning behind using an index.

 2 4827

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

 1 3183

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

 1 7475

Give two examples of referential integrity constraints.

 1 4004

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 13692

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

HCL,

1 6689

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

 1 7841

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

 1 4407

How would you go about generating an EXPLAIN plan?

Satyam,

1 4038

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

 1953

Explain an ORA-01555

 2 5700

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

 2 6731

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

 1 4247

Explain the use of setting GLOBAL_NAMES equal to TRUE.

 1 3603

Un-Answered Questions { Databases }

How to call postgresql function in asp net?

445

What is Weak Entity set?

454

Is mongodb a nosql database? Explain.

1

What is database schema name?

574

How can use stored procedures in sql?

580




Explain normalization in one line?

634

What is autocommit mode in sql server?

541

What is access best used for?

414

explain the difference between delete , truncate and drop commands? : Sql dba

546

What is procedure in pl sql?

535

What is a stored procedure in sql with example?

598

What is a trigger oracle?

557

What is the use of innodb in mysql?

474

Explain about the mainframe connect tools from sybase?

468

Explain tds (tabular data streams).

503

For More Un-Answered { Databases } Questions Click Here