Question 1

What does Debug.assert() do?

technology programming languages

takes Boolean condition as parameter and shows error dialog if condition is true; but proceeds without interruption if condition is false.
takes Boolean condition as parameter and throws exception if condition is false; but proceeds without interruption if condition is true.
takes Boolean condition as parameter and shows error dialog if condition is false; but proceeds without interruption if condition is true.
None of above

Answer

Correct Option: C

Question 2

Which of the below is false about Struct.

technology programming languages

Structs are value-type variables
Structs are saved on stack
structs can be inherited.
None of the above.

Answer

Correct Option: D

Question 3

Connection string entries in web.config file can be encrypted using following tool(S): 1. aspnet_regiis.exe 2. aspnet_wp.exe 3. svcutil.exe

technology programming languages

Both 1 and 2
Only 1
Only 2
Both 1 and 3

Answer

Correct Option: B

Question 4

Which one of following is false about Microsoft-provided data provider classes in ADO.NET ?

technology programming languages

SQLServer.NET data provider is faster than any other provider.
OLE-DB.NET is universal for accessing various data sources other than SQL Server also, but it’s a .NET layer on top of OLE layer, so is comparatively slow.
ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines.
None of the above

Answer

Correct Option: D

Question 5

Which statement is true for primary key and a unique key?

technology programming languages

Both are same.
A table can have multiple primary key and unique key.
Primary keys does not allow null values, but unique key allows only one null value.
Both does not allow null values

AI Explanation

AI 1

To answer this question, we need to understand the concepts of primary key and unique key in a database.

A primary key is a column or a set of columns that uniquely identifies each row in a table. It is used to enforce entity integrity and ensure that each row in the table is unique.

A unique key, on the other hand, is a constraint that ensures that the values in a column or a set of columns are unique. Unlike a primary key, a unique key can allow null values.

Let's go through each option to understand why it is correct or incorrect:

Option A) Both are the same - This option is incorrect because primary key and unique key are not the same. While they both enforce uniqueness, there are differences in their behavior.

Option B) A table can have multiple primary keys and unique keys - This option is incorrect. A table can have only one primary key, which uniquely identifies each row. However, it can have multiple unique keys, which enforce uniqueness on different columns or combinations of columns.

Option C) Primary keys do not allow null values, but unique keys allow only one null value - This option is correct. Primary keys do not allow null values because they are used to uniquely identify each row. Unique keys, on the other hand, can allow one null value. This means that while unique keys enforce uniqueness, they allow one row to have a null value in the column(s) covered by the unique key.

Option D) Both do not allow null values - This option is incorrect. As mentioned earlier, primary keys do not allow null values, but unique keys can allow one null value.

Based on the explanations above, the correct answer is Option C. Primary keys do not allow null values, but unique keys allow only one null value.

Answer

Correct Option: C

Question 6

Which out the following displays a client-side alert message “Processing Successful”, but the code is written at server-side based on some processing:

technology programming languages

string strMessage = "Processing Successful"; string strScript = "alert('" + strMessage + "');"; if(!ClientScript.IsClientScriptBlockRegistered("Startup")) {ClientScript.RegisterClientScriptBlock(Page.GetTy
string strMessage = "Processing Successful"; string strScript = " alert('" + strMessage + "');"; if(!ClientScript.IsClientScriptBlockRegistered("Startup")) {ClientScript.RegisterClientScriptBlock(Page.GetType(), "startup", strScript);}
string strMessage = "Processing Successful"; string strScript = "alert('" + strMessage + "');"; ClientScript. RegisterStartupScript(Page.GetType(), "startup", strScript);
string strMessage = "Processing Successful"; string strScript = " alert('" + strMessage + "');"; ClientScript. RegisterStartupScript(Page.GetType(), "startup", strScript);

Answer

Correct Option: A

Question 7

What is true for DELETE & TRUNCATE commands?

technology programming languages

Truncate command is same as delete command with no where clause.
Data cannot be rolled back when Truncate command is used, while data can be rolled back when delete command used.
Data cannot be rolled back when Delete command is used, while data can be rolled back when truncate command used.
Both are DML commands.

Answer

Correct Option: B

Question 8

Consider the table and query below: row_id seat_1 seat_2 seat_3 1 boy boy boy 2 girl girl girl 3 boy girl boy 4 girl boy girl 5 boy boy girl 6 girl boy boy SELECT * FROM seating WHERE seat_2 = 'boy' ORDER BY seat_3 DESC, seat_1 Which row is first in the results set returned by the SQL statement above?

technology programming languages

2
4
5
6

AI Explanation

AI 1

To answer this question, we need to understand the given SQL query and how it filters and sorts the data.

The SQL query is as follows:

SELECT * FROM seating WHERE seat_2 = 'boy' ORDER BY seat_3 DESC, seat_1

This query selects all rows from the "seating" table where the value in the "seat_2" column is 'boy'. It then orders the results by the "seat_3" column in descending order, and if there are any ties, it further orders by the "seat_1" column.

Let's go through each option to determine which row is first in the results set.

Option A) Row 2 - This option is incorrect because the value in the "seat_2" column for row 2 is 'girl', not 'boy'.

Option B) Row 4 - This option is incorrect because the value in the "seat_2" column for row 4 is 'boy', but the value in the "seat_3" column for row 4 is 'girl'. Since the query orders by "seat_3" in descending order, this row will not be first in the results set.

Option C) Row 5 - This option is correct because the value in the "seat_2" column for row 5 is 'boy', and the value in the "seat_3" column for row 5 is 'girl'. Since the query orders by "seat_3" in descending order, and there are no other rows with a higher value in "seat_3", row 5 will be the first row in the results set.

