Practice Test 2 Flashcards

1
Q

Process of denormalization

A

Merging tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

MySQL Enterprise

A

High end commercial installations, like backup and security

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

LOWER()

A

Function used to convert a string to lowercase

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

One of the primary functions of a DBMS

A

Managing database security and access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

GROUP BY function

A

Aggregates/query’s rows based on a common criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Main advantage of a sorted table

A

Optimal for queries that read data in sort order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

CONCAT()

A

Function that combines two or more strings into a single one

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

JOIN

A

Function that combines rows from two tables based on related columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Composite attribute

A

An attribute that can be divided into smaller parts, turning into a more basic attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How are weak entites represented in a ER diagram

A

Double rectangle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Storage engine

A

Manages the physical storage of data (read, write, indexing, data integrity). Works with the query processor to read or write as needed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

query optimizer

A

Determines the most efficient way to execute an SQL query. works with the query processor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Query Processor

A

responsible for parsing, translating, optimizing, and executing SQL queries from multiple connections (users). Works closely with the optimizer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Connection manager

A

Manages the connections between the database and client applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Hash table

A

structure that provides an efficient way to store and retrieve data using key-value pairs. Uses a function and key to determine the bucket in each row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

CURDATE()

A

Function that returns the current date but not time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

TIMESTAMP()

A

Returns current date and time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Delete

A

removes rows from a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Table Cluster

A

database storage technique where multiple tables that share common columns are stored together in the same physical data blocks. Can improve performance and reduce disk space but can increase complexity and DB maintence and performs poorly for joins with non-cluster key columns

20
Q

NoSQL

A

Designed to handle large volumes of unstructured or semi-structured data.

pro: fast read and write, scaling, diverse data type

con: consistency and complexity

21
Q

MySQL has how many architecture layers?

22
Q

IN function

A

Checks if a value matches a value from a list

23
Q

Cardinality

A

Max or min number of entities that can be involved in a relationship

24
Q

2NF

A

Non-key attributes must be fully dependent on the primary key, it cannot depend on only 1 part of the composite key for example.

25
Q

3N

A

non key attributes shouldnt depend on any other non key attributes. All non key attributes should depend on the entire primary key and nothing but the key

26
Q

Boyce-Codd

A

like 3N but requires super keys

27
Q

Insert()

A

Adds a new row of data to a table

28
Q

MySQL monitor enterprise

A

Collects and displays performance info

29
Q

SQRT()

A

Function to calculate the square root of a number

30
Q

After Indexing a column when would that index get updated next?

A

After deleting a row the index would be updated

31
Q

The person that introduced the relational model

32
Q

MySQL Enterprise Audit component

A

Tracks all database chances including time and user details

33
Q

Heap Table

A

Table that isnt clustered indexed. No order to rows. Data is stored in the order its inserted. Tracks free space as a linked list for future inserts

34
Q

ON function

A

Specifies the condition for the join between two tables

35
Q

Database

A

Structured collection of data

36
Q

Column-oriented storage

A

Data is stored in columns rather than rows. best for analytical queries that involve large scale processing of datasets. Not good for transactions

37
Q

Row oriented storage

A

Stores data in rows. Best used for data sets that will required constant updates, inserts, deletes. Good for transactional applications

38
Q

Associative entity (Bridge entity, junction table)

A

Used to represent a many to many relationship with attributes. table that links two or more tables

39
Q

Set of tuples

A

could be a group of columns or rows. something that a select statement would return

40
Q

Intersection data

A

data that describes the relationship between two entities

41
Q

Scope, Format, and Access

A

All parts of data characteristics of a DB

42
Q

CRUD

A

Create, Read, Update, Delete

43
Q

MySQL Workbench

A

Designed for both admins and users, its a data toolset for modeling, SQL development, and data administration

43
Q

Crows Foot

A

Symbol the reps a one to many relationship in ER diagrams

44
Q

LIKE

A

Search for specified patterns in a column

45
Q

Database Admin

A

Designs the physical layout of data

Secures the database against unauthorized access

Monitors the database performance and makes adjustments to optimize it

46
Q

COUNT()

A

Returns the number of rows that match a specified condition