Description : What is the use of PARFILE option in EXP command ?
Last Answer : Name of the parameter file to be passed for export.
Description : What is the use of CONSISTENT (Ver 7) option in EXP command ?
Last Answer : A flag to indicate whether a read consistent version of all the exported objects should be maintained.
Description : What is the use of CONSTRAINTS option in EXP command ?
Last Answer : A flag to indicate whether constraints on table need to be exported.
Description : What is the use of FULL option in EXP command ?
Last Answer : A flag to indicate whether full databse export should be performed.
Description : What is the use of GRANT option in EXP command?
Last Answer : A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.
Description : What is the use of INDEXES option in EXP command ?
Last Answer : A flag to indicate whether indexes on tables will be exported.
Description : What is the use of ANALYSE ( Ver 7) option in EXP command ?
Last Answer : A flag to indicate whether statistical information about the exported objects should be written to export dump file.
Description : What is the use of COMPRESS option in EXP command ?
Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.
Description : What is the use of ROWS option in EXP command ?
Description : What is the use of RECORD option in EXP command?
Last Answer : For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.
Description : What is the use of RECORD LENGTH option in EXP command ?
Last Answer : Record length in bytes.
Description : What is the use of INCTYPE option in EXP command ?
Last Answer : Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into anotion Completes. e. will be written.
Description : What is the use of SHOW option in IMP command ?
Last Answer : A flag to indicate whether file content should be displayed or not.
Description : What is the use of GRANT option in IMP command ?
Last Answer : A flag to indicate whether grants on database objects will be imported
Description : What is the use of INDEXES option in IMP command ?
Last Answer : A flag to indicate whether import should import index on tables or not.
Description : What is the use of ROWS option in IMP command ?
Last Answer : A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed.
Description : What is the use of IGNORE option in IMP command ?
Last Answer : A flag to indicate whether the import should ignore errors encounter when issuing CREATE commands.
Description : What is the use of FILE option in IMP command ?
Last Answer : The name of the file from which import should be performed.
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 : Give the two types of tables involved in producing a star schema and the type of data they hold.
Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
Description : What are mutating tables
Last Answer : When a table is in state of transition it is said to be mutating. eg :: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select.
Description : What is the difference between deleting and truncating of tables
Last Answer : Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.
Description : What is in all those X$ tables? (for DBA
Last Answer : The following list attempts to describe some x$ tables. The list may not be complete or accurate, but represents an attempt to figure out what information they contain. One should generally not ... Fixed Table. It can predict the potential loss of decreasing the number of database buffers. The
Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.
Description : What are two virtual tables available during database trigger execution ?
Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.
Description : Name the tables where characteristics of Package, procedure and functions are stored ?
Last Answer : User_objects, User_Source and User_error.
Description : How will you estimate the space required by a non- clustered tables?
Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.
Description : What are the dictionary tables used to monitor a database space?
Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.
Description : What are the dictionary tables used to monitor a database spaces ?
Description : How does one get the view definition of fixed views/tables?
Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';
Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii
Last Answer : a) i& ii b) ii & iii
Description : Tables derived from the ERD
Last Answer : a) Are totally unnormalised b) Are always in 1NF c) Can be further denormalised d) May have multi-valued attributes (b) Are always in 1NF
Description : How do you move tables from one tablespace to another tablespace?
Last Answer : There are several methods to do this; 1) export the table, drop the table, create the table definition in the new tablespace, and then import the data (imp ignore=y). 2) Create ... table and rename the temporary table as the original: DROP TABLE real_table; RENAME temp_name TO real_table;
Description : Can you make collection of Statistics for tables automatically?
Last Answer : YES. Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time. There are two scheduled activities related to ... GATHER_STATS_JOB'); Oracle collects optimizer statistics for SQL via the default of autostats_target = auto.
Description : Name the seven types of Oracle tables
Last Answer : Heap Organized Tables, Index Organized Tables, Index Clustered Tables, Hash Clustered Tables, Nested Tables, Global Temporary Tables, Object Tables.
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 command would you use to encrypt a PL/SQL application?
Last Answer : WRAP
Description : What command would you use to create a backup control file?
Last Answer : Alter database backup control file to trace.
Description : What use of command line parameter cmd file?
Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
Description : WWhat is the use of ANALYZE command ?
Last Answer : To perform one of these function on an index,table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary. - To delete statistics about the ... the structure of the object. - To identify migrated and chained rows of the table or cluster.
Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?
Last Answer : srvctl
Description : What command would you use to check the availability of the RAC system?
Last Answer : crs_stat -t -v (-t -v are optional)
Description : What command will you use to navigate through ASM files?
Last Answer : asmcmd
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 : 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 : Some Basics command of ORACLE 10g on Windows Operating System:
Last Answer : SQL> show parameter db_name SQL> show parameter instance_name SQL> show parameterdb_block_size (it will show the default block size which is 8KB)
Description : What command will you start to run the installation of Oracle software on Linux?
Last Answer : runInstaller
Description : What is the lock option in reports layout
Last Answer : By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .