Quiz : .NET Developer

With this quiz we are aiming to learn more about your generic programming skills. The quiz consists of 14 questions with multiple choices.

It is estimated that the quiz will take 20-25 mins to complete. Please note that some questions may have multiple answers.

Good luck!

What is the difference between Primary key and Unique key?

Primary key doesn’t allow null value whereas unique key allows multiple null values Primary key allows one null value whereas unique key doesn’t allow null value Primary key doesn’t allow null value whereas unique key allows one null value

What result would provide this code sample?

int?[] arr=new int?[5];
Console.WriteLine(arr[4]);

NULL 0 Compile time exception Runtime exception

Can we use “this” in the static class

No Yes

Which of the following operator does not throw an exception if the cast fails?

Is As () =

Which of the following extension method allows us to configure custom error handling route?

UseExceptionHandler UseDeveloperExceptionPage UseWelcomePage Run

Which of the following request/response data formats Web API supports by default?

JSON XML BSON All of the options

Lambda expression can be invoked like a delegate

true false

Which of the following keyword is used to declare a variable whose type will be automatically determined by the compiler?

Var Dynamic This Null

Which types of indexes are in the SQL server?

Integer and string Unique and non-unique Clustered and non-clustered None of them

What is a trigger in SQL?

An SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs An event that can be raised from Stored Procedures An SQL procedure that performs actions on accessing database tables A procedure which executes when an error occurred

What are the different types of temporary tables in SQL server?

Indexed and non-index temporary tables Global and local temporary tables Unique and shared temporary tables Small and large temporary tables

Which of the following keyword is used to raise an error in a stored procedure?

THROW THROWERROR RAISERROR ERROR

What is normalization?

It is a set of database design rules to minimize redundancy It is a set of rules to normalize database transactions It is a set of rules to improve database performance None of the items

Which code is more optimal?

1)

String text="FirstName"+"LastName";

2)

StringBuilder textB=new StringBuilder();
textB.Append("FirstName");
textB.Append("LastName");
String text=textB.ToString();

1 2 both are good