How many minimum groups are required for a matrix report

1 Answer

Answer :

The minimum number of groups in matrix report are 4

Related questions

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

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

Last Answer : No

Description : What are the two repeating frame always associated with matrix object?

Last Answer : One down repeating frame below one across repeating frame.

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Description : Can u have more than one layout in report

Last Answer : It is possible to have more than one layout in a report by using the additional layout option in the layout editor.

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

Description : How can a button be used in a report to give a drill down facility?

Last Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

Description : How can a text file be attached to a report while creating in the report writer?

Last Answer : By using the link file property in the layout boiler plate property sheet.

Description : How can a square be drawn in the layout editor of the Report writer?

Last Answer : By using the rectangle tool while pressing the (Constraint) key.

Description : Is it possible to modify an external query in a report which contains it?

Last Answer : No.

Description : What are the ways to monitor the performance of the report?

Last Answer : Use reports profile executable statement. Use SQL trace facility.

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

Description : What are record groups ? * Can record groups created at run-time?

Last Answer : A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to ... you define its structure and row values at design time, and they remain fixed at runtime.

Description : Give built-in routine related to a record groups?

Last Answer : Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) Add_group_column(Function) Add_group_row(Procedure) Delete_group_row(Procedure) Populate_group(Function) Populate_group_with_query(Function) Set_group_Char_cell(procedure)

Description : What are the built -ins used for Modifying a groups structure?

Last Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

Description : What are the built-ins used for Creating and deleting groups?

Last Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

Description : If two groups are not linked in the data model editor, What is the hierarchy between them?

Last Answer : Two group that is above are the left most rank higher than the group that is to right or below it.

Description : The minimum number of scalar multiplication required, for parenthesization of a matrix-chain product whose sequence of dimensions for four matrices is is (1) 630 (2) 580 (3) 480 (4) 405 

Last Answer : (4) 405 

Description : What are the minimum parameters should exist in the parameter file (init.ora) ?

Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

Description : What is the minimum number of instances you need to have in order to create a RAC?

Last Answer : 1. You can create a RAC with just one server.

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 : How you open and close a cursor variable.Why it is required?

Last Answer : OPEN cursor variable FOR SELECT...Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

Description : What is a cursor ? Why Cursor is required ?

Last Answer : Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

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 : With which function of summary item is the compute at options required?

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

Description : What is the basic data structure that is required for creating an LOV?

Last Answer : Record Group.

Description : Matrix report:

Last Answer : A matrix (cross-product) report is a cross tabulation of four groups of data: a. One group of data is displayed across the page. b. One group of data is displayed down the page. c. One group of data is the cross-product, which

Description : What is difference between Tablular and Matrix report? OR What are the different styles of reports?

Last Answer : Tablular report: A tabular report is the most basic type of report. Each column corresponds to a column selected from the database.

Description : The pattern of groups that have odd parity calledthe ses must match one of the of columns in the parity check matrix: a. Syndrome b. Dynodes c. Both d. None of these

Last Answer : a. Syndrome

Description : What do ‘Cash Cows’ symbolize in The Boston Consulting Group's product portfolio matrix? a) Remain Invested b) Problem Child c) Stable Cash Flow d) Cash Traps

Last Answer : c) Stable Cash Flow

Description : __________ is the form of departmentalization that groups similar jobs and activities into departments. (a) A product structure ; (b) A divisional structure ; (c) A matrix structure ; (d) A functional structure 

Last Answer : (d) A functional structure 

Description : If the body is in a state of equilibrium then the energy is minimum. This statement isconsidered in . a.inverse matrix method b.weighted residual method c.Galerkin’s principle d.the minimum potential energy principle

Last Answer : d.the minimum potential energy principle

Description : Which of the following is not a method for calculation of the stiffness matrix? a.The minimum potential energy principle b.Galerkin's principle c.Weighted residual method d.Inverse matrix method

Last Answer : d.Inverse matrix method

Description : How many minimum numbers of zeros are there in ‘3 x 3’ triangular matrix? a.4 b.3 c.5 d.6

Last Answer : b.3

Description : A 1000 × 1000 bus admittance matrix for an electric power system has 8000 non-zero elements. The minimum number of branches (transmission lines and transformers) in this system are _____ (up to 2 decimal places)

Last Answer : Ans: 3500.00

Description : 100 students, 32 oral groups. If I write reports for half the students in the group (50), what's the probability I will end up writing a report for at least someone in each oral group?

Last Answer : answer:I don't have enough time right now to work out a solution, but here is what I quickly figured out: There 28 groups of three students and 4 groups of four students. Assuming the ... mathematically independent. I think that I can have the results of a computer simulation in a few hours.

Description : When you need to create thousands of ad groups, what is the best tool to use? A. Bulk interface creator B. Report editor C. Keyword Planner D. Google Ads Edito

Last Answer : D. Google Ads Edito

Description : Tissues are constructed from many distinct cell types that perform different functions in response to signals from each other and the extracellular matrix. During tissue development and tissue regeneration, ... that stem cells undergo when they are required to generate a particular type of cell?

Last Answer : Asymmetric cell division. After asymmetric division, each of the two resulting daughter cells has a unique life course. For example, one daughter cell may differentiate into a specific cell type ( ... cell), whereas the other daughter cell may remain a stem cell with unlimited proliferative ability.

Description : The transformation matrix required for conversion of CMY colour model to RGB colour model is given as

Last Answer : Answer: C

Description : Find out number of data lines required to interface 16 LEDs arrange in the 4 x 4 matrix form.

Last Answer : 4+4=8, eight lines are required for 4x4 matrix of 16 LEDs