• web technology Online Quiz - 7
Back
0

web technology Online Quiz - 7

Description: web technology Online Quiz - 7
Number of Questions: 20
Created by:
Tags: web technology
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which one is true ?

technology web technology

  1. A view can be created as a join on two or more tables

  2. A view can't be created as a join on two or more tables

  3. A view can't have an ORDER BY clause in SELECT statement

  4. A view can't be created with a GROUP BY clause in SELECT statement

Show answer
Correct Option: A

You have dropped a table from where a VIEW was created . What would be the status of that VIEW

technology web technology

  1. View dropped also

  2. View becomes invalid

  3. View remains as it is

  4. View is accessible

Show answer
Correct Option: B

The EMPLOYEE table contains info about employees. One of your employees got married , so her last name changed . What would be the command to reflect that change in the table ?

technology web technology

  1. UPDATE

  2. ALTER

  3. INSERT

  4. CREATE

Show answer
Correct Option: A

Java does not have multiple inheritance

technology web technology

  1. True

  2. False

Show answer
Correct Option: A

Hello '\n' Hello

technology web technology

  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

  6. 6

Show answer
Correct Option: B

True or False? Characteristic variables cannot be created directly from the Query Designer tool.

technology web technology

  1. True

  2. False

Show answer
Correct Option: B

Characteristics found in a query definition can be restricted by:

technology web technology

  1. Opening the administrator workbench

  2. Changing the query properties within the query designer

  3. Double-clicking on the characteristic in the query definition

  4. Creating a calculated key figure

Show answer
Correct Option: C

Select the statement(s) which is/are not true related to flat file uploads:
technology web technology

  1. CSV and ASCII files can be uploaded

  2. The table used to store the flat file load parameters is RSADMINC

  3. The transaction for setting parameters for flat file upload is RSCUSTV7

  4. None of the above

Show answer
Correct Option: C

Select the true statement(s) related to the start routine in the update rules:

technology web technology

  1. All records in the data packet can be accessed

  2. Variables declared in the global area is available for individual routines

  3. Returncode greater than 0 will be abort the whole packet

  4. None of the above

Show answer
Correct Option: A,B,C

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) All records in the data packet can be accessed - This option is correct. In the start routine of the update rules, all records in the data packet can be accessed. This allows you to perform operations and calculations on the data within the update rules.

Option B) Variables declared in the global area are available for individual routines - This option is correct. Variables declared in the global area are accessible and can be used within individual routines, including the start routine. This allows you to store and manipulate data across different routines within the update rules.

Option C) Returncode greater than 0 will abort the whole packet - This option is correct. In the start routine, if the return code is set to a value greater than 0, it will cause the entire update packet to be aborted. This can be useful in certain scenarios where you want to stop the processing of the update rules based on a specific condition.

Option D) None of the above - This option is incorrect. Options A, B, and C are all true statements related to the start routine in the update rules.

Therefore, the correct answer is A, B, and C. These options are correct because they accurately describe the behavior and capabilities of the start routine in the update rules.

Identify the statement(s) that is/are true. A change run...

technology web technology

  1. Activates the new Master data and Hierarchy data

  2. Aggregates are realigned and recalculated

  3. Always reads data from the InfoCube to realign aggregates

  4. Aggregates are not affected by change run

Show answer
Correct Option: A,B

AI Explanation

To answer this question, you need to understand the concept of a change run in the context of data processing.

Let's go through each option to understand why it is correct or incorrect:

Option A) Activates the new Master data and Hierarchy data - This option is correct because during a change run, the new master data and hierarchy data are activated. This means that any changes made to the master data or hierarchy data will be applied and made active in the system.

Option B) Aggregates are realigned and recalculated - This option is correct because during a change run, the aggregates are realigned and recalculated. Aggregates are pre-calculated summaries of data that improve the performance of data queries. When changes are made to the data, the aggregates need to be updated to reflect the changes.

Option C) Always reads data from the InfoCube to realign aggregates - This option is incorrect because during a change run, the system does not always read data from the InfoCube to realign aggregates. Instead, it uses other mechanisms such as delta queues or change logs to identify the changes that need to be applied to the aggregates.

Option D) Aggregates are not affected by change run - This option is incorrect because during a change run, the aggregates are indeed affected. As mentioned earlier, the aggregates need to be realigned and recalculated to reflect the changes made to the data.

Therefore, the correct answer is A and B. These options correctly describe the actions that occur during a change run.

The structure of the PSA table created for an info source will be...

technology web technology

  1. Featuring the exact same structure as Transfer structure

  2. Similar to the transfer rules

  3. Similarly structured as the Communication structure

  4. The same as Transfer structure, plus four more fields in the beginning

Show answer
Correct Option: D
Explanation:

To answer this question, the user needs to know about the different types of structures used in SAP BW. Specifically, the user needs to know about the PSA (Persistent Staging Area) table and how it is structured.

Option A is incorrect. The PSA table does not have the exact same structure as the Transfer structure. The Transfer structure is used to map data fields from the source system to the PSA table, and it has a different structure than the PSA table.

Option B is incorrect. While the PSA table is similar to the transfer rules in that they both map data from source systems to the PSA table, they have different structures.

