Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )
Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.
Description : How can you enable a trace for a session?
Last Answer : Use the DBMS_SESSION.SET_SQL_TRACE or Use ALTER SESSION SET SQL_TRACE = TRUE;
Description : Explain Connect by Prior ?in a session before accessing next value ?
Last Answer : Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.
Description : What is ROWID ?in a session before accessing next value ?
Last Answer : ROWID is a pseudo column attached to each row of a table. It is 18 character long, blockno, rownumber are the components of ROWID.
Description : What are the usage of SAVEPOINTS ?value in a session before accessing next value ?
Last Answer : SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.
Description : How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?
Last Answer : Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.
Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.
Description : How does one create a new database? (for DBA)
Last Answer : One can create and modify Oracle databases using the Oracle "dbca" (Database Configuration Assistant) utility. The dbca utility is located in the $ORACLE_HOME/bin directory. The Oracle Universal ... ='/u02/oradata/'; ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2='/u03/oradata/'; CREATE DATABASE;
Description : Can we create two blocks with the same name in form 3.0 ?
Last Answer : No
Description : How does one create a standby database? (for DBA)
Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;
Description : Name a tablespace automatically created when you create a database.
Last Answer : The SYSTEM tablespace.
Description : What command would you use to create a backup control file?
Last Answer : Alter database backup control file to trace.
Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.
Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.
Description : How does one create and drop database users?
Last Answer : Look at these examples: CREATE USER scott IDENTIFIED BY tiger -- Assign password DEFAULT TABLESACE tools -- Assign space for table and index segments TEMPORARY TABLESPACE temp; -- Assign sort space ... give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools;
Description : What utility is used to create a physical backup?
Last Answer : Either rman or alter tablespace begin backup will do..
Description : The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:
Last Answer : Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space. . Create an Oracle user who would own this repository. Assign ... would trigger the creation of the repository. From now on, Enterprise manager is ready to accept jobs.
Description : How does one create a repository? (for DBA
Last Answer : For OEM v2 and above, start the Oracle Enterprise Manager Configuration Assistant (emca on Unix) to create and configure the management server and repository. Remember to setup a backup for the repository database after creating it.
Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr
Description : How will you create multiple rollback segments in a database ?
Last Answer : Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment ... ) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments.
Description : How does one create a RMAN recovery catalog? (for DBA
Last Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user ... . Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;
Description : Why is it preferable to create a fewer no. of queries in the data model?
Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.
Description : How does one create a password file? (for DBA
Last Answer : The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be ... visible in the process table of many systems. Administrators needs to be aware of this!
Description : A Column is having many repeated values which type of index you should create on this column, if you have to?
Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.
Description : A table is having few rows, should you create indexes on this table
Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.
Description : On which columns you should create Indexes?
Last Answer : In general, you should create an index on a column in any of the following situations: ▪ The column is queried frequently ▪ A referential integrity constraint exists on the column ▪ A UNIQUE key ... ORDER BY clauses ▪ On columns that have few of the same values or unique values in the table
Description : Which default Database roles are created when you create a Database?
Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES
Description : What is the minimum number of instances you need to have in order to create a RAC?
Last Answer : 1. You can create a RAC with just one server.
Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
Last Answer : True
Description : Can Full Backup be performed when the database is open ?
Last Answer : No.
Description : How you open and close a cursor variable.Why it is required?
Last Answer : OPEN cursor variable FOR SELECT...Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.
Description : s it possible to disable the parameter from while running the report?
Last Answer : Yes
Description : What are various joins used while writing SUBQUERIES?
Last Answer : Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though ... in which one or more columns in one table are equal to one or more columns in the second table.
Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?
Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA
Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.
Description : How can a text file be attached to a report while creating in the report writer?
Last Answer : By using the link file property in the layout boiler plate property sheet.
Description : In Ubuntu, how do you create a bash session you can disconnect from and reconnect to remotely without X?
Last Answer : Check screen(1): http://en.wikipedia.org/wiki/Screen_software
Description : Why do you need Session Handling while working with Selenium?
Last Answer : While working with Selenium, you need Session Handling. This is because, during test execution, the Selenium WebDriver has to interact with the browser all the time to execute given commands. At the time of ... and in the same type of browser. So to avoid such a situation you need Session Handling.
Description : While initiating SSL session, the client code recognizes the SSL request and establishes a connection through TCP Part.................to the SSL code on the server. A) 420 B) 1032 C) 443 D) 322
Last Answer : C) 443
Description : While initiating SSL session, the client code recognizes the SSL request and establishes a connection through TCP Part …………….. to the SSL code on the server. A) 420 B) 1032 C) 443 D) 322
Description : 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 ?
Last Answer : Break. SYSTEM VARIABLES
Description : What package procedure is used for calling another form ?
Last Answer : Call (E.g. Call(formname)
Description : When a form is invoked with call_form, Does oracle forms issues a save point?
Description : Can u run the report with out a parameter form
Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null
Description : What is call form stack?
Last Answer : When successive forms are loaded via the CALL_FORM procedure, the resulting module hierarchy is known as the call form stack.
Description : Difference between database triggers and form triggers?
Last Answer : Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen -Can be row ... other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.
Description : Give the Types of modules in a form?
Last Answer : Form Menu Library
Description : Is it possible to attach same library to more than one form?
Description : What is the maximum size of a form ?
Last Answer : 255 character width and 255 characters Length.