_____ 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

Which is the MySQL instance responsible for data processing?

(a)

MySQL Client

(b)

MySQL Server

(c)

SQL

(d)

Server Daemon Program

Which of the following are the limitations of system

(a)

Data Duplication

(b)

High Maintenance

(c)

Security

(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

Define Single and Multi valued attributes.

What is view in SQL?

What are the various methods to access file system?

What do you mean by table in Relational database model?

What is XAMPP?

List any 5 privileges available in MySQL for the User.

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

List few commonly used databases.

What are the major parts to form a database

Write a short note on Row (or Record or tuple)

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