Tag: technology

Questions Related to technology

Which of the following lines will compile without warning or error.
technology programming languages

  1. float f=1.3;

  2. char c="a";

  3. byte b=257;

  4. int i=10;

Show answer
Correct Option: D

Which of the following SQL functions can operate on any datatype?
technology databases

  1. to_char

  2. max

  3. cube

  4. rollup

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to have knowledge of SQL functions.

A. to_char: This function is used to convert a number or date to a string. It cannot operate on any datatype.

B. max: This function returns the maximum value in a set of values. It can operate on any datatype.

C. cube: This function is used to generate a result set that represents the subtotals and grand totals of the selected columns. It cannot operate on any datatype.

D. rollup: This function is used to generate a result set that represents the subtotals of the selected columns. It cannot operate on any datatype.

Therefore, the correct answer is:

The Answer is: B. max

Which Oracle access method is the fastest way for Oracle to retrieve a single row?
technology databases

  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID

Show answer
Correct Option: D

A byte can be of what size?
technology programming languages

  1. -128 to 127

  2. (-2 power 8 )-1 to 2 power 8

  3. -255 to 256

  4. depends on the particular implementation of the Java Virtual machine

Show answer
Correct Option: A

Which command will delete all data from a table and will not write to the rollback segment?
technology databases

  1. DROP

  2. DELETE

  3. REMOVE

  4. TRUNCATE

Show answer
Correct Option: D

What will be printed out if this code is run with the following command line? java myprog good morning public class myprog{ public static void main(String argv[]) { System.out.println(argv[2]); } }
technology programming languages

  1. myprog

  2. good

  3. morning

  4. Exception raised: "java.lang.ArrayIndexOutOfBoundsException: 2"

Show answer
Correct Option: D

What is the default behaviour of OUT parameter mode in PL/SQL
technology databases

  1. By value

  2. By reference

  3. By type

  4. none of the above

Show answer
Correct Option: A

What is RAC
technology databases

  1. Real abstarct clusters

  2. Real application cursors

  3. Real application clusters

  4. none of the above

Show answer
Correct Option: C

Which of the following are keywords or reserved words in Java?
technology programming languages

  1. if

  2. then

  3. goto

  4. case

Show answer
Correct Option: A,C,D

What will be printed out if you attempt to compile and run the following code ? int i=1; switch (i) { case 0: System.out.println("zero"); break; case 1: System.out.println("one"); case 2: System.out.println("two"); default: System.out.println("default"); }
technology programming languages

  1. one

  2. one, default

  3. one, two, default

  4. default

Show answer
Correct Option: C