Option D) Row 6 - This option is incorrect because the value in the "seat_2" column for row 6 is 'boy', but the value in the "seat_3" column for row 6 is 'boy'. Since the query orders by "seat_3" in descending order, this row will not be first in the results set.

Therefore, the correct answer is option C. Row 5 is the first row in the results set returned by the SQL statement.

Answer

Correct Option: C

Question 9

Consider the following query: SELECT firstname, lastname, SUM(salary) FROM employees GROUP BY firstname, lastname HAVING SUM(salary) > 20000 ORDER BY lastname ASC Which part of the sample code above contains the SQL default and is therefore NOT necessary in the SQL statement?

technology programming languages

SUM
>
Group by
ASC

Answer

Correct Option: D

Question 10

Which of the following is the correct syntax for using Dictionary object in your code:

technology programming languages

using System.Collections.Generic; Dictionary < string , StringBuilder >() dctobj = new Dictionary < string , StringBuilder >;
using System.Collections.Generic; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >();
using System.Collections.Generic; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >;
using System.Text; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >();

Answer

Correct Option: B

Question 11

Which of the following is not true about Microsoft Silverlight:

technology programming languages

Both cross browser and cross platform compatible
XAML can be used for programming user interface
Can be considered as replacement for Windows Presentation Foundation
All of the above

Answer

Correct Option: C

Question 12

You have following two code segments to read records from flat-file/excel: Code segment 1: OleDbConnection con; con = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(filename) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\""); Code segment 2: OleDbConnection con; con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=Excel 8.0;"); Which one of following is true:

technology programming languages

both can create connection to excel and flat files
only second can create connection to excel
first one can create connection to both excel and flat files, whereas second one can craete connection only to Excel
None of the above

Answer

Correct Option: B

Question 13

Suppose you are implementing paging to your datagrid named grdtest using following code: protected void grdtest_PageChanger(object Source, DataGridPageChangedEventArgs E) { DataTable dttable = new DataTable(); //populate dttable with appropriate data from database grdtest.DataSource = dttable; grdtest.DataBind(); } what is the main thing missing in above code:

technology programming languages

grdtest.AllowCustomPaging = true;
grdtest.AllowPaging = true;
grdtest.CurrentPageIndex = E.NewPageIndex;
Both i and ii

Answer

Correct Option: C

Question 14

Which of the following is false for Managed Code performance improvement:

technology programming languages

Late binding defers type identification process until run time, so prefer Late Binding whenever possible
Always enable Option Explicit and Option Strict options(while using Visual Basic.NET)
If Com objects is referred in code, destroy COM objects always after use
While implementing threading, do not use Thread.Abort to terminate other threads

Answer

Correct Option: A

Question 15

Which is false about reading/writing XML data using System.Xml:

technology programming languages

XPathDocument class is very fast, but it is read-only
The XmlDocument class provides editable representation of XML document, but is comparatively slower.
XPathNavigator object can be created using both XPathDocument and XmlDocument classes, which can be used to to select and navigate XML data.
None of the above

Answer

Correct Option: D

Question 16

Consider the table and query below: Table Name: products category type price indoor kitchen 1.50 outdoor garden 6.00 indoor Bathroom 4.75 outdoor garden 20.20 indoor bathroom 4.25 Office desktop 9.80 SELECT category, COUNT(DISTINCT type) FROM products GROUP BY category How many rows are returned by the SQL statement listed above?

technology programming languages

One row
Two rows
Three rows
Four rows

Answer

Correct Option: C

Question 17

While creating a view from two tables, you need to ensure that view cannot be affected by modifications to underlying table schema. What should you do to accomplish this goal with least possible amount of overhead?

technology programming languages

Create CHECK constraints on the tables
Create a DDL trigger to rollback any changes to the tables if then changes affect the columns in the view.
Create the view, specifying the WITH SCHEMABINDING option.
Create the view, specifying the WITH CHECK option.

Answer

Correct Option: C

Question 18

Which of the following is true about xp command shell in SQL Server 2005:

technology programming languages

xp command shell can be enabled by sysadmin by executing following: EXEC sp_configure 'xp_cmdshell', 0;
xp command shell is enabled by default;
xp command shell can be used to run bcp utility
None of above

Answer

Correct Option: C

Question 19

You have created a cursor named test_cursor inside your stored procedure. Following is the cursor code: --------------------------------------------------------------------- DECLARE @Name AS VARCHAR(100) DECLARE test_cursor CURSOR FOR SELECT empname FROM Employee Order BY empid OPEN test_cursor FETCH NEXT FROM test_cursor INTO @Name WHILE @@FETCH_STATUS <> 0 BEGIN -- Do your internal procesing here FETCH NEXT FROM test_cursor INTO @Name END CLOSE test_cursor DEALLOCATE test_cursor --------------------------------------------------------------------- What correction is required in the code above?

technology programming languages

First Deallocate and then close
Use @@FETCH_STATUS = 0 instead of @@FETCH_STATUS <> 0
No need to use "FETCH NEXT FROM test_cursor INTO @Name" again before END statement
Both i and ii

Answer

Correct Option: B

Question 20

When you need to perform complex calculations or access external resources in SQL Server 2005, which one of the following programming methods do you use?

technology programming languages

SQL Server Management Studio
CLR User Defined Type
CLR Stored Procedure
T-SQL View

Answer

Correct Option: C

Description: programming languages Online Quiz - 240
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: programming languages

programming languages Online Quiz - 240

AI Explanation

AI Explanation

AI Explanation

Find more quizzes from top tags