Tag: programming languages

Questions Related to programming languages

While creating tables, the concept that is used to reduce redundancy in data is called
technology programming languages

  1. Views

  2. Normalization

  3. Integrity

  4. Consistency

Show answer
Correct Option: B

SELECT ROUND(123.456,2) , TRUNC(123.456,2), ROUND(125.456, -1) , TRUNC(126.456,-2) FROM DUAL;
technology programming languages

  1. 123.46,123.45,130,100

  2. 123.46,123.45,130,120

  3. 123.46,123.45,120,100

  4. 123.46,123.45,125,100

Show answer
Correct Option: A

A table has following 2 columns with the given valuesc1 c2 -------------- 1 1 1 NULL 2 0 NULL NULL . What will be the output of the following query :select count(*) , count (c1+c2) , count (distinct (c1 + c2)) from temp;
technology programming languages

  1. 3,2,1

  2. 3,2,2

  3. 4,2,1

  4. 4,3,2

Show answer
Correct Option: A

SELECT name,salary , dept FROM emp e WHERE NOT EXISTS (SELECT 1 FROM dept WHERE deptno = e.dept); Which employees are retrieved from the above query:
technology programming languages

  1. Employees who work for a department that is not listed in DEPT table.

  2. Employees who work from department 1

  3. Employees who work for a department with more than 1 employee

  4. Employees who work for a department other than department 1

Show answer
Correct Option: A
  1. package pkgA; 2. public class Foo { 3. int a = 5; 4. protected int b = 6; 5. public int c = 7; 6. } 3. package pkgB; 4. import pkgA.*; 5. public class Baz { 6. public static void main(String[] args) { 7. Foo f = new Foo(); 8. System.out.print(" " + f.a); 9. System.out.print(" " + f.b); 10. System.out.print(" " + f.c); 11. } 12. }
technology programming languages

  1. 5 6 7

  2. 5 followed by an exception

  3. Compilation fails with an error on line 7

  4. Compilation fails with an error on line 8

  5. Compilation fails with an error on line 9

  6. Compilation fails with an error on line 10

Show answer
Correct Option: D,E
  1. class Announce { 5. public static void main(String[] args) { 6. for(int __x = 0; __x < 3; __x++) ; 7. int #lb = 7; 8. long [] x [5]; 9. Boolean []ba[]; 10. enum Traffic { RED, YELLOW, GREEN }; 11. } 12. }
technology programming languages

  1. Compilation succeeds

  2. Compilation fails with an error on line 6

  3. Compilation fails with an error on line 7

  4. Compilation fails with an error on line 8

  5. Compilation fails with an error on line 9

  6. Compilation fails with an error on line 10

Show answer
Correct Option: C,D,F
  1. class X { void do1() { } } 2. class Y extends X { void do2() { } } 3. 4. class Chrome { 5. public static void main(String [] args) { 6. X x1 = new X(); 7. X x2 = new Y(); 8. Y y1 = new Y(); 9. // insert code here 10. } 11. }
technology programming languages

  1. x2.do2();

  2. (Y)x2.do2();

  3. ((Y)x2).do2();

  4. None of the above statements will compile

Show answer
Correct Option: C
  1. public class Tenor extends Singer { 4. public static String sing() { return "fa"; } 5. public static void main(String[] args) { 6. Tenor t = new Tenor(); 7. Singer s = new Tenor(); 8. System.out.println(t.sing() + " " + s.sing()); 9. } 10. } 11. class Singer { public static String sing() { return "la"; } }
technology programming languages

  1. fa fa

  2. fa la

  3. la la

  4. Compilation fails

Show answer
Correct Option: B
  1. class Building { 4. Building() { System.out.print("b "); } 5. Building(String name) { 6. this(); System.out.print("bn " + name); 7. } 8. } 9. public class House extends Building { 10. House() { System.out.print("h "); } 11. House(String name) { 12. this(); System.out.print("hn " + name); 13. } 14. public static void main(String[] args) { new House("x "); } 15. }
technology programming languages

  1. h hn x

  2. hn x h

  3. b h hn x

  4. b hn x h

  5. bn x h hn x

Show answer
Correct Option: C

AI Explanation

To understand the given code and determine the output, let's analyze each part of it step by step:

  1. The code starts with the definition of a class Building.
  2. The Building class has two constructors: Building() and Building(String name).
  3. The first constructor Building() prints "b ".
  4. The second constructor Building(String name) calls the first constructor using this(), and then prints "bn " followed by the value of name.
  5. Next, there is a class House that extends the Building class.
  6. The House class has two constructors: House() and House(String name).
  7. The first constructor House() prints "h ".
  8. The second constructor House(String name) calls the first constructor using this(), and then prints "hn " followed by the value of name.
  9. Finally, the main method of the House class creates a new House object with the value "x " as the argument.

Now, let's go through the options to determine the correct output:

Option A) h hn x

This option is incorrect. It suggests that the output will be "h hn x". However, it doesn't consider the constructors of the Building class.

Option B) hn x h

This option is incorrect. It suggests that the output will be "hn x h". However, it doesn't consider the constructors of the Building class.

Option C) b h hn x

This option is correct. As per the given code, the output will be "b h hn x". The House constructor calls the Building constructor using this(), which in turn calls the Building() constructor, printing "b ". Then, the House constructor prints "h ", followed by "hn " and the value "x ".

Option D) b hn x h

This option is incorrect. It suggests that the output will be "b hn x h". However, it doesn't consider the order of constructor calls.

Option E) bn x h hn x

This option is incorrect. It suggests that the output will be "bn x h hn x". However, it doesn't consider the order of constructor calls.

Therefore, the correct answer is option C) b h hn x.

The __________ attribute is used to declare variables based on definitions of columns in table
technology programming languages

  1. %ROWTYPE

  2. %TYPE

  3. AS_COLUMN

  4. None of the above

Show answer
Correct Option: B