U2. Embedded DB & Console Access

U2. Embedded DB & Console Access

University

15 Qs

quiz-placeholder

Similar activities

tik kelas 7

tik kelas 7

1st Grade - University

15 Qs

Firewall & IDS

Firewall & IDS

University

10 Qs

Critical thinking

Critical thinking

University

11 Qs

SQL Quiz

SQL Quiz

University

18 Qs

Access

Access

10th Grade - University

11 Qs

Basic bioinformatics

Basic bioinformatics

University

10 Qs

basisdata1

basisdata1

University

20 Qs

Simple Way To Build Website

Simple Way To Build Website

University

10 Qs

U2. Embedded DB & Console Access

U2. Embedded DB & Console Access

Assessment

Quiz

Computers

University

Practice Problem

Easy

Created by

Héctor L

Used 21+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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?

Discover more resources for Computers