Correct Answer: SHOW DATABASES LIKE 'DBname';
Explanation:
Note: This Question is unanswered, help us to find answer for this one
MySQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More MySQL MCQ Questions
Best way to update multiple rows? Example: Name id Col1 Col2 name1 1 6 1 name2 2 2 3 name3 3 9 5 name4 4 16 8 Update Col1= 1 where id = 1 Update Col1= 2 where id = 2 Update Col2= 3 where id = 3 Update Col1= 10 and col2= 12 where id = 4
Correct syntax for selecting all rows from a table 'PERSONS', with strings in the column 'LASTNAME' starting with 'JOH'?
Which will restore a MySQL DB from a .dump file?
Correct syntax to restore a database from command line?
Correct syntax to call a stored routine country_hos with a parameter of type VARCHAR is
Which is not a valid Comparison operator?
Which statement is true regarding character sets in MySQL?
Examine the data in the employees table given below: last_name department_id salary ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries will execute well?
Transactions and commit/rollback are supported by MySQL using the MyISAM engine
ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock colum