JASBIR

1)natasha is trying to access a page but she is not able to do it.

on the other hand when john logged in via his credentials he could .what may be the reason?

a)webserver credential overriding

b)role based access------- ANS

c)url cutomization

d)account rendering

2) LINQ stands for

ans) Language integrated query

3)if foreign key coloumns are not available in the model , the relationship are reffered with the object
references instead of

foreign key properties .what is the association called??

a)independent association --------ans

b)dependent association

c)relationship

d)entityrelationship

4)which all index options can be set without rebuilding the index?

a)allow_page_locks-------------ans

b)allow_row_locks-------------ans

c)ignore_dup_keys----------ans

d)data_compression

e)statistics_norecompute-------------ans

5)a query is an expression that retrieves data from a data source?

true ----------------ans

false

6)for any injection ,we use

a)[inject]

b)none -----------------ANS

c) [injection creato]

d) [inject initialze]

7)which of the following is not a HtmlHelper?

a)LabelFor

b)EditorFor

c)ValidationMessageFor

d)None of the listed options--------------ans

8)how can we disable proxy object creation in POCO?

A) [Link] = FALSE;

B)[Link]=FALSE;

A) [Link] = FALSE;

B)[Link] = FALSE;---------------ANS

9)SaveChanges() will be raised exception when which of the following object is added to the

objectcontext and it cannot be successfully created in the data source?

a)DbException

b)Savexception

c)ChangeException

d)UpdateException-------------ans

10)Activator class cannot be inherited?

true--------answer

false

11)which of the following class object is used for manipulatiing entity and trigger the changes while
insert

,delete and update on the entity?

a) DbContext

b) DataContext

c)MOdel-defined Functions

d) None-----------doubt

12)_____________is an xml-based language which describes the entities, functions and relationships
which create a conceptual model of an application?

a) conceptual schema definition language--------------ans

13)Which of the following mapping is supported by Fluent Api?

a) Model-wide mapping

b)entity mapping

c) property mapping

d) all -------------answer
14)what are the significance of recovery model setting??

a)it determines how much data can be recovered in the event of a media failure-----------------ans

b) it determines the location where the data should be recovered in the event of a media failure

c)the default recovery is full , which provieds the greatest level of recovery----------------ans

d) the default is partial which provides the greatest level of recovery

15)Which statements are true about rank function?

a)it returns the rank of each row in the table within the partition of a database-----------ans

b) the rank of a row is equal to the number of ranks that comes before the row in question

c) the rank of a row is one plus the number of ranks that comes before the row in question------ans

d)the rank function returns consecutive integers

e) the rank function does not always return consecutive integers----------ans

18)which of the following should you to choose to activate buildview property in [Link]?

ans) <MvcBuildViews>true</MvcBuildViews>

19)which of the foolowing is the full for for ssdl

ans)Storage Schema Definition Language

20)dependencyresolver() is destructor?

ans)false

21)how is the data of partition tables managed?

(a)The data of aprtioned tables and indexes is divided into units .......ans
(b) the data is partitioned horizontally,...........ans

(d) The table or index is treated as single logical entity.---ans

25)which statements are true about large clr user defined types?

(a) Extend exisiting SQL Server Type Sysytem.--------------ans

(c)Allow you to store CLR objects in SQL Server Database.------------ans

26)how can we delete the database on the database server if it exists?

ans)Delete(DbConnection)

28)which one of the following are the properties of the HTTPcONFIGURATION CLASS?

a) Dependency Resolver--ans

(c) Mesaage Handlers--ans

29)choose handle error attribute globaly

(b) All of the listed options-ans

30)DbContext does not support comiled queries?

true-----------ans

31)How can we set primary key explicitly for an entity?

[Link]<Entity>(t=>[Link]);

[Link]<Entity>().HasKey(t=>[Link]);-----ans

[Link]<Entity>(t=>[Link]);

[Link] of the listed options.--

32)In Lazy loading,the navigation property has to be declared as:

[Link]

[Link]-----------------------------------Ans

[Link]

[Link]----------------------------------Ans

33)Which statements are true about CLR stored procedures?

[Link] is a reference to a [Link] Framework common language runtime(CLR)method.-------------------

---------Ans

[Link] method can take and return user-supplied parameters.------------------------------------------------------

Ans

[Link] method can only take input parameters.

[Link] are implemented as public,static methods on a class in a .NET Framework assembly.-----------------

--------Ans

[Link] are implemented as private,protected methods on a .NET Framework assembly.

34)What are the benefits of using a Unique index?

[Link] is less error prone.

[Link] integrity of the defined columns is ensured.------------------------------------------------------Ans

[Link] information helpful to the query optimizer is provided.-------------------------------------Ans

[Link] performance is not degraded.

35)SQL Server consists of which of the following three types of files?

[Link] data files--------------------Ans

[Link] data files------------------Ans

[Link] files

[Link] files-----------------------------Ans

36)Which of the following is not the Design goal of [Link] MVC3?

[Link] the Web

[Link]

[Link] only--------------------------------Ans

[Link] i and ii

[Link] of the listed options

d.i only

37)What are the limitations of Ownership chaining?

[Link] only to DML statements:SELECT,INSERT,UPDATE and DELETE.----------------------------Ans

[Link] owners of the caliing and the called objects must be the same.-------------------------Ans

[Link] owners of the calling and the called objects must be different.

[Link] not apply to dynamic queries inside the module.--------------------------------------Ans

38)What does the following syntax do?

CREATE TABLE T1(Col1 int primary key,Col2 xml)

[Link] creates a row in a table.

[Link] creates a column of type int in the table & sets it as a primary key.----------------Ans

[Link] creates a column of type xml.--------------------------------------------------------Ans

[Link] creates an empty table.

39)Partial page rendering does which of the following?

[Link] the need for the whole page to be refreshed as the result of a HTTPGet.

[Link] the need for the whole page to be refreshed as the result of a postback.---------------Ans

[Link] header of the page that have changed are updated.

[Link] individual regions of the page that have changed are updated.-----------------------------Ans

40)How are user defined functions different from User-defined Stored Procedures?

[Link] user-defined function the default parameter is specified with a DEFAULT keyword.------------ans

[Link] User-defined function omitting the parameter also implies default value.
[Link]-defined functions do not support output parameters.---------------------------------Ans

[Link]-defined functions do support output parameters.

41)Which of the following is used to provide short expression for querying entities over linq?

[Link] to DataSet.

[Link] to SQL.

[Link] expression.--------ans

[Link] of the listed options.

42)Which of the following approach do we avoid working with the visual designer or entity framework?

[Link] First Approach.----------------a

[Link] First Approach.

[Link] Approach.

[Link] of the listed options.

43)Novak is a given a task by his manager to strictly load a particular image only after page gets
[Link] will you advice him to do?

[Link] him to use JavaScript.

[Link] him to combine OnLoad function with JavaScript.

[Link] him to use AfterLoad function with JavaScript.

a.i and ii--------------------ans

[Link] and iii

c.i and iii

d.i,ii,iii

44)In console window,PM stands for _________

[Link] Manager.

[Link] Manager.-----------------Ans

[Link] Model.
[Link] Manager.

45)Which statements are true about the GROUPING function?

[Link] is an aggregate function that causes an additional column to be used with a value of 1 when the row
is added by either the CUBE or ROLLUP operator.--------ANS

[Link] is an aggregate function that causes an additional column to be used with a value of 0(True) when
the row is added by either the CUBE or ROLLUP operator.

[Link] is an aggregate function that causes an additional column to be used with a value of 0 when the row
is not the result of CUBE or ROLLUP operator.-------ANS

[Link] is an aggregate function that causes an additional column to be used with value equal to the number
of rows added by either the CUBE or ROLLUP operator.

[Link] is allowed only in the select list associated with a GROUP BY clause that contains either the
CUBE or RoLLUP operator. ------ANS

[Link] default, the entry framework will generate the database

queries and update commands when your code interacts with the model?

Ans:True

[Link] is defined as _______ of the object, but not the behavior of the object?(QUES NOT CLEAR)

[Link]

[Link]--------------ANS

[Link]

[Link]

[Link] framework is an open source framework? True or false

Ans:True

[Link] kind of data does the XML datatypes store in SQL server? (Multiple ans)

[Link] documents

[Link] maps
[Link] documents---->ans

[Link]--->ans

[Link] does a cache profile do?

[Link] profile allows libraries to provide fast output to sql queries

[Link] profile avoids repetition in cache attributes

select one:

[Link] i and ii

b.i only

[Link] only -----ANS

d. None of the listed options

[Link] an application page, you are suppose to take students % between 40-80.

which of the following will accomplish this objective?

select one

a.[Range (40,80)]

public virtual int Perc{get;set;}----ans

b.[between (40;80)]

public virtual int Perc{get;set;}

c.[Range (40,80)]

public virtual string Perc{get;set;}

d.[Range (40||80)]

public virtual int Perc{get;set;}

[Link] is carrying out a TDD and is expecting ArgumentOutOfRange exception

but he does not known how to write a code to declare that an exception is expected.

To help him, which of the following would you choose?

select one;
a.[[Link]=ArgumentOutOfRange]

b.[[Link]]

c.[ExpectedException(typeof(ArgumentOutOfRange))]----->ans

d.[[Link]=True]

[Link] are Database-level principles categorized?(Multiple ans)

[Link] administrator

[Link] user-->ans

[Link] role-->ans

[Link] role

[Link] role-->ans

[Link] caching,by default the location property have the value___

[Link]

[Link]--->ans

[Link]

[Link]

[Link] of the following is a way to install/download a Nuget in your system?

[Link] your browser go to [Link]-->click on download

[Link] a visual studio, right click on references-->Add LibraryPackageReferences-->search nuget-->Install

[Link] of the listed options------ans

[Link] visual studio, go to tools-->Extension manager-->search Nuget-->Install

[Link] is meant by Materialization in entity framwork?

Ans:Materialzation is the process of returning query results back to the

client as CLR types

[Link] framework support foreign key? t or f

Ans: True

[Link] your are moving your project from MVC2 to MVC3 what will be the

value of "UnobtrusiveJavaScriptEnabled"

[Link]

[Link]

[Link]--->ans

[Link]

[Link] can write raw sql query in SQLQuery() method in entity framework? T or F

Ans:true

[Link] namespace is used to handle EntityClient provider?

a. [Link]--->ans

[Link]

[Link]

[Link] of the listed options

*************************************************************************************
***********************************************

ajith

1. Which of the following require type-casting in the view?

[Link]

[Link]

Select one:
a.I only

[Link] only

[Link] I and II-------------------------------------------------------ANS

[Link] of the listed options

2. Which of the following snippet creates database in local sql express by default?

[Link] class Context:DbContext

public Context():base()

[Link] class Context:DbContext

public Context():base("DB Name")

Select one:

ans:2&3

3. How is a User-defined table-valued function in SELECT,INSERT,UPDATE or DELETE statements is

invoked?
Select one:

a.A User-defined table-valued function can be invoked in the FROm clause of a SELECT,INSERT,UPDATE
& DELETE statement------------------------------------------------ANS

b.A User-defined table-valued function can be invoked as a stored procedure from a clause of a
SELECT,INSERT,UPDATE & DELETE statement

c.A User-defined table-valued function can be invoked in the WHERE clause of a SELECT,INSERT,UPDATE
& DELETE statement

d.A User-defined table-valued function can be invoked in the USING clause of a SELECT,INSERT,UPDATE
& DELETE statement

4. You are given a task by your manager that includes assembly [Link] file would you configure?

Select one:

[Link]

[Link]

[Link]---------------------------------------------------------------ANS

[Link]

5. Which are the different types of file groups?

Select one or more:

[Link]

[Link]----------------------------------------ANS

[Link]-defined-------------------------------------------ANS

[Link]

6. Model Binder Interface defines

select one

a. the .dll files that are requested for a model binder

[Link] interfacae that are required for a model binder

c. the assembly that are required fro a model binder

[Link] methods that are required for a model binder-------------------------ans

7. Which statements are true about the maax constant in a varchar type?

a. It can be used when the data can exceed more than 8000 charcters-----------------ans

b. It can be used to fix the max length of charcters for the entire column------------------ans

c. It can be used to store large blocks of text----------------ans

d. It can be used to store large image types.

8. ___________ is an XML based language which describes the entities , functions and relationships
which create a conceptual model of a application.

select one

a. Conceptual schema definition langauage (CSDL)---------------ans

[Link] set definition Languaage(CSDL)

[Link] select definition Language(CSDL)

[Link]

9. Which of the following statements are true about AFTER trigger?

select one

[Link] trigger executes after the sattements that triggered it completes-----------------------ans

[Link] trigger executes after the last trigger in the queue.

[Link] the statement fails with an error the trigger is not executed.------------------------------ans

d. AFTER triggers cannot be specified for tables , they can only be specified fro views.

[Link] triggers cannot be specified for views, they can only be specified for tables.-----------------ans
10. Which of teh following methods make entity framework fro detecting changes automatically?

selct one

[Link]

[Link] .Remove

[Link]

[Link]---------------------------------------------ans

11) Which one in the following is not included in the configuration hierarchy?

[Link] Application sub directory

[Link] root directory

root web

IIS

[Link] client server sub directory-----------ANS

12) Unchanged State is the default state for an entity while the entity is retrieved from the database.

TRUE------------------ANs

FALSE

13) Which of the following are database initializers used in Entity Framework

CreateDatabaseIfNotExist---------------ANS

DropCreateDatabaseIfModelChanges-------ANS

DropDatabaseAlways

DropCreateDatabaseAlways---------------ANS

CreateDatabaseAlways

14) public void testdate()

distance z = new Distance();

var message = new Sample(z);

 [Link](distance,message,z);

} - analyse the code and identify why it will not work

15) When a LINQ to Entities is Executed

some expression in the query might be executed on the server and some parts might be
executed locally on the

client. Client-side evaluation of an expression takesplace before the query is executed on the
server-------------------------ANS

some expression in the query might be executed on the server and some parts might be
executed locally on the

server. Client-side evaluation of an expression takesplace before the query is executed on the
server

some expression in the query might be executed on the server and some parts might be
executed locally on the

client. server-side evaluation of an expression takesplace before the query is executed on the
server

None of the options

16) which of the following statements are true about varchar data type?

varchar can hold alphanumeric data------------------------------------------------ANS

the storage size of varchar datatype is fixed

each row can hold different number of characters up to the max length defined-----ANs

each row can hold fixed number of characters as defined by max length

17) What is meant by materialization in entity framework?

Materialization is the process of returning query results back to the client as entity types

Materialization is the process of returning query results back to the client as CLR types-----------
ANS
 Materialization is the process of returning query back to the client as CLR types

None of the options

18) Partial page rendering does which of the following

removes the need for the whole page to be refreshed as the result of a HTTPGet

only individual regions of the page that have changed are updated-------------------ANS

only header of the page that have changed are updated

Removes the need for the whole page to be refershed as the result of a postback-----ANs

19) Correct syntax for ActionLink with following argument AjaxHelper, String, String, AjaxOptions is a.

public static MvcHtmlString ActionLink(

this AjaxHelper ajaxHelper,

string linkText,

string modelName,

AjaxOptions ajaxOptions)

