Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

You are gathering performance and optimization data for your SQL Server 2005 database. Your company has three custom applications that routinely make use of the database. Each application accesses the database using separate login credentials. You wish to gather information concerning the queries executed by each custom application. To gather this data you decide to create a trace using the SQL Server Profiler. You decide to use one of the predefined SQL Server Profiler templates to define what data should be gathered. Which predefined SQL Server Profiler template would best suit your requirements?

  1. TSQL_Duration

  2. TSQL_Grouped

  3. TSQL_Replay

  4. TSQL_SPs
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology programming languages

From the following code fragments select the most appropriate way of throwing exceptions ?Assume that variable i is properly defined , in scope and has appropriate value

  1. if ( i > 10) { throws new IndexOutOfBoundsException("Index is out of bound!"); }

  2. if ( i > 10) { throw new IndexOutOfBoundsException("The value of index i=" + " is out of bound!" ); }

  3. if ( i > 10) { throw "Index is out of bound!"; }

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

Consider the following piece of code: 1 long i = 2 ; 2 switch (i) { 3 case 1: 4 System.out.println ("Case 1"); 5 case 2: 6 System.out.println ("Case 2"); 7 case 3: 8 System.out.println ("Case 3"); 9 default: 10 System.out.println ("Default"); 11 } Which of the following lines will be included in the output? (Choose all that apply, please bear with code as formating it sems is not possible,first numbers represent line numbers)

  1. Case 1

  2. Case 2

  3. Case 3

  4. Default

  5. Compiler Error
Reveal answer Fill a bubble to check yourself
E Correct answer
Full explanation