MySQL

The “father” of MySQL is ______.

• Michael Widenius

• Stephanie Wall

• Bill Joy

Which of the following statement is true?

• A table can contain multiple primary keys and single foreign key

• A table can contain single primary key and multiple foreign keys

• A table can contain multiple primary keys and multiple foreign keys

Full form of DML is

• Data Modification language

• Data Manipulation Language

• Database Manipulation Language

• Database Modification Language

Which of the following is not a feature of MySQL?

• Password protected

• Not open source software

• Runs very fast

• Supports many data types

The structure or the design of a database is

• Database Schema

• Metadata

• Database constraints

• RDBMS

The term ___________ is used to refer a column.

• Row

• Record

• Tuple

• Attribute

Identify the term which is not related to field in RDMS software.

• Column

• Attribute

• Degree

• Cardinality

Attribute that can uniquely identify a tuple in a relation.

• Alternate key

• Primary key

• Foreign Key

The maximum length of char data type is

• 65535 bytes

• 255 bytes

• 256 bytes

Which type of database management system is MySQL?

• Object-oriented

• Hierarchical

• Relational

• Network