0

web technology Online Quiz - 7

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

Which one is true ?

  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


Correct Option: A

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

  1. View dropped also

  2. View becomes invalid

  3. View remains as it is

  4. View is accessible


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 ?

  1. UPDATE

  2. ALTER

  3. INSERT

  4. CREATE


Correct Option: A

Java does not have multiple inheritance

  1. True

  2. False


Correct Option: A

Hello '\n' Hello

  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

  6. 6


Correct Option: B

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

  1. True

  2. False


Correct Option: B

Characteristics found in a query definition can be restricted by:

  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


Correct Option: C
  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


Correct Option: C

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

  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


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

  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


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

  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


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.

  1. True

  2. False


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.

  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.


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?

  1. Characteristic variables

  2. Global structures

  3. Restricted key figures

  4. Technical names of a query


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:

  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


Correct Option: B

AI Explanation

To answer this question, you need to understand how to display a combination of characteristics and key figures in a desired order.

Option A) Activating the download scheduler - This option is incorrect because the download scheduler is not related to displaying characteristics and key figures in a desired order.

Option B) Switching a query definition to tabular mode - This option is correct. By switching a query definition to tabular mode, you can display the characteristics and key figures in a desired order.

Option C) Placing key figures in the rows section of a query definition - This option is incorrect. Placing key figures in the rows section will not necessarily allow you to display them in a desired order.

Option D) Using scissors and duct tape - This option is incorrect. Using scissors and duct tape is unrelated to displaying characteristics and key figures in a desired order.

The correct answer is B) Switching a query definition to tabular mode. This option allows you to display a combination of characteristics and key figures in a desired order.

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

  1. MVC 1

  2. MVC 2

  3. MVC 3

  4. None


Correct Option: B

Strings Are Immutable Objects

  1. True

  2. False


Correct Option: A

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

  1. 4

  2. 5

  3. Runtime Error

  4. Compiler Error


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);
}
  1. 1.5

  2. 1

  3. RuntimeException

  4. CompileTime Error


Correct Option: D

Identify the background process which, is responsible for instance recovery

  1. System Monitor (SMON)

  2. Process Monitor (PMON)

  3. Database Writer (DBWR)

  4. Log Writer (LGWR)


Correct Option: A
- Hide questions