Tag: technology

Questions Related to technology

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?

technology databases

  1. TSQL_Duration

  2. TSQL_Grouped

  3. TSQL_Replay

  4. TSQL_SPs

Show answer
Correct Option: B

ORA-01403 Means?
technology programming languages

  1. No data found

  2. Internal error

  3. TNS:could not resolve service name"

  4. None of the above

Show answer
Correct Option: A

ORA-01017 ?

technology programming languages

  1. Oracle not available (the database is down)

  2. Invalid Username/Password

  3. Snapshot too old (Rollback has been overwritten)

  4. Unique constraint violated

Show answer
Correct Option: B

ORA-00001 Means?
technology programming languages

  1. PL/SQL Error

  2. No data found

  3. Insufficient privileges

  4. Unique constraint violated. (Invalid data has been rejected)

Show answer
Correct Option: D

ORA-00001 Means?
technology programming languages

  1. PL/SQL Error

  2. No data found

  3. Insufficient privileges

  4. Unique constraint violated. (Invalid data has been rejected)

Show answer
Correct Option: D

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

technology programming languages

  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

Show answer
Correct Option: B

ORA-03114 Means?
technology programming languages

  1. Not connected to ORACLE

  2. Table or view does not exist

  3. Internal error (contact support)

  4. None Of The Above

Show answer
Correct Option: A

ORA-03114 Means?
technology programming languages

  1. Not connected to ORACLE

  2. Table or view does not exist

  3. Internal error (contact support)

  4. None Of The Above

Show answer
Correct Option: A

ORA-12154 Means?

technology programming languages

  1. TNS:name lookup failure"

  2. TNS:could not resolve service name"

  3. TNS:protocol adapter error"

  4. Package error raised with DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR

Show answer
Correct Option: B

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)
technology programming languages

  1. Case 1

  2. Case 2

  3. Case 3

  4. Default

  5. Compiler Error

Show answer
Correct Option: E