Mastering H2 Database

Question 1

What is the maximum size of H2 database?

Accepted Answer

Unlimited

Question 2

What is the default username for H2?

Accepted Answer

sa

Question 3

How do you connect to H2 database?

Accepted Answer

JDBC URL

Question 4

Which dependency is needed for H2 in Spring Boot?

Accepted Answer

h2

Question 5

How do you create a table in H2?

Accepted Answer

CREATE TABLE

Question 6

What is a key feature of H2 database?

Accepted Answer

In-memory storage

Question 7

True or false: H2 supports transactions.

Accepted Answer

True

Question 8

How do you run SQL scripts in H2?

Accepted Answer

RUNSCRIPT

Question 9

What is the default port for H2 database?

Accepted Answer

8082

Question 10

Which command is used to drop a table?

Accepted Answer

DROP TABLE

Question 11

How do you enable H2 console in Spring Boot?

Accepted Answer

Set spring.h2.console.enabled=true

Question 12

True or false: H2 is a relational database.

Accepted Answer

True

Question 13

What is the default mode of H2 database?

Accepted Answer

Embedded

Question 14

Which annotation is used for Spring Boot applications?

Accepted Answer

@SpringBootApplication

Question 15

What is the main advantage of H2?

Accepted Answer

Lightweight and fast

Question 16

What is H2 database primarily used for?

Accepted Answer

Web applications

Question 17

What is the purpose of application.properties?

Accepted Answer

Configuration settings

Question 18

What is the purpose of H2 in-memory mode?

Accepted Answer

Fast data processing

Question 19

Which SQL dialect does H2 use?

Accepted Answer

ANSI SQL

Question 20

What is the default password for H2?

Accepted Answer

(empty)

Question 21

Which command is used to run H2 database?

Accepted Answer

java -jar h2.jar

Question 22

How do you access H2 console?

Accepted Answer

/h2-console

Question 23

True or false: H2 can be embedded in applications.

Accepted Answer

True

Mastering H2 Database

Questions 23

Mastering H2 Database

Questions 23