Mysql set 1

MySQL is freely available and is open source.

• True
• False
• Not sure
• Private

What represents a tuple in relational database?

• Table
• Row
• Column
• Object

How is communication established with MySQL?

• SQL
• Network calls
• A programming language like C++
• APIs`

The MySQL server used in its client/server architecture is _______________

• a) mysqla
• b) mysqlb
• c) mysqlc
• d) mysqld

Which of the following clauses is used to display information that match a givenpattern?

• LIKE
• WHERE
• IS
• SAME

What column names are displayed when this SQL command is executed? SHOW COLUMNS FROM tbl_name LIKE ‘%name’;

• suffixed with ‘name’
• prefixed with ‘name
• suffixed with ‘%name’
• prefixed with ‘%name’

The special database that always exists after setting up MySQL in a computer is__________

• sampdb
• mysql
• information_schema
• readme_db

In the following SQL code, InnoDB is __________ CREATE TABLE student ( name CHAR(30), student_id INT, PRIMARY KEY(student_id)) ENGINE = InnoDB;

• database name
• table name
• reference engine
• storage engine

Identify the table name in the following SQL statement. INSERT INTO student VALUES(‘Kyle’,’M’,NULL);

• Student
• b) Values
• c) Kyle
• d) M

What is 'xyz' in the following statement select abc from xyz

• row name
• b) column name
• c) table name
• d) database name