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

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

  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

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

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

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

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

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

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

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