Which language is used to request information from a Database?

(a)

Relational

(b)

Structural

(c)

Query

(d)

Compiler

_____ 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

Which of the following is a not a database? 

(a)

Oracle

(b)

PostgreSQL

(c)

SQLite

(d)

None of these

Which of the following are the limitations of system

(a)

Data Duplication

(b)

High Maintenance

(c)

Security

(d)

All of the above

Which of the following is a commercial relational models in use

(a)

Oracle

(b)

DB2

(c)

Postgre SQL

(d)

Both a and b

________ is known a predecessor of database system

A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: material/details.php

Line Number: 1002

()

File system

__________ who takes care of configuration, installation, performance, security and data backup.

A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: material/details.php

Line Number: 1002

()

Database Administrators

_____________ is a web application written in PHP

A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: material/details.php

Line Number: 1002

()

PHPMYADMIN

________ is a database tool used by developers and DBA's mainly for visualization

A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: material/details.php

Line Number: 1002

()

MySQL Work bench

___________ is a program or process of copying table contents into a file for future reference

A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: material/details.php

Line Number: 1002

()

Backup

An attribute is the information about that ____________

A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: material/details.php

Line Number: 1002

()

Entity

Hierarchical Database

(1)

Sybase

Column

(2)

Multivalued Attribute

Primary key

(3)

Attribute

Double Ellipse

(4)

IMS

Database

(5)

Unique Key Identifier

Define Data Model and list the types of data model used.

Define Single and Multi valued attributes.

What is view in SQL?

Write the difference between SQL and MySQL

State few advantages of Relational databases.

Explain on Evolution of DBMS.

What is relationship in databases? List its types.

List any 5 privileges available in MySQL for the User.

What are the major parts to form a database

List the basic concepts of ER Model with suitable example

Discuss in detail on various types of attributes in DBMS.