IncludeHelp_logo
Skip Navigation Links

Home » MCQs

HSQLDB Multiple-Choice Questions (MCQs)

HSQLDB is a relational database management system (RDBMS) which is written in Java programming language. It has a JDBC driver and supports a large subset of SQL-92, SQL:2008, SQL:2011, and SQL:2016 standards.

HSQLDB MCQs: This section contains multiple-choice questions and answers on the various topics of HSQLDB. Practice these MCQs to test and enhance your skills on HSQLDB.

List of HSQLDB MCQs

1. HSQLDB is written in ____?

  1. Java
  2. Python
  3. C
  4. C++
  5. Erlang

Answer: A) Java

Explanation:

HSQLDB is written in Java.

Discuss this Question

2. HSQLDB is used for ____?

  1. Development of database application
  2. Testing of database application
  3. Deployment of database application
  4. All of the above

Answer: D) All of the above

Explanation:

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

Discuss this Question

3. Is HSQLDB open-source?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

HSQLDB is open-source.

Discuss this Question

4. Each HSQL database is referred to as a ____?

  1. Collection
  2. Catalog
  3. Table
  4. Directory

Answer: B) Catalog

Explanation:

Each HSQL database is referred to as a catalog.

Discuss this Question

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

  1. 5
  2. 4
  3. 2
  4. 3

Answer: D) 3

Explanation:

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

  • Mem
  • File
  • res

Discuss this Question

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

  1. CLOSE
  2. END
  3. SHUT
  4. SHUTDOWN

Answer: D) SHUTDOWN

Explanation:

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

Discuss this Question

7. All ongoing transactions are ____ when SHUTDOWN is ordered?

  1. Deleted
  2. Rolled back

Answer: B) Rolled back

Explanation:

All ongoing transactions are rolled back when SHUTDOWN is ordered.

Discuss this Question

8. HSQL server support which of the following network addressing?

  1. IPv4
  2. IPv6
  3. Both

Answer: B) IPv6

Explanation:

Both IPv4 and IPv6 network addresses are supported by HyperSQL listeners (server).

Discuss this Question

9. The HSQL HTTP servlet mode can serve how many databases?

  1. Multiple
  2. More than One
  3. Only one

Answer: C) Only one

Explanation:

The Servlet mode can only serve one database.

Discuss this Question

10. How many server modes are there in HSQLDB?

  1. 3
  2. 4
  3. 5
  4. 6

Answer: A) 3

Explanation:

The three modes are:

  • HSQLserver
  • HSQL HTTP SERVER
  • HSQL HTTP SERVLET

Discuss this Question

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

  1. True
  2. False

Answer: A) True

Explanation:

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

Discuss this Question

12. In HSQL how many types of tables can be created?

  1. 2
  2. 3
  3. 4
  4. 5

Answer: B) 3

Explanation:

In HSQLDB, three types of tables can be created:

  • MEMORY
  • CACHED
  • TEXT

Discuss this Question

13. Which of the following tables are stored on the Disk?

  1. MEMORY
  2. CACHED
  3. TEXT

Answer: B) CACHED

Explanation:

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

Discuss this Question

14. Which of the following is known as a temporary table?

  1. MEMORY
  2. CACHED
  3. TEXT

Answer: A) MEMORY

Explanation:

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

Discuss this Question

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

  1. Memory
  2. cached

Answer: A) Memory

Explanation:

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

Discuss this Question

16. HSQL support which of the following key constraints?

  1. PRIMARY KEY
  2. UNIQUE KEY
  3. FOREIGN KEY
  4. All of the above

Answer: D) All of the above

Explanation:

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

Discuss this Question

17. ____ are critical for query performance?

  1. Key
  2. Constraints
  3. Commands
  4. Indexes

Answer: D) Indexes

Explanation:

Indexes are critical for query performance.

Discuss this Question

18. Does HSQL ensures atomicity?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

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

Discuss this Question

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

  1. Atomicity
  2. Consistency
  3. Isolation
  4. Durability

Answer: C) Isolation

Explanation:

Isolation means that transactions do not interfere with one another.

Discuss this Question

20. Does HyperSQL supports encrypted databases?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

HyperSQL supports encrypted databases.

Discuss this Question

21. What is JAMon?

  1. Java access management
  2. Java access monitor
  3. Java application monitor
  4. Java application management

Answer: C) Java application monitor

Explanation:

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

Discuss this Question

22. Does HyperSQL supports log4J and JDK logging?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

HyperSQL supports log4J and JDK logging.

Discuss this Question

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

  1. BEFORE
  2. AFTER
  3. INSTEAD OF

Answer: C) INSTEAD OF

Explanation:

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

Discuss this Question

24. Access to schema objects is easily controlled by the ____ objects

  1. Role
  2. User
  3. Both

Answer: C) Both

Explanation:

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

Discuss this Question

25. What is the default field separator in Text tables?

  1. ,
  2. .
  3. !
  4. |

Answer: A) ,

Explanation:

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

Discuss this Question

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

  1. SET TABLE SEPARATOR SOURCE
  2. SET TABLE SOURCE
  3. CHANGE TABLE SEPARATOR

Answer: B) SET TABLE SOURCE

Explanation:

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

Discuss this Question

27. HSQLDB treats CHAR and VARCHAR strings the same.

  1. True
  2. False

Answer: A) True

Explanation:

HSQLDB treats CHAR and VARCHAR strings the same.

Discuss this Question

28. Does Text tables support transactions?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

Text tables support transactions.

Discuss this Question

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

  1. INTEGRATION
  2. CONCAT
  3. COLLATION

Answer: C) COLLATION

Explanation:

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

Discuss this Question

30. A ____ is similar to a TABLE but it does not permanently contain rows of data.

  1. Collection
  2. Schema
  3. View

Answer: C) View

Explanation:

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

Discuss this Question

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

  1. Exceptional
  2. Simple
  3. Creative
  4. Unique

Answer: D) Unique

Explanation:

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

Discuss this Question

32. Does a Simple index allow duplicate values in a table?

  1. Yes
  2. No

Answer: A) Yes

Explanation:

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

Discuss this Question

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

  1. COMMIT
  2. ROLLBACK
  3. SAVEPOINT

Answer: A) COMMIT

Explanation:

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

Discuss this Question

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

  1. COMMIT
  2. ROLLBACK
  3. SAVEPOINT

Answer: B) ROLLBACK

Explanation:

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

Discuss this Question

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

  1. COMMIT
  2. ROLLBACK
  3. SAVEPOINT

Answer: C) SAVEPOINT

Explanation:

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

Discuss this Question

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

  1. LEFT JOIN
  2. INNER JOIN
  3. RIGHT JOIN

Answer: A) LEFT JOIN

Explanation:

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

Discuss this Question

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

  1. LEFT JOIN
  2. INNER JOIN
  3. RIGHT JOIN

Answer: C) RIGHT JOIN

Explanation:

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

Discuss this Question

38. Which data type is used to store large text values?

  1. CLOB
  2. VARCHAR
  3. LONGVARCHAR

Answer: A) CLOB

Explanation:

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

Discuss this Question

39. Which of the following companies are using HSQLDB?

  1. IBM
  2. JASPERSOFT
  3. OPENBRAVO
  4. All of the above

Answer: D) All of the above

Explanation:

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

Discuss this Question

40. What are the alternatives of HSQLDB?

  1. Oracle
  2. MySQL
  3. PostgreSQL
  4. All of the above

Answer: D) All of the above

Explanation:

Following are the alternatives of HSQLB:

  • Oracle
  • MySQL
  • PostgreSQL

Discuss this Question



Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.