• 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

AI Explanation

To answer this question, you need to have knowledge about flat file uploads and the related parameters. Let's go through each option to understand why it is correct or incorrect:

Option A) CSV and ASCII files can be uploaded - This option is correct. Both CSV (Comma Separated Values) and ASCII files can be uploaded as flat files.

Option B) The table used to store the flat file load parameters is RSADMINC - This option is incorrect. The table used to store the flat file load parameters is not RSADMINC. RSADMINC is used to store system-wide parameters for the Business Intelligence system.

Option C) The transaction for setting parameters for flat file upload is RSCUSTV7 - This option is incorrect. The transaction for setting parameters for flat file upload is not RSCUSTV7. RSCUSTV7 is used for maintaining customer-specific settings in SAP systems.

Option D) None of the above - This option is incorrect because option A is true.

The correct answer is C. This option is incorrect because the transaction for setting parameters for flat file upload is not RSCUSTV7.

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

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

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

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

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?

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
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions