|
Explain how can you start and shutdown MySQL server - Set the mysql directory and type: ./bin/mysqld_safe &......
|
|
Tools that are available for managing MySQL Server - mysqld - MySQL server daemon. It is used to start the mysql server.....
|
|
Purpose of mysql command-line interface - Mysql or mysql monitor is a Command line interface used to manage mysql’s data objects like databases, tables etc..
|
|
What is mysqld? - Mysqld is a daemon server program typically used to start and stop mysql server. It runs in the background......
|
|
Explain the concept of mysqlcheck command-line interface - Mysqlcheck is used for Admin’s to check and repair the mysql tables......
|
|
What is mysqladmin? - Mysqlcheck is used to perform administrative tasks.......
|
|
Purpose of mysqldump command-line interface - Mysqldump is used by administrators or end users to export data from the server to files.......
|
|
What is mysqlshow? - Mysqlshow is typically used by end users to see information on tables and columns......
|
|
mysqlimport – It is used by administrators or end users to load data files into tables program tool to load data into tables.
|
|
Explain the mysql command Line options - Following are the most commonly used mysql command line options......
|
|
Explain few command line arguments in MYSQL - -D – specifies database to use, -h, --host=name - connects to host......
|
|
Explain some of the non-standard SQL commands in MySQL - There are many non-standard SQL commands that are supported by mysql. Here is short list of some commonly used commands.......
|
|
Differentiate between BINARY and VARBINARY in MySQL - BINARY and VARBINARY have the same nature of differences like CHAR and VARCHAR......
|
|
Differentiate between CHAR and VARCHAR in MySQL - CHAR stores the data or values in fixed length format. If the size of the string is smaller than the specified length.......
|
|
Differentiate between CHAR and NCHAR - CHAR is commonly referred to as character while NCHAR is referred to as NATIONAL CHARACTER......
|
|
What are date and time data types supported in MySQL? - MySQL supports the following date and time data types......
|
|
IN Conditions and LIKE Conditions in MySQL - IN condition is used to match specified values in a query......
|
|
Regular expression pattern condition: REGEXP in MySQL - REGEXP is used to match a string against a specified pattern. There are different operators used to match patterns......
|
|
Explain CASE Expression in MySQL with syntax - CASE statement is a conditional expression. It is used to execute specific statements when some search condition evaluates to TRUE......
|
|
TIMESTAMP data type in MySQL - A TIMESTAMP data type allows you to record a date and time like DATETIME data.....
|
|
What is a User Account and Predefined User Accounts in MySQL? - A user account in MySQL is assigned a username and password to access MySQL databases......
|
|
Explain how to add a new user account in MySQL - New users in MySQL can be added using the CREATE USER.....
|
|
How to change the password for user account in MySQL - Password in MySQL can be changed using SET PASSWORD command.......
|
|
What are user privileges in MySQL? - Privileges in MySQL are used to restrict users accessing data objects and functions. Below are the commonly used......
|
|
What are the scope levels a user privilege can be granted? - Global Level – This privilege applies to ALL databases present. Privileges granted at the global level stored in mysql.user table......
|
|
Explain how to view and Revoke user privileges in MySQL - Privileges assigned to users can be viewed using the SHOW GRANTS USER_NAME command......
|
|
Explain the command line options offered by mysqld - --help - Displays a short help message on how to use mysqld, --verbose --help - Displays a long help messages on how to use mysqld.....
|
|
What is Binary Log File in MySQL? - The binary log file contains information about statements that could have modified the data and how long it took to modify the data.....
|
|
Explain how to run MySQL Server on a different Port - By default, MySQL will listen at port number 3306 for any client connections......
|
|
MySQL API offers a number of functions- mysql_connect -- Open a connection to a MySQL Server, mysql_get_client_info -- Get MySQL client info......
|
|
Explain how to close MySQL connection objects - MySQL connection objects created with mysql_connect() calls can be closed by calling mysql_close($con) function......
|
|
Explain how to handle MySQL statement execution errors - When a MySQL statement is executed using mysql_query(), a FALSE Boolean value is returned if any error occurred......
|
|
What are storage engines? Explain storage engines supported - Storage engines are used to manage the database of the MySQL.......
|
|
Explain how to create a new table using MyISAM storage engine - MyISAM Is based on Indexed Sequential Access Method is the default storage engine......
|
|
Explain how to create a new table using InnoDB Storage Engine - InnoDB storage engine is transaction safe and developed by Oracle.....
|
|
Explain how to create a new table using BDB Storage Engine - BDB (BerkeleyDB) storage engine is transaction safe and developed by Oracle......
|
|
Explain how to create a new table using CSV Storage Engine - CSV (Comma-Separated Values) storage engine stores table data in text files in comma-separated value format......
|
|
What are the system tables that store user privileges? - mysql.user - Stores privileges granted at the global level, mysql.db - Stores privileges granted at the database level.....
|
