What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
by

1 Answer

Answer :

1,000,00
by

Related questions

How would you go about increasing the buffer cache hit ratio?

Description : How would you go about increasing the buffer cache hit ratio?

Last Answer : Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

What is meant by redo log buffer ?

Description : What is meant by redo log buffer ?

Last Answer : Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into the redo log files ... buffers in SGA and LGWR will write into files frequently. LOG_BUFFER parameter will decide the size.

What is Buffer Manager?

Description : What is Buffer Manager?

Last Answer : It is a program module, which is responsible for fetching data from disk storage into main memory and deciding what data to be cache in memory.

Name the buffer in which all the commands that are typed in are stored

Description : Name the buffer in which all the commands that are typed in are stored

Last Answer : ‘Edit’ Buffer

What is DB Buffer Cache Advisor?

Description : What is DB Buffer Cache Advisor?

Last Answer : The Buffer Cache Advisor provides advice on how to size the Database Buffer Cache to obtain optimal cache hit ratios. Member of Performance Advisors --> Memory Advisor pack.

What is kept in the Database Buffer Cache?

Description : What is kept in the Database Buffer Cache?

Last Answer : The database buffer cache is the portion of the SGA that holds copies of data blocks read from datafiles. All user processes concurrently connected to the instance share access to the database buffer cache.

How can you enable a trace for a session?

Description : How can you enable a trace for a session?

Last Answer : Use the DBMS_SESSION.SET_SQL_TRACE or Use ALTER SESSION SET SQL_TRACE = TRUE;

How can you enable automatic archiving ?

Description : How can you enable automatic archiving ?

Last Answer : Shut the database Backup the database Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file. Start up the database.

Can you disable and enable Primary key?

Description : Can you disable and enable Primary key?

Last Answer : You can use the ALTER TABLE statement to enable, disable, modify, or drop a constraint. When the database is using a UNIQUE or PRIMARY KEY index to enforce a constraint, and constraints associated ... and any FOREIGN KEY constraints that depend on it: ALTER TABLE dept DISABLE PRIMARY KEY CASCADE;

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 are the values that can be specified for OPTIMIZER MODE Parameter ?

Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?

Last Answer : COST and RULE.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Description : What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Last Answer : CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

What is the maximum size of a form ?

Description : What is the maximum size of a form ?

Last Answer : 255 character width and 255 characters Length.

Lawn sprinkler systems are installed so as to provide even coverage. It is accomplished by: a. Spacing the heads so that each sprinkler sprays to the next sprinkler b. Using sprinkler heads with a square pattern throughout the landscape c. Spacing sprinklers based on needs specified in the soil test d. Using one size pipe throughout the landscape

Description : Lawn sprinkler systems are installed so as to provide even coverage. It is accomplished by: a. Spacing the heads so that each sprinkler sprays to the next sprinkler b. Using sprinkler heads ... sprinklers based on needs specified in the soil test d. Using one size pipe throughout the landscape

Last Answer : Spacing the heads so that each sprinkler sprays to the next sprinkler

Main function of proxy application gateway firewall is a. to allow corporate users to use efficiently all internet services b. to allow intranet users to securely use specified internet services c. to allow corporate users to use all internet services d. to prevent corporate users from using internet services

Description : Main function of proxy application gateway firewall is a. to allow corporate users to use efficiently all internet services b. to allow intranet users to securely use specified internet services ... to use all internet services d. to prevent corporate users from using internet services

Last Answer : b. to allow intranet users to securely use specified internet services 

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?

Description : Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?

Last Answer : Yes

How to define data block size?

Description : How to define data block size?

Last Answer : A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

What database block size should I use? (for DBA)

Description : What database block size should I use? (for DBA)

Last Answer : Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should ... 8K. This is because volume manager products use 8K blocks (and this is not configurable).

How to define Data Block size ?

Description : How to define Data Block size ?

Last Answer : A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can’t be changed latter.

Plotter accuracy is measured in terms of repeatability and A) Buffer size B) Resolution C) Vertical dimensions D) Intelligence

Description : Plotter accuracy is measured in terms of repeatability and A) Buffer size B) Resolution C) Vertical dimensions D) Intelligence

Last Answer : Answer : B

Plotter accuracy is measured in terms of repeatability and a. Buffer size b. Resolution c. Vertical dimensions d. Intelligence

Description : Plotter accuracy is measured in terms of repeatability and a. Buffer size b. Resolution c. Vertical dimensions d. Intelligence

Last Answer : b. Resolution

The virtual address generated by a CPU is 32 bits. The Translation Lookaside Buffer (TLB) can hold total 64 page table entries and a 4-way set associative (i.e. with 4- cache lines in the set). The page size is 4 KB. The minimum size of TLB tag is (A) 12 bits (B) 15 bits (C) 16 bits (D) 20 bits

