Learn Database

Topic: All about Database

Browse random answers:

Explain the storage models of OLAP

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

What are statistics, under what circumstances they go out of date, how do you update them?

What are the different ways of moving data/databases between servers and databases in SQL Server?

Are there any undocumented commands in Oracle? (for DBA)

What is the function of Optimizer ?

What is Execution Plan ?

Can one resize tablespaces and data files? (for DBA)

What is SAVE POINT ?

BETWEEN ... AND operators in SQL.

Explain acid properties?

What is ACID property?

Which SQL Server database does not follow ACID properties?

What is rollback and roll forward?

How can one recover the database via reprocessing?

How to check whether the product is install,shared and Not installed in Apps.?

How to find a file version in Application DB:

What are the real time problems you have encountered and how you trouble shooted that?

What is an Oracle instance?

What is referential integrity?

Why Use Sql* Loader in Oracle Database?

How does one create a standby database? (for DBA)

How does one give developers access to trace files (required as input to tkprof)? (for DBA)

What are the responsibilities of a Database Administrator ?

What is a trace file and how is it created ?

What are the roles and user accounts created automatically with the database?

What are the minimum parameters should exist in the parameter file (init.ora) ?

Why and when should I backup my database? (for DBA)

What strategies are available for backing-up an Oracle database? (for DBA)

What is a Query Record Group?

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

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

What is the difference between the SQL*Loader and IMPORT utilities?

What are the different types of segments?

What is a data segment?

What is an index segment?

What is rollback segment?

What are the uses of rollback segment?

What is a temporary segment?

What is a datafile?

What are the characteristics of data files?

What is a redo log?

What is the function of redo log?

What is the use of redo log information?

What does a control file contains?

What is the use of control file?

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Explain the difference between a data block, an extent and a segment.

Compare and contrast TRUNCATE and DELETE for a table.

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

How many types of columns are there and what are they

Describe Referential Integrity ?

What is row chaining?

How to define data block size?

What is path setting for DLL?

What are key-mode and locking mode properties? level ?

What does invoke built-in do?

What are OPEN_FORM,CALL_FORM,NEW_FORM? diff?

Diff. between VAT and Property Class?

Which trigger related to mouse?

What is Current record attribute property?

What are the steps involved in Database Startup

which system variables can be set by users?

What are referenced objects?

Can you store objects in library?

Can you issue DDL in forms?

What are the types of triggers and how the sequence of firing in text item

What are record groups ? * Can record groups created at run-time?

What are ALERT?

Table Space,Data Files,Parameter File, Control Files

What is a 2 Phase Commit

What is pseudo columns ? Name them?

What are Database Triggers and Stored Procedures

What are the Different Optimization Techniques

How does one create and drop database users?

How does one stop and start the OMS? (for DBA)

What is CYCLE/NO CYCLE in a Sequence ?

What are the Back ground processes in Oracle and what are they.

How many types of Sql Statements are there in Oracle

What are different Oracle database objects?

What are the cursor attributes used in PL/SQL ?

Find out nth highest salary from emp table

Explain the difference between a data block, an extent and a segment.

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

How do you increase the performance of %LIKE operator?

What is Cache Fusion Technology?

What is simple replication and advance replication?

How are the indexes updated?

How many memory layers are in the oracle shared pool? Explain them

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

Explain the concept of the DUAL table.

What are the ways tablespaces can be managed and how do they differ?

Explain what are Oracle Catalog and Oracle Archive log?

What are PCT Free and PCT Used? What is PCT increase parameter in segment?

What is dump destination? What are bdump, cdump and udump?

What is the difference between Cloning and Standby databases?

What is Materialized views? Explain its uses.

Why and how the deadlock situation arises?

What are the steps to take to improve performance of a poor performing query?

What is blocking and how would you troubleshoot it?