What is the function of a foreign key?

It links data between two tables

What is a data warehouse?

A large-scale storage system used for analysis and reporting

What is a table in a database?

A collection of related data stored in rows and columns

What is the purpose of a database schema?

To define the structure of a database

What does the SQL command “JOIN” do?

Combines rows from two or more tables based on a related column

What is a database administrator (DBA) responsible for?

Managing and maintaining the database system

What does the SQL command “DELETE” do?

Removes specific rows from a table

A type of software for editing images

What is a query in a database?

A request to retrieve or manipulate data

What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

What is the primary key in a database table?

A unique identifier for each record

What is normalization in databases?

The process of organizing data to reduce redundancy

What is a transaction in a database?

A sequence of database operations treated as a single unit

studbud

Base de datos etapa 1

20 termsStudBud Administration22 plays

Imported from external platform

Flashcards20 cardsFPractice quizPHost liveL

Questions 20

Answers

1
What is an index in a database used for?
To delete duplicate records
To improve search performance
To slow down queries
To store passwords
2
What is the function of a foreign key?
It generates random values
It serves as a backup for the primary key
It is a key used to unlock database
It links data between two tables
3
What is a data warehouse?
A large-scale storage system used for analysis and reporting
A temporary storage for queries
A method of database encryption
A tool for creating websites
4
What is a table in a database?
A programming structure
A type of user interface
A collection of related data stored in rows and columns
A graphical representation of data
5
What is the purpose of a database schema?
To delete redundant data
To define the structure of a database
To store passwords securely
To visualize the data
6
Which of the following is NOT a type of database?
NoSQL database
Spreadsheet database
Object-oriented database
Relational database
7
Which of the following is an example of a database management system (DBMS)?
Google Chrome
Microsoft Word
Adobe Photoshop
MySQL
8
What does the SQL command “JOIN” do?
Combines rows from two or more tables based on a related column
Encrypts database data
Creates a new table
Deletes a record
9
What is a database administrator (DBA) responsible for?
Designing websites
Creating PowerPoint presentations
Managing and maintaining the database system
Writing front-end applications
10
What does the SQL command “DELETE” do?
Creates a new table
Removes specific rows from a table
Modifies existing records
Removes a table completely
11
What is database?
A programming language
A type of software for editing images
A type of operating system
A structured collection of data
12
What is a query in a database?
A request to retrieve or manipulate data
A database backup process
A type of programming language
A type of encryption method
13
What does ACID stand for in database transactions?
Atomicity, Consistency, Isolation, Durability
Algorithm, Calculation, Indexing, Data
Accessibility, Control, Integration, Design
Accuracy, Consistency, Integrity, Durability
14
What is the primary key in a database table?
A type of foreign key
A key used to encrypt data
A column that contain duplicate values
A unique identifier for each record
15
Which type of database model organizes data into tables?
NoSQL
Relation
Network
Hierarchical
16
Which SQL command is used to retrieve data from a database?
DELETE
SELECT
INSERT
UPDATE
17
What is normalization in databases?
The process of making data inconsistent
A type of data encryption
The process of organizing data to reduce redundancy
The process of deleting unnecessary tables
18
Which SQL clause is used to filter the results of a query?
ORDER BY
GROUP BY
SELECT
WHERE
19
What is a transaction in a database?
A method of indexing data
A sequence of database operations treated as a single unit
A process of buying and selling data
A type of database backup
20
What does SQL stand for?
Structural Question Language
Simple Query List
System Query Logic
Structural Query Language

Base de datos etapa 1 Flashcards | StudBud