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) What does the term “aggregate function” mean in MySQL? A) Joins tables B) Filters records C) Deletes data D) Performs calculations 2 / 45 2) How do you remove all records from a MySQL table without deleting the table itself? A) DROP TABLE B) DELETE TABLE C) REMOVE TABLE D) TRUNCATE TABLE 3 / 45 3) What is the purpose of the GROUP_CONCAT() function in MySQL? A) Joins multiple tables B) Counts unique values C) Combines multiple row values D) Sorts data 4 / 45 4) What does the STR_TO_DATE function do in MySQL? A) Parses date B) Converts string to date C) Outputs date D) Formats date 5 / 45 5) What is the purpose of the AVG function in MySQL? A) Joins tables B) Deletes records C) Computes average values D) Filters data 6 / 45 6) How do you create a composite index in MySQL? A) Joins tables B) Creates multi-column index C) Deletes records D) Alters data structure 7 / 45 7) What does the TIMESTAMPDIFF() function do in MySQL? A) Counts dates B) Calculates difference C) Joins dates D) Retrieves date 8 / 45 8) How do you set a column to auto-increment in MySQL? A) Filters records B) Sets auto-increment C) Alters structure D) Joins tables 9 / 45 9) How do you find records where a column value is NULL in MySQL? A) EXISTS B) NOT EXISTS C) IS NOT NULL D) IS NULL 10 / 45 10) What does the term “denormalization” refer to in MySQL? A) Filters data B) Deletes records C) Joins tables D) Improves read performance 11 / 45 11) What does the SUBSTRING() function do in MySQL? A) Joins strings B) Extracts substring C) Filters values D) Counts characters 12 / 45 12) What does the STR_TO_DATE() function do in MySQL? A) Counts dates B) Joins strings C) Converts string to date D) Formats date 13 / 45 13) What is the purpose of the RENAME statement in MySQL? A) Joins tables B) Deletes records C) Renames database objects D) Alters data structure 14 / 45 14) What is the purpose of the ORDER BY clause in MySQL? A) Filters data B) Sorts the result set C) Groups records D) Joins tables 15 / 45 15) How do you use the GROUP_CONCAT() function in MySQL? A) Joins strings B) Filters data C) Counts occurrences D) Concatenates values 16 / 45 16) What is the role of the INFORMATION_SCHEMA in MySQL? A) Accesses database metadata B) Stores data C) Filters data D) Modifies structure 17 / 45 17) What is the purpose of the INNER JOIN in MySQL? A) Returns all records B) Returns all records from one table C) Matches records D) Excludes non-matching 18 / 45 18) What is the purpose of the DELETE statement in MySQL? A) Updates records B) Joins tables C) Inserts records D) Removes records 19 / 45 19) 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 20 / 45 20) 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 21 / 45 21) How do you apply a filter to a query result in MySQL? A) Updates data B) Joins multiple tables C) Deletes specific records D) Restricts results based on conditions 22 / 45 22) What is the default sorting order of the ORDER BY clause in MySQL? A) Alphabetical B) Random C) Descending D) Ascending 23 / 45 23) What does the MySQL function ABS() do? A) Returns absolute value B) Finds maximum C) Finds minimum D) Rounds number 24 / 45 24) How do you insert data into a MySQL table? A) UPDATE ROW B) INSERT INTO C) ADD ROW D) CREATE ROW 25 / 45 25) How do you use the CONCAT function in MySQL? A) Merges multiple strings B) Joins tables C) Deletes records D) Alters data structure 26 / 45 26) What command is used to create a new database in MySQL? A) ADD DATABASE B) MAKE DATABASE C) CREATE DATABASE D) NEW DATABASE 27 / 45 27) What is the purpose of the CHAR_LENGTH() function in MySQL? A) Counts total rows B) Joins multiple tables C) Measures string length D) Retrieves unique values 28 / 45 28) What does the MIN() function do in MySQL? A) AVERAGE B) MAXIMUM C) Returns minimum value D) COUNT 29 / 45 29) What does the NOT IN operator do in MySQL? A) Filters results B) Groups results C) Checks for absence D) Joins tables 30 / 45 30) How do you implement user-defined functions in MySQL? A) Enhances SQL functionality B) Alters data structure C) Joins tables D) Deletes records 31 / 45 31) How do you create a database in MySQL? A) Joins tables B) Deletes database C) Filters records D) Creates new database 32 / 45 32) How do you create a sequence in MySQL? A) Using SUBQUERIES B) Using AUTO_INCREMENT C) Using TRIGGERS D) Using GUIDs 33 / 45 33) What is the purpose of the HAVING clause in conjunction with GROUP BY in MySQL? A) Sorts individual records B) Joins multiple tables C) Deletes records D) Filters aggregated results 34 / 45 34) What is the purpose of the SHOW CREATE TABLE command in MySQL? A) Modifies table B) Displays table creation SQL C) Joins tables D) Deletes records 35 / 45 35) 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 36 / 45 36) How do you retrieve unique values from a column in MySQL? A) Sorts data B) Joins multiple tables C) Counts total records D) Removes duplicates from the result set 37 / 45 37) What is the purpose of the LIMIT clause in MySQL? A) Controls the output size B) Deletes records C) Alters data structure D) Joins tables 38 / 45 38) What does the CASE statement do in MySQL? A) Provides conditional logic B) Filters values C) Joins tables D) Groups results 39 / 45 39) Which MySQL function is used to return the current date? A) NOW() B) CURDATE() C) CURRENT_DATE D) DATE() 40 / 45 40) How do you perform a cross join in MySQL? A) Joins on specific conditions B) Combines all rows from both tables C) Deletes records D) Aggregates data 41 / 45 41) How do you perform a LEFT JOIN in MySQL? A) Returns unmatched records B) Joins matched records C) Filters data D) Sorts results 42 / 45 42) How do you create a view in MySQL? A) Deletes view B) Creates virtual table C) Filters records D) Joins tables 43 / 45 43) How do you create a stored procedure in MySQL? A) CREATE FUNCTION B) CREATE PROCEDURE C) ALTER PROCEDURE D) ADD PROCEDURE 44 / 45 44) How do you count unique values in a column in MySQL? A) Joins tables B) Filters data C) Counts unique values D) Counts total 45 / 45 45) What is the purpose of the GROUP BY clause in MySQL? A) Counts all records B) Joins tables C) Groups similar records D) Deletes data 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
