DATABASE

Question 1

Raw Facts

Answer 1

Data

Question 2

Result of processing raw data to reveal meaning

Answer 2

Information

Question 3

Must be formatted for storage, processing, and presentation.

Answer 3

Raw Data

Question 4

Are the foundation of information, which is the bedrock of knowledge.

Answer 4

Data

Question 5

Shares, integrated computer structure that stores a collection of end user data and metadata.

Answer 5

Database

Question 6

Raw facts of interest to end user.

Answer 6

End-user data

Question 7

Data about data.

It provides description of data characteristics and relationships in data.

Complements and expands value of data.

Answer 7

Metadata

Question 8

What does DBMS stands for?

Answer 8

Database Management System

Question 9

It lets you create a database.
‘Add, change, delete, sort, and view the data in a database.

Answer 9

DBMS

Question 10

When and where did DBMS created?

Answer 10

1990’s Sweden

Question 11

Software whose source code is freely and publicly available.

Answer 11

Open source software

Question 12

Is a free and open-source cross-platform web server solution package developed by Apache Friends.

Answer 12

XAMPP

Question 13

XAMPP stands for

Answer 13

X-operating system, Apache, Mysql, Php, Perl

Question 14

Consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages.

Answer 14

XAMPP

Question 15

View data logically rather than physically

Answer 15

Relational model

Question 16

Structural and data independence

Resembles a file conceptually

Answer 16

Table

Question 17

Is easier to understand than hierarchical and network models

Answer 17

Relational database model

Question 18

Perceived as a two-dimensional structure composed of rows and columns

Answer 18

Table

Question 19

Represents a single entity occurrence within the entity set.

Answer 19

Table row

Question 20

Represents an attribute, and each column has a distinct name.

Answer 20

Table column

Question 21

TRUE or FALSE

Each intersection of a row and column represents a single data value.

Answer 21

TRUE

Question 22

TRUE or FALSE

All values in a column must conform to the same data format.

Answer 22

TRUE

Question 23

Each column has a specific range of values known as the

Answer 23

Attribute Domain

Question 24

TRUE or FALSE

The order of the rows and columns is important to the DBMS.

Answer 24

FALSE

The order of the rows and columns is immaterial to the DBMS.

Question 25

TRUE or FALSE Each table must have an attribute or combination of attributes that uniquely identifies each row.

Answer 25

TRUE

Question 26

Provides detailed accounting of all tables found within the user/designer-created database Contains (at least) all the attribute names and characteristics for each table in the system Contains metadata: data about data

Answer 26

Data dictionary

Question 27

Contains metadata Detailed system data dictionary that describes all objects within the database

Answer 27

System catalog

Question 28

process of determining the particular tables and columns that will comprise a database.

Answer 28

Database Design

Question 29

(like a noun): person, place, thing or event

Answer 29

Entity

Question 30

(like an adjective or adverb): property of an entity

Answer 30

Attribute

Question 31

association between entities

Answer 31

Relationship

Question 32

Relational modeling ideal Should be the norm in any relational database design

Answer 32

1:M relationship

Question 33

Should be rare in any relational database design

Answer 33

1:1 relationship

Question 34

Cannot be implemented as such in the relational model can be changed into 1:M relationships

Answer 34

M:N relationships

Question 35

Popular and widely used language for retrieving and manipulating database data

Answer 35

Structured Query Language (SQL)

Question 36

When did SEQUEL renamed?

Answer 36

1980

Question 37

Used by most DBMSs

Answer 37

Structured Query Language (SQL)

Question 38

When did sql developed

Answer 38

mid-1970s

Question 39

question represented in a way that the DBMS can understand

Answer 39

Query

Question 40

TRUE or FALSE There is a special formatting rules in SQL

Answer 40

FALSE No special formatting rules

Question 41

Use this command to retrieve specified columns and all rows; e.g., list the number, name and balance of all customers

Answer 41

SELECT

Question 42

It indicate all columns in the SELECT clause

Answer 42

asterisk (*)

Question 43

Used to retrieve rows that satisfy some condition

Answer 43

WHERE clause

Question 44

column name, comparison operator followed by either a column name or a value

Answer 44

Simple condition

Question 45

Connects two or more simple conditions with AND, OR, and NOT operators

Answer 45

Compound condition

Question 46

all simple conditions are true

Answer 46

AND operator

Question 47

any simple condition is true

Answer 47

OR operator

Question 48

Reverses the truth of the original condition

Answer 48

NOT operator

Question 49

Use instead of AND operator Use when searching a range of values Makes SELECT commands simpler to construct

Answer 49

BETWEEN Operator

Question 50

Does not exist in the database but is computed using data in existing columns

Answer 50

Computed column

Question 51

Used for pattern matching

Answer 51

LIKE Operator

Question 52

Represents any single character

Answer 52

Underscore (_)

Question 53

TRUE or FALSE By default, no defined order in which results are displayed

Answer 53

TRUE

Question 54

list data in a specific order

Answer 54

ORDER BY clause

Question 55

column on which data is to be sorted

Answer 55

Sort key or key

Question 56

Is default sort order

Answer 56

Ascending

Question 57

For descending order sort, use ___________

Answer 57

DESC

Question 58

Used to calculate totals of columns

Answer 58

SUM Function

Question 59

Eliminates duplicate values Used with COUNT function

Answer 59

DISTINCT Operator

Question 60

an inner query placed inside another query

Answer 60

Subquery

Question 61

uses subquery results

Answer 61

Outer query

Question 62

creates groups of rows that share common characteristics

Answer 62

Grouping

Question 63

What is the difference between HAVING and WHERE.

Answer 63

WHERE: limit rows HAVING: limit groups Can use together if condition involves both rows and groups