What command will you use to navigate through ASM files?

1 Answer

Answer :

asmcmd

Related questions

Description : What is mouse navigate property of button?

Last Answer : When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse. When Mouse Navigate is set ... the resulting validation) to move to the item when an operator activates the item with the mouse.

Description : Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Last Answer : False

Description : ASM-H widely used ___ assembler: a. 8§/370 b $/380 c. $/390 d. S/360

Last Answer : a. 8§/370

Description : Which file is used to store the user entered password? A. .exe B. .txt C. .iso D. .asm

Last Answer : D. .asm

Description : What is the use of TABLES option in EXP command ?

Last Answer : List of tables should be exported.ze)

Description : What is the use of PARFILE option in EXP command ?

Last Answer : Name of the parameter file to be passed for export.

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 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 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 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 IMP command ?

Last Answer : A flag to indicate whether grants on database objects will be imported

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 IMP command ?

Last Answer : A flag to indicate whether import should import index on tables or not.

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 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 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 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 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 ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

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 PARFILE option in EXP command ?

Last Answer : Name of the parameter file to be passed for 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 FILE option in IMP command ?

Last Answer : The name of the file from which import should be performed.

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 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 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 : It is possible to use raw devices as data files and what is the advantages over file. system files ?

Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.

Description : What Oracle tool will you use to transform datafiles into text files?

Last Answer : Trick question: you can’t do that, at least with any Oracle tool. A very experienced DBA should perfectly know this.

Description : Online service that helps you navigate through everyday red tape and paperwork. Would you use it?

Last Answer : answer:It seems unrealistic to think of a one stop shop. Legalzoom and other already cover a lot of those things. And other things, like getting a passport or a Driver's License or a state ... also either way too much for something this already free, or way too little for more complicated things.

Description : How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Last Answer : The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On Unix the default file mask for these files are "rwx r-- -- ... = true Include this in your INIT.ORA file and bounce your database for it to take effect.

Description : Can one resize tablespaces and data files? (for DBA)

Last Answer : One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE 'filename2' RESIZE 100M; Because you can change the ... UNLIMITED DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) ONLINE PERMANENT;

Description : Name two files used for network connection to a database.

Last Answer : TNSNAMES.ORA and SQLNET.ORA

Description : You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Last Answer : I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

Description : What are the characteristics of data files?

Last Answer : A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Description : How to implement the multiple control files for an existing database ?

Last Answer : Shutdown the database Copy one of the existing control file to new location Edit Config ora file by adding new control file. name Restart the database.

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

Description : What are the default extensions of the files created by menu module?

Last Answer : .mmb, .mmx

Description : I've lost my REDOLOG files, how can I get my DB back? (for DBA

Last Answer : The following INIT.ORA parameter may be required if your current redo logs are corrupted or blown away. Caution is advised when enabling this parameter as you might end-up losing your entire database. Please contact Oracle Support before using it. _allow_resetlogs_corruption = true