Section 1

Question 1

What is a Database Application

Answer 1

Is a software that helps business users interact with database systems

Question 2

Database Administrator

Answer 2

Is responsible for securing the database system against unauthorized users. A —- enforces procedures for user access and database system availability.

Question 3

Authorization

Answer 3

Many database users should have limited access to specific tables, columns, or rows of a database. database systems authorize individual users to access specific data.

Question 4

Rules

Answer 4

Database systems ensure data is consistent with structural and business rules.

Question 5

Query processor, query optimization

Answer 5

Interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application. The query processor performs —– to ensure the most efficient instructions are executed on the data.

Question 6

Storage manager, indexes

Answer 6

Translates the query processor instructions into low-level file-system commands that modify or retrieve data. Database sizes range from megabytes to many terabytes, so the —– uses —- to quickly locate data

Question 7

Transaction manager

Answer 7

Ensures transactions are properly executed. The —- prevents conflicts between concurrent transactions. The —– also restores the database to a consistent state in the event of a transaction or system failure.

Question 8

Metadata

Answer 8

Is data about the database, such as column names and the number of rows in each table

Question 9

Relational database

Answer 9

Stores data in tables, columns, and rows, similar to a spreadsheet.
All —– support the SQL query language.

Question 10

Relational databases are

Answer 10

They are ideal for databases that require an accurate record of every transaction, such as banking, airline reservation systems, and student records.

Question 11

MongoDB

Answer 11

Sponsored by: MongoDB,
Type: NoSQL,
License: Open source,
DB-Engines rank: 5

Question 12

INSERT

Answer 12

Inserts rows into a table

Question 13

SELECT

Answer 13

Retrieves data from a table

Question 14

UPDATE

Answer 14

Modifies data in a table

Question 15

DELETE

Answer 15

Deletes rows from a table

Question 16

The SQL CREATE TABLE statement…

Answer 16

Creates a new table by specifying the table and column names. Each column name is assigned a DATA TYPE that indicates the format of column values.

Question 17

Data Types

Answer 17

Can be numeric, textual or complex.

Question 18

INT

Answer 18

Stores integer values

Question 19

DECIMAL

Answer 19

Stores fractional numeric values

Question 20

VARCHAR

Answer 20

Stores textual values

Question 21

DATE

Answer 21

Stores year, month, and day

Question 22

For large, complex databases, the process has three phases:

Answer 22

1. Analysis
2. Logical design
3. Physical design

Question 23

Analysis phase..

Answer 23

Specifies database requirements without regard to a specific database system.
Requirements are represented as entities, relationships, and attributes.
An entity is a person, place, activity, or thing. A relationship is a link between entities, and an attribute is a descriptive property of an entity.

Question 24

Analysis

Answer 24

Has many alternative names, such as conceptual design, entity-relationship modeling, and requirements definition

Question 25

What do rectangles represent in an ER diagram? Where does the name appear?

Answer 25

Rectangles represent entities. Entity names appear at the top of rectangles.

Question 26

Logical design

Answer 26

The logical design phase implements database requirements in a specific database system. For relational database systems, logical design converts entities, relationships, and attributes into tables, keys, and columns.

Question 27

Physical design

Answer 27

The physical design phase adds indexes and specifies how tables are organized on storage media.
Physical design affects query processing speed but never affects the query result.

Question 28

Data independence

Answer 28

Is the principal that physical design never affects query results.

Question 29

API or Application programming interface

Answer 29

These are used to simplify the use of SQL with general-purpose language.

It is a library or procedures or classes that links a host programming language to a database.

Question 30

MySQL Command-Line client

Answer 30

Is a text interface included in the MySQL Server download

Question 31

When does MySQL return an error code?

Answer 31

MySQL Server returns an error code and description when a SQL statement is syntactically incorrect or the database cannot execute the statement.