0

programming languages Online Quiz - 49

Description: programming languages Online Quiz - 49
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0
  1. delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

  2. delete from table_name where rowid in (select max(rowid) from table group by duplicate_values_field_name);

  3. c)delete from table_name where rowid not in (select max(rowid) from table);

  4. delete from table_name where rowid not in (select rowid from table group by duplicate_values_field_name);


Correct Option: A

Which statement selects the odd number of records :

  1. select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);

  2. select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp);

  3. select * from emp where (rowid,1) in (select rowid, mod(rownum,1) from emp);

  4. select * from emp where (rowid,1) in (select rowid, mod(rownum,3) from emp);


Correct Option: A

1)SELECT bus_name, profit 2) FROM business 3) WHERE city = 4) (SELECT city FROM locations 5) WHERE city LIKE 'Noid_' 6) AND state = 'UP') 7) ORDER BY profits desc; How do you modify the above code if you want to avoid causing an error if the subquery returns more than one row.

  1. Change line 1 to read "SELECT DISTINCT bus_name, profits "

  2. Change line 3 to read "where city IN ("

  3. Change line 5 to read "where max (city) LIKE 'NOID%' "

  4. Change line 7 to read "order by city , profits desc "


Correct Option: B

An attribute declared as primary key can have null values.

  1. True

  2. False


Correct Option: B
  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


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;

  1. 3,2,1

  2. 3,2,2

  3. 4,2,1

  4. 4,3,2


Correct Option: A
  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


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. }
  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


Correct Option: D,E
  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


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. }
  1. x2.do2();

  2. (Y)x2.do2();

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

  4. None of the above statements will compile


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"; } }
  1. fa fa

  2. fa la

  3. la la

  4. Compilation fails


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. }
  1. h hn x

  2. hn x h

  3. b h hn x

  4. b hn x h

  5. bn x h hn x


Correct Option: C

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

  1. %ROWTYPE

  2. %TYPE

  3. AS_COLUMN

  4. None of the above


Correct Option: B

Raw types are used to store _________ data.

  1. Binary

  2. Character

  3. ASCII

  4. All of the above


Correct Option: A

SQL has facility for programmed handling of errors that arise during the manipulation of data

  1. TRUE

  2. FALSE

  3. Both

  4. None


Correct Option: B

_________ data type stores unstructured binary data upto 4GB length

  1. CLOB

  2. BLOB

  3. LONG

  4. All of the above


Correct Option: B

In a PL/SQL block structure, which parts are optional?

  1. DELCARE and BEGIN

  2. DECALRE and EXCEPTION

  3. EXCEPTION and END

  4. BEGIN and END


Correct Option: B

Procedure C is a local construct to the package. What happens when this package is compiled?

  1. It produces the output Procedure B calling C

  2. It produces the output Procedure C calling B

  3. It produces a compilation error because procedure C requires a forward declaration

  4. It produces a compilation error because procedure B requires a forward declaration.


Correct Option: C

A Rollback statement cannot be used to close transaction

  1. TRUE

  2. FALSE

  3. Both

  4. None


Correct Option: C
- Hide questions