Multiple Choice Questions -SQL

Regional district management system

Relational database management system

Regular database management system

Regular district machine system

Structured Query Language

Simple Query Language

Simple Query Limit

Structured Query Limit

Domain & Attribute

Attribute & Domain

Tuple & Attribute

Attribute & Tuple

Degree 5, Cardinality 45

Degree 45, Cardinality 5

Degree 50, Cardinality 45

Degree 50, Cardinality 2250

Foreign key

Super Key

Primary Key

All of these

Alternate key

Foreign key

Primary key

Super Key

MySQL Server Instance

MySQL Database

MySQL Query Optimizer

(a) & (b) both

DDL

DML

TCL

(a) & (b) both

Creating database

Undoing changes to the database.

Modification of data stored in the database.

All of the above

Retrieval of data stored in the database

Insertion of data in to the database

Deletion of data from the database

Making changes permanent to the database.

Int

Float

Blob

Double

DD/MM/YYYY

YYYY/MM/DD

MM-DD-YYYY

YYYY-MM-DD

Open <databasename>;

USE <databasename>;

Access <databasename>;

(a) & (b) both

Create table emp add(id integer(3));

Create table emp (id integers(3));

Create table emp modified (id integer(3));

Create table emp (id integer(3));

INSERT ROW (1,‟ RAM SINGH‟) INTO STORE;

INSERT VALUES (1,‟ RAM SINGH‟) INTO STORE;

INSERT INTO (1,‟ RAM SINGH‟) STORE;

INSERT INTO STORE VALUES (1,‟ RAM SINGH‟);

Where

Having

Group By

Order by

All

Unique

Distinct

IN

In

Like

Between

IS

IN

Like

Between

IS

SELECT * FROM EMP WHERE EMPNO LIKE (1,2,3,4);

SELECT * FROM EMP WHERE SAL BETWEEN 3000 TO 15000;

SELECT * FROM EMP WHERE COMM IS NOT NULL;

All of the above

ALTER TABLE EMPLOYEE MODIFY (last_name CHAR2(2000));

ALTER TABLE EMPLOYEE CHANGE (last_name CHAR2(2000));

ALTER TABLE EMPLOYEE CHANGE (last_name VARCHAR2 (2000));

ALTER TABLE EMPLOYEE MODIFY (last_name VARCHAR2 (2000));

By Select we can retrieve all the rows from table.

By where clause with select we can retrieve selected rows from table.

We can retrieve unique rows from table with the use of Distinct key word.

All of the above.

Group by clause

Having clause

Order by Clause

Where Clause

All

Distinct

Unique

Diverse

A Programming language

A Processing language

A technique for writing reliable programs

A Relational Database Management System