Wednesday, October 1, 2008

How does one list one's databases in the OEM Console? (for DBA)

How does one list one's databases in the OEM Console? (for DBA)


Follow these steps to discover databases and other services from the OEM Console:
1. Ensure the GLOBAL_DBNAME parameter is set for all databases in your LISTENER.ORA file (optional). These names will be listed in the OEM Console. Please note that names entered are case sensitive. A portion of a listener.ora file:
(SID_DESC =
(GLOBAL_DBNAME = DB_name_for_OEM)
(SID_NAME = ...
2. Start the Oracle Intelligent Agent on the machine you want to discover. See section "How does one start the Oracle Intelligent Agent?".
3. Start the OEM Console, navigate to menu "Navigator/ Discover Nodes". The OEM Discovery Wizard will guide you through the process of discovering your databases and other services.

What is CYCLE/NO CYCLE in a Sequence ? 
CYCLE specifies that the sequence continues to generate values after reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum.NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum value.

What is correlated sub-query ? 
Correlated sub query is a sub query which has reference to the main query.

What are the data types allowed in a table ? 
CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ? 
CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

Can a view be updated/inserted/deleted? If Yes under what conditions ? 
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

What are the different types of Coordinations of the Master with the Detail block? 
POPULATE_GROUP(function)
POPULATE_GROUP_WITH_QUERY(function)
SET_GROUP_CHAR_CELL(procedure)
SET_GROUPCELL(procedure)
SET_GROUP_NUMBER_CELL(procedure)

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? 
I) TRUE II) FALSE 

II) FALSE

Use the ADD_GROUP_ROW procedure to add a row to a static record group? 
I) TRUE II) FALSE 

I) FALSE


No comments:

Post a Comment

Thanks to given comments.......

My Blog List