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


Databases Interview Questions
Questions Answers Views Company eMail

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

 2 7762

Describe what redo logs are.

 1 4330

How would you force a log switch?

 4 11987

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

 2 10594

What does coalescing a tablespace do?

 1 14602

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

 2 6048

Name a tablespace automatically created when you create a database.

 5 10526

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

 3 7623

How do you add a data file to a tablespace?

 3 6591

How do you resize a data file?

 2 12999

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

 3 7437

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

 3 8290

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

 4 9669

How can you rebuild an index?

 6 11677

Explain what partitioning is and what its benefit is.

 2 6363

Un-Answered Questions { Databases }

What is the purpose of sql profiler in sql server? : sql server database administration

623

What is compound trigger?

557

What is control file used for?

602

how to use like conditions? : Sql dba

575

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

537




Explain primary key, foreign key and unique key?

542

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

993

What is a table called in database?

471

In which tcp/ip port does sql server run? Can it be changed?

545

What is full form of rtm?

534

Can you purchase just microsoft access?

456

tell me about various levels of constraint. : Sql dba

531

What is the use of custom fields in report?

561

what do you understand by change data capture?

558

what is storage manager?

534

For More Un-Answered { Databases } Questions Click Here