What is the use of GRANT option in IMP command ?

What is the use of GRANT option in IMP command ?
by

1 Answer

Answer :

A flag to indicate whether grants on database objects will be imported
by

Related questions

What is the use of SHOW option in IMP command ?

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.

What is the use of INDEXES option in IMP command ?

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.

What is the use of ROWS option in IMP command ?

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.

What is the use of IGNORE option in IMP command ?

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.

What is the use of FILE option in IMP command ?

Description : What is the use of FILE option in IMP command ?

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

What is the use of GRANT option in EXP command?

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'.

What is the use of TABLES option in EXP command ?

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

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

What is the use of PARFILE option in EXP command ?

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

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

What is the use of CONSISTENT (Ver 7) option in EXP command ?

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.

What is the use of CONSTRAINTS option in EXP command ?

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.

What is the use of FULL option in EXP command ?

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

Last Answer : A flag to indicate whether full databse export should be performed.

What is the use of INDEXES option in EXP command ?

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

Last Answer : A flag to indicate whether indexes on tables will be exported.

What is the use of ANALYSE ( Ver 7) option in EXP command ?

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.

What is the use of COMPRESS option in EXP command ?

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.

What is the use of ROWS option in EXP command ?

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.

What is the use of RECORD 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.

What is the use of PARFILE option in EXP command ?

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

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

What is the use of RECORD LENGTH option in EXP command ?

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

Last Answer : Record length in bytes.

What is the use of INCTYPE option in EXP command ?

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.

Diff. between VAT and Property Class? imp

Description : Diff. between VAT and Property Class? imp

Last Answer : Named visual attributes define only font, color, and pattern attributes; property classes can contain these and any other properties. You can change the appearance of objects at runtime by ... visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

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 ?

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

What command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

What use of command line parameter cmd file?

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.

WWhat is the use of ANALYZE command ?

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.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

What command would you use to check the availability of the RAC system?

Description : What command would you use to check the availability of the RAC system?

Last Answer : crs_stat -t -v (-t -v are optional)

What command will you use to navigate through ASM files?

Description : What command will you use to navigate through ASM files?

Last Answer : asmcmd

When creating a user, what permissions must you grant to allow them to connect to the database?

Description : When creating a user, what permissions must you grant to allow them to connect to the database?

Last Answer : Grant the CONNECT to the user.

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

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.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

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.

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 ?

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.

Some Basics command of ORACLE 10g on Windows Operating System:

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)

What command will you start to run the installation of Oracle software on Linux?

Description : What command will you start to run the installation of Oracle software on Linux?

Last Answer : runInstaller

What is the lock option in reports layout

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 .

What is the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMAC.CREATE CLUSTERD.All of theaboveE.None of the above;

Description : In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMA C. CREATE CLUSTER D. All of theabove E. None of the above;

Last Answer : CREATE SCHEMA

As a teacher, select the best option to ensure your effective presence in the classroom. (A) Use of peer command (B) Making aggressive statements (C) Adoption of well-established posture (D) Being authoritarian

Description : As a teacher, select the best option to ensure your effective presence in the classroom. (A) Use of peer command (B) Making aggressive statements (C) Adoption of well-established posture (D) Being authoritarian

Last Answer : (C) Adoption of well-established posture

Mark the correct option remittances sent by post a) When a remittance is to be sent by post, the money should be placed in Leather cash bag and cash sealed by treasure. b) The remittance advice and acknowledgement dispatch inside of Regd bag. c) When remittances is to be sent in charge of a special carrier, the amount should be made over to the carrier and he should be required to grant a receipt for the same in treasurer cash book. d) All the above

Description : Mark the correct option remittances sent by post a) When a remittance is to be sent by post, the money should be placed in Leather cash bag and cash sealed by treasure. b) The remittance advice and ... he should be required to grant a receipt for the same in treasurer cash book. d) All the above

Last Answer : d) All the above

Mark the correct option a) No one can be claim the max number days casual leave as a matter of rightb) Casual Leave should not be sanctioned more than 5 days at a timec) The persons appointed middle of the year the authority competent to sanctionGrant such leave will have discretion to grant either the full period or 8 daysOr only proportiond) CL not a form of leave and not treaded as absente) All the above;

Description : Mark the correct option a) No one can be claim the max number days casual leave as a matter of right b) Casual Leave should not be sanctioned more than 5 days at a time c) The persons appointed middle ... days Or only proportion d) CL not a form of leave and not treaded as absent e) All the above;

Last Answer : e) All the above;

What option does the central government does not include in development expenditure? A) Grant to States B) Expenditure on Social and Community Services C) Expenditure on Economic Services D) Defence Expenditure

Description : What option does the central government does not include in development expenditure? A) Grant to States B) Expenditure on Social and Community Services C) Expenditure on Economic Services D) Defence Expenditure

Last Answer : Answer: D

Who were the outsiders being referred to as dikus? [Imp.] -History

Description : Who were the outsiders being referred to as dikus? [Imp.] -History

Last Answer : Traders, moneylenders, missionaries, Hindu landlords, and the British were the outsiders being referred to as dikus.

How did partition change the lives and occupations of the refugees? [Imp.] -History

Description : How did partition change the lives and occupations of the refugees? [Imp.] -History

Last Answer : The partition caused massive transfer of populations on both sides of the new border. Muslims left Delhi for Pakistan while their place was taken by equally large numbers of Sikh and Hindu refugees ... their occupation. They had to take up new jobs as hawkers, vendors, carpenters and ironsmiths.

Why did Machlipatnam lose its importance as a port-town by the late 18th century? [V.Imp.] -History

Description : Why did Machlipatnam lose its importance as a port-town by the late 18th century? [V.Imp.] -History

Last Answer : It was because the British shifted their trade to the new ports of Bombay, Madras and Calcutta.

1. Describe governance in the Mauryan empire. [V. Imp.] -History

Description : 1. Describe governance in the Mauryan empire. [V. Imp.] -History

Last Answer : The Mauryan empire consisted of severed different parts which were ruled over differently. The Empire's capital. The areas adjacent to Pataliputra, the capital of the empire, were under the direct ... , , which were vital for transport. Resources, whatever available, were collected as a tribute.

2. How was Ashoka unique? [V. Imp.] -History

Description : 2. How was Ashoka unique? [V. Imp.] -History

Last Answer : Ans: Ashoka was the most famous Mauryan ruler. He was known to take his message amongst the people through inscriptions. His inscriptions were in the people's language Prakrit. Ashoka also remains the only ... in the Kalinga war. Ashoka then became a Buddhist and got the idea of the dhamma'.

8.What was the purpose of Ashoka’s ‘dhamma’? [V. Imp.] -History

Description : 8.What was the purpose of Ashoka’s ‘dhamma’? [V. Imp.] -History

Last Answer : Ans: Ashoka wished to instruct his subjects, for which he introduced his ‘dhamma’.

7. What change came upon Ashoka after the Kalinga war?[V. Imp.] -History

Description : 7. What change came upon Ashoka after the Kalinga war?[V. Imp.] -History

Last Answer : Ans: Ashoka saw that there was a lot of violence in the war and many people were killed. So he decided he would not fight any more wars,

6. What was special about Ashoka as a ruler? [V. Imp.] -History

Description : 6. What was special about Ashoka as a ruler? [V. Imp.] -History

Last Answer : Ans: Ashoka was the first ruler who tried to take his message to his subject through inscriptions.