x

Recent tagged oracle


What does "jumps off the screen" mean?
Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

Show More

0 views 1 answer



How to add conditions in select statement in oracle?
Last Answer : Just add the decode

Show More

0 views 1 answer



How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?
Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

Show More

1 view 1 answer



What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items

Show More

4 views 1 answer



Can one export a subset of a table? (for DBA
Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

Show More

2 views 1 answer



What are the types of visual attribute settings?
Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

Show More

2 views 1 answer



How does one use the import/export utilities? (for DBA
Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

Show More

3 views 1 answer



what is a display item?
Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

Show More

2 views 1 answer



What is import/export and why does one need it? (for DBA
Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Show More

3 views 1 answer



Are there any troubleshooting tips for OEM? (for DBA
Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Show More

2 views 1 answer



Where can one get more information about TCL? (for DBA
Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

Show More

1 view 1 answer



How does one start the Oracle Intelligent Agent? (for DBA
Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

Show More

2 views 1 answer



What is the Oracle Intelligent Agent? (for DBA
Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

Show More

3 views 1 answer



What are the types of SQL Statement ?
Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

Show More

1 view 1 answer



How does one backout events and jobs during maintenance slots? (for DBA
Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

Show More

4 views 1 answer



What are the pre requisites ?
Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

Show More

1 view 1 answer



What kind of jobs can one schedule with OEM? (for DBA
Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Show More

3 views 1 answer



Difference between SUBSTR and INSTR ?
Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Show More

2 views 1 answer



Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA
Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Show More

3 views 1 answer



Explain UNION,MINUS,UNION ALL, INTERSECT ?
Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

Show More

5 views 1 answer



WHY USE RMAN ? (for DBA
Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

Show More

1 view 1 answer



WHAT IS RMAN ? (for DBA
Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

Show More

2 views 1 answer



What is the basic structure of PL/SQL ?
Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

Show More

2 views 1 answer



What are the two parts of a procedure ?
Last Answer : Procedure Specification and Procedure Body.

Show More

1 view 1 answer



What are the datatypes a available in PL/SQL ?
Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

Show More

4 views 1 answer



What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?
Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

Show More

1 view 1 answer



What is Overloading of procedures ?
Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

Show More

2 views 1 answer



s it possible to set a filter condition in a cross product group in matrix reports?
Last Answer : No

Show More

2 views 1 answer



Can a repeating frame be created without a data group as a base?
Last Answer : No

Show More

1 view 1 answer



What is an OLE?
Last Answer : Object Linking & Embedding provides you with the capability to integrate objects from many Ms-Windows applications into a single compound document creating integrated applications enables you to use the features form .

Show More

5 views 1 answer



What are the different objects that you cannot copy or reference in object groups?
Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

Show More

1 view 1 answer



If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Last Answer : Only for 10 records.

Show More

3 views 1 answer



Are there any undocumented commands in Oracle? (for DBA
Last Answer : Sure there are, but it is hard to find them. Look at these examples: From Server Manager (Oracle7.3 and above): ORADEBUG HELP It looks like one can change memory locations with the ORADEBUG POKE ... rdbms/lib/oradbx.o; make -f oracle.mk oradbx) SQL*Plus: ALTER SESSION SET CURRENT_SCHEMA = SYS;

Show More

1 view 1 answer



How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA
Last Answer : Execute the "ORADEBUG HELP" command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug ... oradebug lkdebug -a convres SQLPLUS> oradebug lkdebug -r (i.e 0x8066d338 from convres dump)

Show More

2 views 1 answer



What is the OPTIMAL parameter?
Last Answer : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Show More

2 views 1 answer



What is the use of TABLES option in EXP command ?
Last Answer : List of tables should be exported.ze)

Show More

1 view 1 answer



What is the use of PARFILE option in EXP command ?
Last Answer : Name of the parameter file to be passed for export.

Show More

3 views 1 answer



What is the difference between DBFile Sequential and Scattered Reads?(for DBA
Last Answer : Both "db file sequential read" and "db file scattered read" events signify time waited for I/O read requests to complete. Time is reported in 100's of a second for Oracle 8i releases and below, ... v_$system_event b where a.event = 'db file sequential read' and b.event = 'db file scattered read';

Show More

2 views 1 answer



How does one tune Oracle Wait events? (for DBA
Last Answer : Some wait events from V$SESSION_WAIT and V$SYSTEM_EVENT views: Event Name: Tuning Recommendation: db file sequential read Tune SQL to do less I/O. Make sure all objects are analyzed. Redistribute ... SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

Show More

2 views 1 answer



How does one manage Oracle database users? (for DBA
Last Answer : 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 ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

Show More

4 views 1 answer



How does one manage Oracle database users? (for DBA
Last Answer : 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 ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

Show More

2 views 1 answer



What is the difference between static and dynamic lov
Last Answer : The static lov contains the predetermined values while the dynamic lov contains values that come at run time

Show More

4 views 1 answer



How many minimum groups are required for a matrix report
Last Answer : The minimum number of groups in matrix report are 4

Show More

2 views 1 answer



How do you use the same lov for 2 columns
Last Answer : 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

Show More

1 view 1 answer



What are the inline and the precompiler directives
Last Answer : The inline and precompiler directives detect the values directly

Show More

2 views 1 answer



How many types of Exceptions are there
Last Answer : 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

Show More

2 views 1 answer



How do u implement the If statement in the Select Statement
Last Answer : 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 .

Show More

2 views 1 answer



What is hit ratio ?
Last Answer : 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.

Show More

1 view 1 answer



What is mean by Program Global Area (PGA) ?
Last Answer : It is area in memory that is used by a Single Oracle User Process.

Show More

1 view 1 answer



The value recorded in system.last_record variable is of type
Last Answer : a. Number b. Boolean c. Character. ? b. Boolean.

Show More

5 views 1 answer