Option C is incorrect. The Communication structure is used to transfer data between different components of SAP BW. It is not used in the creation of the PSA table.

Option D is correct. The PSA table has the same structure as the Transfer structure, with four additional fields added at the beginning. These fields are used to store metadata about the data in the PSA table, such as the load date and the request ID.

Therefore, the correct answer is:

The Answer is: D

If a characteristic value has been entered in InfoCube-specific properties of an InfoCube, only these values can be loaded to the cube for that characteristic.

technology web technology

  1. True

  2. False

Show answer
Correct Option: A
Explanation:

To solve this question, the user needs to have knowledge of the InfoCube-specific properties in SAP Business Warehouse.

The statement "If a characteristic value has been entered in InfoCube-specific properties of an InfoCube, only these values can be loaded to the cube for that characteristic" is True.

Explanation:

In SAP Business Warehouse, InfoCube-specific properties are used to define the behavior of an InfoCube. One of the properties that can be set is the "Fixed value" property for characteristics. If a fixed value is set for a characteristic in an InfoCube, only that value can be loaded into the InfoCube for that characteristic. Any other values for that characteristic will be rejected during the data loading process.

Therefore, the statement is true and option A is correct.

The Answer is: A

The following statements are true for OLAP CACHE.

technology web technology

  1. Query navigation states and query results are stored in the application server memory.

  2. If the same query has been executed by another user the result sets can be used if the global cache is active.

  3. Reading query results from OLAP cache is faster than reading from the database.

  4. Changing the query will invalidate the OLAP cache for that query.

Show answer
Correct Option: A,B,C,D
Explanation:

To understand the statements made about the OLAP CACHE, the user needs to know what OLAP CACHE is and how it works. OLAP CACHE is a technology that enables faster query processing by storing query results and navigation states in the application server memory. With that said, let's go through each statement and determine if it is true or false.

A. Query navigation states and query results are stored in the application server memory.

This statement is true. OLAP CACHE stores both query navigation states and query results in the application server memory, enabling faster query processing.

B. If the same query has been executed by another user the result sets can be used if the global cache is active.

This statement is also true. If the global cache is active, the result sets from a previously executed query can be used by another user who executes the same query, resulting in faster query processing times.

C. Reading query results from OLAP cache is faster than reading from the database.

This statement is also true. Because OLAP CACHE stores query results in the application server memory, reading those results is much faster than reading from the database, which requires I/O operations.

D. Changing the query will invalidate the OLAP cache for that query.

This statement is true. If a query is changed, the OLAP CACHE for that query will be invalidated because the query results and navigation state will no longer be valid for the new version of the query.

Therefore, the correct options are:

A. True B. True C. True D. True

The Answer is: D

Which of the following can be shared amongst query designers within a single InfoProvider?

technology web technology

  1. Characteristic variables

  2. Global structures

  3. Restricted key figures

  4. Technical names of a query

Show answer
Correct Option: A,B,C

AI Explanation

To answer this question, you need to understand the concept of sharing components within a single InfoProvider in the context of query designers.

Option A) Characteristic variables - This option is correct because characteristic variables can be shared among query designers within a single InfoProvider. Characteristic variables allow you to define reusable variables that can be used in multiple queries.

Option B) Global structures - This option is correct because global structures can be shared among query designers within a single InfoProvider. Global structures allow you to define reusable structures that can be used in multiple queries.

Option C) Restricted key figures - This option is correct because restricted key figures can be shared among query designers within a single InfoProvider. Restricted key figures allow you to define reusable calculations or formulas that can be used in multiple queries.

Option D) Technical names of a query - This option is incorrect because the technical names of a query cannot be shared among query designers within a single InfoProvider. The technical name of a query is unique to each query and cannot be reused.

The correct answer is A, B, C. These options are correct because characteristic variables, global structures, and restricted key figures can be shared among query designers within a single InfoProvider, allowing for reusability and consistency in query design.

A combination of characteristics and key figures can be displayed in any desired order by:
technology web technology

  1. Activating the download scheduler

  2. Switching a query definition to tabular mode

  3. Placing key figures in the rows section of a query definition

  4. Using scissors and duct tape

Show answer
Correct Option: B

To implement business Logic seperately and independently which MVC pattern should be used?

technology web technology

  1. MVC 1

  2. MVC 2

  3. MVC 3

  4. None

Show answer
Correct Option: B

Strings Are Immutable Objects

technology web technology

  1. True

  2. False

Show answer
Correct Option: A

String x = new String("Life");System.out.println( x.length);

technology web technology

  1. 4

  2. 5

  3. Runtime Error

  4. Compiler Error

Show answer
Correct Option: D

What is the output of following. 

public static void main(String[]  args)  {
    int b=3;
    byte c=b/2;
    System.out.println("&c="+ &c);
}
technology web technology

  1. 1.5

  2. 1

  3. RuntimeException

  4. CompileTime Error

Show answer
Correct Option: D

Identify the background process which, is responsible for instance recovery

technology web technology

  1. System Monitor (SMON)

  2. Process Monitor (PMON)

  3. Database Writer (DBWR)

  4. Log Writer (LGWR)

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions