MYSQL_CLASS XI

Which type of database management system is MySQL?

• Object-oriented

• Hierarchical

• Relational

• Network

What is data in a MySQL database organized into?

• Objects

• Tables

• Networks

• File systems

MySQL is freely available and is open source.

• True

• False

What represents an ‘attribute’ in a relational database?

• Table

• Row

• Column

• Object

What represents a ‘tuple’ in a relational database?

• Table

• Row

• Column

• Object

What does ‘name’ represent in the following SQL code?

CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );

• A table

• A row

• A column

• An object

In MySQL databases, the structure representing the organizational views of the entire databases is ____________

• Schema

• View

• Instance

• Table

The general term for information about databases and the objects in MySQL is _________

• datum

• info

• record

• metadata

In which language MYSQL is written?

• 1. PYTHON

• 1. C/C+

• 1. JAVA

• 1. COBOL

To see the list of options provided by MYSQL which of the following command is used?

• 1. HELP

• 1. –HELP

• 1. -- HELP

• 1. ELP-