C# 4.0 MCQs(Multiple Choice Questions)

After Basic set of asp.net MCQs lets try for some advance topics.

1.The infrastructure that supports these dynamic operations at run time is called the__________.
A.CLR
B.CTS
C.CLS
D.DLR
Click for answer 

D. DLR(Dynamic Language Runtime).

2.The___________keyword is new to C# 4.0, and is used to tell the compiler that a variable's type can change or that it is not known until runtime.
A.Covariance
B.dynamic
C.Contravariance
D.Object
Click for answer 

B.dynamic

3.___________methods are not supported for dynamic types.
A.Anonymous
B.Static
C.Abstract
D.Extension
Click for answer 

D.Extension

4.myMobile.Accept(55, inReject: false); Above statement is an example of which new concept of C# 4.0?
A.Named Parameters
B.Optional Parameters
C.dynamic
D.Variance
Click for answer 

A.Named Parameters

5.COM Interop is simplified in C#4.0 e.g.var doc = Application.GetDocument("MyFile.txt"); In above statement_______ keyword was essential in parameters of GetDocument() in previous versions of C#.
A.out
B.named
C.base
D.ref
Click for answer 

D.ref

6.Covariance and Contravariance are new features introduced in C# 4.0.True/False?
A.False
B.True
Click for answer 

B.True

7._________parameters allows you to give a method parameter a default value so that you do not have to specify it every time you call the method.
A.optional
B.named
C.out
D.ref
Click for answer 

A.optional

8.Duck typing is implemented by using_________ keyword.
A.dynamic
B.object
C.ref
D.base
Click for answer 

A.dynamic

MCQs on Stored Procedures in SQL

1.A stored procedure in SQL is a___________.
A.block of functions
B.group of Transact-SQL statements compiled into a single execution plan.
C.group of distinct SQL statements.
D.None of above
Click for answer 

B.group of Transact-SQL statements compiled into a single execution plan.

2.It is possible to return data (such as an integer or character value) or a cursor variable by using________.
A.IN parameters
B.OUTPUT parameters
C.IN and OUT parameters
D.Return keyword
Click for answer 

B.OUTPUT parameters

3.____________assist in achieving a consistent implementation of logic across applications.
A.Table
B.Functions
C.Stored procedures
D.Views
Click for answer 

C.Stored procedures

4.In SQL Server system stored procedures whose names usually start with__________.
A.sp
B.sp_
C.dbo
D.None of these
Click for answer 

B.sp_

5.Temporary stored procedures are stored in _________ database.
A.master
B.model
C.user specific
D.tempdb
Click for answer 

D.tempdb

6.Benefit(s) of using stored procedures in SQL is/are______
A.They allow modular programming
B.They can reduce network traffic
C.Both A & B
D.Easy for data access.
Click for answer 

C.Both A & B

7.CREATE PROCEDURE statements cannot be combined with other SQL statements in a single batch.True or False?
A.True
B.False
Click for answer 

A.True

8.It is strongly recommended that you do not create any stored procedures using sp_ as a prefix.
A.although the user-created stored procedure prefixed with sp_ may exist in the current database, the master database is always checked first, even if the stored procedure is qualified with the database name.
B.It will not allow to create stored procedure
C.It will get stored in model database
D.The stored procedure will get stored as dbo as the owner.
Click for answer 

A.although the user-created stored procedure prefixed with sp_ may exist in the current database, the master database is always checked first, even if the stored procedure is qualified with the database name.

Blog Directory | Submit to Directories and Promote your Blogs

Basic Web Development MCQs

1.Basic features of Web Browsers are ___________.
1)Mass access to web pages
2)Easy hyperlinks
3)Number of commands
4)Easy online help
5)Support Search mechanism
A.1, 2, 3 &4
B.2, 3, 4 & 5
C.1, 3, 4 & 5
D.1, 2, 3, 4 & 5
Click for answer 

D.1, 2, 3, 4 & 5

2.URIs typically consists of _________________

1)The naming scheme of the mechanism used to access the resource.
2)The name of the machine hosting the resource.
3)The name of the resource itself, given as a path.
A.1 & 2
B.1, 2 & 3
C.1 & 3
D.2 & 3
Click for answer 

B.1,2 & 3

3.Programs that ask servers for services are called _________
A.FTP
B.URL
C.Clients
D.None of these
Click for answer 

C.Clients

4.Three version of POP are ___________
A.POP, POP2, and POP3
B.POP1, POP2, and POP3
C.POP0, POP1, and POP2
D.POP, POP2, and POP4
Click for answer 

B.POP1, POP2, and POP3

5.______ is a method of recording a visited website or web pages.
A.blog
B.bookmark portal
C.Robot
D.bookmark
Click for answer 

D.bookmark

6.Relative path make your hypertext links______________
A.Discrete
B.Uniform
C.Portable
D.Interactive
Click for answer 

C.Portable

7.Which of the following path is supported by HTML?
A.Absolute and Relative
B.Server path
C.Both A & B
Click for answer 

A.Absolute and Relative

8.What is the most widely used e-mail form script?
A.PHP
B.ASP
C.Perl
D.JSP
Click for answer 

A.PHP