which system variables can be set by users?

which system variables can be set by users?
by

1 Answer

Answer :

SYSTEM.MESSAGE_LEVEL
SYSTEM.DATE_THRESHOLD
SYSTEM.EFFECTIVE_DATE
SYSTEM.SUPPRESS_WORKING
by

Related questions

List system variables available in forms 4.0, and not available in forms 3.0?

Description : List system variables available in forms 4.0, and not available in forms 3.0?

Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

List the system variables related in Block and Field?

Description : List the system variables related in Block and Field?

Last Answer : 1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.

State any three mouse events system variables?

Description : State any three mouse events system variables?

Last Answer : System.mouse_button_pressedSystem.mouse_button_shift

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

How you were passing cursor variables in PL/SQL 2.2?

Description : How you were passing cursor variables in PL/SQL 2.2?

Last Answer : In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

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.

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

Give the stages of instance startup to a usable state where normal users may access it.

Description : Give the stages of instance startup to a usable state where normal users may access it.

Last Answer : STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened

Who created all these users in my database?/ Can I drop this user? (for DBA

Description : Who created all these users in my database?/ Can I drop this user? (for DBA

Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.

How does one create and drop database users?

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;

How does one change an Oracle user's password?(for DBA

Description : How does one change an Oracle user's password?(for DBA

Last Answer : Issue the following SQL command: ALTER USER IDENTIFIED BY ; From Oracle8 you can just type "password" from SQL*Plus, or if you need to change another user's password, type "password ... this example: SQL> password Changing password for SCOTT Old password: New password: Retype new password:

How does one add users to a password file? (for DBA

Description : How does one add users to a password file? (for DBA

Last Answer : One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;

You want users to change their passwords every 2 months. How do you enforce this?

Description : You want users to change their passwords every 2 months. How do you enforce this?

Last Answer : Oracle password security is implemented via Oracle "profiles" which are assigned to users. PASSWORD_LIFE_TIME - limits the number of days the same password can be used for authentication First, start ... to detect and remove duplicate rows ▪ Delete duplicate table rows that contain NULL values

Can you assign Priority to users?

Description : Can you assign Priority to users?

Last Answer : YES. This is achievable with Oracle Resource Manager. DBMS_RESOURCE_MANAGER is the packcage to administer the Database Resource Manager. The DBMS_RESOURCE_MANAGER package maintains plans, consumer groups, and ... also provides semantics so that you may group together changes to the plan schema.

How can you view all the current users connected in your database in this moment?

Description : How can you view all the current users connected in your database in this moment?

Last Answer : SELECT COUNT(*),USERNAME FROM V$SESSION GROUP BY USERNAME;

How can you view all the users account in the database?

Description : How can you view all the users account in the database?

Last Answer : SELECT USERNAME FROM DBA_USERS

s it possible to set a filter condition in a cross product group in matrix reports?

Description : s it possible to set a filter condition in a cross product group in matrix reports?

Last Answer : No

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

Can u set default font in forms?

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

What is the built-in used to get and set lov properties during run-time?

Description : What is the built-in used to get and set lov properties during run-time?

Last Answer : Get_lov_property Set_lov_property Record Group

What database events can be set? (for DBA

Description : What database events can be set? (for DBA

Last Answer : The following events are frequently used by DBAs and Oracle Support to diagnose problems: " 10046 trace name context forever, level 4 Trace SQL statements and show bind variables in trace output. " 10046 ... . On Unix, you can type "oerr ora 10053" from the command prompt to get event details.

What is a database EVENT and how does one set it? (for DBA

Description : What is a database EVENT and how does one set it? (for DBA

Last Answer : Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these ... changes to the INIT.ORA file will affect all sessions once the database has been restarted.

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

Atleast how many set of data must a data model have before a data model can be base on it?

Description : Atleast how many set of data must a data model have before a data model can be base on it?

Last Answer : Four

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

What are the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

If a break order is set on a column would it affect columns which are under the column?

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

Which parameter can be used to set read level consistency across multiple queries?

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

VALUE SET LIST TYPES

Description : VALUE SET LIST TYPES

Last Answer :  List of values (10 to 200)  Long list of values (> 200)  Poplist (> 10)

A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Description : A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Last Answer : a) is in 1NF

Name the three major set of files on disk that compose a database in Oracle

Description : Name the three major set of files on disk that compose a database in Oracle

Last Answer : There are three major sets of files on disk that compose a database. All the files are binary. These are ∙ Database files ∙ Control files ∙ Redo logs The most important of these ... actual data resides. The control files and the redo logs support the functioning of the architecture itself.

What is Set-at-a-time or Set-oriented?

Description : What is Set-at-a-time or Set-oriented?

Last Answer : The High level or Non-procedural DML can specify and retrieve many records in a single DML statement. This retrieve of a record is said to be Set-at-a-time or Set-oriented.

What is Relationship set?

Description : What is Relationship set?

Last Answer : The collection (or set) of similar relationships.

What is Weak Entity set?

Description : What is Weak Entity set?

Last Answer : An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

What is an Entity set?

Description : What is an Entity set?

Last Answer : It is a collection of all entities of particular entity type in the database.

Is this statement true or falseA system of linear equations is a set of two or more equations with the same variables, and the graph of each equation is a line?

Description : Is this statement true or falseA system of linear equations is a set of two or more equations with the same variables, and the graph of each equation is a line?

Last Answer : 1

The qualitative or quantitative attribute of a variable or set of variables is termed as A) data B) information C) both of above D) none of above

Description : The qualitative or quantitative attribute of a variable or set of variables is termed as A) data B) information C) both of above D) none of above

