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 6185

Give the reasoning behind using an index.

 2 4833

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

 1 3191

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

 1 7485

Give two examples of referential integrity constraints.

 1 4019

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 13720

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

HCL,

1 6717

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

 1 7854

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

 1 4417

How would you go about generating an EXPLAIN plan?

Satyam,

1 4055

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

 1959

Explain an ORA-01555

 2 5730

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

 2 6743

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

 1 4254

Explain the use of setting GLOBAL_NAMES equal to TRUE.

 1 3611

Un-Answered Questions { Databases }

Who created postgresql?

408

Why are stored procedures used?

405

What is foreign key in dbms?

479

How do I view a stored procedure in sql server query?

540

What is a checkpoint in dbms?

557




What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

620

What is the advantages and disadvantages of database management system?

439

How to call shell script from pl sql procedure?

625

Write a query to display current date and time?

518

How do I connect to a mysql database?

493

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

581

a text item is there what r the different types of triggers associated with it

1514

Is sql an operating system?

545

How to load a large xml file?

586

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

280

For More Un-Answered { Databases } Questions Click Here