The WPF .Net Online Test is Very helpful for all students. Now Scroll down below n click on “Start Quiz” or “Start Test” and Test yourself.

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading...

You must sign in or sign up to start the quiz.

You have to finish following quiz, to start this quiz:

Results

0 of 20 questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 points, (0)

Average score

Your score

Categories

Not categorized0%

maximum of 20 points

Pos.

Name

Entered on

Points

Result

Table is loading

No data available

Your result has been entered into leaderboard

Loading

Name:
E-Mail:

Captcha:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

Answered

Review

Question 1 of 20

1. Question

Which one is Server type state management?

Session State

View State

Hidden Field

None

All Above

Correct

Session State and Application State is Server type state management, as the requests goes to server every time when it is post-back or load. The values are stored in server, so the process is secure.

Incorrect

Session State and Application State is Server type state management, as the requests goes to server every time when it is post-back or load. The values are stored in server, so the process is secure.

Question 2 of 20

2. Question

Which one is Client type state management?

Session State

View State

Application State

No option

All Above

Correct

View State is client type state management. It keeps the information in the client and when we want to use the data after the post-back, we can use the value of viewstate. Actually through postback the browser communicates through the server, while communicating to the server we can keep the value in state.

Incorrect

View State is client type state management. It keeps the information in the client and when we want to use the data after the post-back, we can use the value of viewstate. Actually through postback the browser communicates through the server, while communicating to the server we can keep the value in state.

Question 3 of 20

3. Question

Extension when LINQ to SQL is used in C#?

.db

.dbml

.sql

No option

All Above

Correct

The DBML file contains the C# source code which allow us to write the LINQ Queries to SQL .dbml file will be added under App_Code folder.

Incorrect

The DBML file contains the C# source code which allow us to write the LINQ Queries to SQL .dbml file will be added under App_Code folder.

String DNF will be split into individual characters like D N F row wise. The numberCTE generates the sequential numbers based on the length of the string. It will be 3 here. The substring function [CODE]SUBSTRING(@String,rn,1)[/CODE] will accept the numbers one by one and will return individual characters based on the Rn value. final output [CODE]Characters ————- D N F[/CODE]

Incorrect

String DNF will be split into individual characters like D N F row wise. The numberCTE generates the sequential numbers based on the length of the string. It will be 3 here. The substring function [CODE]SUBSTRING(@String,rn,1)[/CODE] will accept the numbers one by one and will return individual characters based on the Rn value. final output [CODE]Characters ————- D N F[/CODE]

Question 7 of 20

7. Question

What will be the output of the following?
DECLARE @String VARCHAR(MAX)
DECLARE @Noise TABLE(Noise VARCHAR(100),ReplaceChars VARCHAR(10))
SET @String = ‘hello! DNF.!’

12. Question

Azure Blob storage is a service that stores unstructured data e.g. Text file, Images, CSV, Excel, JSON etc. It is also known as object storage.

Incorrect

Azure Blob storage is a service that stores unstructured data e.g. Text file, Images, CSV, Excel, JSON etc. It is also known as object storage.

Question 13 of 20

13. Question

Passing a variable as a out parameter you need to

Initialize

Not Initialize

Doesn't matter it is Initializeor not

No option

All Above

Correct

The argument can be passed without assigning any value to it. An argument that is passed using an out keyword must be initialized in the called method before it returns back to calling method.

Incorrect

The argument can be passed without assigning any value to it. An argument that is passed using an out keyword must be initialized in the called method before it returns back to calling method.

Question 14 of 20

14. Question

Passing a variable as a ref parameter you need to.

Initialize

No need to Initialize

Doesn't matter it is Initializeor not

No option

All Above

Correct

When the value of parameter is changed in called method it get reflected in calling method also.

Incorrect

When the value of parameter is changed in called method it get reflected in calling method also.

Question 15 of 20

15. Question

Which function implements IF..THEN ELSE logic?

INITCAP

REPLACE

DECODE

IFELSE

All Above

Correct

DECODE – This will create IF THEN ELSE logic. INITCAP – will be like Captilaize the first Letter of each word (Camel Case). REPLACE – will replace instead of one word or string to another. IFELSE – No keyword exists like that.

Incorrect

DECODE – This will create IF THEN ELSE logic. INITCAP – will be like Captilaize the first Letter of each word (Camel Case). REPLACE – will replace instead of one word or string to another. IFELSE – No keyword exists like that.

Question 16 of 20

16. Question

Which date components does the CURRENT_TIMESTAMP function display?

Session date and session time zone offset

Session time zone offset

Session date and session time

Session date, session time, and session time zone offset

All Above

Correct

The CURRENT_TIMESTAMP function returns the session date, session time, and session time zone offset.

Incorrect

The CURRENT_TIMESTAMP function returns the session date, session time, and session time zone offset.

Question 17 of 20

17. Question

What is the value for SIGN(NVL(-16,0))?

1

-1

16

-16

All Above

Correct

Here Let see how we calculate these values. Consider we have the following : SIGN(ABS(NVL(-75,0))) Just like mathematics we should take it from the inner brackets. So first step will be, NVL(-75,0) = -75 Now, next bracket ABS(-75) = 75 //ABS always take positive Finally SIGN(75) = 1 If SIGN(>1) = 1, SIGN(<1) = -1, SIGN(0) = 0. So in our question we didn’t use the ABS function, So it remains Negative and SIGN Function of Negative will be -1.

Incorrect

Here Let see how we calculate these values. Consider we have the following : SIGN(ABS(NVL(-75,0))) Just like mathematics we should take it from the inner brackets. So first step will be, NVL(-75,0) = -75 Now, next bracket ABS(-75) = 75 //ABS always take positive Finally SIGN(75) = 1 If SIGN(>1) = 1, SIGN(<1) = -1, SIGN(0) = 0. So in our question we didn’t use the ABS function, So it remains Negative and SIGN Function of Negative will be -1.

Question 18 of 20

18. Question

ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed. Which is called as?

Drop Cascade

Delete Cascade

Update Cascade

Truncate

All Above

Correct

[B]Delete Cascade[/B] which drops the Foreign or Reference Key when the Primary Key deleted.

Incorrect

[B]Delete Cascade[/B] which drops the Foreign or Reference Key when the Primary Key deleted.

Question 19 of 20

19. Question

What are the various credential types used along with OAuth 2.0?

MAC Token,Auth1.0,SAML

SAML,DSL,Auth1.0

Bearer Token, MAC token, SAML

Session Token,Auth1.0, SAML

All Above

Correct

There are three types of credentials available to use along with OAuth 2.0, such as Bearer Token, MAC token, SAML. Examples: 1. Authorization: Bearer <TOKEN_VALUE> 2. Authorization: MAC id=”h480djs93hd8″, ts=”1336363200″, nonce=”dj83hs9s”, mac=”xxxxxxxxxxxxxxxxxxxxxxxxxx” 3. Security Assertion Markup Language (SAML) is a XML-based framework to exchange security related information between Service Consumer, Identity Provider and Service Provider. <saml:Assertion …> .. </saml:Assertion>

Incorrect

There are three types of credentials available to use along with OAuth 2.0, such as Bearer Token, MAC token, SAML. Examples: 1. Authorization: Bearer <TOKEN_VALUE> 2. Authorization: MAC id=”h480djs93hd8″, ts=”1336363200″, nonce=”dj83hs9s”, mac=”xxxxxxxxxxxxxxxxxxxxxxxxxx” 3. Security Assertion Markup Language (SAML) is a XML-based framework to exchange security related information between Service Consumer, Identity Provider and Service Provider. <saml:Assertion …> .. </saml:Assertion>