What are the common RMAN errors (with solutions)? (for DBA)
Some of the common RMAN errors are:
RMAN-20242: Specification does not match any archivelog in the recovery catalog.
Add to RMAN script: sql 'alter system archive log current';
RMAN-06089: archived log xyz not found or out of sync with catalog
Execute from RMAN: change archivelog all validate;
How can you execute the user defined triggers in forms 3.0 ?
Execute Trigger (trigger-name)
Execute Trigger (trigger-name)
What ERASE package procedure does ?
Erase removes an indicated global variable.
Erase removes an indicated global variable.
What is the difference between NAME_IN and COPY ?
Copy is package procedure and writes values into a field.
Name in is a package function and returns the contents of the variable to which you apply.
Copy is package procedure and writes values into a field.
Name in is a package function and returns the contents of the variable to which you apply.
What package procedure is used for calling another form ?
Call (E.g. Call(formname)
Call (E.g. Call(formname)
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
Break.
SYSTEM VARIABLES
Break.
SYSTEM VARIABLES
The value recorded in system.last_record variable is of type
a. Number
b. Boolean
c. Character. ?
b. Boolean.
a. Number
b. Boolean
c. Character. ?
b. Boolean.
What is mean by Program Global Area (PGA) ?
It is area in memory that is used by a Single Oracle User Process.
It is area in memory that is used by a Single Oracle User Process.
What is hit ratio ?
It is a measure of well the data cache buffer is handling requests for data. Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/ Logical Reads.
It is a measure of well the data cache buffer is handling requests for data. Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/ Logical Reads.
How do u implement the If statement in the Select Statement
We can implement the if statement in the select statement by using the Decode statement. e.g. select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .
We can implement the if statement in the select statement by using the Decode statement. e.g. select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .
How many types of Exceptions are there
There are 2 types of exceptions. They are
a) System Exceptions
e.g. When no_data_found, When too_many_rows
b) User Defined Exceptions
e.g. My_exception exception
When My_exception then
There are 2 types of exceptions. They are
a) System Exceptions
e.g. When no_data_found, When too_many_rows
b) User Defined Exceptions
e.g. My_exception exception
When My_exception then
What are the inline and the precompiler directives
The inline and precompiler directives detect the values directly
The inline and precompiler directives detect the values directly
How do you use the same lov for 2 columns
We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code
We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code
How many minimum groups are required for a matrix report
The minimum number of groups in matrix report are 4
The minimum number of groups in matrix report are 4
What is the difference between static and dynamic lov
The static lov contains the predetermined values while the dynamic lov contains values that come at run time
The static lov contains the predetermined values while the dynamic lov contains values that come at run time
How does one manage Oracle database users? (for DBA)
Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB Configuration Assistant (dbca). DBA's must unlock these accounts to make them available to users.
Look at these examples:
ALTER USER scott ACCOUNT LOCK -- lock a user account
ALTER USER scott ACCOUNT UNLOCK; -- unlocks a locked users account
ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password
Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB Configuration Assistant (dbca). DBA's must unlock these accounts to make them available to users.
Look at these examples:
ALTER USER scott ACCOUNT LOCK -- lock a user account
ALTER USER scott ACCOUNT UNLOCK; -- unlocks a locked users account
ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password
What is the use of PARFILE option in EXP command ?
Name of the parameter file to be passed for export.
Name of the parameter file to be passed for export.
What is the use of TABLES option in EXP command ?
List of tables should be exported.ze)
List of tables should be exported.ze)
What is the OPTIMAL parameter?
It is used to set the optimal length of a rollback segment.
Share This :
It is used to set the optimal length of a rollback segment.
0 comments:
Post a Comment