Tag: programming languages

Questions Related to programming languages

close with lock statement closes an opened file and it prevents the file from further being opened by the same program.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

SEARCH can be applied to a table which does not have an INDEX defined.

technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

Which is responsible for dot net framework language interoperability

technology programming languages

  1. JIT

  2. Language Specific Compiler

  3. MSIL

  4. CTS

Show answer
Correct Option: C

The above code compiles in __ language?

technology programming languages

  1. JAVA

  2. C#

  3. works in java but not in C#

  4. works in C# but not in JAVA

  5. works in both languages

Show answer
Correct Option: C

Create table temp (name varchar2 (20) , empid integer) ; insert into temp ('abc',100) ; savepoint a; insert into temp ('def' , 100); delete from temp; rollback to a; commit;
technology programming languages

  1. 0

  2. 2

  3. error

  4. 1

Show answer
Correct Option: D

Which of the following statements is true :
technology programming languages

  1. inner join and intersect are same

  2. left join and union are same

  3. inner join when used with distinct can simulate intersect

  4. inner join and union are same

Show answer
Correct Option: C

Which of the following queries can be used to delete duplicate records from a table -
technology programming languages

  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);

Show answer
Correct Option: A

Which statement selects the odd number of records :

technology programming languages

  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);

Show answer
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.
technology programming languages

  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 "

Show answer
Correct Option: B

An attribute declared as primary key can have null values.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B