The _____ diagram gives a logical structure of the database graphically?

(a)

Entity-Relationship

(b)

Entity

(c)

Architectural Representation

(d)

Database

_____ represents a “tuple” in a relational database?

(a)

Table

(b)

Row

(c)

Column

(d)

Object

Which is the MySQL instance responsible for data processing?

(a)

MySQL Client

(b)

MySQL Server

(c)

SQL

(d)

Server Daemon Program

DBMS provides to ___________ data

(a)

create

(b)

retrieve

(c)

update

(d)

all of the above

___________ is defined as the system's ability to recover all committed transactions during the failure of storage or the system

(a)

Durability

(b)

Consistency

(c)

Concurrency

(d)

All of the above

A _________ is a "copy" of a primary key

(a)

Candidate Key

(b)

Super Key

(c)

Foreign Key

(d)

Composite Key

An _________ can be anything a real-world object

(a)

Data

(b)

Entity

(c)

Instance

(d)

Relationship

_____________ describes a unique characteristic of an entity

(a)

Key Attribute

(b)

Simple Attributes

(c)

Composite Attributes

(d)

Single Valued Attribute

A __________ contains only one value for the attribute and they don't have multiple numbers of values.

(a)

Key Attribute

(b)

Simple Attributes

(c)

Composite Attributes

(d)

Single Valued Attribute

A _____ has more than one value for that particular attribute

(a)

Multi valued attribute

(b)

Simple Attributes

(c)

Composite Attributes

(d)

Single Valued Attribute