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 use the GROUP BY clause in MySQL? A) Deletes records B) Alters data structure C) Summarizes data D) Joins tables 2 / 45 2) What does the GROUP_CONCAT() function do in MySQL? A) Groups rows B) Sums values C) Concatenates rows D) Averages values 3 / 45 3) Which keyword is used to sort the result set in MySQL? A) SORT BY B) SORT C) ORDER BY D) ORDER BY 4 / 45 4) How do you use the BETWEEN operator in MySQL? A) Filters data within a range B) Deletes records C) Joins tables D) Alters table structure 5 / 45 5) What is the default sorting order of the ORDER BY clause in MySQL? A) Alphabetical B) Random C) Descending D) Ascending 6 / 45 6) What does the SUBSTRING() function do in MySQL? A) Joins strings B) Extracts substring C) Filters values D) Counts characters 7 / 45 7) 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 8 / 45 8) How do you create a temporary table in MySQL? A) Creates permanent table B) Deletes existing table C) Alters existing table D) Creates temporary table 9 / 45 9) What is the purpose of the SUBSTRING_INDEX() function in MySQL? A) Aggregates data B) Deletes specific records C) Joins multiple tables D) Splits strings based on a delimiter 10 / 45 10) What is the purpose of the INFORMATION_SCHEMA database in MySQL? A) Provides database structure B) Joins tables C) Alters data D) Deletes records 11 / 45 11) How can you increase the size of a VARCHAR column in MySQL? A) MODIFY COLUMN B) CHANGE COLUMN C) RESIZE COLUMN D) ALTER TABLE 12 / 45 12) What is the purpose of the INSERT INTO … SELECT statement in MySQL? A) Deletes records B) Joins tables C) Filters data D) Transfers data between tables 13 / 45 13) How do you find the second highest salary from a salary table in MySQL? A) ORDER BY B) Subquery C) COUNT D) JOIN 14 / 45 14) How do you rename a MySQL database? A) RENAME DATABASE B) MODIFY DATABASE C) CHANGE DATABASE D) ALTER DATABASE 15 / 45 15) What is the purpose of the CHARACTER SET in MySQL? A) Limits data size B) Joins tables C) Defines column characters D) Counts records 16 / 45 16) What does the EXISTS keyword do in MySQL? A) Retrieves unique records B) Joins multiple tables C) Counts total rows D) Returns TRUE if rows exist 17 / 45 17) How do you add a new column to an existing MySQL table? A) CHANGE COLUMN B) MODIFY TABLE C) ALTER TABLE D) ADD COLUMN 18 / 45 18) How do you drop a database in MySQL? A) Deletes a single table B) Removes the entire database C) Joins multiple databases D) Modifies a table 19 / 45 19) How do you implement a self-join in MySQL? A) Joins tables B) Deletes records C) Alters data structure D) Compares records in the same table 20 / 45 20) How do you perform an INNER JOIN in MySQL? A) Filters data B) Joins unmatched records C) Returns matched records D) Counts records 21 / 45 21) What is a subquery in MySQL? A) Aggregate function B) Nested query C) Main query D) JOIN condition 22 / 45 22) What does the DEFAULT keyword do in MySQL? A) Removes value B) Sets default value C) Modifies value D) Overwrites value 23 / 45 23) What does the EXISTS operator do in MySQL? A) Filters rows B) Checks for NULL values C) Sorts rows D) Checks for row existence 24 / 45 24) What does the term “sharding” refer to in MySQL? A) Distributes data B) Backs up data C) Splits queries D) Combines databases 25 / 45 25) How do you add a comment to a MySQL query? A) Using /…/ B) Using // C) Using — D) Using # 26 / 45 26) What is the purpose of the BETWEEN operator in MySQL? A) Sorting B) Filtering C) Range checking D) Exact matching 27 / 45 27) What is the purpose of the CROSS JOIN operator in MySQL? A) Joins matched records B) Returns all combinations C) Filters data D) Counts records 28 / 45 28) What does the CROSS JOIN do in MySQL? A) Joins matched rows B) Excludes non-matching C) Filters rows D) Combines all rows 29 / 45 29) What does the RAND() function do in MySQL? A) Returns integer B) Returns string C) Returns date D) Returns random number 30 / 45 30) How do you perform a full-text search in MySQL? A) Groups results B) Joins tables C) Filters results D) Searches text 31 / 45 31) How do you remove a database in MySQL? A) DROP DATABASE B) TRUNCATE DATABASE C) DELETE DATABASE D) REMOVE DATABASE 32 / 45 32) What is the purpose of the LEFT JOIN clause in MySQL? A) Sorts records B) Deletes specific entries C) Joins multiple tables D) Includes unmatched records from the left 33 / 45 33) What is the purpose of the UNION operator in MySQL? A) Merges multiple result sets B) Deletes records C) Joins tables D) Alters data structure 34 / 45 34) How do you implement a string search in MySQL? A) Alters data structure B) Deletes records C) Joins tables D) Finds specific patterns 35 / 45 35) How do you implement a data export in MySQL? A) Joins tables B) Deletes records C) Alters data structure D) Facilitates data sharing 36 / 45 36) Which MySQL statement is used to change data in a table? A) MODIFY B) CHANGE C) ALTER D) UPDATE 37 / 45 37) What does the MIN() function do in MySQL? A) Counts records B) Retrieves smallest value C) Retrieves largest value D) Joins tables 38 / 45 38) How do you use the GROUP BY clause with the COUNT() function in MySQL? A) Counts records in groups B) Joins tables C) Sorts results D) Filters data 39 / 45 39) How do you implement a foreign key constraint in MySQL? A) Deletes records B) Joins tables C) Enforces referential integrity D) Alters data structure 40 / 45 40) What does the term “row-level locking” mean in MySQL? A) Deletes old records B) Allows multiple transactions C) Improves performance D) Locks entire table 41 / 45 41) What is the purpose of the IS NULL condition in MySQL? A) Joins tables B) Filters non-null values C) Checks for null values D) Counts records 42 / 45 42) How do you prevent deadlocks in MySQL? A) Allows multiple locks B) Increases transaction time C) Deletes data D) Prevents deadlocks 43 / 45 43) What is the purpose of the EXPLAIN statement in MySQL? A) Analyzes query performance B) Deletes records C) Joins tables D) Modifies queries 44 / 45 44) How do you get the current date and time in MySQL? A) NOW() B) SYSDATE() C) CURRENT_DATE() D) CURRENT_TIME() 45 / 45 45) Which MySQL function is used to remove leading and trailing spaces from a string? A) TRIM() B) LTRIM() C) RTRIM() D) REMOVE SPACES 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 13Share on WhatsApp6Share on LinkedIn4Share on YouTube9Share on Facebook Comments 0