A company has the following departments: Marketing, Designing, production, Packing What will be the result of the following query? select * from table where department < 'marketing';
The query will return "Designing, Packing" 0.0%
The query will return "Designing, production, Packing" 9.0%
The query will return "packing" 0.0%
Strings cannot be compared using < operator 0.0%
The query will return "Designing" 90.0%
A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?
select * from orders where sum(amount) > 20000 0.0%
select * from orders where sum(amount) > 20000 order by OrderDate 0.0%
select * from orders group by OrderDate having sum(amount)>20000 100.0%
select * from orders group by OrderDate where sum(amount) > 20000 0.0%
Check the following code: Public Shared Sub UpdateData(ByVal sql As String,ByVal connectionString As String, ByVal dataTable As DataTable) Dim da As New OleDb.OleDbDataAdapter() Dim cnn As New Ol...
Add code to the Application_OnStart event handler in the Global.asax file to set the values of the text strings. 100.0%
Add code to the Application_BeginRequest event handler in the Global.asax file to set the values of the text strings. 0.0%
Add code to the Session_OnStart event handler in the Global.asax file to set the values of the text strings. 0.0%
Include code in the Page.Load event handler for the default application page that sets the values if the text strings when the IsPostback property of the Page object is False. 0.0%
Include code in the Page.Load event handler for the default application page that sets the values of the text strings when the IsNewSession property of the Session object is set to True. 0.0%
Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the Cu...
Select * from Products order by CurrentStock,ProductGroup 0.0%
Select * from Products order by CurrentStock DESC,ProductGroup 0.0%
Select * from Products order by ProductGroup,CurrentStock 0.0%
Select * from Products order by ProductGroup,CurrentStock DESC 83.0%
None of the above 16.0%
Consider the following queries: 1. select * from employee where department LIKE '[^F-M]%'; 2. select * from employee where department = '[^F-M]%'; Select the correct option:
Query 2 will return an error 20.0%
Both the queries will return the same set of records 0.0%
Query 2 is perfectly correct 80.0%
Query 2 would return one record less than Query 1 0.0%
Consider the following table structure of students: rollno int name varchar(20) course varchar(20) What will be the query to display the courses in w...
Select course from students where count(course) > 5; 0.0%
Select course from students where count(*) > 5 group by course; 0.0%
Select course from students group by course; 0.0%
Select course from students group by course having count(*) > 5; 100.0%
Select course from students group by course where count(*) > 5; 0.0%
Select course from students where count(group(course)) > 5; 0.0%
Select count(course) > 5 from students; 0.0%
None of the above 0.0%
Consider the following two statements and choose the most appropriate option: 1. For configuration, ASP.NET uses IIS Metabase 2. For configuration, ASP.NET uses an XML based configuration system
1 only 0.0%
2 only 0.0%
Both 1 and 2 100.0%
Neither 1 nor 2 0.0%
Consider the following two statements relating to ASP.NET and choose the most appropriate option: Statement 1: Value types are allocated on a stack Statement 2: Reference types are allocated on a ...
Statement 1 is true and statement 2 is false 0.0%
Statement 2 is true and statement 1 is false 0.0%
Both statements 1 and 2 are true 100.0%
Both statements 1 and 2 are false 0.0%
Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, bran...
It will return the fields customer_id, customer_name, branch_name 0.0%
It will return the fields customer_id, customer_name, branch_id, branch_name 0.0%
It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name 100.0%
It will return an empty set since the two tables do not have any common field name 0.0%
It will return an error since * is used alone for one table only 0.0%
Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?
Names starting with "a" 0.0%
Names containing "a" as the second letter 100.0%
Names starting with "a" or "A" 0.0%
Names containing "a" as any letter except the first 0.0%
Consider the transaction: Begin Transaction Create table A ( x smallint, y smallint) Create table B ( p smallint, q smallint) Update A set x=600 where y > 700 Updat...
The transaction will work perfectly fine 0.0%
It will report an error 0.0%
The error handling routine contains a syntax error 0.0%
None of the above 0.0%
Both b and c 100.0%
Evaluate the following SQL statement: SELECT e.employee_id,( (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus))) AS CALC_VALUE FROM employees e, sales s WHERE e.employe...
The value displayed in the CALC_VALUE column will be lower 0.0%
The value displayed in the CALC_VALUE column will be higher 0.0%
There will be no difference in the value displayed in the CALC_VALUE column 100.0%
An error will be reported 0.0%
Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?
It returns employees whose salary is 50% more than $23,000 0.0%
It returns employees who have 50% commission rate or salary greater than $23,000 80.0%
It returns employees whose salary is 50% less than $23,000 0.0%
None of the above 20.0%
Examine the query:- select (2/2/4) from tab1; where tab1 is a table with one row. This would give a result of:
4 0.0%
2 0.0%
1 0.0%
.5 0.0%
.25 0.0%
0 100.0%
8 0.0%
24 0.0%
Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is tru...
The two statements produce identical results 100.0%
The second statement returns an error 0.0%
There is no need to specify DESC because the results are sorted in descending order by default 0.0%
None of the above 0.0%
How can you change "Hansen" into "Nilsen" in the LastName column in the Persons Table?
UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen' 100.0%
UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen' 0.0%
SAVE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen' 0.0%
SAVE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen' 0.0%
How can you pop-up a window to display text that identifies the author of the book?
For each image, set the AlternateText property to specify the text you want to display, and set the ToolTip property to True. 0.0%
In the onmouseover event handler for each image, add code that calls the RaiseBubbleEvent() method of the System.Web.UI.WebControls.Image class. 0.0%
In the onmouseover event handler for each image, add code that calls the ToString() method of the System.Web.UI.WebControls.Image class. 0.0%
For each image, set the ToolTip property to specify the text you want to display. 100.0%
How can you view the results of Trace.Write() statements?
By enabling page tracing 71.0%
By enabling application tracing 28.0%
By enabling server tracing 0.0%
By looking up the system.log file 0.0%
How you will generate a report with minimum network traffic?
Use Microsoft SQL Server indexes to optimize the data calculations 0.0%
Implement the calculations in a business layer class 20.0%
Implement the calculations in a data layer class 0.0%
Use Microsoft SQL Server stored procedures for the data calculations 80.0%
In a SQL Server query, what will the output be if you try to perform arithmetic on NULL values?
0 0%
NULL 0%
It will generate an error message 0%
Can't be determined 0%
In ASP.NET, the control's value set during the postback can be accessed in:
Page_Init 0.0%
Page_Load 100.0%
Both Page_Init and Page_Load 0.0%
Neither in Page_Load nor Page_Init 0.0%
In ASP.NET, the exception handling should be used:
to signal the occurrence of unusual or unanticipated program events 100.0%
to redirect the program's normal flow of control 0.0%
in cases of potential logic or user input errors 0.0%
in case of overflow of an array boundary 0.0%
In ASP.NET, which of the following is not an event of the Page class?
Init 0.0%
Load 0.0%
Error 0.0%
Abort 100.0%
In SQL Server, which of the following is not a control statement?
if...else 0.0%
if exists 60.0%
do...while 40.0%
while 0.0%
begin...end 0.0%
In SQL Server, you should avoid the use of cursors because:
They are very difficult to implement 0.0%
Programs with cursors take more time to run, hence performance degrades 100.0%
Programs with cursors are more lengthy, hence they consume more space/memory 0.0%
No, you must maximize the use of cursors because they improve performance 0.0%
In which of the following namespaces is the Assembly class defined?
System.Assembly 0.0%
System.Reflection 100.0%
System.Collections 0.0%
System.Object 0.0%
In which sequence are queries and sub-queries executed by the SQL Engine?
primary query -> sub query -> sub sub query and so on 0.0%
sub sub query -> sub query -> prime query 80.0%
the whole query is interpreted at one time 0.0%
there is no fixed sequence of interpretation, the query parser takes a decision on the fly 20.0%
In Windows built-in authentication, what will happen with the following set of statements? <system.web> <authorization> <deny users="RIL"/> <allow users="RIL"/> </authorization> </s...
The user RIL is first denied and then allowed access 0.0%
The user RIL is denied access because the <deny> element takes precedence over the <allow> element 80.0%
An error is generated because deny and allow cannot both be assigned to the same user 20.0%
Can't say. It depends on the Windows OS version 0.0%
Is it possible to insert several rows into a table with a single INSERT statement?
Is the FROM clause necessary in every SELECT statement?
It is time for the annual sales awards at your company. The awards include certificates awarded for the five sales of the highest sale amounts. You need to produce a list of the five highest revenu...
SELECT TOP 5 OrderAmount, SalesPersonID FROM orders 0.0%
SELECT TOP 5 OrderAmount, SalesPersonID FROM orders ORDER BY OrderAmount DESC 100.0%
SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders 0.0%
SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders ORDER BY OrderAmount 0.0%
LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis ...
SELECT distinct department_id FROM employees Where salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); 0.0%
SELECT distinct department_id FROM employees Where salary > (SELECT AVG(salary) FROM employees GROUP BY department_id); 0.0%
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); 44.0%
SELECT distinct department_id FROM employees Where salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); 55.0%
SELECT distinct department_id FROM employees Where salary < (SELECT AVG(salary) FROM employees GROUP BY department_id); 0.0%
Sam is developing an application that enables the users to perform read and write operations on text files. He uses structured exception handling to handle the errors. He writes the code for closin...
Finally block will be executed only if an error occurs 0.0%
Finally block is executed after Catch block when no error occurs 0.0%
Finally block is executed after Try block regardless of whether an error occurs 100.0%
Finally block is executed only when no error occurs 0.0%
Study the situation described below and identify the nature of relationship? Each student can enroll into more than one class. Each class can accommodate more than one student.
1 to N 0.0%
1 to 1 0.0%
M to N to 1 0.0%
M to N 100.0%
N to 1 0.0%
The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used? Employee --------- Empno Emp...
Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100); 100.0%
Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100); 0.0%
Select departname from department where count(deptno) > 100; 0.0%
Select departname from department where deptno in (select count(*) from employee where count(*) > 100); 0.0%
The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or more orders. How should primary and ...
A primary key should be created for the customer_id field in the customer table and also for the customer_id field in the order table 0.0%
A primary key should be created for the order_id field in the customer table and also for the customer_id field in the order table 0.0%
A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the customer_id field in the order table 100.0%
A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the order_id field in the order table 0.0%
None of these 0.0%
The simplest query must include at least________ and _________.
A select clause 50.0%
A where clause 0.0%
A from clause 50.0%
A group by clause 0.0%
A having clause 0.0%
An order by clause 0.0%
The STUDENT_GRADES table has these columns: STUDENT_ID INT SEMESTER_END DATETIME GPA FLOAT Which of the following statements finds the highest Grade Point Average (G...
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL 0.0%
SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL 0.0%
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end 100.0%
SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades 0.0%
SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL 0.0%
View the following Create statement: 1 Create table Pers 2 (EmpNo Int not null, 3 EName Char not null, 4 Join_dt Datetime not null, 5 Pay Int) Which line contains an error?
1 0.0%
2 0.0%
3 0.0%
4 0.0%
5 28.0%
None 71.0%
What data types do the RangeValidator control support?
Integer, String, and Date 100.0%
char, String, and Date 0.0%
Integer, String, and varchar 0.0%
Integer, bool, and Date 0.0%
What does the following line of code do? <%@ Register tagprefix="ril" Tagname="test" Src="rilTest.ascx" %>
Register a new web site 0.0%
Register a new tag 20.0%
Register a new user control 80.0%
Register a new web page 0.0%
What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by
1,2,3,4,5 0.0%
1,3,5,4,2 100.0%
1,3,5,2,4 0.0%
1,3,2,5,4 0.0%
1,3,2,4,5 0.0%
1,5,2,3,4 0.0%
1,4,2,3,5 0.0%
1,4,3,2,5 0.0%
What is the order of precedence among the following operators? 1 IN 2 NOT 3 AND 4 OR
1,2,3,4 16.0%
2,3,4,1 83.0%
1,2,4,3 0.0%
1,4,3,2 0.0%
4,3,2,1 0.0%
4,1,2,3 0.0%
4,2,1,3 0.0%
3,2,1,4 0.0%
What is the total no. of events in Global.asax file in Asp.NET?
20 0.0%
25 0.0%
19 100.0%
32 0.0%
What is wrong with the following query: select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
In the sub query, '*' should be used instead of 'OrderID' 0.0%
The sub query can return more than one row, so, '=' should be replaced with 'in' 100.0%
The sub query should not be in parenthesis 0.0%
None of the above 0.0%
What will happen if the Server configuration file and the Application configuration file have different values for session state?
The Server configuration will always override the Application configuration 20.0%
The Application configuration will always override the Server configuration 0.0%
The Server configuration will override the Application configuration if allowOverride is set to "false" in the settings in the Server configuration file 80.0%
The Application configuration will override the Server configuration if allowOverride is set to "false" in the settings in the Server configuration file 0.0%
What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;
EMPNO, unique value of ENAME and then SALARY are displayed 0.0%
EMPNO, unique value ENAME and unique value of SALARY are displayed 0.0%
DISTINCT is not a valid keyword in SQL 0.0%
No values will be displayed because the statement will return an error 100.0%
When designing a database table, how do you avoid missing column values for non-primary key columns?
Use UNIQUE constraints 20.0%
Use PRIMARY KEY constraints 0.0%
Use DEFAULT and NOT NULL constraints 80.0%
Use FOREIGN KEY constraints 0.0%
Use SET constraints 0.0%
When you make some changes to the configuration file, do you need to stop and start IIS to apply the new settings?
Which DLL is responsible for processing the page requests running on the server?
Internet Server Application Programming Interface 20.0%
Internet Information Server Program 0.0%
Webserver interface 0.0%
IIS Application 80.0%
Which line of code should you use to copy the edited rows from dataset productInfo into another dataset productChanges?
productChanges = productInfo.GetChanges(DataRowState.Detached) 25.0%
productChanges = productInfo.GetChanges() 25.0%
productChanges.Merge(productInfo, true) 25.0%
productChanges.Merge(productInfo, false) 25.0%
Which of following is correct if you want to import a C# class called myClass that is implemented in the myClass.cs file into a .aspx page?
<%@Page Import="myClass" Src="myClass.cs" %> 0%
<%@Page Inherits="myClass" Src="myClass.cs" %> 0%
<%@Page Include="myClass" Src="myClass.cs" %> 0%
<%@Page Insert="myClass" Src="myClass.cs" %> 0%
Which of the following are aggregate functions in SQL?
Avg 50.0%
Select 0.0%
Order By 0.0%
Sum 50.0%
Union 0.0%
Group by 0.0%
Having 0.0%
Which of the following are false for ASP.NET events?
Events are specialized forms of delegates 0.0%
Events are used to support the callback event notification model 0.0%
The signature of any event handler is fixed 0.0%
All of the above are true 100.0%
Which of the following are not true in ASP.NET?
A try block can have more than one catch blocks 10.0%
Every try block must have a catch block 40.0%
Every try block must have a finally block 50.0%
All exception classes are to be derived from System.Exception 0.0%
Which of the following are the valid methods of the SqlTransaction class?
Commit 36.0%
Terminate 0.0%
Save 31.0%
Close 0.0%
Rollback 31.0%
Which of the following connectionstring in Web.Config is correct if Microsoft SQL Server database named ClassList resides on a server named Neptune is to be used?
<add key="SqlConnect" value="Data Source=Neptune;Initial Catalog=ClassList;Persist Security Info=True;User ID=xyz;Password=abc"> 100.0%
<add key="SqlConnect" value="Data Source=ClassList;Initial Catalog=Neptune;Persist Security Info=True;User ID=xyz;Password=abc"> 0.0%
<add key="SqlConnect" value="Data Source=abc;Initial Catalog=xyz;Persist Security Info=True;User ID=Neptune;Password=ClassList"> 0.0%
<add key="SqlConnect" value="Data Source=abc;Initial Catalog=xyz;Persist Security Info=True;User ID=ClassList;Password=Neptune"> 0.0%
Which of the following constraints can be used to enforce the uniqueness of rows in a table?
DEFAULT and NOT NULL constraints 0.0%
FOREIGN KEY constraints 0.0%
PRIMARY KEY and UNIQUE constraints 100.0%
IDENTITY columns 0.0%
CHECK constraints 0.0%
Which of the following datatypes is not supported by SQL-Server?
Character 0.0%
Binary 0.0%
Logical 100.0%
Date 0.0%
Numeric 0.0%
All are supported 0.0%
Which of the following has the highest order of precedence in SQL Server?
Functions and Parenthesis 60.0%
Multiplication, Division and Exponents 40.0%
Addition and Subtraction 0.0%
Logical Operations 0.0%
Which of the following is not a service provided by Common Language Runtime (CLR)?
Garbage collection 0.0%
Multiple platform support 100.0%
Code verification 0.0%
Code access security 0.0%
Which of the following is not a valid ASP.NET Web form control?
<ASP:Panel> 0.0%
<ASP:Div> 100.0%
<ASP:TableCell> 0.0%
<ASP:ImageButton> 0.0%
Which of the following is not a valid directive in ASP.NET?
@Page 0%
@Implements 0%
@Insert 0%
@Register 0%
@Reference 0%
Which of the following is not a valid SQL operator?
Between..and.. 0.0%
Like 0.0%
In 0.0%
Is null 20.0%
Having 0.0%
Not in 0.0%
All of the above are valid. 80.0%
Which of the following is the default configuration file for each application in ASP.NET?
config.web 0.0%
web.config 100.0%
sys.config 0.0%
config.sys 0.0%
Which of the following is the syntax for creating an Index?
CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns) 0.0%
CREATE [UNIQUE] INDEX OF tbl_name (index_columns) 0.0%
CREATE [UNIQUE] INDEX ON tbl_name (index_columns) 0.0%
CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns) 100.0%
Which of the following is the way to handle Unmanaged Code Exceptions in ASP.NET?
Server.GetLastError() 0.0%
Exception ex 20.0%
Raise Error 0.0%
None of above 80.0%
Which of the following objects is required by the Dataset to retrieve data from a database and to save updated data back to the database?
DataAdapter 80.0%
DataReader 0.0%
Command 0.0%
Connection 20.0%
Which of the following queries is valid?
Select * from students where marks > avg(marks); 0.0%
Select * from students order by marks where subject = 'SQL'; 0.0%
Select * from students having subject ='SQL'; 0.0%
Select name from students group by subject, name; 50.0%
Select group(*) from students; 0.0%
Select name,avg(marks) from students; 0.0%
None of the above 50.0%
Which of the two statements is true? (a)MSIL code is platform independent (b)CLR is platform dependent
Only (a) is true, (b) is false 80.0%
Only (b) is true, (a) is false 0.0%
Both (a) and (b) are true 20.0%
Both (a) and (b) are false 0.0%
Which one of the following correctly selects rows from the table myTable that have null in column column1?
SELECT * FROM myTable WHERE column1 is null 83.0%
SELECT * FROM myTable WHERE column1 = null 16.0%
SELECT * FROM myTable WHERE column1 EQUALS null 0.0%
SELECT * FROM myTable WHERE column1 NOT null 0.0%
SELECT * FROM myTable WHERE column1 CONTAINS null 0.0%
Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp
+ 0.0%
- 0.0%
/ 0.0%
* 100.0%
Which query will display data from the Pers table relating to Analysts, clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?
select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job= 'Analyst' or 'clerk' or 'salesman' 0.0%
select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job= 'Analyst' or job= 'clerk' or job= 'salesman' 0.0%
select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job= 'Analyst' or 'clerk' or 'salesman') 0.0%
None of the above 100.0%
XYZ is creating an e-commerce site for PremiumBoutique. The site is distributed across multiple servers in a Web farm. Users will be able to navigate through the pages of the site and select produc...
Create a StateBag object. Use the StateBag object to store the DataSet object in the page's ViewState property 0.0%
Use the HttpSessionState object returned by the Session property of the page to store the DataSet object. Use the Web.config file to configure an out-of-process session route 40.0%
Use the Cache object returned by the page's Cache property to store a DataSet object for each user. Use an HttpCachePolicy object to set a timeout period for the cached data 0.0%
Use the Session_Start event to create an Application variable of type DataSet for each session. Store the DataSet object in the Application variable 60.0%
You are a web developer for an international literary website. Your application has a lot of text content that requires translation and few executable components. Which approach would you use?
Detect and redirect 0.0%
Use run-time adjustment 0.0%
Use satellite assemblies 100.0%
Allow the client browser to decide 0.0%
You are creating an ASP.NET application for AutoMart Internet Web site. A toolbar is required that will be displayed at the top of each page in the Web site. The toolbar will contain only static HT...
Add a new component class to your ASP.NET project. Use HTML server controls to design the toolbar within the designer of the component class. 0.0%
Create a new Web Control Library project. Create the toolbar within a Web custom control. 0.0%
Add a new Web user control to your ASP.NET project. Create the toolbar within the Web user control. 100.0%
Add a new Web Form to your ASP.NET project. Use HTML server controls to design the toolbar within the Web Form and save the Web Form with an ascx extension. 0.0%
You are creating an ASP.NET application that is hosted on your company's Web server. You want to access a database with minimal effort. What you will not do?
Begin a transaction 0.0%
Create a connection to the database 15.0%
Create a data set using an adapter object 23.0%
Use the data set to display data or to change items in the database 23.0%
Update the database from the data set 23.0%
Close the database connection 15.0%
Check for transaction errors 0.0%
You are creating an ASP.NET application that will record each customer's entry. It is possible that thousands of entries could be posted at any given time. Your application will be hosted on twenty...
View State 20.0%
Hidden fields 0.0%
State Server 0.0%
Application state 0.0%
SQL Server 80.0%
You are creating an ASP.NET application that will run on your company's intranet. You want to control the browser window and respond immediately to non-post-back events. Which should you use?
Server-side code 0.0%
Use the Browser object's VBScript or JavaScript properties to test if the browser can run scripts 0.0%
Use the Browser object's Cookies 0.0%
Client-side scripts 100.0%
You are creating an ASP.net application to enter timesheet data intuitively. Users will enter data using a DataGrid. You have added a button column to your DataGrid. The button column uses a custom...
EditCommand 0.0%
OnClick 0.0%
ButtonClicked 0.0%
ItemCommand 100.0%
You are creating an ASP.NET application. The application will be deployed on intranet. Application uses Microsoft Windows authentication. More than 100 users will use the ASP.NET application simult...
Add the following element to the authentication section of the Web.config file: <allow users="?"/> 100.0%
Use the Configuration Manager for your project to designate the user's security context. 0.0%
Write code in the Application_AuthenticateRequest event handler to configure the application to run in the user's security context. 0.0%
Add the following element to the system.web section of the Web.config file: <identity impersonate="true"/> 0.0%
You are creating an ASP.NET page for Premium Consultants. You create a GridView control that displays past purchases made by the user. The GridView control is populated from an existing database wh...
Set the Enabled property of the GridView control to false. 0.0%
Set the EnableViewState property of the GridView to false. 0.0%
Write code in the Page.Load event handler that populates the GridView control only when the IsPostBack property of the page is false. 100.0%
Write code in the Page.Load event handler that populates the GridView control only when the IsPostBack property of the page is true. 0.0%
You are creating an ASP.NET page for your company's Web site. Customers will use the ASP.NET page to enter payment information. You add a DropDownList control named oPaymentTypeList that enables cu...
Add a RequiredFieldValidator control and set its ControlToValidate property to oPaymentTypeList. Set the InitialValue property of the RequiredFieldValidator control to Select. 20.0%
Add a RequiredFieldValidator control and set its ControlToValidate property to oPaymentTypeList. Set the DataTextField property of the oPaymentTypeList control to Select. 80.0%
Add a CustomValidator control and set its ControlToValidate property to oPaymentTypeList. Set the DataTextField property of the oPaymentTypeList control to Select. 0.0%
Add a RegularExpressionValidator control and set its ControlToValidate property to oPaymentTypeList. Set the ValidateExpression property of the RegularExpressionValidator control to Select. 0.0%
You are creating an ASP.NET Web site for your company. The Web site will use both Microsoft(R) .NET Framework server controls and ActiveX controls. You want to use Microsoft Visual Studio(R) .NET t...
Cab 0.0%
Merge Module 75.0%
Web Setup 0.0%
Setup 25.0%
You are debugging a Visual Basic.NET application. You add a variable to the watch window. When Visual Basic enters break mode, the Value of the expression variable is "". What is the most likely ca...
The variable is not currently in scope. 100.0%
The variable has been defined as public. 0.0%
The variable has been defined as private. 0.0%
The variable has not been defined in this project. 0.0%
You are debugging an ASP.NET application for Premium Corp.. Users will use the application to produce reports. Your application contains several Debug.WriteLine statements. Which window in Visual S...
Command 0.0%
Locals 0.0%
Output 100.0%
Breakpoints 0.0%
You are developing a website that has four layers. The layers are user interface (web pages), business objects, data objects, and database. You want to pass data from the database to controls on a ...
Populate the data objects with data from the database. Populate the controls with values retrieved from the data objects. 0.0%
Populate the business objects with data from the database. Populate the controls with values retrieved from the business objects. 0.0%
Populate the data objects with data from the database. Populate the business objects with data from the data objects. Populate the controls with values retrieved from the business objects 100.0%
Bind the controls directly to the database. 0.0%
You are developing an application to take orders over the Internet. When the user posts back the order form, you first check to see whether he is a registered customer of your company. If not, you ...
Response.Redirect() 100.0%
Server.Transfer() 0.0%
Server.Execute() 0.0%
Page.ProcessRequest() 0.0%
You are maintaining data for its products in the Products table, and you want to see those products, which are 50 items that is currentStock or more than 50 but less than the minimum stock limit of...
(a) is correct 0.0%
(b) is correct 0.0%
(a) and (b) both are correct 66.0%
(a) and (b) both are incorrect 33.0%
You are the software engineer for Premium Corp.. One of the pages in an ASP.NET application contains the following declaration: <%@ Register Tagprefix="WoodySideBankControls" Namespace="WoodySideB...
<WoodySideBankControls:CSC1 id="Control1" runat="server" /> 60.0%
<WoodySideBankNameSpace:CSC1 id="Control1" runat="server" /> 0.0%
<WoodySideBankControls:Control1 id="CSC1" runat="server" /> 40.0%
<WoodySideBankNameSpace:Control1 id="CSC1" runat="server" /> 0.0%
You create an ASP.NET application for ABC Corporation. The project manager requires a standard appearance for all Web applications. Standards are expected to change periodically. You need to enforc...
Create a Microsoft Visual Studio .NET Enterprise template 25.0%
Create a sample HTML page 0.0%
Create a sample ASP.NET Web form 0.0%
Create a cascading style sheet 75.0%
You create an ASP.NET application for an online insurance site PremiumInsurance. A page named PersonalDetails.aspx has the following Page directive: <%@ Page Language="VB" CodeBehind="PersonalDeta...
In the Page directive for PersonalDetails.aspx, ensure that the AutoEventWireup attributes is set to "true". 50.0%
In the Page directive for PersonalDetails.aspx, ensure that the EnableViewState attribute is set to "true". 0.0%
In the MemberID HTML element, ensure that the AutoPostback attribute is set to "false". Include code for the client-side onserverchange event to submit the Web Form for processing by the server. 0.0%
In the MemberID HTML element, ensure that the AutoPostback attribute is set to "true". Include code in the TextChanged event handler to query the XML Web service. 50.0%
You create an ASP.NET page named Customer.aspx. Customer.aspx contains a Web user control that displays a drop-down list box of Cities. The Web user control is named CityList, and it is defined in ...
In the code-behind file for CityList.ascx, add the following line of code: Protected CuCity As DropDownList 0.0%
In the code-behind file for Customer.aspx, add the following line of code: Public CuCity As DropDownList 0.0%
In the code-behind file for Customer.aspx, add the following line of code: Protected CuCity As DropDownList 0.0%
In the code-behind file for CityList.ascx, add the following line of code: Public CuCity As DropDownList 100.0%
You create an ASP.NET page named ProjectCalendar.aspx that shows scheduling information for projects in your company. The page is accessed from various other ASP and ASP.NET pages hosted throughout...
Add the following statement to the Page.Load event handler for ProjectCalendar.aspx: Response.Expires(0) 0.0%
Add the following statement to the Page.Load event handler for ProjectCalendar.aspx: Response.Cache.SetExpires (DateTime.Now()) 0.0%
Add the following attribute to the Page directive for ProjectCalendar.aspx: EnableViewState="True" 0.0%
Add the following attribute to the Page directive for ProjectCalendar.aspx: SmartNavigation="True" 100.0%
You create an ASP.NET page that allows a user to enter a requested delivery date in a TextBox control named txtDelDate. The date must be no earlier than two business days after the order date, and ...
Set the AutoPostBack property of txtDelDate to False. Write code in the ServerValidate event handler to validate the date. 0.0%
Set the AutoPostBack property of txtDelDate to True. Write code in the ServerValidate event handler to validate the date. 0.0%
Set the AutoPostBack property of txtDelDate to False. Set the ClientValidationFunction property to the name of a script function contained in the HTML page that is sent to the browser. 100.0%
Set the AutoPostBack property of txtDelDate to True. Set the ClientValidationFunction property to the name of a script function contained in the HTML page that is sent to the browser. 0.0%
You have developed a custom server control and have compiled it into a file named FirstReport.dll. The code is displayed below: <%@ Register TagPrefix=" CertKing Tag" Namespace="ReportNS" Assembly...
< CertKing Tag:ReportNS PageNumber="77" runat="server" /> 0.0%
<myReport PageNumber="77" src="rptctrl" runat="server" /> 0.0%
< CertKing Tag:myReport PageNumber="77" runat="server" /> 100.0%
<% Control TagName="myReport" src="rptctrl" runat="server" %> 0.0%
You need to install an online parcel tracking application and its supporting assemblies so that the application and its assemblies can be uninstalled using the Add/Remove Programs Control Panel app...
Use a Web installation package for the Web application. Use the Global Application Cache (GAc)utility, GACUtil.exe, to install the supporting assemblies into the GAC. 0.0%
Use Xcopy deployment for the Web application and its supporting assemblies. 0.0%
Use Xcopy deployment to deploy the Web application. Use merge modules to install the supporting assemblies. 0.0%
Use a Web installation package to install the Web application and the supporting assemblies. 100.0%
You use a Command object to retrieve employee names from the employee table in the database. Which of the following will be returned when this command is executed using ExecuteReader method?
DataRow 0.0%
DataSet 0.0%
DataTable 0.0%
DataReader 100.0%
You want to access data from the "Customer" table in the database. You generate a DataSet named "MyDataSet" by adding "Customer" table to it. Which of the following statements should you use to loa...
MyAdapter.Fill(MyDataSet,"Customer") 25.0%
MyAdapter.Fill("MyDataSet",Customer) 0.0%
MyAdapter.Fill(MyDataSet) 75.0%
MyAdapter.Fill("MyDataSet") 0.0%
You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the ...
SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '11/11/2002' ORDER BY purchase_date; 0.0%
SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< '11/11/2002' ORDER BY purchase date ASC; 0.0%
SELECT book_title FROM books WHERE price < 500 OR>900 AND purchase_date DESC; 0.0%
SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '11/11/2002' ORDER BY purchase date DESC 100.0%
Your company, StoreIt Inc has stored the text of several journals in a Microsoft SQL Server 7.0 database. Each sentence is stored in a separate record so that the text can be retrieved with the fi...
Use a RichTextBox object to hold the data as it is being concatenated. 0.0%
Use the Append method of the String class. 0.0%
Use the String class and the & operator. 0.0%
Use the StringBuilder class. 100.0%