Posts

Showing posts from February, 2022

MY SQL Linkedin Answers

Image
  Q1. When you have a subquery inside of the main query, which query is executed first?  The subquery is never executed. Only the main query is executed.  They are executed at the same time  the main query  the subquery Q2. You need to export the entire database, including the database objects, in addition to the data. Which command-line tool do you use?  mysqlexport  mysqladmin  mysqldump  mysqld Q3. You must ensure the accuracy and reliability of the data in your database. You assign some constraints to limit the type of data that can go into a table. What type of constraints are you assigning?  row level  database level  column level  function level Q4. Which option of most MySQL command-line programs can be used to get a description of the program's different options?  --options  ?  --help  -h Q5. MySQL uses environment variables in some of the programs and command-line operations. Which variable is...