MySql

Overview

Rewards

FAQs

Overview

MySQL is an open-source relational database management system that stores, manages, and retrieves data efficiently. It’s essential today for powering web applications, ensuring data integrity, and supporting scalability.MySQL is widely used in industries for tasks like data analysis, transaction management, and reporting. Its flexibility supports various platforms and programming languages. As a key component of many modern systems, learning MySQL enhances both development and database management skills.

Take the assessment to know how good you are with MySQL Concepts & Commands.

Click the Rewards tab for eligibility requirements.

Read the FAQs tab carefully for Instructions before beginning the assessment.

Rewards

NYXPoints are used to generate the Leaderboard (coming soon). They are awarded for achieving a certain score.

200 nyxpoints for a passing score of 80% or more
300 nyxpoints for a perfect score of 100%
Didn’t pass? You still get 30 nyxpoints for attempting the assesment

FAQs

IMPORTANT instructions for taking the Assessment

The timer starts when you click Start Assessment
DO NOT refresh/reload the page or use the back button to navigate away from the page.
Navigating away from the assessment page DOES NOT stop/pause the timer and the will restart the assessment when you come back to it. The answers are NOT saved.

General

There are NO pre-requisites to take this assessment. Take this assessment even if you are completely new to Linux.
The assessment is completely FREE.
Preferably take it in a closed book mode.
DO NOT copy/paste, share or upload questions elsewhere.

Eligible Rewards

300 NyxCoins*

* NyxCoins vary on score

Questions

Minutes

1 %

Passing Score

Time limit: 0

Assessment Summary

0 of 30 Questions completed

Questions:

Information

You have already completed the assessment before. Hence you can not start it again.

Assessment is loading…

You must sign in or sign up to start the assessment.

You must first complete the following:

Results

Assessment complete. Results are being recorded.

Results

0 of 30 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Average score
Your score

Categories

Not categorized 0%

Current
Review
Answered
Correct
Incorrect

Question 1 of 30

1. Question
Which privilege must be given to the database to create a stored function or procedure?
- CREATE METHOD
- CREATE ROUTINE
- CREATE PROCEDURE
- CREATE FUNCTION
Correct

Incorrect
Question 2 of 30

2. Question
What is reason to introduce data redundancy into a normalized database design?
- Reduce storage space
- Avoid Data Inconsistencies
- Reduce corrupted data
- All of the above
Correct

Incorrect
Question 3 of 30

3. Question
In a well-designed structured relational database, what should every table have?
- A Set of triggers
- A Sequential id field
- Primary key
- None of the above
Correct

Incorrect
Question 4 of 30

4. Question
Which type of SQL query is best suited for validating the format of an email address in a MySQL table?
- SQL query using partitions
- SQL query using IS NULL
- SQL query using a regular expression
- None of the above
Correct

Incorrect
Question 5 of 30

5. Question
Which of the following statements is true about an INNER JOIN in MySQL?
- It returns all rows from both tables, including non-matching rows
- It returns all rows from the left table, along with the matching rows from the right table
- It returns only the rows where there is no match between the columns in both tables
- It returns only the rows where there is a match between the columns in both tables
Correct

Incorrect
Question 6 of 30

6. Question
Select an option to get the current date and time in MySQL.
- Select SYSDATE();
- Select DATE();
- Select SYS();
- None of the above
Correct

Incorrect
Question 7 of 30

7. Question
What does the GROUP BY clause do in a MySQL query?
- It sorts the results in ascending order
- It groups rows that have the same values in specified columns
- It filters rows based on a condition
- It combines the results of two or more queries
Correct

Incorrect
Question 8 of 30

8. Question
Which MySQL function can be used to calculate the total number of rows in a result set?
- sum()
- count(*)
- count(column_name)
- max()
Correct

Incorrect
Question 9 of 30

9. Question
How can you retrieve only unique values from a column in a MySQL table?
- Use the DISTINCT keyword
- Apply the UNIQUE constraint
- Limit the results with LIMIT
- Sort the results with ORDER BY
Correct

Incorrect
Question 10 of 30

10. Question
In MySQL databases, the structure representing the organizational views of the entire databases is known as ___________.
- View
- Instance
- Table
- Schema
Correct

Incorrect
Question 11 of 30

11. Question
What is the output of the following SQL Statement?

SELECT * FROM Students WHERE Name LIKE ‘c%’
- Fetches data in the Students table where the value in the Name column starts with "c"
- Fetches data in the Students table where the value in the Name column doesn't contain "c"
- Fetches data in the Students table where the value in the Name column contains "c"
- Fetches data in the Students table where the value in the Name column ends with "c"
Correct

Incorrect
Question 12 of 30

12. Question
Which of the following is the default port for MySQL Server?
- 25
- 990
- 3308
- 3306
Correct

Incorrect
Question 13 of 30

13. Question
What character is used to terminate queries in MySQL?
- Linebreak
- Semicolon
- Colon
- None of the above
Correct

Incorrect
Question 14 of 30

14. Question
Which MySQL statement is used to remove a table from a database?
- DELETE TABLE
- REMOVE TABLE
- DROP TABLE
- TRUNCATE TABLE
Correct

Incorrect
Question 15 of 30

15. Question
Select a MySQL command which shows the structure of a table.
- DESCRIBE <tablename>;
- SHOW <tablename>;
- STRUCTURE <tablename>;
- INFO table <tablename>;
Correct

Incorrect
Question 16 of 30

16. Question
What is the MySQL perror command line utility used for?
- To display storage error codes
- To display your version of mysql
- To display OS error codes
- To display default settings that are in error
Correct

Incorrect
Question 17 of 30

17. Question
Which of the following is not a valid string type for a column in MySQL?
- SET
- CHAR
- BIT
- ENUM
Correct

Incorrect
Question 18 of 30

18. Question
In which table does mysql stores user account passwords?
- mysql.admin
- mysql.passwords
- mysql.accounts
- mysql.user
Correct

Incorrect
Question 19 of 30

19. Question
Which keyword is used to remove all rows from a table emp?
- REMOVE emp;
- TRUNCATE table emp;
- DELETE ALL emp;
- CLEAR emp;
Correct

Incorrect
Question 20 of 30

20. Question
Which of the following SQL statements correctly drops multiple tables in a single command?
- DROP TABLE table1, table2, table3;
- DROP TABLE table1; DROP TABLE table2; DROP TABLE table3;
- DROP TABLE table1; table2; table3;
- DROP TABLE table1, DROP TABLE table2, DROP TABLE table3;
Correct

Incorrect
Question 21 of 30

21. Question
Which of the following is not a DDL (Data Definition Language) command?
- DELETE
- TRUNCATE
- DROP
- ALTER
Correct

Incorrect
Question 22 of 30

22. Question
To export an entire database, including both its objects and data, which command-line tool should you use?
- Mysqld
- Mysqlexport
- Mysqladmin
- Mysqldump
Correct

Incorrect
Question 23 of 30

23. Question
What does the ON DELETE CASCADE option do in a relational database?
- Deletes the referenced row in the parent table when a row in the child table is deleted
- Automatically updates the parent table when a row in the child table is deleted
- Ensures that when a row in the parent table is deleted, all related rows in the child table are also automatically deleted
- Prevents deletion of rows in the parent table if there are related rows in the child table
Correct

Incorrect
Question 24 of 30

24. Question
How can you list all columns for a given table (demo)?
- SHOW COLUMNS FROM demo;
- Select COLUMNS FROM demo;
- SHOW demo COLUMNS;
- LIST demo COLUMNS;
Correct

Incorrect
Question 25 of 30

25. Question
Which command is used to grant all privileges on a database named testdb to a user named john?
- GRANT ALL PRIVILEGES ON testdb TO 'john';
- GRANT ALL PRIVILEGES ON testdb TO john;
- GRANT ALL ON testdb TO 'john';
- GRANT PRIVILEGES ON testdb TO 'john';
Correct

Incorrect
Question 26 of 30

26. Question
The procedure of nesting one select statement into another is called as?
- Binding
- Nesting
- Sub-querying
- Encapsulating
Correct

Incorrect
Question 27 of 30

27. Question
What is the purpose of the INDEX in MySQL?
- To ensure data integrity
- To improve the speed of data retrieval operations
- To encrypt data
- To create a backup of the table
Correct

Incorrect
Question 28 of 30

28. Question
Which clause is used to sort the output of a query in SQL?
- GROUP
- ORDER BY
- ORDER
- GROUP BY
Correct

Incorrect
Question 29 of 30

29. Question
What is InnoDB in the below given SQL Query __________?

CREATE TABLE vendor (

name CHAR(30),

id INT,

PRIMARY KEY (id)

) ENGINE = InnoDB;
- storage engine
- table name
- reference engine
- database name
Correct

Incorrect
Question 30 of 30

30. Question
Which MySQL function is used to extract a substring from a string?
- CONCAT()
- SUBSTRING()
- TRIM()
- REPLACE()
Correct

Incorrect

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

MySql

Eligible Rewards

300 NyxCoins*

Assessment Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question

26. Question

27. Question

28. Question

29. Question

30. Question