b.

public static MvcHtmlString ActionLink(

this AjaxHelper ajaxHelper,

string linkText,

string actionName,

AjaxOptions ajaxOptions;

c.-----------------------------ANS

public static MvcHtmlString ActionLink(

this AjaxHelper ajaxHelper,

string linkText,

string actionName,

AjaxOptions ajaxOptions)
20) Which of the following will render carinfo object stored in viewbag to a view

Select one:

a.

<p>

car information: @[Link]

</p>

b.

<p>

car information: @ViewBag{carinfo}

</p>

c.

<p>

car information: @[Link](carinfo)

</p>

d.---------------------------------------------- ANS

<p>

car information: @[Link]

</p>

21) Which of the following option is correct about Navigation Property

 Navigation properties provide a way to navigate an assiciation between two entity types

Every object can have navigation property for every relationship in which it participates

Navigation properties allow you to navigate and manage relationship in both directions,
returning either a reference object or a collection

All of the options------------------ANS

22) IObjectContextAdapter Interface is used to:

get the reference of ObjectContext from object

get the reference of ObjectContext from entity

get the reference of ObjectContext from DBModel

get the reference of ObjectContext from DBContext-----------ANS

23) which exception will raise when you define an entity data model that uses stored procedures to
make updates to the data source

OptimisticException

ConcurrencyException

OptimisticConcurrencyException-----------ANS(Doubt)

None of the options

24) analyse the link:- "[Link] Choose the option which is correct for it

I. Not running under cassini

II. running under IIS

I only

II only--------------------------------------------------------------------------------------------ANS

both I and II

none of the options

25) Which of the following model is used to defined application specific object

Entity Data Model-------------ANS

SqlDataModel

ObjectModel

None of the Options

26. What are the different classes into which the SQL server divides principles?

select one or more

a. windows-level principle-------------------------------ANS

b. field-level principle

c. database-level principle------------------------------ANS

d. SQL Server- level principle---------------------------ANS

27. LINQ stands for

select one

a. Line Integrated Query

b. Line Integrated New Query

c. Language Integrated New Query

d. Language Integrated Query-------------------------------------------------------------------------------ANS

28. How can the execution plan of queries on partitioned tables and indexes be examined?

Select one or more

a. By using the Transact SQL SET SHOWPLAN_XML------------------------------------------------------ANS

b. By using the Transact SQL SET STATISTICS_XML----------------------------------------------------ANS

c. By using the Transact SQL SET PARTITION_XML

d. By using the Transact SQL SET INDEX_XML

29. You are given a task to make the current form secure such that it can be prevented csrf. Which of
the following will be helpful?
Select One

a. <% using ([Link]()) {%><%= [Link]()%}

b. <% using ([Link]()) {%><%= [Link]()%}-----------------------------------------

----------ANS

c. <% using ([Link]()) {%><%= [Link]()%}

d. <% using ([Link]()) {%><%= [Link]()%}

30. Which of the following is true in doing DB initialization in config file?

Select one (both a and c are same check once again)

a. <?xml version=1.0 encoding=utf-8?><configuration><appSettings><add

key=[Link], BlogDataLayer/></
appSettings></configuration>

b. <?xml version=1.0 encoding=utf-8?><configuration><appSettings><add

key=[Link], BlogDataLayer

