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

Using the namespace once, and putting it in a proper Java package namespace,

  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

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

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

  1. True

  2. False


Correct Option: A

Constraints can be specified after a table is created

  1. True

  2. False


Correct Option: A

AI Explanation

To answer this question, you need to understand how constraints are specified in a database table.

Option A) True - This option is correct. In most database management systems, constraints can be specified after a table is created. Constraints are used to enforce rules and conditions on the data stored in a table. They can be added or modified using SQL statements, even after the table has been created.

Option B) False - This option is incorrect. Constraints can indeed be specified after a table is created.

The correct answer is A) True. Constraints can be specified after a table is created.

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

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

How many categories are available for SQL Commands

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: C

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