Last Answer : Answer : A

A linear programm A linear programming model CANNOT be used when whic ing model CANNOT be used when which of the followin h of the following are true? g are true? a)An optimal production plan is desired b)The values of decision variables are fractional c)A set of linear constraints may be defined d)Cross product relationships exist between two or more decision variables

Description : A linear programm A linear programming model CANNOT be used when whic ing model CANNOT be used when which of the followin h of the following are true? g are true? a)An optimal ... set of linear constraints may be defined d)Cross product relationships exist between two or more decision variables

Last Answer : d)Cross product relationships exist between two or more decision variables

Let Pi and Pj be two processes, R be the set of variables read from memory, and W be the set of variables written to memory. For the concurrent execution of two processes Pi and Pj, which of the following conditions is not true? (A) R(Pi)∩W(Pj)=Φ (B) W(Pi)∩R(Pj)=Φ (C) R(Pi)∩R(Pj)=Φ (D) W(Pi)∩W(Pj)=Φ

Description : Let Pi and Pj be two processes, R be the set of variables read from memory, and W be the set of variables written to memory. For the concurrent execution of two processes Pi and Pj, which of the following conditions is not true? (A) R(Pi)∩W(Pj)=Φ (B) W(Pi)∩R(Pj)=Φ (C) R(Pi)∩R(Pj)=Φ (D) W(Pi)∩W(Pj)=Φ

Last Answer : (C) R(Pi)∩R(Pj)=Φ 

Let P(m,n) be the statement “m divides n” where the Universe of discourse for both the variables is the set of positive integers. Determine the truth values of the following propositions. (a) ∃m ∀n P(m,n) (b) ∀n P(1,n) (c) ∀m ∀n P(m,n) (A) (a)-True; (b)-True; (c)-False (B) (a)-True; (b)-False; (c)-False (C) (a)-False; (b)-False; (c)-False (D) (a)-True; (b)-True; (c)-True

Description : Let P(m,n) be the statement m divides n where the Universe of discourse for both the variables is the set of positive integers. Determine the truth values of the following propositions. (a) ∃m ∀n P(m,n) (b) ∀n P(1,n) ( ... -False (C) (a)-False; (b)-False; (c)-False (D) (a)-True; (b)-True; (c)-True

Last Answer : Answer: A

The value recorded in system.last_record variable is of type

Description : The value recorded in system.last_record variable is of type

Last Answer : a. Number b. Boolean c. Character. ? b. Boolean.

System.effective_date system variable is read only True/False?

Description : System.effective_date system variable is read only True/False?

Last Answer : False

What is the difference between system.current_field and system.cursor_field ?

Description : What is the difference between System.current_field and system.cursor_field ?

Last Answer : 1. System.current_field gives name of the field. 2. System.cursor_field gives name of the field with block name.

It is possible to use raw devices as data files and what is the advantages over file. system files ?

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.

What is system.coordination_operation?

Description : What is system.coordination_operation?

Last Answer : It represents the coordination causing event that occur on the master block in master-detail relation.

What are the system resources that can be controlled through Profile ?

Description : What are the system resources that can be controlled through Profile ?

Last Answer : The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the ... idle time for the user's session the allowed amount of connect time for the user's session.

What is SYSTEM tablespace and when is it created?

Description : What is SYSTEM tablespace and when is it created?

Last Answer : Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.