Tag: programming languages

Quizzes (351) Questions (7021)

Questions Related to programming languages

Multiple choice technology programming languages

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

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

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

  3. using System.Collections.Generic; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >;

  4. using System.Text; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >();
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology programming languages

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:

  1. both can create connection to excel and flat files

  2. only second can create connection to excel

  3. first one can create connection to both excel and flat files, whereas second one can craete connection only to Excel

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology programming languages

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:

  1. grdtest.AllowCustomPaging = true;

  2. grdtest.AllowPaging = true;

  3. grdtest.CurrentPageIndex = E.NewPageIndex;

  4. Both i and ii
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology programming languages

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

  1. Late binding defers type identification process until run time, so prefer Late Binding whenever possible

  2. Always enable Option Explicit and Option Strict options(while using Visual Basic.NET)

  3. If Com objects is referred in code, destroy COM objects always after use

  4. While implementing threading, do not use Thread.Abort to terminate other threads
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology programming languages

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

  1. XPathDocument class is very fast, but it is read-only

  2. The XmlDocument class provides editable representation of XML document, but is comparatively slower.

  3. XPathNavigator object can be created using both XPathDocument and XmlDocument classes, which can be used to to select and navigate XML data.

  4. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology programming languages

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?

  1. Create CHECK constraints on the tables

  2. Create a DDL trigger to rollback any changes to the tables if then changes affect the columns in the view.

  3. Create the view, specifying the WITH SCHEMABINDING option.

  4. Create the view, specifying the WITH CHECK option.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology programming languages

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?

  1. First Deallocate and then close

  2. Use @@FETCH_STATUS = 0 instead of @@FETCH_STATUS <> 0

  3. No need to use "FETCH NEXT FROM test_cursor INTO @Name" again before END statement

  4. Both i and ii
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation