UTS Basis Data II - ITM

What is a MySQL view?

• A MySQL view is a physical table in the database.

• A MySQL view is a virtual table based on the result of a query.

• A MySQL view is a stored procedure in the database.

• A MySQL view is a backup of a table in the database.

How do you create a MySQL view?

• CREATE VIEW AS SELECT statement

• CREATE VIEW view_name AS SELECT statement

• CREATE VIEW view_name SELECT statement

• CREATE VIEW view_name FROM table_name

What are the advantages of using MySQL views?

• Using MySQL views decreases performance

• MySQL views have no advantages

• MySQL views can only be used for simple queries

• The advantages of using MySQL views are: simplifying complex queries, data security, data abstraction, improved performance, and code reusability.

What is a MySQL transaction?

• A MySQL transaction is a type of database table.

• A MySQL transaction is a way to store data in memory.

• A MySQL transaction is a function that performs calculations on data.

• A MySQL transaction is a sequence of SQL statements that are treated as a single unit of work.

How do you start a MySQL transaction?

What is table lock in MySQL?

• A table lock in MySQL is a lock placed on a column to prevent other transactions from modifying or accessing the column while the lock is held.

• A table lock in MySQL is a lock placed on a database to prevent other transactions from modifying or accessing the database while the lock is held.

• A table lock in MySQL is a lock placed on a table to prevent other transactions from modifying or accessing the table while the lock is held.

• A table lock in MySQL is a lock placed on a table to allow other transactions to modify or access the table while the lock is held.

How do you lock a table in MySQL?

• LOCK TABLES table_name [READ | WRITE];

• LOCK table_name;

• LOCK TABLES table_name;

• LOCK TABLE table_name;

What is a MySQL index?

• A MySQL index is a data structure that improves the speed of data retrieval operations on a database table.

• A MySQL index is a data structure that is used for data encryption in a database table.

• A MySQL index is a data structure that stores data in a separate table.

• A MySQL index is a data structure that slows down data retrieval operations on a database table.

How do you create an index in MySQL?

• CREATE INDEX index_name ON table_name (column1, column2, column3)

• CREATE INDEX index_name ON table_name (column1, column2)

• CREATE INDEX index_name ON table_name (column1)

• CREATE INDEX index_name ON table_name (column1, column2, column3, column4)

What is a fulltext index in MySQL?

• A fulltext index in MySQL is an index that allows for efficient searching of numeric data in a table.

• A fulltext index in MySQL is an index that allows for efficient sorting of text-based data in a table.

• A fulltext index in MySQL is an index that allows for efficient searching of text-based data in a table.

• A fulltext index in MySQL is an index that allows for efficient filtering of text-based data in a table.