value=[Link]`1[[[Link],
BlogDataLayer]], EntityFramework/></ appSettings></configuration>---------------------------------------------
--------------------ANS

c. <?xml version=1.0 encoding=utf-8?><configuration><appSettings><add

key=[Link], BlogDataLayer/></
appSettings></configuration>

d. <?xml version=1.0 encoding=utf-8?><configuration><appSettings><add

key=[Link], BlogDataLayer, value=Create
Database/></ appSettings></configuration>

31. Which of the following statements are true.

I. The CompiledQuery class provides compilation and caching of queries for reuse.

II. Execute method is to create a new delegate to represent the compiled query.

III. Once the query is compiled you can only supply parameters of primitive type but you cannot replace
parts of the query that would change the generated SQL

Select one

a. I and II

b. II and III

c. I and III------------------------------------------------------------------------------------------ANS
d. I, II and III

32. What do you understand by XSS attack?

Select One

a. Injection of malicious script------------------------------------------------------------------------ANS

b. Injection of class definition

c. Hacking via Browser

d. Hacking through cookies

33. What are the benefits of using Unique index?

Select one or more

a. It is less error prone

b. Data integrity of the defined column is ensured-----------------------------------------------------ANS

c. Additional information helpful to the query optimizer is provided-----------------------------------ANS

d. The performance is not degraded---------------------------------------------------------------------ANS

[([Link]

Benefits of a Unique Index

Multicolumn unique indexes guarantee that each combination of values in the index key is unique. For
example, if a unique index is created on a combination of LastName, FirstName, and MiddleName
columns, no two rows in the table could have the same combination of values for these columns.

Provided that the data in each column is unique, you can create both a unique clustered index and
multiple unique nonclustered indexes on the same table.

Unique indexes ensure the data integrity of the defined columns.

Unique indexes provide additional information helpful to the query optimizer that can produce more
efficient execution plans.)]

34. Which action result type will return a temporary redirect (HTTP 302 status code) or a permanent
redirect (HTTP 301 status code) depending on the Boolean parameter?

Select one
a. HttpNotFoundResult

b. RedirectResult----------------------------------------------------------------------------------
ANS([Link]

c. HttpStatusCodeResult

d. HttpRedirectResult

35. You are handling a page of event. Now the content and information you have cached so that it is
loading quickly but

you need to keep a clock which shows time for the event dynamic. Which of the following will be
helpful?

a. <%DateTime([Link]);%>

b. <%[Link](t=>[Link]())%>-------------------------------------
--------------------ANS

c. <% var c = [Link]() %>

d. <%session s= new session[Time];%>

36. What is entity Key?

Select One

a. An entity key is a property or a set of properties of an entity type that are used to determine
identity--------------------------------------------------------------------ANS

b. An entity key is a property or a set of properties of an entity type that are used to determine the
column for searching index

c. An entity key is a property or a set of properties of an entity type that are used to identity
relationship among the entities.

d. All of the listed

37. Problem Statement- Peter is a web developer and has created a website in [Link] MVC3 using
razor view. People were giving feedback on his site without going through products detail page. They
were navigating to the feedback page by editing the URL.

Now as a friend, suggest him to use ChildAction through @HtmlAction.

Which of the following would he choose?

Select one
a. The solution given by Brock is legitimate

b. Peter should use @[Link] in place of @HtmelAction

c. Peter should user ChildActionOnly in place of ChildAction------------------------ANS

d. Such problem cant exist

51) Identify the different types of stored procedures.

[Link]-defined stored procedures-Transact SQL & CLR.------------------Ans

[Link] Stored Procedures.-----------------------------------------Ans

[Link] Stored Procedures.

[Link] Stored Procedures.-------------------------------------------Ans

52) Which method converts string to HTML Encoded string?

[Link].

[Link].

[Link].---------------------------------------------Ans

[Link].

53) [Link],contains settings that apply to an entire [Link] true or False.

[Link].

[Link].--------------------------------------------------------------Ans

54) The ObjectContext class is not [Link] True or False.

[Link].---------------------------------------------------------------Ans

[Link].

55) Which of the package can be used to write an implementation for [Link] Identity that targets
different persistence stores such as Azure Table Storage,NoSQL databases etc.?
[Link].-------------------------------------Ans

[Link].

[Link]

[Link];

56) Which of the following is a way to install/download a Nuget in your system?

[Link] your browser go to [Link]->click on Download

[Link] visual studio,go to tools->Extension Manager->search Nuget->Install

[Link] of the listed options----------------------------------------------------------------------------------Ans

[Link] a visual studio,right click on references->Add LibraryPackageReferences->search Nuget->Install

57) public class DependencyResolver-is the syntax for Dependency resolver [Link] True or False.

[Link]---------------------------------------------------------------------Ans

[Link]

58) Which of the following code snippets is correct for an entity Post having relationship with Blog?

[Link]<Post>().HasRequired(p=>[Link])------------------------Ans

[Link]<Post>().NeedRelationship(p=>[Link])

[Link]<Post>().Required(p=>[Link])

[Link] of the listed options.

59) Which of the following approach do we avoid working with the visual designer or entity framework?

[Link] First Approach.--------------------------------Ans

[Link] First Approach.

[Link] Approach.

[Link] of the listed options.

60) Which of the following statements are TRUE?

[Link] wins and store wins are actions which are used when concurrency happens.
[Link] Client wins the data from the server is loaded in to your entity objects.

[Link] Store wins data from the entity object is saved to the database.

a.i and ii

[Link] and iii

[Link] i----------------------------------------------Ans

d.i,ii and iii

*************************************************************************************
************************************************

mohak

[Link] to Entities provides developers to write LINQ queries

Stata True or False.

Select one:

True-------------------------------------------------------ANS

False

[Link] does not support Complied Queries.

State True or False.

Select one:

True-------------------------------------------------------ANS

Fasle

[Link] to Entity Query results are usually returned as which of the following?

Select one:
a.A collection of zero or more typed entity objects or a projection of complex types defined in the
conceptual model.

[Link] collections

[Link] to objects

[Link] types

[Link] of the listed options.-------------------------------------------------------ANS

[Link] is also known as____________.

Select one:

[Link] the listed options

b.L10N-------------------------------------------------------ANS

[Link]-zation

[Link]

[Link] of the following principals are included in the security context ?

Select one or more:

a. The login

b. The user--------------------------ANS

c. Authentication memberships--------ANS

d. Role memberships-----ans

e. Role aggregation

[Link] are user defined functions different from User-defined Stored Procedures?

[Link] user-defined function the default parameter is specified with a DEFAULT keyword.----ans

[Link] User-defined function omitting the parameter also implies default value.

[Link]-defined functions do not support output parameters.---------------------------------Ans

[Link]-defined functions do support output parameters.

[Link] expression starts with____________.

a.@---------------------------------------------------ANS

b.%

c.#

d.$

[Link] is given a task to make his website a bit intelligent and in the process he's been told to add
autocomletion on the "searchBox".Which of the following will be helpful?

select one

ans: $function(){

$("#searchBox").autocomplete("/Product/SearchCandidates",{minChars:3});

});

[Link] is the significance of INSTEAD OF argument of the CREATE TRIGGER statement?

Select one or more:

[Link] that the DML trigger is excuted instead of the triggering SQl statement

[Link] overrides the actions of the triggering statements-------------------------------------------------------------------

----------------ANS

[Link] can be specified for DDl or logon triggers--------------------------------------------------------------------------------

-----------ANS

[Link] cannot be specifoed for DDl or logon triggers.

[Link] of the foloowing provider is used to access data in conceptual model?

Select one:

[Link] provider-------------------------------------------------------ANS

[Link]

[Link]
[Link]

[Link] are NON-clustered indexes different from Clustered indexes?

select one:

[Link] data columns of the underlying table are not stored in order based on their nonclustered keys.

[Link] data rows of the underlying table are sorted and stored in order based on their nonclustered
keys.-------------------------------------------------------ANS

[Link] leaf layer of a nonclustetred index is amde up of index pages instead of data pages.--------------------
-----------------------------------ANS

[Link] leaf layer of a nonclustetred index is amde up of data pages instead of index pages.

[Link] of the following statements are true about Clustered index?

Select one or more:

a.A clustered index sorts and stores the data rows of the table or view in order based on clustered index
key-------------------------------------------------------ANS

b.A clustered index sorts and stores the data columns of the table or view in order based on the
clustered index key.

c.A clustered index is implemented as a B-tree index strucuture-------------------------------------------------------

ANS

d.A clustered index is implemented as aLinked-list structure.

[Link] of the following object is used to query and modify data?

Select one:

[Link]-------------------------------------------------------ANS

[Link]

[Link]

[Link] of the listed options.

14. Your manager has given youa task to write a code to list recent 30 events and this should be
accessible to no one other than admins.

which of the following should you choose?

select one:

[Link] class EventController:Controllers{public ActionResult Index(){AspNerDB db = new AspNerDB();

var f=[Link](e=>[Link]).take(30);return View(f);}}

b.[Authorize(Roles="Managers")]public class EventController:Controllers{public ActionResult

Index(){AspNerDB db = new AspNerDB(); var
f=[Link](e=>[Link]).take(30);return View(f);}}

c.[Authorize(Roles="Admin")]public class EventController:Controllers{public ActionResult

Index(){AspNerDB db = new AspNerDB(); var
f=[Link](e=>[Link]).take(30);return View(f);}}--------------------------------
-------------------------------------------ANS

[Link] class EventController:Controllers{public ActionResult Index(){AspNerDB db = new AspNerDB();

var f=[Link](e=>[Link]).take(30);return View(f);}}

[Link] of the following are the data annotations attribute?

Select one or more

[Link]

[Link]

[Link]-------------------------------------------------------ANS

[Link]-------------------------------------------------------ANS

[Link] of the following annotation is used to mark one or more properties to be used for concurrency
checking while user modifies in an entity?

Select one:
[Link]-------------------------------------------------------ANS

[Link]

[Link]

[Link] of the listed options

[Link] the link:- "[Link] Choose the option which is correct for it

I. Not running under cassini

II. running under IIS

I only

II only---------------ANS

both I and II

none of the options

[Link] default in Entity Framework Snapshot change tracking is enabled snapshot change tracking
mechanism.

State true or false

True-------------------------------------------------------ANS

Fasle

[Link] are the significance of recovery model setting??

Select one or more:

a)it determines how much data can be recovered in the event of a media failure-----------------Ans

b) it determines the location where the data should be recovered in the event of a media failure

c)the default recovery is full , which provieds the greatest level of recovery-----------------Ans

d) the default is partial which provides the greatest level of recovery

[Link] wants to make the appearance of his site [Link] wants to show an image when a
"divhello" result takes time to display.

Which of the following should he choose?

Select one:

a.[....@[Link]("Hello","Hello",new AjaxOptions(){UpdateTargetID="div-
hello",HttpMethod="GET",LoadingElementId="divloadingimage"})....]

b.[....@[Link]("Hello","Hello",new AjaxOptions(){UpdateTargetID="div-
hello",HttpMethod="GET",LoadingElementId="divloadingimage"})....]

c.[....@[Link](AjaxOptions(){UpdateTargetID="divhello",HttpMethod="GET",LoadingElementId
="divloadingimage"})....]

d.[....@[Link]("Hello","Hello",new
AjaxOptions(){UpdateTargetID="divhello",HttpMethod="GET",LoadingElementId="divloadingimage"})....
]------ans

[Link] template is used in entity framework to generate code in C# by reading .edxm file?

a. C# template

b. T4 template---------------------------------ANS

c. XML template

d. none

[Link] of the following are used to locate the entities at the ends of an association in a conceptual
model?

Select one:

[Link] properties.------=---- Ans

[Link]

[Link]
[Link]

[Link] is Dependency Injection?

Select one:

a.A technique gor achieving tight coupling between objects and their collaborators.

b.A technique gor achieving loose coupling between objects and their collaborators.---------------------------
----------------------------ANS

c.A technique gor achieving tight coupling between Model and their views.

d.A technique gor achieving tight coupling between Model and their respective server.

[Link] define the______________of an object but not the behavior of the object.

select one:

[Link]

[Link]-------------------------------------------------------ANS

[Link]

[Link] of the liosted options.

25.A basic TDD cycle is______.

Select one:

[Link]-Green-Refactor-------------------------------------------------------ANS

[Link]-Error-Resolve

[Link]-Green-Resolve

[Link]-Pass-Repeat

[Link] can pass information from a controller to a view using ViewBag.

State true or False:

Select one:

True-------------------------------------------------------ANS

False

[Link] of the following require type-casting in the view?

[Link]

[Link]

Select one:

a.I only

[Link] only

[Link] I and II-------------------------------------------------------ANS

[Link] of the listed options

[Link] of the following keyword is used for lazy loading related data in entity framework?

Select one:

[Link]

[Link]-------------------------------------------ANS

[Link]

[Link]

[Link] can we disable proxy object creation in POCO?

A) [Link] = FALSE;

B)[Link]=FALSE;

C) [Link] = FALSE;

D)[Link] = FALSE;---------------ANS
[Link] of the package can be used to write an implementation for [Link] Identity that targets
different persistence stores such as Azure Table Storage, NoSQL databases etc..,?

Select one:

[Link]

[Link]...................ans

[Link]

[Link]

31. [Link](new SampleFilter())- what will the above piece of code do ?

Select one:

a. It will move it sample filter to the global filter

b. None of the listed options

c. It will add custom filter "SampleFilter" to the GlobalFilters------------------------------------------------ANS

d. it is not possible to add new filter, so it will give an error

32. Which of the following statements are true about extended stored procedures?

Select one or more:

a. they are inherited from another user defined stored procedure

b. they are DLLs developed in a programming language like c that an instance of

Microsoft SQL server can dynamically load and run-------------------------------------------ANS

c. they run directly in the address space of an instance of SQL server-------------------------------------------ANS

d. they are programmed by using the SQL server extended stored procedure APL--------------------------------
-----------ANS
33. ObjectContext mainly used for which of the following ?

i. Database connection

ii. Object set of every entity

iii. state of pending changes

Select one:

a. i and ii

b. i and iii

c. ii and iii

d. i, ii and iii-------------------------------------------ANS

34. ModelBinder interface defines

select one:

a. the .dll files that are required for a model binder

b. the interface that are required for a model binder

c. the methods that are required for a model binder-------------------------------------------ANS

d. the assembly that are required for a model binder

35. which of the following is the correct option to get related subjects count without loading

it of the student name os "vijay" ?

select one:

a. var user = [Link](b =>[Link] == "vijay").FirstorDefault();var subjectCount =

[Link]();
b. var user = [Link](b =>[Link] == "vijay").FirstorDefault();var subjectCount =
[Link](user).

Take(b =>[Link]).Query().Count();

c. var user = [Link](b =>[Link] == "vijay").FirstorDefault();var subjectCount =

[Link](user).

Include(b =>[Link]).Query().Count();

d. var user = [Link](b =>[Link] == "vijay").FirstorDefault();var subjectCount =

[Link](user).

Collection(b =>[Link]).Query().Count();--------------------------------------------------------------------------------
ANS

36. Which statements are true about nonclustered indexes with respect to partitions?

select one or more:

a. nonclustered indexes have one row in [Link] with index_id >0 for each partition used by the
index-------------------------------------------ANS

b. nonclustered indexes have one column in [Link] with index_id >0 for each partition used by
the index

c. by default, a nonclustered index has a single partition-------------------------------------------ANS

d. by default, a nonclustered index has a multiple partition

e. each partition has a B-tree structure that contains the index rows for that specific partition------ans

37. If we want to retrieve friend along with contact entity, which of the following code will fetch us the
required result ?

select one:

a. [Link] index(){var friends = [Link](a => [Link]);return View(friends);}-----

--------------------------------------ANS

b. [Link] index(){var friends = [Link];return View(friends);}

c. [Link] index(){var friends = [Link](a => [Link]);return View([Link]);}

d. [Link] index(){var friends = [Link](a => [Link]);return View(friends);}

38. How does SQL Server execute a stored procedure or a trigger ?

select one or more:

a. SQL server stores only the source for stored procedures and rtiggers--------------------------------------------
------------------------------ANS

b. SQL server keeps the stored procedures & triggers in compiled form for future execution

c. when a stored procedure or trigger is first executed, the source is compiled into an execution plan-----
---------------------------------------ANS

d. if the stored procedure or trigger is again executed before the execution plan is aged from memory,
the relational

engine detects the existing plan and reuse it------------------------------------------------------------------------------

--------------------ANS

e. if the execution plan has aged out of memory, a new plan is built-------------------------------------------------
----------------------------ANS

39. Jason is trying to access Appsettings of "sampleserverA" & the accidently wrote this varserver =

[Link]["sampleserver"];- what result will he get ?

select one:

a. He will get an alert

b. He will get a nullvalue back

c. He will get a ArgumentException-----------------------------------------------------ANS

d. All the listed options

40. choose a code block which will show "Hello World" on the WEb page
select one:

a. public ActionResult Index()

[Link] = "Hello World";

return View();

b. public ActionResult Index()

View@Message = "Hello World";

return View();

c. None of the listed options

[Link] ActionResult Index()

[Link] = "Hello World";-------------------------------------------ANS

return View();

41. "Type or Namespace name "SampleTest" could not be found" - you are getting the above error while
you

trying to build a test. what could be the reason ?

select one:

a. You didn't instantiate the object for the sampletest controller and view

b. you didn't have the class called "sample test"

c. the inline constructor is yet to get validated

d. you have not parsed the class assembly------------------------------------------ANS

42. if we use database first generation a Dbcontext is generated by default

State true or false

select one:

a. true-------------------------------------------------------------ANS

b. false

43. which of the following are the standard query operators of LINQ ?

select one:

a. select

b. where

c. groupby

d. all the listed options-------------------------------------------ANS

44. which method in the DBcontext writes inserts, updates and deletes to the data source ?

select one:

a. save

b. saveChanges-------------------------------------------ANS

c. saveEntity

d. All of the listed options

45. Natasha is typing to access a page but she is not able to do it. on the other hand, when john logged
in

via his credentials he could. what may be the reason ?

select one:

a. web server credential overriding

b. roel based access -------------------------------------------ANS

c. URL customization

d. Account rendering

46. Entity framework provides us with which of the following attribute to indicate multiple relationships

between two labels ?

select one:

a. [insertProperty]

b. [InverseProperty]------------------------------------------------------------ANS

c. [INProperty]

d. None of the listed options

47. how is the information returned from table-valued functions ?

select one or more:

a. information may be returned from table-valued functions using output paramaters-------------------------

------------------ANS

b. information may be returned from table-valued functions using return paramaters

c. you must specify the parameters by value

d. you must specify the parameters by reference--------------------------------------------------------------------------

----ANS
48. sam is developing [Link] MVC 3 web application. He is using SQL server as database. As it is in
staring stages,every time

the database changes, an error pops up in the application. which of the foolowing method should sam
add to take care of this ?

select one:

a. DropCreateDatabaseselfModelChanges<>()-------------------------------------------ANS

b. RefreshDb<>()

c. DeleteUpdateDatabaseselfModelChanges<>()

d. none of the listed options

49. which statements are true about the max constant in a varchar type ?

select one:

a. It can be used when the data can exceed more than 8000 characters---------------------------------------------
-----ANS

b. it can be used to fix the max length of characters for the entire column-----------------------------------------
--ANS

c. it can be used to store large blocks of text-----------------------------------------------------------------------ANS

d. it can be used to store large image types

50. By default value of "UnobstustiveJavaScriptEnabled" is

select one:

[Link]

[Link]

[Link]---------------------------------------------------------------------------------------ANS
[Link]

[Link] which folder is the [Link] file stored?

Select one :

a.App_Data

b.App_Start-------------------------------------------ANS

[Link]

[Link]

[Link] is a new developer and the manager has told him to make the current code less [Link]
current code

has all the html and processing code in same file.

Which of the following should he choose?

Select one:

[Link] him to use seperate models and controller for each logic and store it in new database

[Link] him to use partial views and create custom Html helpers to make the ocde readable and less
croeded of all the things in one place.---------------------------ANS

[Link] him to create a new page for every logic.

[Link] of the listed option

[Link] class is used for transactions in entity framework?

Select one:

[Link] Transaction-------------------------------------------ANS

[Link]

[Link]

[Link] of the listed options.

[Link] of the following statements are true about varbinary data type?

Selct one or more:

[Link] can hold binary data.-------------------------------------------ANS

[Link] can hold character data.-------------------------------------------ANS

[Link] exceed 8000 characters -------------------------------------------ANS

[Link] value is absed on regular expression logic

[Link] are the steps for creating partition tables&indexes?

Select one or more:

[Link] partition function to specify how a table or index that uses the function can be partitioned-------
------------------------------------ANS

[Link] partition function to specify the placement of the partitions of a partition function on
filegroups

[Link] partition Schema to specify the placement of the partitions of a partition function on
filegroups------------------------------------------ANS

[Link] partition Schema to specify how a table or index that uses the function can be partitioned

[Link] a table or index using the partition Schema-------------------------------------------ANS

[Link] are the restrictions related to the database file creation?

Selct one or more:

a. Database file name shouuld not be more than 8 characters

[Link] file name should be unique---------------- Ans

[Link] file must reside on one of the following devices: the local server on which SQL Server is installed,a
Storage

Area Network[SAN],or an iSCSI-based network

[Link] path specified must exist on the drive prior to creating the database---------------- Ans
[Link] the correct code to execute sql raw query in the entity frameqwork from the following

select one:

[Link](var ctx = new schoolDBentities())

varstudentlist = [Link]("select*from student").tolist<student>();

[Link] of these

[Link](var ctx = new schoolDBentities())

varstudentlist = [Link]("select*from student").tolist<student>();

[Link](var ctx = new schoolDBentities())

varstudentlist = [Link]("select*from student").tolist<student>();-----------------------

--------------------ANS

[Link] current date using javascript as Sat Jun 4 2016

select one:

a.-------------------------------------------ANS

<p id-"sample"></p>

<script>

var d= new Date();

[Link]("sample").innerHTML=[Link]();

</script>

b.

<p id-"sample"></p>
<script>

var d= new Date();

[Link]("sample").innerHTML=[Link]();

</script>

c.

<p id-"sample"></p>

<script>

var b= new Date();

[Link]("sample").innerHTML=[Link]();

</script>

d.

<p id-"sample"></p>

<script>

var d= new Date();

[Link]("sample").innerHTML=[Link]();

</script>

[Link] of the following is issued to obtain a configuration object for a given property in Fluent API?

Select one:

[Link]()

[Link]()

[Link]()

[Link]()-------------------------------------------ANS

[Link] of the following are database initialization strategies in EF code First?

Select one or more:

[Link]----------------------------------ANS
[Link]

[Link]----------------------------------ANS

[Link]

*************************************************************************************
************************************************

arjun

Entity Framework supports three ways to load related data -

eager loading, lazy loading and explicit loading. The techniques

shown in this topic apply equally to models created with Code First and the EF Designer.

[Link] of the following loading is supported by Entity framework?

select one:

[Link] Loading

[Link] Loading

[Link] Loading

[Link] -----------------------------------------------------------------------------ANS

[Link] stored procedure returns complex type that is only on conceptual model and not in databse table

ans:complex

[Link] wants to make the appearence of his site [Link] wants to show an image when a
"divhello" result takes time to display

which should be choosed?

select one

a.[....@[Link]([Link]())

UpdateTargetId="div-hello",Httpmethod="GET",LoadingElementId="divloadingimage"

} )...]

b.[....@[Link]("Hello","Hello",new [Link]())

UpdateTargetId="div-hello",Httpmethod="GET",LoadingElementId="divloadingimage"

} )...]

c.[....@[Link]("Hello","Hello",new [Link]())

UpdateTargetId="divhello",Httpmethod="GET",LoadingElementId="divloadingimage"

} )...]-------------------------------------------------------------------------------------------------------ANS

d.[....@[Link]([Link]())

UpdateTargetId="divhello",Httpmethod="GET",LoadingElementId="divloadingimage"

} )...]

[Link] resolver() is destructor

[Link]

[Link]...............ans
[Link] can CLR functions be used?

select one or more:

[Link] functions can be used to access external files-----------------------------------------------------------------------

------ANS

[Link] functions can be used to access network resources---------------------------------------------------------------

--------------ANS

[Link] functions can be used to configure the instance of SQL server--------------------------------------------------

---------------------------ANS

[Link] functions can be used to access WEb services----------------------------------------------------------------------

-------ANS

[Link] functions can be used to connect to other databases

[Link] syntax of GetService Method is?

Select one

[Link](

Type serviceType

[Link] GetService(

Type serviceType

)-----------------------------------------------------------------------------ANS

[Link] GetService(

[Link]

)
[Link] GetService(

[Link]

[Link] cache is used to cache output of a controller

ans:true

It enables us to cache the content returned by any controller method

so that the same content does not need to be generated each time the same controller method is
invoked

[Link] sql is a storage independent query language

ans:true

[Link] of the following method is used to get correct type for the specified target role in a
relationship in the class relationshipmanager?

select one:

[Link] End---------------------------------------------------ANS

[Link]

[Link]

[Link]

[Link] of the following is the full form of CSDL ?

[Link] SelectData Definition Language

[Link] Select Definition Language

[Link] Set Definition Language

[Link] Schema Definition Language-------------------------------------------------ANS

[Link] can we get the single employee name when there are many employees whose name is "John" in
the database?

Select one:

[Link] employee=(from emp in [Link] where [Link]="John"select

emp).FirstOrDefault<Employee>()

[Link] employee=(from emp in [Link] where [Link]=="John"select

emp).FirstOrDefault<Employee>()-----------------------------------ANS

[Link] employee=(from emp in [Link] where [Link]=="test" select emp);

[Link] of the listed options

[Link] of the following does the input to QueryOptimizer consist?

Select one or more:

[Link] query

[Link] database schema-------------------------------------------------ans

[Link] database statistics-------------------------------------------------ANS

[Link] selected rows.

Note:The input to the optimizer consists of the query, the database schema (table and index
definitions), and the database statistics.

([Link]

[Link] are the following are the type of entity?

Select one or more:

[Link] entity------------------------------------------------------------ANS

[Link] proxy entity------------------------------------------------------------ANS

[Link]

[Link]

[Link] statements are true about RANK function?

Select one or more:

[Link] returns the rank of each row in the table within the partition of a database.----------------------------------
--ANS

[Link] rank of a row is equal to the number of ranks that come before the row in question.

[Link] rank of a row is one plus the number of ranks that come before the row in question--------------------
-----ANS

[Link] RANK function returns consecutive integers.

[Link] Rank function does not always return consecutive integers. ---------------------------------------------------
----------------------ANS

[Link] to XML is based on in-memory XML programming interface.

State True or False

Select one:

True----------------------------------------------------ANS

False

[Link] are the conditions for assemblies created by using EXTERNAL ACCESS permission sets?

Select one or more: ---------------------------------------------ANS

[Link] assesmbly code should be type-safe-----------------------------------------------------------------------------------

---ANS
[Link] assesmbly should contain only stattic data members in its classes unless they are marked as read-
only------------------------------------------------------------ANS

[Link] classes in the assesmbly must contain finalizer methods---------------------------------------------------------

---ANS

[Link] classes or methods of the assesmbly should be annotated only with allowed codes attributes--------
----------------------------------------------------ANS

([Link]

[Link] one in the following is not included in the configuration hierarchy?

Select one:

[Link] web

[Link]

[Link] Application sub directory

[Link] Client Server sub directory------------------------------------------------------------ANS

[Link] root directory.

[Link] is meant by Materialization in entity framework? REPEATED QUESTION

Select one:

[Link] is the process of returning query results back to the client as entity types.

[Link] is the process of returning query results back to the client as CLR types.---------------------
----------ANS

[Link] is the process of returning queries back to the client as CLR types.

[Link] of the listed options.

[Link] command will remove the package?

Select one:
[Link] packageName----------------------------------ANS

[Link] package

[Link]-package PackageName

[Link] of the listed options.

[Link] need to write a view to show Hi!"username" If user is authenticated display signoff link & sign in
link for anonymous user.

Which of the following should you choose?

Select one:

a.<%if([Link]){Hi!<%=[Link]([Link])%>[<%=[Link]
k("SignOff","SignOff","Account")%>]<%}else{%>[<%=[Link]("Sign In","Sign
In","Account")%>]<%}%>-------------------------------------------------------------------------------------------ANS

b.<%{Hi!<%=[Link]([Link])%>[<%=[Link]("Sign Off","Sign
Off","Account")%>]<%}else{%>[<%=[Link]("Sign in","Sign in","Account")%>]<%}%>

c.<%(user=Authorize){Hi!<%=[Link]([Link])%>[<%=[Link]("Sign
Off","Sign Off","Account")%>]<%}else{%>[<%=[Link]("Sign in","Sign in","Account")%>]<%}%>

[Link] of the listed options.

40) Which of the following is Lambda operator?

a) "a"

b) "=>"-----------Ans

c) " "

d) "@"

[Link] state is the default state of newly created entity.?

ans:true
Note:Detached is the default state of a newly created entity because the context cant track the creation
of any object in your code.

38) Which statements are true about DENSE_RANK function?

a) Returns the rank of rows within the partition of a result set, without any gaps in the ranking---------
Ans

b) The rank of a row is one plus the number of distinct ranks that come before the row in question-------
--Ans

c) Returns the rank of each row within the partition of a result set

d) The rank of a row is one plus the number of ranks that come before the row in question

[Link] are given a task by your manager that include assembly binding??

ans:[Link]

Note: [Link] contains configuration settings for machine-wide assembly binding, built-in
remoting channels, and [Link].

36) What does the update command do?

a) Updates a package----------Ans

b) Updates the project

c) Updates the Visual studio

d) Updates the solution

35) On what conditions can you perform concurrent online index operations on the same table?

a) Creating multiple clustered indexes

b) Creating multiple nonclustered indexes------------------------------ans

c) Reorganizing different indexes on the same table------------------------ans

d) Reorganizing unique indexes on multiple tables

 e) Reorganizing different indexes while rebuilding nonoverlapping indexes on the same table---------------
-ans

34) How can we disable proxy object creation in POCO?

a) [Link]=false

b) [Link]=false

c) [Link]=false

d) [Link]=false----------Ans

33) What is Remote Validation?

a) it is a mechanism that can make a remote client call in order to validate a form field without passing
the entire form to the server

b) A mechanism to validate a client machine through remote call

c) A mechanism to validate form field using remote conditions

d) A mechanism that can make a remote server call in order to validate a form field without posting the
entire form to the server------------Ans

32) Which of the following is the CORRECT option for Model First approach?

a) Generate a Database from a Model------------Ans

b) Generate a Model from the Class

c) Generate a Model from the Database

d) Generate a Object from the Model

31) Which of the following are the properties of the HTTPConfiguration class?

Select one or more:

a) Message Handlers----------Ans

b) Comparer

c) Stack Tree

d) Dependency Resolver--------Ans
[Link] Model We can keep Which of the following:

select one or more............ans

a:Business Logic..............ans

b:Data Logic..................ans

c:Session Logic...............ans

d:Validation Logic............ans

Note:The model is where the domain-specific objects are defined. These definitions should include
business logic (how objects behave and relate),

validation logic (what is a valid value for a given object), data logic (how data objects are persisted) and
session logic (tracking user state for the application).

29)what is the purpose of NotMapped annotation in entity framework

a)not to create a property for an entity

b)to remove mapping a property to the data base for an entity..........ans

c)to add property for a data base entity

d)none

Note: You can apply NotMapped attribute to a property which you do NOT want to create a column in a
database table for.

[Link] of the following arguments of the CREATE TRIGGER statements specifies

the security context under which the trigger is executed.

a)all server

b)with encryption

c)execute as--------------ans

d)instead of

[Link] default, LINQ supports which of the following

[Link] Loading--------------ans

[Link] Loading

[Link] Loading

Note:By default LINQ supports lazy

loading.([Link]
eager-loading)

[Link] of the following statements are true about trigger creation?(multiple)

[Link] TRIGGER must be the first statements in the batch-----------------------ans

[Link] TRIGGER must be the last statements in the batch

[Link] TRIGGER can apply to only one table----------------------------------------------------ans

[Link] TRIGGER can apply to multiple tables

e.A trigger is created only in the current database;however a trigger

can references objects outside the current database-----------------------ans

[Link] of the following two are name types of SQL Server Files?

select one or more:

a:Physical_File_name

b:Logical_file_name......................ans

c:Primary_File_Name

d:Os_File_Name...........................ans

23.23)which of the following options are true about temp. stored procedures

with respect to performance?

b:Heavy use of temporary stored procedures can create contention on the system tables in tempdb
and adversely affect performance........ans

c:It is recommended that sp_executesql be used instead....................ans

e:sp_executesql discard data in the system tables and therefore avoids the problem............ans
[Link] entity framework ,Data is retrieved as objects.

true..................ans

false

[Link] are Entity state members?

select one

a:Added

b:Deleted

c:Modified

d:All of the listed options..................ans

20. What is entity key?

select one

a. An entity is a property or a set of properties of an entity type that are used to determine identity.------
------------------ans

b. An entity is a property or a set of properties of an entity type that are used to determine the column
for searching index

c. An entity is a property or a set of properties of an entity type that are used to identify relationship
among the entities

d. All of the listed options

[Link] the following definition and choose the correct option. -->Contains methods to create types of
objects locally or remotely ,or obtain references to existing remote objects.

select one

a:Activator................ans

b:Validator

c:ModelBinder

d:Dependency Resolver
[Link] need to perform an arithmetic operation in Razor view. which of the following will accomplish
the task?

a. "@[value][arithmatic operator][value]"

b. "@;([value][arithmatic operator][value])"

c. "@:([value][arithmatic operator][value])"

d. "@([value][arithmatic operator][value])"-------------------------------------------------------------ANS

[Link] are the features supported by SQLXML in SQL Server?

select one or more

a. ability to transform the result of a query into XML on the client side ---------------------------------------------
----------------ANS

b. ability to create an XML view of relational data bye using an annotated XSD mapping schema file-------
------------------------------------------------------ANS

c. ability to access SQL server using HTTP-------------------------------------------------------------ANS

d. ability to access SQL server using TCP/IP

e. ability to expose functionality offered by stored procedures, user-defined functions, and template
queries as SOAP-based web services-------------------------------------------------------------ANS

16. What will be the output of the following code

Public ActionResult Search (string idea="A"){

return View();

I. It will set the default value of String idea to "A"

II. It will set the default pointer of idea to "A"

Select one:

a. Both I and II

b. II only

c. None of the listed

d. I only-------------------------------------------ANS
[Link] which of the following conditions one should go for partitioning table

select one or more:

[Link] contain large amounts of data that are used in different ways.-----ans

[Link] contain large amount of table

[Link] or updates against the table are not performing as intended, or maintenance costs exceed
predefined maintenance periods.....ans

[Link] tables has many columns.

[Link] of the statement are true about DATABASE argument of the create trigger statement

select one or more:

[Link] scope of DDL to current database.----------------------ans

[Link] trigger fires whenever event_type or event_group occours.-------------------------ans

[Link] trigger fires whenever new record is inserted in table in current database

[Link] trigger fires whenever record is deleted from table in current database.

[Link] of the following method is used to change relationship state of two entity object

[Link]

[Link]--------------------------ANS

[Link]

[Link] of the above

[Link] file will conatin the application level configurations?

select one:

[Link]

[Link]

[Link]..................ans

[Link]
Note:[Link] configuration data is stored in XML text files that are each named [Link].

[Link] does LINQ to SQL do:

[Link] enables you to query data using Datacontext

[Link] provides tightly coupled approach

Select one:

[Link] I

[Link] II

[Link] I and II-------------------------------ANS

[Link] I or II

[Link] Framework____________________ all data before storing it to the database by default ,using
valiadtion method.

[Link] ..........ans

[Link] lets yu pic date from calendar instead of writing it?true----ans

[Link] alert on the page:

a. alert("you have generated an alert box");..........ans

[Link] of the following method in Entity type configuration is used to configure an optional
relationship?

[Link]..........ans
[Link] are the different classes into which sql server divides principals?

ans:a,c,d

5 store schema definition language (SSDL)

4.___________ allows you to store and retrieve values using object-property syntax rather than key-
value syntax used by dictionary object.

[Link].................ans

[Link]

[Link]

[Link]

[Link] of the following is used to configure a Code First Model?

select one

[Link] API....................ans

[Link]

[Link]

[Link] of the listed options

[Link] provides the ability to asynchronously exchange data between a web browser and a web server?

select one

[Link].................ans

[Link]

[Link]

[Link]

*************************************************************************************
********************************************************************************
gokul-1st attempt

(Gokul)

[Link] are given a task to make the current from secure such that it can be prevented [Link] of the
following will be helpful?

Select one:

a.<% using([Link]()){%> <% = [Link]()%>

b.<% using([Link]()){%> <% = [Link]()%>-------------------------------------------------

-ANS

c.<% using([Link]()){%> <% = [Link]()%>

d.<% using([Link]()){%> <% = [Link]()%>

2. Which of the follwing statements are true about AFTER trigger?

Select one or more:

[Link] trigger executes after the statement that triggeres it completes..................................ans

[Link] trigger executes after the last trigger in the queue.

[Link] the statemnt falls with an error the trigger is not executed...............................ans

[Link] triggers cannot be specified for tables,they can only be specified foe views

[Link] triggers cannot be specified for views,they can only be specified foe tables...................ans

ANS:a,c,e

3. The ObjectContext class is not thread-safe

State True or False

Select one:

True--------------------------------------------------------------------------------------------ANS

false

[Link] can the execution plans of queries on partitioned tables and indexes be examined?

Select one or more:

[Link] using the transact-SQL SET SHOWPLAN_XML

[Link] using the transact-SQL SET STATISTICS_XML--------------------------------------------------------------------------

------------------ANS

[Link] using the transact-SQL SET PARTITION_XML

[Link] using the transact-SQL SET INDEX_XML

[Link] the link:-"Http"//localhost/music/".Choose the option which is correct for it.

[Link] running under cassini.

[Link] under IIS.

Select one:

a.I only

[Link] only--------------------------------------------------------------------------------------------ANS

[Link] I and II

[Link] of the listed options.

[Link] void TestDate()

Distance z= new Distance();

var message = new Sample(z);

AssertAreEqual(distance,message.z);

}-Analyse the code and identify why it will not work.

Select one:

a.[Status=TestMethod]is not written

b.[TestMethod]is not written

[Link] refference is not invoked at the start of the test. --------------------------------------------------------------

--------------------ANS

[Link] of the above

7. What are the benefits of using a Unique index?

Select one or more:

[Link] is less error prone..................................ans

[Link] integrity of the defined columns is ensured..................ans

[Link] information helpful to the query optimizer is provided..................ans

[Link] performance is not degraded.

ANS:a,b,c

[Link] of the following is a way to install/download a Nuget in your system?

Select one:

[Link] the listed options

[Link] visual studio, go to tools->Extension Manager->search Nuget->install

[Link] your browser go to [Link]->click on Download-------------------------------------------------------------------

------------------ANS

[Link] a visual studio,right click on References->Add LibraryPackagesReferences->search Nuget->Install

[Link] class DependencyResolver

- is the syntax for Dependency Resolver class

State True or False

Select one;

True--------------------------------------------------------------------------------------------ANS

False

[Link] can we create basic Entity Mapping?

Select one:

[Link]<Blog>().MapStoredProcedures();

[Link]<Blog>().MapToStoredProcedures();--------------------------------------------------------------
--------------------ANS

[Link]<Blog>().ToStoredProcedures();

[Link]<Blog>().StoredProcedures();

11) Which of the following is true for DB initialization in config file

ANS

<?xml version="1.0" encoding="utf-8"?><configuration><appSettings>

<add key="[Link], BlogDataLayer"

value="[Link]'1[[[Link],BlogdataLayer]]
,EntityFramework"/>

</appSettings></configuration>

12) LINQ stands for-----

Line integrated new query

 Language integrated new query

Language integrated Query---------ANS

Line Integrated Query

13) Which of the following option is correct about navigation property

Navigation properties provide a way to navigate an association betwwen two entity types

Every object can have a navigation property for every relationship in which it participates

Navigation properties allow you to navigate and manage relationship in both directions,
returning either a reference object or a collection

All of the options----------------ANS

14) How is a user defined table valued function in select insert update or delete statements is invoked?

a user defined table valued function can be invoked in the from clause of a select, insert, update
and delete statement------------ANS

a user defined table valued function can be invoked as a stored procedure from a select, insert,
update and delete statement

a user defined table valued function can be invoked in the where clause of a select, insert,
update and delete statement

a user defined table valued function can be invoked in the using clause of a select, insert, update
and delete statement

15) Entity framework supports automatic change tracking of the loaded entities during the life time of
the conext.

true-----------------------------ANS

false

16) Which are the different types of file groups?

Secondary

Primary------------------ANS

User-defined-------------ANS

Hidden
17) Which statements are true about CLR stored procedures?

It is a reference to a microsoft .net framework common language runtime(CLR) method------------

--------ANS

the method can only take and return user-supplied parameters.------------------------------------------

ANS

the method can only take input parameters.

they are implemented as public static ,methods on a class in a .net framework assembly-----------
-------ANS

they atre implemented as private protected methods on a class in a .net framework assembly

18) You are working on a web application and for a particular small operation it is loading the whole
page. Which of the following technology will you adopt to improve the functionality

AJAX-------------------------ANS

C++

sharepoint

selenium

19) Which of the following methods make entity framework for detecting changes automatically?

[Link]

[Link]

[Link]

All of the options------------------------ANS

20) Which exception will raise when you define an Entity Data Model that uses stored procedures to
make updates to the data source

OptimisticException

ConcurrencyException

OptimisticConcurrencyException

None of the listed options------------- ANS (doubt) may be ans is

dbupdateconcurrencyexception...........right
21) By default value of "UnobstrusiveJavaScriptenabled" is

FALSE----------ANS

TRUE

NONE

AUTO

22) Which of the following will render carinfo object stored in viewbag to a view

<p>---------------------------------------------- ANS

car information: @[Link]

</p>

23) Problem statement:- peter is a web developer and has created website in ASP>NET MVC# using
razor view. people were giving feedback on his site without goignthrough the products details page.
they were navigating to the feedback page by

editing the url.

as a friend suggest him to use "ChildAction" through "@[Link]".which of the following

would he chose??

peter should use "@[Link]" inplace of "@[Link]"

peter should use "ChildActionOnly" inplace of "ChildAction"---------------------------------------Ans

24) Which method converts string to HTML Encoded string

[Link]

[Link]---------------------------ANS

[Link]

[Link]
25) ModelBinder interface defines---------

the methods that are required for a model binder---------------ANS

the .dll filesthat are required for a model binder

the interface that are required for a model binder

the assembly that are required for a model binder

41. You are given a task by your manager that includes assembly [Link] file would you
configure?

select one:

[Link]

[Link]

[Link]-----------------------------------ANS

[Link]

42.

Unchanged state is the default state for an entity while the entity is retrived from the database

[Link]-----------------------------------------------ANS

[Link]

[Link] of the statement is true about VARCHAR datatype?

select one or more:

[Link] can hold alphanumeric data----------------------------------------ANS

[Link] storage size of varchar data type is fixed

[Link] row can hold different no of characters up to the maxlength defined.---------------------------------ANS

[Link] row can hold fixed number of characters as defined by max length.
[Link] action result typewill return a temporary redirect(HTTP 302 sattus code) or a permanent
redirect(HTTP 301 status code),depending on a boolean parameter?

select one:

[Link]

[Link]

[Link]

[Link]------------------------------------------ANS

[Link] contain setting that apply to entire network.

[Link]----------------------------------------ANS

[Link]

46.______________is an XML -based language which describes the entities ,functions and relationships
which create a conceptual model of a application.

select one:

[Link] schema definition language(CSDL)-----------------------------------ANS

[Link] set definition language(CSDL)

[Link] select definition language(CSDL)

[Link] of above

47. Which statements are true about the max constant in a varchar type?

[Link] can be used when the data can exceed more than 8000 charactes.---------------------ans

[Link] can be used to fix the max length of charactes for the entire column---------------------ANS

[Link] can be used to store large blocks of text.---------------------------------------------ANS

[Link] can be used to store large image types.

[Link] is an XML file

[Link]---------------------------------------ANS

[Link]
[Link] of the package can be used to write an implementation for [Link] identify that targets
different persistence store such as Azure Table Storage,NoSql database etc.

[Link]---------------------------------------------------ANS

[Link]

[Link]

d. [Link]

[Link] can we stop autodetection change in entity framework?

select one:

[Link]=false;------------------------------------ANS

[Link]=false;

[Link]=true;

[Link]=True;

51)Which of the following statements are TRUE?

[Link] CompiledQuery class provides compilation and caching of queries for reuse

[Link] method is to create a new delegate to represent the compiled query

[Link] the query is compiled you can supply parameters of primitive type but you cannot replace parts
of the query that would change the generated SQL

a.i and ii

[Link] and iii

c.i and iii----------------------------Ans

d.i,ii and iii

52)Which of the following require type-casting in the View?

[Link]

[Link]

a.i only
[Link] only

[Link] i and ii--------------------------Ans

[Link] of the listed options

53)Which of the following snippet creates database in local sql express by default?

[Link] class Context:DbContext

public Context():base()

[Link] class Context:DbContext

public Context():base("DB Name")

[Link] class Context:DbContext

public SchoolDBContext():base("name=EduDB")

a.i and ii
b.i and iii

[Link] and iii--------------------ans

d.i,ii and iii

54)Which of the following code snippets is correct for an entity Post having relationship with Blog?

[Link]<Post>().HasRequired(p=>[Link])------------------------Ans

[Link]<Post>().NeedRelationship(p=>[Link])

[Link]<Post>().Required(p=>[Link])

[Link] of the listed options.

55)IObjectContextAdapter Interface is used to:

[Link] the reference of ObjectContext from object

[Link] the reference of ObjectContext from Entity

[Link] the reference of ObjectContext from DBModel

[Link] the reference of ObjectContext from DBContext------------------Ans

56)Which of the following are database initializers used in Entity Framework?

[Link]--------------------------Ans

[Link]-------------------Ans

[Link]

[Link]---------------------------Ans

[Link]

57)What are the different classes into which the SQL Server divides principals?

[Link]-level principal-----------------------------Ans

[Link]-level principal

[Link]-level principal-----------------------------Ans
[Link] Server-level principal---------------------------Ans

58)What is entity key?

[Link] entity key is a property or a set of properties of an entity type that are used to determine identity--
----------------------Ans

[Link] entity key is a property or a set of properties of an entity type that are used to determine the
column for searching index

[Link] entity key is a property or a set of properties of an entity type that are used to identify relationship
among the entities

[Link] of the listed options

59)In remote validation HttpPost is used by [Link] True or False.

[Link]---------------ans

[Link]

60)Which of the following are different Securable scopes?

[Link]-------------------Ans

[Link]

[Link]------------------Ans

[Link]---------------------Ans

*************************************************************************************
*************************************************************************************
*************************************************************

HEMANT

[Link] does the ROWCOUNT_BIG function work?

select one or more

[Link] the total number of rows in a table

[Link] the number of rows affected by the last staetement executed--------------ans

[Link] return type of ROWCOUNT_BIG is bigint--------------------ans

[Link] return type of ROWCOUNT_BIG is int

[Link] which attributes of columns,clustered indexes are not advisable?

select one or more

[Link] are unique or contain distinct values

[Link] change frequently------ans

[Link] are accessed sequently

[Link] there are wide keys.-----ans

[Link] of the following will render carinfo object stored in VIewBAg to a view?

select one

a.<p>

car information: @ViewBag{carinfo}

</p>

b.<p>

car information: @[Link]

 </p>

c.<p>

car information: @[Link]

</p>---------------------------------ans

d.<p>

car information: @[Link](carinfo)

</p>

[Link] good practice what should you follow to prevent XSS attacks?

select one or more

[Link] HTML markup-----------------ans

[Link] put untrusted data---------ans

[Link] not use javascript

[Link] allow cross scripts---------------ans

[Link] do you understand by state management?

select one:

[Link] is a process by which you override the state and client information over multiple requests for the
same pages.

[Link] is a process which you override the state and page information over single functional calls for the
same controller
[Link] is a process by which you maiintain the client and server information over multiple requests for the
same or different pages

[Link] is a process by which by whoch you maintain the state and page information over multiple requests
for the same or different pages------ans

[Link] do you mean by eager loading in MVC?

[Link] objects(child objects)are loaded automatilly with its parent object.

[Link] objects(child objects)are not loadede automatically with its parent object until they are
requested.

Select one:

a.I only-----------------ans

[Link]

[Link] I and II

[Link] only

[Link] are user-defined functions different from User-defined stored procedures?

sselect one or more

[Link] user-defined function the default parameter is specified with a DEFAULT keyword---------------ans

[Link] user-defined function omitting the parameter also implies default value

[Link]-defined functions do not support output parameters-----------------ans

[Link] defined functions do support output parameters

[Link] a good practice we should put HTML in which of the following?

[Link]

[Link] View

[Link]-Partial View

select one:

a.I and II------------------------ans

[Link] and III

c.I and III

d.I,II,III

[Link] is the difference deterministic & non-determinstic scalar-valued function?

select one or more

a. A non-determiinstic function always returns the same result when it is called with a specific set of
input parameters

b.A deterministic function always returns the same result when it is called with a specific set of input
parameters-----------------ans

c.A non-deterministic function always returns the different results when it is called with a specific set of
input parameters--------------ans
d.A deterministic function always returns the different results when it is called with a specific set of
input parameters

[Link] of the following option is Correct to turn off lazy loading for all the entities for BLogging
Context?

select one:

[Link] class BloggingContext :DbContext{public BloggingCOntext()

{[Link] =false;}}-----------ans

[Link] class BloggingContext :DbContext{public BloggingCOntext()

{[Link] =true;}}

[Link] class BLoggingContext :DbContext{public BloggingCOntext()

{[Link] =true;}}

[Link]

[Link] method in MOdelBuilder make sure that entity should have relationship with other entity?

select one:

[Link]

[Link]
[Link]---------------ans

[Link]

[Link] of the following are the attributes of [Link]

class?

a. Timestamp-------------------ans

b. Model

c. ConcurrencyCheck------------------ans

d. Entity

[Link] of the following statement is used to fetch an entity using composite key ?

select one:

[Link](key1,key2)-----------------------ans

[Link](key1,Key2)

[Link](key1,key2)

[Link](obj)

[Link] of the following are the properties of the HTTPConfiguration Class?

select one or more:

[Link] Tree

[Link] Resolver---------ans

[Link] Handlers----------ans

[Link]

[Link] the code to show alert on page.

select one:

[Link]("you have generated an alert box")

[Link]("you have generated an alert box");----------ans

[Link]

[Link](you have generated an alert box);

[Link] is a class.

state true or False

true----------ans

false

[Link] which system Storeprocedure the administrator will register the extended stored procedure
DLL to the SQL server?
select one:

a.sp_ActiveDirectory_obj

b.sp_addextendedproc----------ans

c.sp_addlinkedsrvlogin

d.sp_addlinkedserver

[Link] Framework can track changes to the model's objects.

True------------ans

FAlse

[Link] type of authentication accepts login credentials that will be checked against the domain or
local server and are sent in a hashed format?

select one:

[Link] Authentication

[Link] Authentication-------------------ans

[Link] Authentication

[Link] Authentication
[Link]

[Link] of the following class provides you important methods to configure entities and its properites
to override various code-first conventions?

select one

[Link]

[Link]---------------ans

[Link]

[Link]

[Link] EF v4.0 and DbCOntext EF V4.1

True

FAlse

[Link] can be one PreApplicationStartMethod per assembly.

True-------ans

False

[Link] COnceptual model,which of the following defines relationship between two entity types?
select one:

[Link]

[Link]----------------ans

[Link]

[Link]

[Link] of the following annontation is to EF that a particular property is required ?

select one:

[Link]

[Link]------------------ans

[Link]

[Link]

[Link] of the following loads the related data inscalaar and navigation properties along with query
result at first shot ?

select one :

[Link] Loading
[Link] Loading------------------ans

[Link] Loading

[Link] Loading

[Link] class is used to execute an Entity SQL COmmand against an entity mode ?

select one

[Link]-------------ans

[Link]

[Link]

[Link]

[Link] statement are true about an inline scalar function?

selct one or more

[Link] is no functiion body----------------------ans

[Link] function body defined in BEGIN ...END block contains a series of T-SQL statements--------------ans

[Link] scalar value is a result of a single statement-------------ans

[Link] scalar value is a result of all statements in the BEGIN...END block

[Link] enable globalization ,whcih of the following parameters are set in auto mode?

select one or more

[Link]

[Link]------------ans

[Link]

[Link]-----------ans

[Link] of the following advantage does a strongly typed view have ?

select one:

[Link] time

[Link]---------ans

[Link] buffering

[Link]

[Link] controller class is responsible for the following processing stages:

selct one:

[Link] the appropriate action method to call and validating that it can be called
[Link] the values to use as the action method's arguments.

[Link] all errors that might occur during the execution of the action method

[Link]------------ans

[Link] a unit test to check whether the partcipant A1 has covered half distance of total.

Select one

a.

[TestMethod]

int total_distance=2;

int distance_covered=10;

int distance_left=10;

Disatnce d1=new Distance("A1",total_distance)

[Link](distance_covered);

int left=[Link];

[Link](distance_left,left); -----------------ans

b.

[TestMethod]

int total_distance=2;

int distance_covered=10;
 int distance_left=10;

Disatnce d1=new Distance("A1",total_distance)

[Link](distance_covered);

int Left1=[Link];

[Link](distance_left.left);

c.

[TestMethod]

int total_distance=2;

int distance_covered=10;

int distance_left=10;

Disatnce d1=new Distance("A1",total_distance)

[Link](distance_covered);

int Left1=d1@remaining;

[Link](distance_left.left);

[Link] the listed options

[Link] does the following code denote?(not sure )

DECLARE @odetails orderdetails;

SELECT @odetails =orderdetais::GetFirstItem();

PRINT @[Link]();
Select one or more:

[Link] denotes usage of Scope Resolution operator-----ans

[Link] denotes usage of Compound operator

[Link] operator is denoted by a::symbol-----ans

[Link] operator provides access to public non-static memebers of acompind data type

[Link] operator provides access to static memebers of a compund data type.

[Link] of the following model is the design model to include tables,stored procedures,views,keys and
relatonship?

Select one:

[Link]

[Link]----------------------ans

[Link]

[Link] of the listed options.

[Link] are used to control placement of_______.

Select one:

[Link]=-------------ans

[Link]

[Link]

[Link]

[Link] of the following method of the ObjectStateManager is used to get Object State entry?

Select one:

[Link]-------------ans
[Link]

[Link]

[Link]

[Link] of the following are database intialization strategies in EF Code First?

Select one or more:

[Link]----------------ans

[Link]

[Link]--------------ans

[Link]

*************************************************************************************
************************************************************************************

MATHI

1) Which namespace is used to include NET data provider for SQL server?

a)System Data SqlClient----------------Ans

b)System Data ComponentModel

c)System Data SqlProvider

d)System Data OracleClient

2) When you execute user-defined functions that return scalar values, hw are the parameters specified?

a)The argument values are enclosed in paranthesis

b)The argument values are not enclosed in paranthesis-------Ans

c)Parameter names can be specified-----------------------Ans

d)If parameter names are specified the argument.........

3) Which libraries are added for XSS provision?

a)HTMLSerializationLibrary

b)CSRFLibrary

c)AntiXSSLibrary-------Ans

d)SecurityLibrary

6) LINQ to XML is based on in-memory XML programming interface

=> True-----Ans

7) You are given a task to restrict the user to enter the surname which shall not be more than 15
characters How you will achieve this/

=> [StringLength(15)]

public string Sname(get , set)---------Ans

8) Entity data model considers the business domain

=> True------Ans

10)Database model provides the normalized schema designed by the database administrator

=> True-------Ans

11)SELECT name AB object_name

.SCHEMA-NAME(schema_id) AB schema_name

.type-desc

.create_date

.modify_date

FROM sys objects

=> It uses the [Link] catalog view--------Ans

=> It returns all databases objects that have been newly added in the last 10 days-------Ans

12)Match the following

=> Globalization is the process of = Making a product multi------Ans

=> Localization is the process of = Adapting a global product for a particular language and country---Ans

14)Which does the following syntax do?

CREATE TABLE T1(Col1 int primary key, Col2 xml)

=> It creates a column of type xml--------Ans

=> it creates an empty table------Ans

15)JsonResult Class has which of the following syntax?

=> public class JsonResult : ActionResult---------Ans

17)We can write raw sql query in SQLQyery() method in entity framework

=> True----Ans

*************************************************************************************
*****************************

PRAJAKTA

2..edmx file will create which of the following?

select one:

[Link] & Relationships------------------ans

[Link] & keys

[Link]

[Link]

[Link] which of the following the entities and relationships are created on the EDMX design surface?

select one:

[Link] First Approach

[Link] First Approach---------------------------ans

[Link] Approach

[Link]

[Link] are available Database intializer in EntityFramework Code First model?

select one:

[Link]-----------------------ans

[Link]

[Link] Always

[Link]

[Link] a user clicks on a product, you have to make sure to ask him/her whether he/she sure about
it or not .

which of the following would you choose ?

select one :
a.<%=[Link]("Click here","Sample". new AjaxOptions
(LoadingElementId="AONE",Question="Are you sure ?", Update TargetId="ProductAone",})%>

b.<%=[Link]("Click here","Sample". new AjaxOptions

(LoadingElementId="AONE",Confirm="Are you sure ?", Update TargetId="ProductAone",})%>---------------
ans

c.<%=[Link]("Click here","Sample". new AjaxOptions (LoadingElementId="AONE",Query="Are

you sure ?", Update TargetId="ProductAone",})%>

d.<%=[Link]("Click here","Sample". new AjaxOptions (LoadingElementId="AONE",Ask="Are you

sure ?", Update TargetId="ProductAone",})%>

11. Where can CLR functions be used?

select one or more:

a. CLR functions can be used to access external files----------------------------ans

b. CLR functions can be used to access network resources-------------------------ans

c. CLR functions can be used to configure the instance of SQL server

d. CLR functions can be used to access web services-------------------------------ans

e. CLR functions can be used to connect to other databases

12. which of the following are valid for a Contoller class?

a. Encapsulating presentation logic

b. handling all errors that might occur during the execution of the action method.-----------------ans

c. storing data in a persistent storage

d. getting the values to use as the action method's arguments------------------------------ans

([Link]
13. what are available database initializers in EntityFramework Code first model?

a. CreateDatabaseifNotExists.-------------ans

b. DropCreateDatabaseWhenModelCHanges

c. DropCreateDatabaseAlways------------------ans

d. All given options

15. which of the following are used to locate the entities at ends of an association in a conceptual
model?

a. Navigation properties-------------------------ans

b. Attributes

c. Index

d. Proxy

16 and 21(both same options in diff order). which of the following code will provide custom error pages
for 404 errors and general exceptions?

a. <[Link]>

<customErrors mode=RemoteOnly defaultRedirect=Error/GeneralException>

<errorstatuscode=404redirect=ErrorController.Status404/>

</customerrors>

</[Link]>

--------------------------------------------------------------------------------ans a

b. <[Link]>

<customErrors mode=LocalOnly defaultRedirect=Error/GeneralException>

<errorstatuscode=404redirect=ErrorController.Status404/>
</customerrors>

</[Link]>

<[Link]>

<httpErrorserrormode=Detailed/>

</[Link]>

c. <[Link]>

<customErrors mode=RemoteOnly defaultRedirect=Error/GeneralException>

<errorstatuscode=404redirect=ErrorController.Status404/>

</customerrors>

</[Link]>

<[Link]>

<httpErrorserrormode=Detailed/>

</[Link]>

d. <[Link]>

<customErrors mode=RemoteOnly>

<errorstatuscode=404redirect=ErrorController.Status404/>

<errorstatuscode=GeneralExceptionredirect=Error/GeneralException/>

</customerrors>

</[Link]>

<[Link]>

<httpErrorserrormode=Detailed/>

</[Link]>

22. You want to return a file from the server which method you will use?

a. Display File

b. return file------------------------ans

c. download file
d. None

23. which of the followinf are used to locate the entities at the ends of an association in a conceptual
model?

a. Navigation properties-------------------------------------ans

b. attributes

c. Index

d. Proxy

25. Which of the following statements are true about AFTER Trigger?

Select one or more:

a. AFTER trigger executes after the statement that triggered it completes.---------------------ans

b. AFTER trigger executes after the last trigger in the queue.

c. if the statement fails with an error the trigger is not executed.--------------------ans

d. AFTER triggers cannot be specified for tables, they can only be specified for views

e. AFTER triggers cannot be specified for views, they can only be specified for tables.------------------ans

29. Repeated

30. Localization is also known as.........

a. LCN

b. L10N----------------------------ans

c. All

d. LOC-zation
 [Link] output cache contains a different version of the requested document for each combination of
specified parameters is applicable for?

select one:

[Link]

[Link]

[Link]-----------------------------------ans

[Link]

34(Kajal).which of the following is an example of direct mapping?

select one:

[Link]<Product>().property(p=>[Link]).DirectMap("product_id");

[Link]<Product>().property(p=>[Link])==("product_id");

[Link]<Product>().property(p=>[Link])=("product_id");

[Link]<Product>().property(p=>[Link]).HasCoulmnName("product_id");-----------ans

34(Prajakta). which of the following add-in is helpful in TDD?

I. coderush express

II. Test Express

a. None

b. II only

c. I only-------------------------ans

d. Both I and II

42. which of the following are valid for a controller class ?

select one or more

[Link] the values to usse as the action methods arguments------------------------ans

[Link] errors that might occur dring the execution of the action method--------------------ans

[Link] data in a persistent storage

[Link] presentation logic

[Link] files have _________ extension.

select one:

a. .rsrcx

b. .srcx

c. .resx---------------------------ans

d. .src

55. which of the following class provides you important methods to configure entities and its properties
to override various code first conventions?
select one:

[Link]

[Link]------------------------ans

[Link]

[Link]

[Link] you are testing the value of variable "a" is not getting set and you need to have value of "a"
before stating of test.

How will you solve this error?

select one:

a."[Link]" public void Initialize() {var a="sometestvalue";}

b.[Testinitialize] public void Initialize() {var a="sometestvalue";}------------------------------ans

c.[IntializeBeforeTest]public voidInitialize() {var a="sometestvalue";}

[Link] void Initialize() {var a="sometestvalue";}

*************************************************************************************
*************

MEDHAVI's MVC Attempt

[Link] of the following statements is used to fetch an entity using composite key?

Select one:
[Link](key1,key2)-----ans

[Link](key1,key2)

[Link](key1,key2)

[Link](Obj)

[Link] testing,you are using dynamically generated test [Link] type of test double it is?

Select one:

[Link]-------ans

[Link]

[Link] of the listed options

[Link]

[Link] of the following namespace supports code-first conventions?

Select one:

[Link]

[Link]

[Link]---------------ans

[Link] of the listed options

[Link] is "ExcuteStoreCommand" method?

Select one:

[Link] SQL statements in an Entity framework environment

[Link] values in the model

[Link] xml data

[Link] of the listed options.-------------ans

[Link] is the purpose of key annotation?

Select one:

[Link] set the columns as Unique

[Link] set the columns as required

[Link] set the columns as primary key----------ans

[Link] set the columns as foreign key

[Link] statement are true about Global Temporary stored procedure?

Select one or more:

a.A Global temporary procedure is available to all connections.----ans

b.A Global temporary procedre is available to all connections with explicit EXECUTE permission.

c.A Global temporary procedure is dropped when the clean-up function is called by the calling
procedure.

d.A Global temporary procedure is dropped at the end of the last session using the procedure.------ans

[Link] a global temporary procedure is created,all users with EXCUTE permissions can access it &
permissions can also be revoked explicitly.

[Link] want a particular section of your site to be accessed by "Admins" [Link] of the following is
the correct option to go about it?

Select one:

[Link]=Admins

[Link]="Admins"

[Link](Roles=Admins")------ans

d.(Authorize="Admins")
[Link] will be the order of TDD steps:

[Link] enough code so that it passes the test.

[Link] a unit test.

[Link] the test again to watch it pass.

[Link] it fail.

Select one:

[Link],IV,I,II----------ans

[Link],I,II,IV

[Link],I,II,III

[Link],I,IV,III

[Link](callback)-What is the function of this method?

Select one:

[Link] a class library to be executed, whenever an AJAX reqest begins and there is more tahn one
active.

[Link] a header to be executed,whenever an AJAX reqest begins and there is none already active.

[Link] a function to be executed,whenever an AJAX reqest begins and there is none already active.----
----------ans

[Link] a method to be executed,whenever an AJAX reqest begins and there is none already active.

[Link] does the following Query do?

INSERT INTO docs

SELECT 10,xCol FROM (SELECT * FROM OPENROWSET(BULK 'C:\temp\[Link]',SINGLE_BLOB)AS

xCol)AS R(xCol)

Select one:

[Link] is typed XML insert statement.

[Link] XML Data Generated Using FOR XML with TYPE Directive

c.A new row is inserted into the table named docs-------ans

[Link] and Modifying XML Data.

Note:The INSERT statement in the following code segment reads the content of file C:\temp\[Link]
as a BLOB by using OPENROWSET.

A new row is inserted into the table named docs with a value of 10 for the primary key and the
BLOB for the XML column xCol.

A well-formedness check occurs when file content is assigned to the XML column.

[Link] of the following statements are TRUE?

[Link] entity sets can be defined using the same entity type.--true

[Link] instance of a given type can only exist in one entity set.---ans

[Link] entity key for the instance may not unique within the entity set.

Select one:

a.I and II-----ans

[Link] and III

c.I and III

d.I,II and III

Note:The entity key for the instance is unique within the entity set.

[Link] can we set primary key explicitly for an entity?

Select one:

[Link]<Entity>(t=>[Link]);

[Link]<Entity>().HasKey(t=>[Link]);-----ans

[Link]<Entity>(t=>[Link]);

[Link] of the listed options.

[Link] loading is the process of loading related entites/objects.

State True or False

Select one:

True---ans

False

[Link] need to install A but it requires [Link] this scenario,what will the Nuget download?

Select one:

[Link] A

[Link] will throw an error----ans(build error will be thrown)

c.A & B

[Link] B

[Link] which of the following options, Aggregate functions be used as Expressions?

Select one or more:

[Link] select list of a SELECT statement(either a subquery or an outer query) -----ans

b.A COMPUTE or COMPUTE BY clause

c.A GROUP BY clause

d.A HAVING clause----ans

[Link] OVER clause

[Link] Framework(EF) is an Object/Relational mapping

State True or False

Select one:
True----true

False

[Link] on console are implemented as powershell command.

State True or False.

Select one:

True---ans

False

[Link] of the following options are CORRECT about entity relationships?

I.n Entity Framework, an entity can be related to other entities through an association(realtionship)

[Link] relationship contains two ends that describe the entity type and the multiplicity of the
type(one,zero-or-more,or many)for the two entites in that relationship.

Select one:

[Link] I

[Link] II

[Link] I nor II

[Link] I and II.----ans

[Link]-First will create the database tables with the name of_________ properties in the context class.

Select one:

[Link]

[Link]

[Link]

[Link]----ans
[Link] do you understand by RAW ajax?

Select one:

[Link] communicate to business server making the use of "XMLHTTPREQUEST"

[Link] communicate to database server making the use of "XSLREQUEST"

[Link] communicate to client server making the use of "XMLHTTPREQUEST"

[Link] communicate to database server making the use of "XMLHTTPREQUEST"----------------------ans

[Link] helpers Supports the rendering of HTML controls in a view.

State True or False.

Select one:

True---ans

False

[Link] can have more than 1 [Link] file in [Link] MVC3

State true or Fasle

Select one:

True---ans

False

Note:By creating [Link] file in sub root folders we can use multiple [Link]

files in our application but each folder should contains only one [Link] file.

[Link] view files have Extention_____________.

Select one:

[Link]------------ans
[Link]

[Link]

[Link]

[Link] of the following options are CORRECT about data annotations?

Select one:

[Link] not only let you describe client and server side validation in your code first classes,
but they also allow you to enchance and

even correct the assumptions that code first will make about your classes based on its conventions.

[Link] DataAnnotations you can not only drive database schema generation, but you can also map your
code first classes to a pre-existing database.

[Link] provide only the most commonly needed configuration changes you can be make on
your code first classes.

[Link] the listed options---------ans

[Link] does the Query exeuction plan define?

Select one or more:

[Link] sequence in which the source tables are accessed.-----ans

[Link] sequence in which the rows are accessed.

[Link] methods used to extract data from each table------ans

[Link] methods used to arrange data from each table.

[Link] of the following line of code will invoke the cart controllers ad method?

Select one:

[Link] redirect("Cart/Add")

[Link] View("[Link]")-----------------------ans

[Link] Content("[Link]")
[Link]("[Link]?Add")

[Link] foreign key columns are not avaliable in the model, the relationships

are reffered with the object references instead of foreign key [Link] is this association
called?

Select one:

[Link] association---------------ans

[Link] association

[Link]

[Link]

*************************************************************************************
*****************************************************

JASBIR-ENTITY FRAMEWORK

1) Which of the following is the CORRECT option for getting the user whose name is "Raja" and to load
all the roles related to the user eagerly?

a. var user = [Link]

.Where(b => [Link] !="Raja")

.Take(b => [Link])

.FirstOrDefault();

b. var user = [Link]

.Where(b => [Link] =="Raja")

.Select(b => [Link])

.FirstOrDefault();
c. var user = [Link]

.Where(b => [Link] =="Raja")....................................ans

.Include(b => [Link])

.FirstOrDefault();

d. var user = [Link]

.Where(b => [Link] ="Raja")

.Take(b => [Link])

.FirstOrDefault();

2) Which namespace is used to handle EntityClient provider?

a. [Link]

b. None of the listed options

c. [Link]

d. [Link].....................ans

3) Which of the following Entity will create a table with the following specifications:

I. It should have FirstName and should be required

II. It should have LastName and should be required

III. Full Name must be FirstName LastName

iV. EmployeeID should be primary key

V. It should have DepartmentID

VI. Department Entity should be lazy loading

a. public class Employee

b. public class Employee

[key]

public string EmployeeID {get;set;}

public string FirstName {get;set;}

[DatabaseGenerated([Link])]

public string FullName

get{ return FirstName +"."+LastName;}

public string DepartmentID{get;set;}

public virtual Department Department{get;set;}.....................................................ans

c. public class Employee

[key]

public string EmployeeID {get;set;}

public string FirstName {get;set;}

public string FullName {get;set;}

public string DepartmentID {get;set;}

public Department Department{get;set;}

d. public class Employee

public string EmployeeID {get;set;}

public string FirstName {get;set;}

public string FullName {get;set;}

public string DepartmentID {get;set;}

public Department Department{get;set;}

e. public class Employee

[key]

public string EmployeeID {get;set;}

public string FirstName {get;set;}

public string DepartmentID {get;set;}

public Department Department{get;set;}

4) What is meant by eagerly loading in entity framework?

a. Eager loading is the process whereby a query for one type of entity also loads related entities as part
of the query.................ans

b. Eager loading is the process whereby a query for one type of entity also load related entities as part of
the query on demand

c. None of the listed options

d. Eager loading is the process of query only the details mapped in the entity

5) DdContext is just a lightweight version of the ObjectContext class.

a. True.................................ans

b. False

6) What is meant by Materialization in entity framework?

a. Materialization is the process of returning queries back to the client as CLR types...................ans

b. Materialization is the process of returning query results back to the client as entity types

c. Materialization is the process of returning query results back to the client as CLR types

d. None of the listed options

7) How to set maximum length for a column using entity framework?

a. [Link]<Entity>().Property(t => [Link]).HasMaxLength(50)

b. [Link]<Entity>().Property(t => [Link]).HasMaxLength(50).......................ans

c. [Link]<Entity>().Property(t => [Link]).HasMaxLength(50)

d. None of the listed options

8) Which of the following statements are TRUE?

I. [Link] should be true.

II. [Link] should be true.

III. Navigation property should be defined as public, virtual. Context will NOT do lazy loading if the
property is not defined as virtual.

a. I,II and III.......................ans

b. II and III

c. I and III

d. I and II

Note:

Rules for lazy loading:

[Link] should be true.

[Link] should be true.

Navigation property should be defined as public, virtual. Context will NOT do lazy loading if the property
is not defined as virtual.

9) Entity Framework will support in web services and WCF.

State True or False.

a. True .......................ans

b. False

10) LINQ to XML is based on in-memory XML programming interface.

State True of False

a. True ...................ans

b. False

11) How can we stop auto detection change in entity framework?

a. [Link] = false;

b. [Link] = false;...........................ans

c. [Link] = true;

d. [Link] = true.

12) which of the following object is used to track changes, manage entities, concurrency and
relationship of the entities?

a. DbContext

b. EntityDataModel....................ans

c. Entity

d. None of the listed options

13) [Link] Property Provides access to features of the context that deal with change
tracking of entities. State True or False.

a. True................ans

b. False

14) Which of the following snippet creates database in local sql express by default?

I. public class Context: DbContext

public Context(): base()

}
II. public class Context: DbContext

public Context(): base("DB Name")

III. public class Context: DbContext

public SchoolDBContext(): base("name=EduDB")

a. I,II and III

b. I and II

c. I and III----ans

d. II and III

15) In foreign key association when the relationship changed, the Entity state of the dependent object
will change to [Link] from [Link].

state True or False

a. True.................ans

b. False

16) Which of the following is the default database initializer in Entity framework?(default initializer)
a. CreateDatabaseIfNotExists........................ans

b. DropCreateDatabaseAlways----ans

c. DropCreateDatabaseIfModelChanges----ans

d. DropDatabaseAlways

Note:[Link] [Link] [Link]

[Link] DB Initializer are the 4 DB initializer

17) Which of the following is CORRECT for the sql implementation of the below linq query from s in
[Link] from c in [Link] where [Link] == 1 select new {[Link],c}

a. SELECT

[Extent1].[StudentId]AS[StudentID],

[Extent1].[StudentName]AS[StudentName],

[Join1].[CourseId1]AS[CourseId],

[Join1].[CourseName]As[CouseName],

[Join1].[Location]As[Location],

[Join1].[TeacherId]AS[TeacherId]

FROM [dbo].[Student]AS[Extent1]

INNER JOIN
(SELECT[Extent2].[StudentId]AS[StudentId],[Extent3].[CourseId]AS[CourseId1],[Extent3].[CourseName]A
S[CourseName],[Extent3].[Location]AS[Location],[Extent3].[TeacherId]AS[TeacherId]

FROM [dbo].[StudentCourse]AS[Extent2]

INNER JOIN[dbo].[Course]AS[Extent3]ON[Extent3].[CourseId] = [Extent2].[CourseId] ) AS

[Join1]ON[Extent[1].[StudentID] = [Join1].[StudentId]

WHERE 1 = [Extent1].[StandardID]

[Link]

[Extent1].[StudentId]AS[StudentID],

[Extent1].[StudentName]AS[StudentName],
[Join1].[CourseId1]AS[CourseId],

[Join1].[CourseName]As[CouseName],

[Join1].[Location]As[Location],

[Join1].[TeacherId]AS[TeacherId]

FROM [dbo].[Student]AS[Extent1]

INNER JOIN
(SELECT[Extent2].[StudentId]AS[StudentId],[Extent3].[CourseId]AS[CourseId1].[Extent3].[CourseName]

[Join1].[CourseId1]AS[CourseId],

[Join1].[CourseName]AS[CouseName],

[Join1].[Location]As[Location],

[Join1].[TeacherId]AS[TeacherId]

FROM [dbo].[Student]AS[Extent1]

INNER JOIN
(SELECT[Extent2].[StudentId]AS[StudentId],[Extent3].[CourseId]AS[CourseId1],[Extent3].[CourseName]A
S[CourseName],[Extent3].[Location]AS[Location],[Extent3].[TeacherId]AS[TeacherId]

FROM [dbo].[StudentCourse]AS[Extent2]

OUTER JOIN[dbo].[Course]AS[Extent3]ON[Extent3].[CourseId] = [Extent2].[CourseId] ) AS

[Join1]ON[Extent[1].[StudentID] = [Join1].[StudentId]

WHERE 1 = [Extent1].[StandardID]

c. None of the listed options

d. SELECT

[Extent1].[StudentId]AS[StudentID],

[Extent1].[StudentName]AS[StudentName],

[Join1].[CourseId1]AS[CourseId],

[Join1].[CourseName]As[CouseName],

[Join1].[Location]As[Location],

[Join1].[TeacherId]AS[TeacherId]

FROM [dbo].[Student]AS[Extent1]
Group by
(SELECT[Extent2].[StudentId]AS[StudentId],[Extent3].[CourseId]AS[CourseId1],[Extent3].[CourseName]A
S[CourseName],[Extent3].[Location]AS[Location],[Extent3].[TeacherId]AS[TeacherId]

FROM [dbo].[StudentCourse]AS[Extent2]

OUTER JOIN[dbo].[Course]AS[Extent3]ON[Extent3].[CourseId] = [Extent2].[CourseId] ) AS

[Join1]ON[Extent[1].[StudentID] = [Join1].[StudentId]

WHERE 1 = [Extent1].[StandardID]

18) Eager loading returns all of the objects including the related objects. State True or False.

a. True----ans

b. False

19) Which of the following are the attributes of [Link]

class?

a. ForeignKey

b. Model

c. Column.......................ans

d. Entity

20) Which of the following are the benefits of Entity framework?

a. Mapping manual

b. None of the listed options----------ans

c. Auto generate code

d. Reducing development time

21) In Lazy loading, the navigation property has to be declared as:

a. public.............ans

b. static

c. virtual............ans

d. proxy

22) Which of the followings are database initialization strategies in EF Code First?

a. CustomDBInitializer................ans

b. CreateDatabaseIfNotExists...........ans

c. MigrateDatabaseToLatestVersion

d. AlterDatabasewithchanges

23) If we use database first generation a DbContext is generated by default. State True or False

a. True...............ans

b. False

24) By default, the Entity Framework will generate the database queries and update commands when
your code interacts with the model. State True or False.

a. True ................ans

b. False

25) Which method in the DBContext writes inserts, updates, and deletes to the data source?
a. SaveChanges.........................ans

b. All of the listed options

c. Save

d. SaveEntity

26) Linq to Entity Query results are usually returned as which of the following?

a. Linq to objects

b. A collection of zero or more typed entity objects or a projection of complex types defined in the
conceptual model.............ans

c. All of the listed options

d. Anonymous types...............ans

e. Inline collections..................ans

After a LINQ to Entities query is converted to command trees and executed, the query results are usually
returned as one of the following:

A collection of zero or more typed entity objects or a projection of complex types in the conceptual
model.

CLR types supported by the conceptual model.

Inline collections.

Anonymous types.

27) Which of the following is used to define plain old CLR Objects that are NoT related to certain
persistence technology?

a. Persistence Ignorance..............ans

b. None of the listed options

c. Self-Tracking Entities
d. Deferred or Lazy Loading

The DataRelation object is used to add relationship between two DataTable objects. What are ...
Persistence Ignorance -

Facilitates you to define your own Plain Old CLR Objects (POCO)

which are independent of any specific persistence technology.

28) How can we disable proxy object creation in POCO?

a. [Link] = false;................ans

b. [Link] = false;

c. [Link] = false;

d. [Link] = false;

29) Which of the following class is used to programmatically create connection string and parse existing
connecting string to create attributes and methods for the class?

a. EntityConnectionStringBuilder.................ans

b. EntityClientProvider

c. EntityContext

d. EntityConnection

30) How can we Update UnitPrice of Product?

a. NorthwindEntities dbContext = new NorthwindEntities();

Product product = [Link]( p=> [Link] == "Aniseed Syrup");

[Link] = 1000;

[Link]();
b. NorthwindEntities dbContext = new NorthwindEntities();

Product product = [Link]( p=> [Link] == "Aniseed

Syrup");............................................ans

[Link] = 1000;

[Link]();

c. NorthwindEntities dbContext = new NorthwindEntities();

Product product = [Link]( p=> [Link] == "Aniseed Syrup");

[Link] = 1000;

[Link]();

d. NorthwindEntities dbContext = new NorthwindEntities();

Product product = [Link]( p=> [Link] == "Aniseed Syrup");

[Link] = 1000;

[Link]();

[Link] of the following is used to manipulating dataset using linq?

[Link] to dataset.....................ans

[Link] of these

[Link] TO SQL

[Link] TO XML

32.a POCO class will not be inherited from entity object class

state true or false

[Link].....................ans

[Link]

[Link] model provides the normalised schema designed by the database administrator
state true or false

a. true

[Link]

[Link] you use the using statement,then compiler automatically creates a try/finally block and calls
dispose in the finally block.

state true or false

[Link]....................ans

[Link]

[Link] of the following property is used to map two seperate types in the storage model?

select one

[Link] entity...................ans

[Link] property

[Link]

[Link] of these

Note:scalar property:A property of an entity that maps to a single field in the storage model

split entity:An entity type that is mapped to two separate types in the storage model.

[Link] namespace is used to include .net data provider for sql server?

[Link]

[Link]

[Link]

[Link]....................ans

[Link] templateused to generatewhich of the following?

select one
[Link] of these

[Link] ignorant modeltypes

[Link] ignorant entity types.........................anss

[Link] ignorant object types

Note:

POCO Entities

POCO stands for "plain-old" CLR objects which can be used as existing domain objects with your data
model.

POCO data classes which are mapped to entities are defined in a data model.

It also supports most of the same query, insert, update, and delete behaviors as entity types that are
generated by the Entity Data Model tools.

You can use the POCO template to generate persistence-ignorant entity types from a conceptual model.

[Link] model support quering only entities defined in entity datamodel

state true or false

a. true

[Link]

Note:The Entity Framework even supports mapping entities in the conceptual model to stored
procedures in the data source.

[Link] the foreign key columns are not included in the model,the association information is
managedas an independent object

state true or false

[Link]......................ans

[Link]

[Link] framework supports automatic change tracking of the loaded entities during the life time of
the context

state true or false

[Link]...........................ans
[Link]

[Link] is the purpose of the [Link] namespace?

select one

[Link] of these

[Link] first approach to use [key] attribute

[Link] first approach to use [key] attribute...........................ans

[Link] first to use [key] attribute

[Link] can we mark properties in the entity framework to be ignored?

select one

a.[remove]

b.[ignored]

c.[notmapped]..........................ans

[Link] of these

[Link] of the following statements are TRUE?

[Link] an entity framework application data is loaded from the file with the [Link]

[Link] information is publicaly accessible

[Link] entity framework uses the metadata in the mapping types to translate queries against the
conceptual model to data source specific commands

select one:

[Link] & III

b.I & II

[Link] & III

d.I & III..............................ans

[Link]() will be raised exception when which of the following object is added to the
objectcontext and it cannot be successfully created in the data source?

select one:

[Link]

[Link]

[Link]..............................ans

[Link]

Note:

SaveChanges can generate an UpdateException when an object added to the ObjectContext cannot be
successfully created in the data source.

This can happen if a row with the foreign key specified by the relationship already exists

[Link] a linq entities query is excecuted.

select one:

(ans) [Link] expressions in the query might be executed on the server and some parts might be
executed locally on the [Link]-side evaluaion of an expression takes place before the query is
executed on the server...................ans

[Link] expressions in the query might be executed on the server and some parts might be executed
locally on the [Link]-side evaluaion of an expression takes place before the query is executed on
the server.

[Link] of these

[Link] expressions in the query might be executed on the server and some parts might be executed
locally on the [Link]-side evaluaion of an expression takes place before the query is executed on
the server.

[Link] of the following annotation validates property whether it has minimum length of the array or
string?

select one:

[Link] of these

[Link]

[Link]...........................ans

[Link]
[Link] splitting enables which of the following?

select one:

[Link] map two tables to multiples entities

[Link] map a single table to multiple entities..........................ans

[Link] map a single entity to multiple tables

[Link] map a single schema to multiple entities

[Link] can we enable concurrency mode in entity framework?

select one:

a.<property name="status" type="byte" nullable="false" concurrencymode="true"/>

b.<property name="status" type="byte" nullable="false" concurrencymode="enabled"/>

c.<property name="status" type="byte" nullable="false" concurrencymode="yes"/>

d.<property name="status" type="byte" nullable="false"

concurrencymode="fixed"/>.............................ans

[Link] ____________ class supports both LINQ to entities and entitySQL queries against a conceptual
model.

select one:

[Link]..............................ans(may be)

[Link] of these

[Link]

[Link]

[Link] of the following is true about overlapping keys?

select one:

[Link] change a foreign key association that includes overlapping keys,it is recommend to modify the
foreign key values instead of using the object references.

[Link] keys are composite keys where some properties in the key are also part of another key in
the entity
[Link] of these.............................................................ans

[Link] cannot have an overlapping key in an independent association

[Link] of the following annotation is used to mark one or more properties to be used for concurrency
checking while user modifies in an entity?

select one:

[Link]......................ans

[Link] of these

[Link]

[Link]

[Link] class is responsible for interacting data as object in the entity framework?

select one:

[Link]

[Link]

[Link]

[Link]........................ans

[Link] of the following option is CORRECT about navigation property?

select one:

[Link] properties provide a way to navigate an association between two entity types.

[Link] object can have a navigation property for every relationship in which it participates.

[Link] properties allow you to navigate and manage relationships in both directions,returning
either a reference object(if the multiplicity is either one or zero-or-0ne)or collection(if the multiplicity is
many)

[Link] of these.................ans

[Link] annotation is used when you have multiple relationships between classes?

select one:

[Link]
[Link]

[Link] key

[Link] property.......................ans

[Link] state property is enum type

state true or false

select one:

[Link].................................ans(may be)

[Link]

[Link] can we get objectcontext from DBcontext?

select one:

[Link]

[Link]()

[Link] of these

d.((lobjectcontextadaptor)db).objectcontext;.......................ans

[Link] of the following is the fullform of CSDL?

select one:

[Link] set definition language

[Link] schema definition language............................ans

[Link] select definition language

[Link] selectdata definition language

[Link] the correct code to execute sql raw query in the entity frameqwork from the following

select one:

[Link](var ctx = new schoolDBentities())

varstudentlist = [Link]("select*from student").tolist<student>();

}

[Link] of these

[Link](var ctx = new schoolDBentities())

varstudentlist = [Link]("select*from student").tolist<student>();

[Link](var ctx = new schoolDBentities())

varstudentlist = [Link]("select*from
student").tolist<student>();...............................ans

[Link] of the following statements are true?

[Link] compiled query class provides compilation and caching of queries for reuse

[Link] method is to created a new delegates to represent the compiled query

[Link] the query is compiled you can only supply parameters of primitive type but you cannot replace
parts of the query that would change the generated SQL.

select one:

[Link] & III

b.I,II & III......................ans

C.I & III

d.I & II

[Link] of the following provider is used to access data in the conceptual model?

select one:

[Link]

[Link]

[Link] model provider

[Link] client provider......................ans

*************************************************************************************
************************************************************************

Sanskar MVC 1st Attempt

sanskar mvc qstns :

1)which data types cannot be return types of scalar function?

a)text------------ans

b)ntext------------------ans

c)integer

d)image---------------------ans

e)cursor-------------ans

2)which class provides the rsults by executing command in conceptual model?

a)entitydatareader--------------ans

b)Dbcontext

c)objectcontext

d)entityconnection

3)which of the following is the ability to add and use your own data classes along

with your data model?

a)entityobject

b)[Link]-------------------------------ANS

c)poco

d)none
4)razor syntax have intellisense

true or false

true------ans

5)how do aggregate functions work?

a)they work only on integer values

b)they ignore null values----------------ans

c)they perform a calculation on a set of values and return a single/summarized value------------ans

d)they frequently used with the group by clause of the select statement------ans

e)they cannot be used with the group by clause of the select statement

6)how does external_access permission set work?

a)allow access only to external assemblies with minimal access to internal computation

b)allows access to internal computations

c)allow access to external system resource such as files,networks and environment variables----------------
ans

d)allow access to registry

7)what does linq to sql do?

a)it enables you to query data using datacontext

b)it provides tightly coupled approach

only 1

only 2

both 1 and 2----------ans

none

8)if we want to create a backward compatible application which of the following view engine will be
preferred in mvc3?

a)sparx

b)aspx

c)razor------ans

d)Nhaml

9)what is the significance of instead of argument of the create trigger statement?

a)specifies that the DML trigger is executed instead of the triggering sql statement

b)it overrides the actions of the triggeering statements------------------ANS

c)it can be specified for DDL or logon triggers----------------ANS

d)it can not be specified for DDL or logon triggers

10)what will be the output of the following code:-

public actionresult search(string idea ="a"){

return view();

1)it will set the default value of string idea to "a"

2)it will set the default pointer of idea to "a"

only 1--------------------------------------------------ANS

only 2

both 1 and 2

none

11)what are the query considerations for using clustered indexes?

a)use clustered index when a query returns a range of values by using operators such as between
>,>=,<,<=-----------ans
b)use clustered index when a query returns largs resultsets----------------ans

c)use clustered index when a query needs to handle null values

d)use clustered index when a query uses join clauses--------------ans

e)use clustered index when a query uses group by or order by clauses-----------ans

12)The _______________class supports both linq to entities sql queries agaimst a conceptual model

a)sqlquery

b)objectquery-------------------ans

c)entitytosql

d)none

13)TDD uses ________________to drive the design of software?

a)red-green-refractor----------------------------------------------------ANS

b)unit debug

c)unit test

d)regression test

14)which of the followin are true?

a)the entity framework lifetime of the context begins when the instance is created and ends when the
instance is either disposed or garbage collected----------------------ans

b)the lifetime of the context begins when the application starts--------ans

c)the primary class that is responsible for interacting with data as objects is
[Link]------ans

d)dB ENTITY PROPERTIES repersent collections of the specified entites in the context

15)Nunit have many dependencies

true or false

ANS:true
16)what is the significance of the results apne of the query designer?

a)it shows a grid with data retrieved by the query or view--------ans

b)it shows the results of the most recently executed select query-----ans

c)it shows the query syntax

d)you can modify the database by editing values in the cells of the grid--ans

e)you can add or delete rows------ans

17)entitystate property is enum type.

true or false

true-----ans

18)what should be tested a controller?

1)proper actionresult are returned or not

2)proper model are build or not

A)2 ONLY

B)BOTH

C)NONE

D)1 ONLY---------------------ANS

19)which of the following two are name types of sql server files?

a)physical_file_name

b)logical_file_name------------ans

c)primary_file_name

d)os_file_name-------ans

20)i have a table blog which i want to split into two [Link] of the followin is the correct snippet?
a)protected override void OnModelCreating(DbModelBuilder
modelBuilder){[Link]<Blog>().HasRequired(e=>[Link]).WithRequiredPrincipal();mod
[Link]<Blog>().ToTable("Blogs");[Link]<BlogAbout>().ToTable("Blogs");}

b)protected override void OnModelCreating(DbModelBuilder

modelBuilder){[Link]<Blog>().ToTable("Blogs");[Link]<BlogAbout>().ToTable
("Blogs");}------------------------------------------------------------------------------------------------ANS

c)protected override void OnModelCreating(DbModelBuilder

modelBuilder){[Link]<Blog>().HasRequired(e=>[Link]).WithRequiredPrincipal();}

d)protected override void OnModelCreating(DbModelBuilder

modelBuilder){[Link]<Blog>().HasRequired(e=>[Link])[Link]<Blog>().T
oTable("Blogs");[Link]<BlogAbout>().ToTable("Blogs");}

21.----inproves the performance of [Link] MVC application drastically.

[Link] profiling

[Link] Regeneration

[Link] updation

[Link] caching---------ans

[Link] of the following argument of the CREATE TRIGGER statement specifies

the security context under which the trigger is executed?

[Link] SERVER

[Link] ENCRYPTION

[Link] AS----------ans

[Link] OF

[Link] can we disable proxy object creation in POCO?

[Link]=false;

[Link]=false;

[Link]=false;

[Link]=false;-----------ans
[Link] of the package can be used to write an implementation for [Link] Identity

that targets different persistence stores such as Azure Table [Link] database etc

[Link] [Link]

[Link] security

[Link] [Link]---------ans

[Link] [Link]

[Link] of the following statements are TRUE?(MULTIPLE ANS)

[Link] file is an [Link]

[Link] declares a conceptual model,storage model and mapping between these models

[Link] divided into three categorieS SSDL,CSDL and MSL

Select one:

a.I and II

b. II and III

c. I and III

d.I,II and III------------------------------------------ANS

[Link] dont want to allow anyone to do any change to the code being deployed on

production [Link] will be the solution?

[Link] "Allow this precompiled site to update" under Output Assemblies-->Compilation-----------------

----ANS

[Link] "Allow this precompiled site to update" under configuration-->Compilation

[Link] "Allow this precompiled site to update" under signing-->Compilation

[Link] "Allow this precompiled site to update" under deployment-->Compilation

[Link] have a certain number of products with price ranging from high to low to medium. You

want to filter products by their respective price [Link] of the following option

will fulfill this conditions?

a.[...

@using([Link]("index","Range"))

[Link]("Product",new selectList([Link]))

<input type="submit" value="filter"/>

...]

b.[...

@using([Link]("index","Product"))

[Link]("Range",new selectList([Link]))

<input type="password" value="filter"/>

...]

c.[...

@using([Link]("index","Product"))

[Link]("Range",new selectList([Link]))

<input type="submit" value="filter"/>

...]

d.[... ------------------------------------------------------------------ANS

@using([Link]("index","Product"))

[Link]("Range",new selectList([Link]))

<input type="submit" value="filter"/>

}

...]

[Link] are given a task by your manager that includes assembly binding. Which file

would you configure?

[Link]

[Link]

[Link]------------------------------------ANS

[Link]

[Link] happens when you create a primary key constraint?

[Link] index on the column ,or columns is automatically created which is by default nonclustered

[Link] index on the column ,or columns is automatically created which is by default clustered-----------
-----------ANS

[Link] index on the column ,or columns is automatically created which is by default spatial

[Link] index on the column ,or columns is automatically created which is by default XML

[Link] of the following keyword is used for lazy loading related data in entity framework?

[Link]

[Link]----------------------ANS

[Link]

[Link]

[Link] is stored procedure? choose all relevant options

a.a collection of compiled T-SQL commands that are directly accessible by SQL SERVER -----------------------
-----ans

B.A COLLECTION of commands written in any base .net language that are directly

accessible by DQL server

[Link] placed in a stored procedure are interpreted one line at a time during execution

d,commands placed in a stored procedure are executed as one batch----------------------------------------------

ans

[Link] procedures reduce network traffic

[Link] command will remove the package

[Link]-package packagename ---------------------------------------------------------------------------ans

b. delete package

[Link] packagename

[Link] of the lists

Ref Link: [Link]

manager-console

[Link] a unit test to check whether the participant A1 has covered half the ditance of total

a.[TestMethod]

int total_distance=2;

int distance_covered=10;

int distance_left=10;

Distance d1=new Distance("A1",total_distance); --------------------------------------------------------------------------

-ans

[Link](distance_covered);

int Left=[Link];

[Link](distance_left,Left);

b.[TestMethod]

int total_distance=2;

int distance_covered=10;
int distance_left=10;

Distance d1=new Distance("A1",total_distance);

[Link](distance_covered);

int Left=d1@remaining;

[Link](distance_left,Left);

[Link] of the lists

d.[TestMethod]

int total_distance=2;

int distance_covered=10;

int distance_left=10;

Distance d1=new Distance("A1",total_distance);

[Link](distance_covered);

int Left1=[Link];

[Link](distance_left,Left);

[Link]([Link])- this is correct for the BindModel method

[Link] ---------------------------------------------------------------------------ans

[Link]

35.

[Link] class is used to execute an entity SQL command against an entity mode?

[Link] ---------------------------------------------------------------------------ans

[Link]
[Link]

[Link] of the lists

[Link] objects can be serialized and deserialized with binary serialization

[Link] ---------------------------------------------------------------------------ans

[Link]

[Link] we use database first generation a DbContext is generated by default

[Link]---------------------------------------------------------------------------ans

[Link]

[Link] server 2008 security model is based on three categories that seperate

the basic elements of [Link] among the following are those?(Multiple ans)

[Link] ---------------------------------------------------------------------------ans

[Link]

[Link] ---------------------------------------------------------------------------ans

[Link] ---------------------------------------------------------------------------ans

[Link] is the support for XML integrated into SQL server?(multiple ans)

[Link] for the xml data type ---------------------------------------------------------------------------ans

[Link] to specify an XQuery against XML data stored in columns and variables of the xml type------------
--------ans

[Link] to handle bulk loading of xml data ---------------------------------------------------------------------------ans

[Link] to merge xml

Q.41 which of the following is the default database iitializer in entity framework?

a CreateDatababaseifnotexists ---------------------------------------------------------------------------ans

b DropCreateDatabaseifModelChanges
c DropCreateDtabaseAlways

d DropDtabaseAlways

Q42 Which namespace is used to handle EntityClient provider?

a [Link] ---------------------------------------------------------------------------ans

b [Link]

c [Link]

d None of the listed options

Q.43 We can create entity framework without existing database

State True or False

a True

b False

Q.44 Which of the following statements are true about Clustered index?

a A Clustered index sorts and stores the data rows of the table or view in order based on the

clustered index key.---------------------------------------------------------------------------ans

b A Clustered index sorts and stores the data columns of the table or view in order based on the

clustered index key.

c A clustered index is implemented as a B-tree index structure.-----------------------------------ans

d A clustered index is implemented as a Linked -list structure.

Q.45 Entity Framework provide us with which of thefollowing attribute to indicate multiple relationships

between two tables?

a [InsertProperty]

b [InverseProperty]-------------------ans

c [InProperty]

d None of the listed options

Q.46 Conceptual model properties are not same as the properties created in .edmx file. State True or
False

a True

b False-------------------ans

Q.47 Which of the following method of the ObjectStateManager is used to get Object State entry?

a TryGetObjectStateEntry

b ChangeObjectState -------------------ans

c GetRelationshipManager

d ChangeRelationshipState

Q.48 Commands on console are implemented as powershell command.

State True or False

a True-------------------ans

b False

Q.49 [Link](new SampleFilter()); - What will the above piece of code do?

a It is not possible to add new filter,so it will give an error.

b It will add customer filter "SampleFilter" to the GlobalFilters.-------------------ans

c None of the listed options

d It will move built insample filter to the Global Filter.

Q.50 Repeated

Q.51 How can we insert Products with new Category?

a NorthwindEntities dbContext = new NorthwindEntities();("same everywhere only last line

changes")[Link]();-------------------ans

b NorthwindEntities dbContext = new NorthwindEntities();("same everywhere only last line

changes")[Link]();
 c NorthwindEntities dbContext = new NorthwindEntities();("same everywhere only last line
changes")[Link]();

d NorthwindEntities dbContext = new NorthwindEntities();("same everywhere only last line

changes")[Link]();

Q.52 Read the description & identify which method it belongs to.:-"Initializes a new instance of the
HtmlHelper class by using

the specified view context,view data container,and route collection."

a [Link](|ViewContext viewContext,ViewDataContainer
viewDataContainer,RouteCollection routeCollection)

b [Link](ViewContext viewContext,|ViewDataContainer
viewDataContainer,RouteCollection routeCollection)-------------------ans

c [Link](ViewContext viewContext,ViewDataContainer viewDataContainer,|RouteCollection

routeCollection)

d [Link](@viewContext,@viewDataContainer,@routeCollection)

Q.53 What doesa Dependency resolver() do?

a Creates a new dependency

b Creates a new interface

c Initializes a new interface

d Initializes a new instance of the DependencyResolver Class-------------------ans

Q.54 Which ActinResult rediects to another action method?

a All of the listed options.

b RediredtToAction-------------------ans

c ForwardTo

d ActionRedirect

Q.55 Read the Followinfdefinition and choose the correct option ----" Contains methods to create types
of objects locally or

remotely, or obtain references to existiong remote objects.

a ModelBlinder

b Dependency Resolver

c Activator-------------------ans

d Validator

q.56 Which of the following class is used to programmatically create connection string and parse existing
connecting string

to create attributes and methods for the class?

a EntityConnection

b EntityClientProvider

c EntityConnectionStringBuilder -------------------ans

d EntityContext

Q.57 Which of these are jQuery Event metods?

a focus()-------------------ans

b mouseenter()-------------------ans

c on()-------------------ans

d hover()-------------------ans

Q.58 Do we have a console option in the Nuget?

a Maybe

b Yes-------------------ans

c no

d None of the listed options

Q.59 Find the object query methods from the following

a Distinct

b Except
c GroupBy

d All of the listed options-------------------ans

Q.60 You are handling page ofan event. Now the content and information you have cached so that it is
loading quickly but you

need to keep the clock which shows time for the event dynamic. which of the following will be
helpful?

a <%DateTime([Link]);%)

b <%[Link](t=>[Link]());%> -------------------ans

c <% var c=[Link]()%>

d <%session s= new session["Time"];>