Description : The virtual address generated by a CPU is 32 bits. The Translation Lookaside Buffer (TLB) can hold total 64 page table entries and a 4-way set associative (i.e. with 4- cache lines in the set). The page size is 4 KB. The minimum size of TLB tag is (A) 12 bits (B) 15 bits (C) 16 bits (D) 20 bits

Last Answer : (C) 16 bits Explanation: VirtualAddress = 32 bits PageSize = 4KB = 12 bits therefore : VPNTag = 20 bits, OffsetTag = 12 bits TLBEntryLength = VPNTag = 20 bits TotalTLBEntries = 64, 4-way implies ... therefore : TLBIndex = 4 bits TLBTag = TLBEntryLength - TLBIndex = 20 - 4 = 16 bits

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.

How many maximum number of radio buttons can you assign to a radio group?

Description : How many maximum number of radio buttons can you assign to a radio group?

Last Answer : Unlimited no of radio buttons can be assigned to a radio group

List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

What is the Maximum allowed length of Record group Column?

Description : What is the Maximum allowed length of Record group Column?

Last Answer : Record group column names cannot exceed 30 characters.

What is the maximum no of chars the parameter can store?

Description : What is the maximum no of chars the parameter can store?

Last Answer : The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

How many maximum Redo Logfiles one can have in a Database?

Description : How many maximum Redo Logfiles one can have in a Database?

Last Answer : Maximum number of logfiles is limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement. Control file can be resized to allow more entries; ultimately an operating system limit. ... for the CREATE DATABASE statement, then the database uses an operating system default value.

How many Maximum Datafiles can there be in Oracle Database?

Description : How many Maximum Datafiles can there be in Oracle Database?

Last Answer : Regardless of the setting of this paramter, maximum per database: 65533 (May be less on some operating systems) Maximum number of datafiles per tablespace: OS dependent = usually 1022 Limited also ... instance Bigfile tablespaces can contain only one file, but that file can have up to 4G blocks.

Use the add_group_column function to add a column to record group that was created at a design time?

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

What is the function of Optimizer ?

Description : What is the function of Optimizer ?

Last Answer : The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

What is the function of redo log?

Description : What is the function of redo log?

Last Answer : The primary function of the redo log is to record all changes made to data.

How is mapping of name of DLL and function done?

Description : How is mapping of name of DLL and function done?

Last Answer : The dll can be created using the Visual C++ / Visual Basic Tools and then the dll is put in the path that is defined the registery.

Can you pass values to-and-fro from foreign function ? how ?

Description : Can you pass values to-and-fro from foreign function ? how ?

Last Answer : Yes . You obtain a return value from a foreign function by assigning the return value to an Oracle Forms variable or item. Make sure that the Oracle Forms variable or item is the same data type as ... SQL data type; it must also be the appropriate parameter type as defined in the PL/SQL interface.

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

What is syntax for dropping a procedure and a function .Are these operations possible?

Description : What is syntax for dropping a procedure and a function .Are these operations possible?

Last Answer : Drop Procedure procedure_name Drop Function function_name

Difference between procedure and function.?

Description : Difference between procedure and function.?

Last Answer : Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

What is difference between a PROCEDURE & FUNCTION ?

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

Give the structure of the function ?

Description : Give the structure of the function ?

Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;

What is the built-in function used for finding the alert?

Description : What is the built-in function used for finding the alert?

Last Answer : Find_alert Editors

Identify package function from the following ?

Description : Identify package function from the following ?

Last Answer : 1. Error- Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code? 1. Error_Code 2. Error_Text 3. Form_Failure 4. Form_Fatal 5. Message_Code

What is the difference between a Function Key Trigger and Key Function Trigger ?

Description : What is the difference between a Function Key Trigger and Key Function Trigger ?

Last Answer : Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.

What are the built-ins used for finding Object ID function?

Description : What are the built-ins used for finding Object ID function?

Last Answer : FIND_GROUP(function) FIND_COLUMN(function)

With which function of summary item is the compute at options required?

Description : With which function of summary item is the compute at options required?

Last Answer : ummary item is the compute at options required?

What is the function of BL buffer in DNA extraction?

Description : What is the function of BL buffer in DNA extraction?

Last Answer : In a DNA extraction, the purpose of a buffer is to solubilizeDNA as well as RNA. Because of this, it prevents the DNA fordegrading.

What is the function of BL buffer in DNA extraction?

Description : What is the function of BL buffer in DNA extraction?

Last Answer : In a DNA extraction, the purpose of a buffer is to solubilizeDNA as well as RNA. Because of this, it prevents the DNA fordegrading.