WorksheetsU2. Embedded DB & Console Access
Total questions: 15
Worksheet time: 10mins
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);
What is one of the advantages of SQLite?
It supports multi-threaded applications natively.
It is open-source and self-contained with no configuration required.
It is faster than all other relational databases.
It only works with Java-based applications.
What is the role of a database management system (DBMS) in a relational model?
To ensure referential integrity and manage constraints.
To connect non-relational data sources.
To create embedded databases only.
To store data exclusively in XML format.
Which type of database access does not require a running server?
Remote server-based access.
Embedded database access.
Graphical user interface access.
Console-based database access.
What do you think is the most important concept of the content covered in this unit?
You can only use 1-2 words.
From 1 to 5, how confident do you feel with the topic covered in this unit?
1 - not confident at all
2 - slightly confident
3 - moderately confident
4 - very confident
5 - extremely confident
