_____ represents a “tuple” in a relational database?

(a)

Table

(b)

Row

(c)

Column

(d)

Object

Communication is established with MySQL using

(a)

SQL

(b)

Network calls

(c)

Java

(d)

API’s

The structure representing the organizational view of entire database is known as ______ in MySQL database.

(a)

Schema

(b)

View

(c)

Instance

(d)

Table

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

What is view in SQL?

What is Relationship and List its types.

State few advantages of Relational databases.

What is XAMPP?

What is meant by the Designing of databases?

List any 5 privileges available in MySQL for the User.

Write few commands used by DBA to control the entire database.

What are the roles of Database administrator?

What are the major parts to form a database

What are the major the functions performed using SQL?

List the basic concepts of ER Model with suitable example

Explain the DDL command of their functions in SQL.

Explain the following
1. Primary Key
2. Foreign Key
3. Candidate Key
4. Super Key
5. Composite key

Tabulate the ER diagram notations