Top 40 HSQLDB Multiple Choice Questions (MCQs) with Answers

1 .

HSQLDB is Written in Which Programming________?

A)

C

B)

C++

C)

Java

D)

Python

Correct Answer : Java

Explanation : HSQLDB (HyperSQL DataBase) is the leading SQL relational database system written in Java

2 .

HSQLDB Is Open-Source?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : HSQLDB is open-source.

3 .

All databases running in different modes can be closed with which of the following command?

A)

END

B)

SHUT

C)

CLOSE

D)

SHUTDOWN

Correct Answer : SHUTDOWN

Explanation : All databases running in different modes can be closed with the SHUTDOWN command, issued as an SQL statement.

4 .

What are the alternatives of HSQLDB?

A)

MySQL

B)

Oracle

C)

PostgreSQL

D)

All of the above

Correct Answer : All of the above

Explanation : Following are the alternatives of HSQLB :

* Oracle
* MySQL
* PostgreSQL

5 .

Which data type is used to store large text values?

A)

VARCHAR

B)

CLOB

C)

LONGVARCHAR

D)

None of the above

Correct Answer : CLOB

Explanation : CLOB is used to store large text values, also BLOB.

6 .

How many types of the catalog are there depending upon how the data is stored?

A)

2

B)

3

C)

4

D)

5

Correct Answer : 3

Explanation : Depending on how the data is kept, there are three sorts of catalog :

* Mem
* File
* res

7 .

Each HSQL database is referred to as a ______?

A)

Table

B)

Collection

C)

Catalog

D)

Directory

Correct Answer : Catalog

Explanation : Each HSQL database is referred to as a catalog.

8 .

HSQLDB is used for ______?

A)

Testing of database application

B)

Deployment of database application

C)

Development of database application

D)

All of the above

Correct Answer : All of the above

Explanation : HSQLDB is used for the development, testing, and deployment of database applications.

9 .

All ongoing transactions are ____ when SHUTDOWN is ordered?

A)

Deleted

B)

Rolled back

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Rolled back

Explanation : All ongoing transactions are rolled back when SHUTDOWN is ordered.

10 .

Which of the following companies are using HSQLDB?

A)

IBM

B)

JASPERSOFT

C)

OPENBRAVO

D)

All of the above

Correct Answer : All of the above

Explanation : Companies like IBM, JASPERSOFT, and OPENBRAVO are using HSQLDB.

11 .

Which of the following type of join returns all rows from the right table even if no matches are found in the left table?

A)

RIGHT JOIN

B)

LEFT JOIN

C)

INNER JOIN

D)

All of the above

Correct Answer : RIGHT JOIN

Explanation : RIGHT JOIN returns all rows from the right table even if no matches are found in the left table.

12 .

Which of the following type of Join returns all rows from the left table even if no matches are found in the right table?

A)

RIGHT JOIN

B)

LEFT JOIN

C)

INNER JOIN

D)

All of the above

Correct Answer : LEFT JOIN

Explanation : LEFT JOIN returns all rows from the left table even if no matches are found in the right table.

13 .

HSQL server support which of the following network addressing?

A)

IPv4

B)

IPv6

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Both (A) and (B)

Explanation : The HyperSQL listeners support both ipv4 and ipv6 network addressing.

14 .

The HSQL HTTP servlet mode can serve how many databases?

A)

Only one

B)

Multiple

C)

More than One

D)

None of the above

Correct Answer : Only one

Explanation : The Servlet mode can only serve one database.

15 .

How many server modes are there in HSQLDB?

A)

3

B)

4

C)

5

D)

6

Correct Answer : 3

Explanation : The three modes are :

* HSQLserver
* HSQL HTTP SERVER
* HSQL HTTP SERVLET

16 .

____ command creates a point inside the collection of transactions from which to rollback.

A)

COMMIT

B)

ROLLBACK

C)

SAVEPOINT

D)

SAVEPOINT command creates a point inside the collection of transactions from which to rollback.

Correct Answer : SAVEPOINT

17 .

If the transaction fails, the ____ command should be used to restore the prior state of all tables referenced in the transaction?

A)

COMMIT

B)

ROLLBACK

C)

SAVEPOINT

D)

None of the above

Correct Answer : ROLLBACK

Explaination : If the transaction fails, the ROLLBACK command should be used to restore the prior state of all tables referenced in the transaction.

18 .

The successful transaction should always be completed by issuing the ____ command.

A)

COMMIT

B)

ROLLBACK

C)

SAVEPOINT

D)

None of the above

Correct Answer : COMMIT

