0

databases Online Quiz - 181

Description: databases Online Quiz - 181
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

The iBATIS XML configuration file contains ________________ that have a dramatic effect on how iBATIS behaves

  1. Beans and Objects

  2. Settings and Properties

  3. settings and getting

  4. configuration and Creations


Correct Option: B
  1. It will clean up your code and reduce the complexity of iBATIS

  2. It will generate the folder structure and delete the Objects from the cache memory

  3. It will clean up your code and improve the usability of iBATIS in the long term

  4. None of the above


Correct Option: C

Define Mapper class in iBATIS:

  1. Mapper classes are Java classes that contain SQL Mapping Annotations that avoid the need for XML

  2. Mapper classes are Java classes that contain data Mapping Annotations that encourage the need for XML

  3. Mapper classes are Java classes that contain SQL that avoid the need for XML

  4. Mapper classes are O/R Mapping objects contain SQL Mapping objects that avoid the need for XML


Correct Option: A
  1. configuration, environments, environment, transactionManager, dataSource, mappers,mapper

  2. configuration, environments, transactionManager, dataSource, property, mappers

  3. configuration, environments, environment, transactionManager, dataSource, property, mappers,mapper

  4. configuration, environment, transactions, dataSource, property, mappers,mapper


Correct Option: C

SQL is case sensitive

  1. True

  2. False


Correct Option: B

The SQL SELECT INTO statement can be used to create backup copies of tables.

  1. True

  2. False


Correct Option: A

We cannot add SQL functions, WHERE, and JOIN statements to a view

  1. True

  2. False


Correct Option: B

the data type "tinyint" allows whole numbers from 0 to 198

  1. True

  2. False


Correct Option: B

The WHERE keyword cannot be used with aggregate functions.

  1. True

  2. False


Correct Option: A

Which of the following is the correct usage of Order by

  1. select col1,col2 from table_a order by col2,col1 desc

  2. select col1,col2 from table_a order by 2,col1 desc

  3. select col1,col2 from table_a order by 2,1

  4. select col1,col2 from table_a order by 1,col2


Correct Option: A,C

What will happen when Database Instance is up but Listner is not running

  1. you will not be able to connect locally ,but you can be able to connect to DB from remote

  2. you cannot be able to connect to DB either from remote or from local

  3. you cane to connect to DB either from remote or from local

  4. you will not be able to connect remotely ,but you can be able to connect to DB locally


Correct Option: D

What are the different tags which can be used with 'LIKE'

  1. *

  2. ?

  3. _ (underscore)

  4. %


Correct Option: B,C,D
- Hide questions