Tag: programming languages

Questions Related to programming languages

Select the VALID trigger type(s)?
technology programming languages

  1. AFTER statement trigger

  2. INSERT row trigger

  3. DELETE row trigger

  4. All of the above

Show answer
Correct Option: A

PL/SQL raises an exception, in which TWO of the following cases:
technology programming languages

  1. When a SELECT statement returns no rows

  2. When a SELECT statement returns more than one row

  3. When the datatypes of SELECT clause and INTO clause do not match

  4. When INTO statement is missing in the SELECT statement

Show answer
Correct Option: A,B

In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
technology programming languages

  1. NULL

  2. 0

  3. Results in a compilation error

  4. An exception will be raised

Show answer
Correct Option: A

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

  1. TO_CHAR

  2. LOWER

  3. LPAD

  4. MAX

Show answer
Correct Option: D

Which section of a PL/SQL block would most likely contain a RAISE statement?
technology programming languages

  1. Header

  2. Declarative

  3. Executable

  4. Exception

Show answer
Correct Option: C,D

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table?
technology programming languages

  1. SELECT ADD(Price) FROM Sales

  2. SELECT SUM(Price) WHERE Sales

  3. SELECT TOTAL(Price) FROM Sales

  4. SELECT SUM(Price) FROM Sales

Show answer
Correct Option: D
Explanation:

To solve this question, the user needs to know the correct SQL syntax for getting the total value of a column in a table. The correct SQL syntax for getting the total value of a column in a table is to use the SUM() function.

Now, let's go through each option and explain why it is right or wrong:

A. SELECT ADD(Price) FROM Sales: This option is incorrect because there is no ADD() function in SQL. The user should have used SUM() instead of ADD().

B. SELECT SUM(Price) WHERE Sales: This option is incorrect because the WHERE clause is incomplete. The correct SQL syntax would be to use the FROM keyword after the WHERE clause to specify the table from which to retrieve the data. Additionally, the correct SQL syntax for getting the total value of a column is to use the SUM() function, not the WHERE keyword.

C. SELECT TOTAL(Price) FROM Sales: This option is incorrect because there is no TOTAL() function in SQL. The user should have used SUM() instead of TOTAL().

D. SELECT SUM(Price) FROM Sales: This option is correct. The user has used the correct SQL syntax to get the total value of the 'Price' column in the 'Sales' table. The SUM() function is used to add up all the values in the 'Price' column and return the total value.

The Answer is: D

Which of the following SQL statements does count the rows in the 'Sales' table?
technology programming languages

  1. SELECT COUNT(*) FROM Sales

  2. SELECT COUNT(*) IN Sales

  3. SELECT COUNTER(*) FROM Sales

  4. SELECT NUM() FROM Sales

Show answer
Correct Option: A
Explanation:

To count the rows in a table, we use the COUNT() function in SQL. The correct answer is:

The Answer is: A. SELECT COUNT(*) FROM Sales

Explanation:

A. SELECT COUNT() FROM Sales: This option is correct because it uses the COUNT() function to count all the rows in the 'Sales' table. The () symbol means that we are counting all the rows.

B. SELECT COUNT(*) IN Sales: This option is incorrect because the syntax is not correct. The keyword IN cannot be used in this context.

C. SELECT COUNTER(*) FROM Sales: This option is incorrect because there is no such function as COUNTER() in SQL. The correct function name is COUNT().

D. SELECT NUM() FROM Sales: This option is incorrect because there is no such function as NUM() in SQL. We need to use the COUNT() function to count the rows in the table.

Therefore, option A is the correct answer.

Given the following code: public class OrtegorumFunction { public int computeDiscontinuous(int x) { int r = 1; r += X; if ((x > 4) && (x < 10)) { r += 2 * x; } else (x <= 4) { r += 3 * x; } else { r += 4 * x; } r += 5 * x; return r; } public static void main(String [] args) { OrtegorumFunction o = new OrtegorumFunction(); System.out.println("OF(11) is: " + o.computeDiscontinuous (11)); } } What is the result?
technology programming languages

  1. OF(11) is: 45

  2. OF(11) is: 56

  3. OF(11) is: 89

  4. OF(11) is: 111

  5. Compilation fails

  6. An exception is thrown at runtime.

Show answer
Correct Option: E

Given: 1. class Crivitch { 2. public static void main(String [] args) { 3. int x = 0; 4. // insert code here 5. do { } while (x++ < y); 6. System.out.println(x); 7. } 8. } Which, inserted at line 4, produces the output 12?
technology programming languages

  1. int y = x;

  2. int y = 10;

  3. int y = 11;

  4. int y = 12;

  5. int y = 13;

  6. None of the above will allow compilation to succeed

Show answer
Correct Option: C

Given: class Plane { static String s = "-"; public static void main(String[] args) { new Plane().s1() ; System.out.println(s); } void sl() { try { s2(); catch (Exception e) { s += "c"; } } void s2() throws Exception { s3(); s += "2"; s3(); s += "2b"; } void s3() throws Exception { throw new Exception(); } } What is the result?
technology programming languages

  1. -

  2. -c

  3. -c2

  4. -2c

  5. -c22b

  6. -2c2b

Show answer
Correct Option: B
Explanation:

To solve this question, we need to trace the execution of the code and see how the value of the variable s changes.

Starting with the main method, it creates a new instance of the Plane class and calls its method s1().

In the s1() method, it calls the method sl().

In the sl() method, it calls the method s2(). Since s2() throws an exception, execution of the sl() method is transferred to the catch block. Here, it appends "c" to the value of s.

Control is then transferred back to the s1() method, which then returns to the main method. Finally, the value of s is printed to the console, which is "-c" since the catch block was executed.

Therefore, the answer is: B. -c