U2. Embedded DB & Console Access

What is a primary characteristic of embedded databases?

• They require a dedicated server to run.

• They are stored in local files and run inside the application.

• They can only be accessed through a graphical user interface.

• They are not suitable for single-user applications.

Which of the following is not an example of an embedded database?

• SQLite

• Oracle

• HSQLDB

• Apache Derby

What command is used in SQLite to check if foreign key enforcement is enabled?

• SELECT foreign_keys;

• PRAGMA foreign_keys;

• CHECK FOREIGN KEYS;

• SHOW KEYS;

In relational databases, what is the purpose of a foreign key?

• To uniquely identify each row in a table.

• To create a relationship between tables.

• To prevent duplicate values in a column.

• To index a table for faster searching.

What does the following SQL command do in SQLite?

INSERT INTO departamentos VALUES (1, 'SOFTWARE', 'VALENCIA');

• Creates a new table called departamentos.

• Adds a new record to the departamentos table.

• Updates the departamentos table with new columns.

• Deletes a record from the departamentos table.

Which of the following is a disadvantage of embedded databases?

• High resource consumption.

• Limited portability across systems.

• Limited or single-user access.

• Incompatibility with SQL-92 standards.

Which command in the SQLite console opens an existing database file?

• .connect <path>

• .use <db_name>

• .open <path>

• .load <db_name>

Which tool integrates JDBC to manage databases and supports SQLite, PostgreSQL, and others?

• MySQL Workbench

• DBeaver

• Oracle SQL Developer

• SQLite3 CLI

Which SQL keyword is used to enforce changes to the database in HSQLDB?

• SAVE;

• COMMIT;

• FINALIZE;

• APPLY;

What is the correct syntax to create a table in SQLite with a primary key?

• CREATE TABLE employees (id INT PRIMARY KEY, name TEXT);

• CREATE TABLE employees PRIMARY KEY (id, name TEXT);

• CREATE employees (id INT PRIMARY KEY, name TEXT);

• TABLE CREATE employees (id INT PRIMARY KEY, name TEXT);