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


Databases Interview Questions
Questions Answers Views Company eMail

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

 1

Why do we use materialized view instead of table or views?

 1

How can we use tkprof?

 1

How would you identify the shared_pool_size parameter that needs to be adjusted?

 1

How can we collect the statistics of different database objects?

 1

What do you understand from cache fusion?

 1

Why do we need to rebuild indexes?

 1

What is the difference between media recovery & crash recovery?

 1

What are the different types of backups that are available in oracle?

 1

What are the different tools that are provided by oracle to assist performance monitoring?

 1

What is the difference between restoring a database and recovering a database?

 1

Can you list down the different components of physical and logical database structure?

 1

What do you understand by redo log file mirroring?

 1

What do you mean by sga and how is it different from pga?

 1

What is a flashback query and when should it be used?

 1

Un-Answered Questions { Databases }

What is the insert?

490

Explain database partitioning.

638

What is xml datatype?

651

There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

1705

What is group by in sql?

546




What are the different types of record groups in oracle? Explain each of them

600

What do you mean by a deadlock?

515

Difference between drill down and drill through report.

544

What is the purpose of firebase?

547

what is innodb? : Sql dba

575

What are the types of processing and explain each? : sql server analysis services, ssas

738

What is the difference between float and double?

587

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1098

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

618

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1933

For More Un-Answered { Databases } Questions Click Here