Explanation : The successful transaction should always be completed by issuing the COMMIT command.

19 .

In HSQL how many types of tables can be created?

A)

0

B)

1

C)

2

D)

3

Correct Answer : 3

Explanation : In HSQLDB, three types of tables can be created :

* MEMORY
* CACHED
* TEXT

20 .

Which of the following tables are stored on the Disk?

A)

TEXT

B)

CACHED

C)

MEMORY

D)

None of the above

Correct Answer : CACHED

Explanation : The type of table that is stored on disk in HSQLDB is called a CACHED table.

21 .

The Servlet Mode cannot be started independently from the servlet engine?

A)

True

B)

False

C)

Can Not Say

D)

None of the above

Correct Answer : True

Explanation : The Servlet Mode cannot be started independently from the servlet engine.

22 .

Which of the following is known as a temporary table?

A)

TEXT

B)

CACHED

C)

MEMORY

D)

None of the above

Correct Answer : MEMORY

Explanation : MEMORY tables are known as a temporary tables, that are stored in memory.

23 .

Which of the following table is used for the small amount of data?

A)

cached

B)

Memory

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Memory

Explanation : A MEMORY table is used for a small amount of data.

24 .

Does a Simple index allow duplicate values in a table?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : Yes, a simple index allows duplicate values in a table.

25 .

A ____ index ensures that no two rows have the same index value.

A)

Simple

B)

Creative

C)

Exceptional

D)

Unique

Correct Answer : Unique

Explanation : A unique index ensures that no two rows have the same index value.

26 .

A)

View

B)

Schema

C)

Collection

D)

All of the above

Correct Answer : View

Explanation : A VIEW is similar to a TABLE but it does not permanently contain rows of data.

27 .

A ____ is a mechanism for arranging character strings in ordered sets as well as determining the equivalence of two character strings.

A)

CONCAT

B)

COLLATION

C)

INTEGRATION

D)

None of the above

Correct Answer : COLLATION

Explaination : A COLLATION is a mechanism for arranging character strings in ordered sets as well as determining the equivalence of two character strings.

28 .

Does Text tables support transactions?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : Text tables support transactions.

29 .

HSQL support which of the following key constraints?

A)

UNIQUE KEY

B)

PRIMARY KEY

C)

FOREIGN KEY

D)

All of the above

Correct Answer : All of the above

Explanation : HyperSQL supports PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.

30 .

____ are critical for query performance?

A)

Key

B)

Commands

C)

Constraints

D)

Indexes

Correct Answer : Indexes

Explanation : Indexes are critical for query performance.

31 .

Does HSQL ensures atomicity?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : HSQL ensures atomicity, both during operations and in the event of a system crash.

32 .

Which ACID property in HSQL represents transactions that do not interfere with one another?

A)

Durability

B)

Atomicity

C)

Consistency

D)

Isolation

Correct Answer : Isolation

Explanation : Isolation means that transactions do not interfere with one another.

33 .

Does HyperSQL supports encrypted databases?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

34 .

What is JAMon?

A)

Java access monitor

B)

Java application monitor

C)

Java access management

D)

Java application management

Correct Answer : Java application monitor

Explanation : HyperSQL is supported by the monitoring tool JAMon (Java Application Monitor).

35 .

HSQLDB treats CHAR and VARCHAR strings the same.

A)

True

B)

False

C)

Can Not Say

D)

None of the above

Correct Answer : True

Explanation : HSQLDB treats CHAR and VARCHAR strings the same.

36 .

Suppose you want to change the default field separator then which of the following statement would you use?

A)

CHANGE TABLE SEPARATOR

B)

SET TABLE SEPARATOR SOURCE

C)

SET TABLE SOURCE

D)

All of the above

Correct Answer : SET TABLE SOURCE

Explanation : SET TABLE SOURCE, the statement can change the field separator.

37 .

What is the default field separator in Text tables?

A)

.

B)

!

C)

|

D)

,

Correct Answer : ,

Explanation : The default field separator in Text tables is the comma(,).

38 .

Does HyperSQL supports log4J and JDK logging?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : HyperSQL supports log4J and JDK logging.

39 .

Access to schema objects is easily controlled by the ____ objects

A)

Role

B)

User

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Both (A) and (B)

Explanation : Access to schema objects is easily controlled by the ROLE and USER objects.

40 .

____ triggers are only permitted if the trigger is defined on a VIEW?

A)

AFTER

B)

BEFORE

C)

INSTEAD OF

D)

None of the above

Correct Answer : INSTEAD OF

Explanation : INSTEAD OF triggers are only permitted if the trigger is defined on a VIEW.