Search Header Logo

U2. Embedded DB & Console Access

Authored by Héctor L

Computers

University

Used 21+ times

U2. Embedded DB & Console Access
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

SQLite

Oracle

HSQLDB

Apache Derby

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

.connect <path>

.use <db_name>

.open <path>

.load <db_name>

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?