Explain Access Control Lists.
What are the nonstandard string types?
Following are Non-Standard string types:
What are the objects can be created using CREATE statement?
Following objects are created using CREATE statement:
Which command is used to view the content of the table in MySQL?
How to display top 50 rows?
What is the usage of regular expressions in MySQL?
In MySQL, regular expressions are used in queries for searching a pattern in a string.
Example:
The following statement retrieves all rows where column employee_name contains the text 1000 (example salary):
How do you determine the location of MySQL data directory?
How to enter Characters as HEX Numbers?
How MySQL Optimizes DISTINCT?
DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause.
What is MySQL data directory?
What is InnoDB?
What is the use of mysql_close()?
What is ISAM?
How can we run batch mode in mysql?
Following commands are used to run in batch mode:
What are the advantages of MyISAM over InnoDB?
What is the difference between mysql_fetch_array and mysql_fetch_object?
Following are the differences between mysql_fetch_array and mysql_fetch_object:
mysql_fetch_array() -Returns a result row as an associated array or a regular array from database.
mysql_fetch_object – Returns a result row as object from database.
How is MyISAM table stored?
MyISAM table is stored on disk in three formats.
Is Mysql query is case sensitive?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
What is the basic MySQL architecture?
How can we get the number of rows affected by query?
Write a query to count the number of rows of a table in MySQL.
What is the difference between BLOB and TEXT?
What are the column comparisons operators?
How do you backup a database in MySQl?
How can one restart SQL Server in single user or minimal configuration modes?
How can we convert between Unix & MySQL timestamps?
What is SQLyog?
What is meant by transaction and ACID properties?
What do you mean by % and _ in the LIKE statement?