Tag: technology

Questions Related to technology

  1. a) By using the insert="false" and update="false" attributes.

  2. b) By using the isinsert="false" and isupdate="false" attributes.

  3. c) By using the isinsert="no" and isupdate="no" attributes

  4. d) None


Correct Option: A
  1. a) Use sigsend()

  2. b) use kill()

  3. c) use signal()

  4. d) Only init can send signals


Correct Option: B

Which statement is correct ?

  1. a) A Session will not obtain a JDBC Connection (or a Datasource) unless it is needed

  2. b) A Session will obtain a JDBC Connection (or a Datasource) on object create

  3. c) A Session has no relation with JDBC Connection (or a Datasource)

  4. d) none of the above


Correct Option: A
  1. It returns a single result row based on single rows

  2. It returns a single result row based on groups of rows

  3. It can only appear in ORDER BY clauses

  4. It cannot appear in select lists


Correct Option: B
  1. a) hibernate.cache.query_cache true

  2. b) hibernate.cache.use_query_cache true

  3. c) hibernate.cache.query_cache yes

  4. d) none


Correct Option: B
  1. SELECT ABS(-33) "Absolute" FROM DUAL;

  2. SELECT ABS(-33), Absolute FROM DUAL;

  3. SELECT ABS("-33") Absolute FROM DUAL;

  4. None of these


Correct Option: A
Explanation:

To solve this question, the user needs to know the syntax for calculating the absolute value in SQL. The ABS function can be used to calculate the absolute value of a number.

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

A. SELECT ABS(-33) "Absolute" FROM DUAL; This option is correct. The ABS function is used to calculate the absolute value of a number, and the syntax in this statement is correct. The "Absolute" alias is used to rename the column with the calculated value.

B. SELECT ABS(-33), Absolute FROM DUAL; This option is incorrect. The "Absolute" alias is not defined in the statement. Additionally, the ABS function is used correctly.

C. SELECT ABS("-33") Absolute FROM DUAL; This option is incorrect. The quotation marks around the number indicate that it is a string, not a number. The ABS function cannot calculate the absolute value of a string.

D. None of these This option is incorrect. Option A is the correct answer.

The Answer is: A

  1. a) Session.load();

  2. b) Session.get();

  3. c) Session.fetch();

  4. d) None of the above


Correct Option: B
  1. a) bag has index column

  2. b) bag permits duplicate element values

  3. c) bag does not permits duplicate element values

  4. d) None


Correct Option: B
Explanation:

To solve this question, the user needs to have knowledge about the concept of a bag data structure. A bag is a collection of unordered elements that may contain duplicates.

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

a) bag has index column: This statement is incorrect. A bag is an unordered collection, which means it does not have an index column. Items in a bag are stored in any order.

b) bag permits duplicate element values: This statement is correct. A bag allows duplicate elements to be added to it. For example, a bag can contain two or more items with the same value.

c) bag does not permit duplicate element values: This statement is incorrect. A bag permits duplicate elements to be added to it. Therefore, this statement is false.

d) None: This option is incorrect because option B is correct.

The Answer is: B