Which language is used to request information from a Database?

(a)

Relational

(b)

Structural

(c)

Query

(d)

Compiler

An entity set that does not have enough attributes to form primary key is known as

(a)

Strong entity set

(b)

Weak entity set

(c)

Identity set

(d)

Owner set

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 is a commercial relational models in use

(a)

Oracle

(b)

DB2

(c)

Postgre SQL

(d)

Both a and b

A key With more than one attribute to identify rows uniquely in a table is called ___________

(a)

Candidate Key

(b)

Super Key

(c)

Foreign Key

(d)

Composite Key

_________ are the values for the entity

(a)

Data

(b)

Entity

(c)

Instance

(d)

Relationship

___________ can be subdivided into simple attributes without change in the meaning of that attribute

(a)

Key Attribute

(b)

Simple Attributes

(c)

Composite Attributes

(d)

Single Valued Attribute

The ________ cannot be separated it will be having a single value for their entity.

(a)

Key Attribute

(b)

Simple Attributes

(c)

Composite Attributes

(d)

Single Valued Attribute