QUESTION 3

A central concept of his RDBMS theory is that all data is stored in rows of tables and each row is identified by _______________(s).

QUESTION 4

In the MySQL architecture, the MySQL Shell is a

	a	Server
	b	Client
	c	Neither
	d	Both

QUESTION 5

The SQL keyword used to specify the database to work with is

a		CHOOSE
b		USE
c		SELECT
d		DATABASE

QUESTION 6

The SQL command most typically used to query data from a table is

a		QUERY
b		READ
c		DUMP
d		SELECT

QUESTION 7

In a VirtualBox virtual machine (VM) which of these could be used for virtual storage? (i.e configured through Settings->Storage in the VirtualBox control panel)

		Both
		Neither
		A .vdi hard disk image
		An ISO image of a CD or DVD

QUESTION 8

in an Entity-Relationship diagram, a rectangle with a solid outline is:

a		A Weak Entity
b		A Relationship
c		An Attribute
d		An Entity

QUESTION 9

Which of these is a multi-byte characater set?

A		latin1
B		UTF-8
C		ASCII
D		hp8

QUESTION 17

In a production database, Schema are likely to change more frequently than instances.

True

False

QUESTION 18

All SQL statements must end with what character?

A		New-line
B		Period (.)
C		Semi-colon (;)
D		Colon (:)

QUESTION 19

Which of these SQL data items (type and value) requires the most storage space in the system?

A		CHAR(100) "hi"
B		CHAR(20) "hello"
C		VARCHAR(30) "hello world"
D		VARCHAR(200) "hello"

QUESTION 20

Which SQL data type would be most likely used to store a student's birth date?

A		TIMESTAMP
B		DATE
C		YEAR
D		DATETIME

QUESTION 13 5 points Saved In this ERD notation style, what is the minimum number of orders that a customer must have Address Name E-mail Customer Orders O One O Zero O More than one O Seven