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

The configuration XML file contains below mentioned tags

  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

Constraints can be specified after a table is created

  1. True

  2. False


Correct Option: A

The users cannot see an index

  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

DATE() returns the current date

  1. True

  2. False


Correct Option: B

The WHERE keyword cannot be used with aggregate functions.

  1. True

  2. False


Correct Option: A

SQL wildcards must not be used with the SQL LIKE operator.

  1. True

  2. False


Correct Option: B

The IN operator allows you to specify multiple values in a WHERE clause.

  1. True

  2. False


Correct Option: A

Commit is required after truncate command is issued.

  1. True

  2. False


Correct Option: B

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 are the notations used for writing SQL language

  1. OMEGA

  2. RHO

  3. DELTA

  4. PIE


Correct Option: B,D

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