How many clustered indexes can be created on single table?
1
128
Up to number of columns in table
256
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed?
before the WHERE clause
before the FROM clause
after the ORDER BY clause
after the WHERE clause
What statement could you use in the WHERE clause to select all the rows in a table where no price is defined?
WHERE price <>NULL
WHERE price != 0
WHERE price IS NULL
WHERE price IS NOT NULL
Referential integrity refers to what?
The enforced uniqueness of a row in a table
The enforced uniqueness of a column in a table
Ensuring that a Foreign Key attribute cannot be NULL
The enforced synchronization of Primary Key and Foreign Key values
What is web garden?
Multiple Worker processes on single server
Multiple Worker processes on multiple servers
Where does ASP.NET store SessionIDs by default?
In cache
In cookies
In a global variable
In URL strings or in a database
Which of these string definitions will prevent escaping on backslashes in C#?
string s = #"Test string";
string s = ."Test string";
string s = @"Test string";
string s = &"Test string";
What is NET?
NET is a set of tools, services, applications, and servers based around the.NET Framework and common language runtime (CLR).
It is a tool for Net working.
It is a tool to develop Net working operating System.
None of the above.
The classes in ________make up ADO.NET. It uses XML to represent data internally, enabling you to use XML files just as if they were a traditional data source.
System.Data
System.XML
System.Web.UI
None of the above
Where are the namespaces located?
All of the .NET namespaces are located in assemblies (previously known as dynamically linked libraries, or DLLs)
All of the .NET namespaces are located in System.Data
All of the .NET namespaces are located in System.XML
None of the above
What is the use of validation control?
A validation control enables us to validate an input and display an error message if necessary.
The Validation controls automatically generate client-side and server side validation code.
If necessary, you can also develop custom validation functions.
All of the above
How many validation controls are there?
6
7
8
None of the above
What are the different types of custom controls?
There are two types of custom controls: Web User Controls and Web Custom Controls.
There are three types of custom controls: Web User Controls, web server and Web Custom Controls.
There are four types of custom controls: Web server, Web User Controls, web client controls and Web Custom Controls.
None of the above
Are paths such as HREFs in user controls relative to the user control or to the host page that they are in?
The paths are relative to the user control and not to the host page.This makes it much easier for the user control to find things irrespective of what directory the calling .aspx file is. Another interesting feature in paths is that you can use the “~” to represent the application root to shortcut the use of the Request Application path.This really makes the building of large Web sites more manageable.
The paths are relative to the host page and not to the user control.
The paths are relative to the neither host page nor to the user control.
None of the above
Cookies are now no longer a requirement, and sessions can be set to be_________.
Cookies.
cookieless.
cookies or cookieless.
None of the above.
In what occasions session may end?
The session may end when the user closes his or her browser.
The session may end when the session has timed out
The session may end when the user closes his or her browser or the session has timed out.
None of the above
What is the usage of application state?
Application state is the management of information relating to the whole application.
Application state is the management of all of the currently live users.
Application state is the management of information relating to the whole application and all of the currently live users.
None of the above.
Session state relates to _______.
Each user separately.
All users combinable.
For each group of users separately.
None of the above.
Must I have a Global.asax?
A Global.asax is not required; only use one if you need to.
You will not need a Global.asax unless you want to use events or static variables, for example. Application, session, and cache values do not depend on your writing a Global.asax.
A Global.asax is not required; only use one if you need to & You will not need a Global.asax unless you want to use events or static variables, for example. Application, session, and cache values do not depend on your writing a Global.asax.
None of the above.
Can you override private virtual methods?