|
Tablespace fragmentation can be prevented by using PCTINCREASE command....
|
|
An extent is stored some specific information. This information is stored using specific number of adjoining data blocks...
|
|
Roles in Oracle can be used to grant privileges to a specific group of users for security.......
|
|
A snapshot log is a copy of the master table. The snapshot table is updated using batch updates....
|
|
Open_form opens the indicated form. Call_form not just opens the indicated form, but also keeps the parent form alive.....
|
|
Post-form commit fires once during the post and commit transactions process, after the database commit occurs......
|
|
Advantage of having disk shadowing/Mirroring....
|
|
A cursor variable works like pointer in C. It is used to hold address of an item rather than the item itself.....
|
|
When a sequence is created using CYCLE option, values for the column are regenerated from MINVALUE.....
|
|
A cold backup is done when there is no user activity going on with the system......
|
|
SQL*Loader can be used to load data from Delimiter separated files and fixed or variable width text....
|
|
In a Bitmap index, a 2 dimensional array is created. The array represents the index value multiplied by number of rows...
|
|
Normal cursors fall under the category of static cursors while REF cursors are dynamic.....
|
|
GLOBAL TEMPORARY TABLE is used to store temporary data in scenarios where complex calculation is involved....
|
|
Pragma init exception is used to associate a user defined exception with an error number and a custom message....
|
|
Triggers can execute every time some field in database is updated. If a field is likely to be updated often, it is a system overhead.......
|
|
Apart from IN, OUT, IN OUT parameters, oracle 8i offers another parameter called NOCOPY.....
|
|
Raise_application_error allows users to create custom error messages...
|
|
View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables.....
|
|
What are the kinds of roles in oracle? - Following are the kinds of roles available in oracle: ....
|
|
Define primary key and foreign key - A column or combination of columns that identify a row of data in a table is Primary Key. A key in a table that identifies records in other table in called a foreign key....
|
|
Explain how to DISABLE and ENABLE constraint in Oracle - Disable a constraint by using the DISABLE clause......
|
|
Define Statement Auditing, Privilege Auditing and Object Auditing in oracle - Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.....
|
|
Retrieve 5th highest sal from emp table - SELECT DISTINCT (emp1.sal) FROM EMP emp1 WHERE &N = (SELECT COUNT (DISTINCT (emp2.sal))...
|
|
What is $FLEX$ and $PROFILES$? - $FLEX$ is used to get a value used in the previous value set. It is usually used to retrieve the Flex value contained in an AOL value...
|
|
Trigger inside a stored procedure - A trigger cannot be called within a stored procedure. Triggers are executed automatically as a result of DML or DDl commands...
|
|
What is WATER MARK IN oracle? - WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once...
|
|
What is an object groups? - Object group is a container for a group of objects....
|
|
Difference between clustering and mirroring - Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s
responds...
|
|
Difference between paging and fragmentation - Paging is a concept occurring in memory, whereas, Fragmentation occurs on disk level...
|
|
How to insert an image in table? - Insert image into a table: Create the following table: create table pics_table (bfile_id number...
|
|
Second largest value in the table - SELECT * FROM EMP WHERE SAL IN (SELECT MAX(SAL) FROM EMP...
|
|
Disadvantage of user defind function in oracle - Disadvantage of UDF in Oracle: Oracle does not support calling UDFs with Boolean parameters or return types...
|
|
Cluster table or non cluster table - A Cluster provides an alternate method of storing table data. It is made up of a group of tables that share the same data...
|
|
Pragma restrict_reference - Pragma restrict_reference is used to check for violations of any rules applied, at compile time. It’s used in functions to obey some...
|
|
Not null constraint - Not NULL is a column level constraint to ensure that any value in that column is not null...
|
|
The between-page trigger is used for creating conditional formatting, eg: retrieving information...
|
|
Delete all duplicate records using subquery - Query: DELETE from table1 where rowid not in (select MAX(rowid) from table1 GROUP BY column_name);...
|
|
Types of trigger can be used in a table - We can use maximum of 12 triggers on a table. • BEFORE INSERT • AFTER INSERT...
|
|
Partitioned table - Partitioning allows decomposing large tables and indexes into smaller manageable units called partitions...
|
|
What is the role of Archiver [ARCn]? - ARCn is an oracle background process responsible for copying the entirely filled online redo log file to the archive log...
|
|
Difference between bitmap and btree index - Btree It is made of branch nodes and leaf nodes. Branch nodes holds prefix key value along with the link to the leaf node. The leaf node in
turn...
|
|
Convert oracle table data into excel sheet - There are 2 ways to do so: 1. Simply use the migration wizard shipped with Oracle...
|
|
Hash partitioning - Scenarios for choosing hash partitioning: Not enough knowledge about how much data maps into a give range...
|
|
Materialized view and snapshot - A materialized view is a database object that contains the results of a query. A snapshot is similar to materialized view...
|
|
NO archive log mode - 1. Less disk space is consumed 2. Causes database to freeze if disk gets full...
|
|
Advantages of running a database in archive log mode - It makes it possible to recover database even in case of disk failure...
|
|
What is dba_segment in oracle? - DBA_SEGMENTS tells about the space allocated for all segments in the database for storage...
|
|
What is dba_segment in oracle? - DBA_SEGMENTS tells about the space allocated for all segments in the database for storage...
|
|
Purpose of using Nextval - NextVal gives you the available number in the sequence asked for...
|
|
What is forall Statement? - The FORALL binds input as a collection and sends them to the SQL engine for processing...
|
|
What is flashback Query? - Oracle Flashback Query allows users to see a consistent view of the database as it was at a point in the past...
|
|
Tablespace purposes and significances - A tablespace is a logical container unit within an Oracle database. It does not exist physically on a filesystem...
|
|
Sequence and sequence cache - Seqences are often used to generate autonumber fields. A sequence is an object in Oracle used to create a number sequence...
|
|
Formula column and place holder - Difference between formula column and place holder...
|
|
Placeholder columns in oracle - Steps to create placeholder columns: Click inside the container group at the position where you want the column to be placed...
|
|
What is autonomous transaction? - Autonomous transactions have the ability to leave the context of calling transaction, then perform an independent transaction...
|
|
How to create LOV in Oracle forms? - List of Values(LOV) are used either when a selected list is too long and hence would not be appropriate for a drop down, but needs a search form to select the value...
|
|
Sql command to print out from oracle - PRINT: ...
|
|
sql*loader parameters - SQL Loader is used for the following: • Load data across a network. • Load data from multiple data files during a single load session...
|
|
Report output in excel sheet in oracle applications - It is a two step process: 1. Export Oracle Report to text file...
|
|
Restore a Table that accidantly dropped - An accidently dropped table can only be recovered from the backup. It is easier to recover tables in Oracle 10g...
|
|
Use of Data Link in Reports - Data links are used to establish parent-child relationships between queries...
|
|
Type of triggers - Types of triggers in Oracle reports: - 1 before parameter form 2 after parameter form...
|
|
Trigger associated with image items - There are 2 triggers associated with image items: • When-Image-Activated: Triggered when image is double clicked...
|
|
Status of the Rollback segment - SELECT segment_name, status FROM sys.dba_rollback_segs;...
|
|
Use of NOARCHIEVELOG parameter - On media failures while the database in NOARCHIVELOG mode, only database to the point of the most recent full database...
|
|
SMON process - The Shared Global Area is where SMON process runs. Once the redo log buffer is full...
|
|
Types of Calculated columns - In forms there are 2 types of calculated columns 1. formula column 2.summary column...
|
|
Difference between trigger and stored procedure - Procedure runs only when one call them manually whereas a trigger runs when there is any activity (insert,update,delete) on table on which the trigger is written...
|
|
Row level and statement level trigger - Row Level Trigger is fired each time row is affected by Insert, Update or Delete command...
|
