How many type of database buffer blocks are available? What are they?

shekar2130

 Profile Answers by shekar2130 Questions by shekar2130

• Jul 15th, 2010

There are 3 types of buffers present:1. Free buffer2. Pinned buffer,3. Dirty buffer

sharmme

 Profile Answers by sharmme Questions by sharmme

• Feb 17th, 2010

Following are the types of Buffer blocks available.Pinned - Marked not to be released as per LRU algorithm. These are marked as required for further writes/changes/reads by transactions.Dirty - Change...

Answer Question  Select Best Answer

Which process creates parsing?

himaVemula

• Nov 18th, 2014

Hard parse is the process that creates parsing

sharmme

 Profile Answers by sharmme Questions by sharmme

• Feb 17th, 2010

Server process dedicated to the user both in shared and dedicated server connection configuration.

Answer Question  Select Best Answer

How do you control number of Datafiles one can have in an Oracle Database?

dbashashi

 Profile Answers by dbashashi Questions by dbashashi

• Oct 8th, 2010

Without doubt through DB_FILES in Initialization parameter file and not to forget the OS limitation of number of files it can open to process.Shashi singh

mani1304

 Profile Answers by mani1304 Questions by mani1304

• Jul 21st, 2010

Through DB_FILES parameter.

Answer Question  Select Best Answer

Take cold backup and recover

shoaib1786

 Profile Answers by shoaib1786 Questions by shoaib1786

• Nov 5th, 2011

Just create the datafile with same location mention in ur controlfile and recover the datafile ... Its simple.

naveen

• Sep 19th, 2011

Alter database create datafile 'and give the datafile location and /name' by using this command we can recover the datafile without backup also

Answer Question  Select Best Answer

What is the query to change the rows into column and columns into row

oracle2066

 Profile Answers by oracle2066 Questions by oracle2066

• Dec 28th, 2011

Alter table A add column address1 varchar2(10);

Manas Kumar Hati

• Oct 31st, 2011

Unsing Pivot Query

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

Oracle Enterprise Manager

malli

 Profile Answers by malli Questions by malli

• Aug 1st, 2015

SQL Loader

Answer Question  Select Best Answer

What is the solution if some users are encountering slow performance in production db?

Abbey

• Feb 16th, 2018

Scan for virus first

Shalu

• Dec 4th, 2016

Check the query that is running in database, try to optimize the query by using correct hint and indexes"oracle8 SELECT department_id, last_name, salary FROM employees WHERE ...

Answer Question  Select Best Answer

habib

• Nov 12th, 2005

Send me questions about databases and certifications tools of databases oracle sqlserver please

Chiranjeevi Manne

• Nov 9th, 2005

FIRST_ROWSLAST_ROWSFIRST_ROWS_10FIRST_ROWS_100FIRST_ROWS_1000ALL_ROWS

Answer Question  Select Best Answer

dhampack

 Profile Answers by dhampack Questions by dhampack

• Nov 24th, 2008

I would say, write more sql statementfor exin join statement if x=y, y=z (you can also add x=z to give more hint to optimizer)

LAKSHMAN CHOWDARY

• Oct 17th, 2005

USING COMMENT LINES WITH (+) SIGN YOU CAN PASS THE HINTS TO SQL ENGINE----------->/* +PARALLEL() */

Answer Question  Select Best Answer

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

In 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong

Ritesh Raj Singh

• Jul 12th, 2006

There is no possibilities of disabling the connection as sysdba because sys is the owner of the database who has all the powers of the database so you can disable the account of sys what u can do is y...

Answer Question  Select Best Answer

Pooja Chaturvedi

• Nov 19th, 2006

Log shipping transfers database dumps and logs from the primary server to the secondary server. As with any warm standby solution, failure detection and failover processing is not automated. When log ...

Baby Sarojini M

• Aug 28th, 2006

I thought of going thru the answers once -- for gaining knowledge

Answer Question  Select Best Answer

How will you find-out if your database is using recovery catalog or not?

Ram

• Jun 20th, 2012

Querying views like rc_database in each catalog will identify the target database it is registered with.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

There are few ways through which you would find if your database uses recovery catalog: Check backup scripts and findout if the scripts are making any connection to a recovery catalog. Check tnsnames...

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

FTS means the oracle server reads all the records from the concerned table. And it all depends on the size of the table/ partitioned table. What you say if a table consists of 10 million of records. so we musr avoid FTS. And  after all Oracle is build for searching.

Answer Question  Select Best Answer

Mohammed Mushtaq Momen

• Jul 23rd, 2006

Lookup tables are like constraints which hold a value.  The content in the lookup tables dosen't change often, hence refered as lookup (reference). Example : Countries table Countries are not add...

ed Di

• Apr 18th, 2006

They're all lookup tables.  After you load a table what's left to do but "Look up" the information at a later time. It's what database is all about; storing information for later retrieval.You pr...

Answer Question  Select Best Answer

Looking for a detailed answer if possible

aw_zahid

 Profile Answers by aw_zahid Questions by aw_zahid

• Nov 18th, 2008

A many-to-many relationship is usually resolved by making a tertiary (third intermediate) table where PKs of both the related tables are recoreded as FKs.Example: A student can take many classes and a...

Answer Question  Select Best Answer

kodaliprakash

 Profile Answers by kodaliprakash Questions by kodaliprakash

• Sep 7th, 2007

DSS is desicion support system. This is mainly useful for tking appropriate decisions based on existing data. All the data is already available in the DB. And we have to get reports according to the n...

Answer Question  Select Best Answer

What is a waterfall testing?

qaisar khan umraj

• Aug 12th, 2013

In waterfall we each step check 1st and last time means only one time we checking never take back checking never
we can repeat any previous steps

Answer Question  Select Best Answer

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 17th, 2008

Alter table add constraint primary key ()DEFERRABLE initially immediate enable novalidate

Answer Question  Select Best Answer

saurabh.nigam27

 Profile Answers by saurabh.nigam27 Questions by saurabh.nigam27

• Sep 16th, 2009

Due to DML commands, HWM will increase, which means for a query till the HWM all the blocks will be read whether blocks contain data or not (due to delete), because of this performance will go down.

Answer Question  Select Best Answer

Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS? Write your answer according to the requirements of Oracle 9i or 10g Enterprise database system.

vdamodharan

 Profile Answers by vdamodharan Questions by vdamodharan

• Jan 20th, 2010

That depends on what role you are playing in the DBA team.  If you are a operation DBA, then all you need to know to create a database are:  Initial sizing, redo, archive log size.  The...

Answer Question  Select Best Answer