admin Oct, Wed, 2024 EXAM MYSQL 123456789101112131415161718192021222324252627282930313233343536373839404142434445 Exam Instructions: Total Number of Questions: 45 You will be required to answer a total of 45 multiple-choice questions. Time Limit: 15 minutes for the entire exam Once the time is up, the exam will automatically submit. Passing Criteria: A minimum score of 50% is required to pass the exam Multiple Attempts: You are allowed to take the exam multiple times. Only your highest score will be considered for certification. Additional Instructions: The exam timer cannot be paused once it begins. Good luck, and feel free to retake the exam to improve your score! MYSQL Test your MYSQL skills with a challenging exam designed to evaluate your knowledge in programming, data structures, and algorithms The certificate will be generated based on the information you provide in the form, so please ensure that all details are entered correctly. NameEmailPhone NumberUniversityCollegeDegreeDepartmentPass Out YearPass Out Year2014201520162017201820192020202120222023202420252026202720282029 1 / 45 1) How do you handle NULL values during aggregation in MySQL? A) Deletes records B) Joins multiple tables C) Counts total records D) Ensures accurate calculations 2 / 45 2) How do you get the total number of unique values in a column in MySQL? A) COUNT B) SUM C) COUNT(DISTINCT) D) AVERAGE 3 / 45 3) What does the term “deadlock” refer to in MySQL? A) Joins tables B) Halts transaction processing C) Commits changes D) Deletes records 4 / 45 4) How do you remove all records from a table without deleting the table? A) DROP TABLE B) DELETE TABLE C) TRUNCATE TABLE D) REMOVE ALL 5 / 45 5) How do you grant privileges to a user in MySQL? A) Revokes privileges B) Alters structure C) Grants specific privileges D) Joins tables 6 / 45 6) How do you define a foreign key in MySQL? A) FOREIGN KEY B) UNIQUE KEY C) PRIMARY KEY D) INDEX 7 / 45 7) Which MySQL function is used to return the current date? A) NOW() B) CURDATE() C) CURRENT_DATE D) DATE() 8 / 45 8) Which MySQL command is used to create a database? A) CREATE DATABASE B) MAKE DATABASE C) NEW DATABASE D) ADD DATABASE 9 / 45 9) What does the CONVERT() function do in MySQL? A) Joins tables B) Formats values C) Changes data type D) Counts records 10 / 45 10) What is the purpose of the DROP INDEX statement in MySQL? A) Alters data structure B) Deletes the specified index C) Deletes records D) Joins tables 11 / 45 11) How do you use the UNION operator in MySQL? A) Aggregates data B) Joins multiple tables C) Merges query results into one set D) Sorts records 12 / 45 12) What does the HAVING clause do in MySQL? A) Limits records B) Joins tables C) Filters aggregated results D) Filters rows 13 / 45 13) What is the purpose of the GROUP_CONCAT() function in MySQL? A) Joins tables B) Filters data C) Counts rows D) Concatenates values 14 / 45 14) What is the purpose of the WHERE clause in MySQL? A) Filters records B) Groups results C) Sorts records D) Joins tables 15 / 45 15) How do you export a MySQL database? A) ARCHIVE B) BACKUP C) mysqldump D) EXPORT 16 / 45 16) What is the purpose of the SHOW PROCESSLIST statement in MySQL? A) Deletes records B) Monitors server activity C) Joins tables D) Alters data structure 17 / 45 17) What is the purpose of the CHANGE MASTER TO command in MySQL? A) Deletes records B) Joins tables C) Updates replication settings D) Starts replication 18 / 45 18) How do you optimize a slow query in MySQL? A) Alters data structure B) Deletes records C) Joins tables D) Improves query performance 19 / 45 19) How do you use the SUBSTRING function in MySQL? A) Deletes records B) Joins tables C) Retrieves part of a string D) Alters data structure 20 / 45 20) How do you check if a column is NULL in MySQL? A) EXISTS B) IS NOT NULL C) NOT EXISTS D) IS NULL 21 / 45 21) How do you create an event in MySQL? A) Deletes records B) Automates tasks C) Filters data D) Joins tables 22 / 45 22) What does the UNION ALL operator do in MySQL? A) Sorts results B) Combines all results C) Groups results D) Filters duplicates 23 / 45 23) What does the EXISTS operator do in MySQL? A) Joins tables B) Checks existence C) Counts records D) Filters values 24 / 45 24) How do you find records that match multiple criteria in MySQL? A) Sorts data B) Joins multiple tables C) Applies multiple filters D) Deletes specific records 25 / 45 25) What does the GROUP_CONCAT() function do in MySQL? A) Groups rows B) Sums values C) Concatenates rows D) Averages values 26 / 45 26) What does the term “index scan” refer to in MySQL? A) Scans entire table B) Deletes data C) Joins tables D) Improves query performance 27 / 45 27) What does the TIMESTAMPDIFF() function do in MySQL? A) Counts dates B) Calculates difference C) Joins dates D) Retrieves date 28 / 45 28) What does the CURRENT_DATE() function do in MySQL? A) Counts dates B) Retrieves date C) Returns today's date D) Joins dates 29 / 45 29) How do you create an index in MySQL? A) BUILD INDEX B) ADD INDEX C) CREATE INDEX D) NEW INDEX 30 / 45 30) What is the purpose of the COALESCE function in MySQL? A) Alters data structure B) Joins tables C) Handles null values D) Deletes records 31 / 45 31) What is the purpose of the UNION operator in MySQL? A) Deletes records B) Merges multiple queries C) Joins tables D) Filters data 32 / 45 32) How do you specify the character set for a MySQL column? A) FORMAT B) CHARACTER SET C) DATA TYPE D) COLLATION 33 / 45 33) What is the difference between a primary key and a unique key in MySQL? A) Unique identifier B) Both are mandatory C) Both can be NULL D) Prevents duplicates 34 / 45 34) How do you create a stored function in MySQL? A) Deletes a function B) Returns a single value C) Defines a procedure D) Creates a trigger 35 / 45 35) What is the purpose of the REPLACE function in MySQL? A) Modifies substring B) Removes substring C) Appends substring D) Replaces substring 36 / 45 36) How do you perform a natural join in MySQL? A) Joins tables B) Simplifies join operations C) Alters data structure D) Deletes records 37 / 45 37) What is the purpose of the COALESCE() function in MySQL? A) Filters records B) Returns first non-null value C) Counts values D) Joins tables 38 / 45 38) How do you perform a LEFT JOIN in MySQL? A) Returns unmatched records B) Joins matched records C) Filters data D) Sorts results 39 / 45 39) How do you check the structure of a MySQL table? A) DESCRIBE B) LIST TABLE C) SHOW COLUMNS D) VIEW STRUCTURE 40 / 45 40) How do you update a record in MySQL? A) Modifies records B) Joins tables C) Groups results D) Filters results 41 / 45 41) How do you update data in a MySQL table? A) Updates records B) Deletes records C) Inserts records D) Joins tables 42 / 45 42) Which command is used to create a new database in MySQL? A) NEW DATABASE B) ADD DATABASE C) DROP DATABASE D) CREATE DATABASE 43 / 45 43) How do you implement user-defined functions in MySQL? A) Enhances SQL functionality B) Alters data structure C) Joins tables D) Deletes records 44 / 45 44) What does the COALESCE function do in MySQL? A) Returns NULL B) Returns last value C) Returns all values D) Returns first non-null value 45 / 45 45) What does the UPPER() function do in MySQL? A) Converts to uppercase B) Formats string C) Joins strings D) Filters values Your score is LinkedIn Facebook Twitter VKontakte 0% ExamWEB DEVELOPMENT EXAM...Read MoreREACT JS PROGRAMMING EXAM...Read MorePYTHON FULL STACK...Read MorePYTHON EXAMS ...Read MoreMYSQL...Read MoreMACHINE LEARNING...Read MoreJAVASCRIPT PROGRAMMING EXAM...Read MoreJAVA SPRING BOOT...Read MoreJAVA PROGRAMMING EXAM...Read MoreJAVA FULL STACK...Read MoreHTML PROGRAMMING EXAM...Read MoreDEEP LEARNING...Read MoreDATA SCIENCE...Read MoreCSS PROGRAMMING EXAM...Read MoreANGULAR JS PROGRAMMING EXAM...Read More 16Share on WhatsApp10Share on LinkedIn5Share on YouTube9Share on Facebook Comments 0
