MySQL Quiz - Unlock Synoriq

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Diksha
D
Diksha
Community Contributor
Quizzes Created: 1 | Total Attempts: 352
| Attempts: 352
SettingsSettings
Please wait...
  • 1/14 Questions

    How can we get the number of records or rows in a table?

    • Using COUNT
    • Using NUM
    • Using NUMBER
    • Both a and c above
Please wait...
About This Quiz

This MySQL quiz covers fundamental aspects such as querying data, table operations, and SQL commands, enhancing understanding and skills in managing MySQL databases.

MySQL Quiz - Unlock Synoriq - Quiz

Quiz Preview

  • 2. 

    In a LIKE clause, you can could ask for any value ending in “ton” by writing

    • LIKE ton$

    • LIKE ^.*ton$

    • LIKE %ton

    • LIKE *ton

    • LIKE .*ton

    Correct Answer
    A. LIKE %ton
    Explanation
    The correct answer is "LIKE %ton". This is because the "%" symbol is used as a wildcard character in SQL, representing any number of characters. So when we write "LIKE %ton", it means we are looking for any value that ends with "ton".

    Rate this question:

  • 3. 

    Which of the following is NOT available in MySQL:

    • REVOKE

    • FETCH

    • LIKE

    • JOIN

    • SELECT

    Correct Answer
    A. FETCH
  • 4. 

    Which operation are allowed in a join view

    • UPDATE

    • INSERT

    • DELETE

    • All of the mentioned

    Correct Answer
    A. All of the mentioned
    Explanation
    In a join view, all of the mentioned operations (UPDATE, INSERT, DELETE) are allowed. This means that you can update, insert, and delete records in a join view. This allows for more flexibility and control over the data in the view, as you can make changes to the underlying tables through the join view.

    Rate this question:

  • 5. 

    . Which of the constraint can be enforced one per table?

    •  Primary key constraint  

    • Not Null constraint  

    • Foreign Key constraint  

    • Check constraint

    Correct Answer
    A.  Primary key constraint  
    Explanation
    The primary key constraint can be enforced one per table. This constraint ensures that each row in a table has a unique identifier, which is the primary key. It prevents duplicate values from being inserted into the primary key column and helps maintain data integrity. Additionally, the primary key constraint also automatically creates an index on the primary key column, which improves query performance.

    Rate this question:

  • 6. 

    Constraints can be applied on ___________

    • Column

    • Table

    • Field

    • All of the mentioned

    Correct Answer
    A. All of the mentioned
    Explanation
    Constraints can be applied on columns, tables, and fields in a database. Constraints are used to enforce rules and restrictions on the data that is stored in the database. By applying constraints, we can ensure data integrity and maintain consistency in the database. Therefore, all of the mentioned options (columns, tables, and fields) can have constraints applied to them.

    Rate this question:

  • 7. 

    Which join refers to join records from the right table that have no matching key in the left table are include in the result set:  

    • Left outer join  

    • Right outer join

    • Full outer join

    • Half outer join

    Correct Answer
    A. Right outer join
    Explanation
    A right outer join refers to joining records from the right table that have no matching key in the left table and includes them in the result set. In other words, all the records from the right table are included in the result, and if there is no match in the left table, NULL values are used for the columns of the left table in the result set.

    Rate this question:

  • 8. 

    Purpose of foreign key constraint in SQL Server is __________

    • FOREIGN KEY constraints identify and enforce the relationships between tables  

    • A foreign key in one table points to a candidate key in another table  

    • You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value  

    • None of the mentioned  

    Correct Answer
    A. FOREIGN KEY constraints identify and enforce the relationships between tables  
    Explanation
    The purpose of a foreign key constraint in SQL Server is to identify and enforce the relationships between tables. This means that a foreign key in one table points to a candidate key in another table, establishing a connection between the two tables. This constraint ensures that you cannot insert a row with a foreign key value unless there is a corresponding candidate key with that value.

    Rate this question:

  • 9. 

    Which of these commands will delete a table called XXX if you have appropriate authority

    • DROP XXX

    • DELETE XXX WHERE confirm = “YES”

    • DROP XXX WHERE confirm = “YES”

    • DROP TABLE XXX

    • DELETE XXX

    • DELETE TABLE XXX

    Correct Answer
    A. DROP TABLE XXX
    Explanation
    The correct answer is "DROP TABLE XXX". This command is used to delete a table called XXX if the user has appropriate authority. The "DROP" keyword is used to remove an entire table from the database, and "TABLE" specifies that it is a table that should be dropped. The other options either have incorrect syntax or do not specify that a table should be dropped.

    Rate this question:

  • 10. 

    Which command is used to set the current database to “mysql”?

    • SHOW mysql

    • CREATE mysql

    • USE mysql

    • DESCRIBE mysql

    Correct Answer
    A. USE mysql
    Explanation
    The correct answer is "USE mysql". This command is used to set the current database to "mysql". It is used to switch to a different database in order to perform operations on that specific database.

    Rate this question:

  • 11. 

    Which of the following SQL clauses is used to filter rows after an aggregation in a MySQL query?

    • WHERE

    • HAVING

    • GROUP BY

    • ORDER BY

    Correct Answer
    A. HAVING
    Explanation
    The HAVING clause is used to filter rows after an aggregation in a MySQL query. While the WHERE clause is used to filter rows before any aggregation occurs, HAVING is specifically used after the GROUP BY clause to filter groups based on the aggregate values. The GROUP BY clause groups rows, and ORDER BY is used to sort the result set.

    Rate this question:

  • 12. 

    Which of the following ways below are the correct way to get the current date?

    • SELECT CURTIME();

    • SELECT CURDATE();

    • SELECT CURRRENT_TIME()

    • All of the above

    Correct Answer
    A. SELECT CURDATE();
    Explanation
    The correct SQL command to retrieve the current date is SELECT CURDATE();. Option A, CURTIME(), retrieves the current time, not the date. Option C is incorrect due to a typo ("CURRRENT_TIME" should be "CURRENT_TIME()"), which retrieves the current time as well. Therefore, the only correct option for getting the current date is SELECT CURDATE();.

    Rate this question:

  • 13. 

    Which of the following is not a comment in MySQL

    • /* This code is commented */

    • # This code is commented

    • /# This code is commented

    • -- This code is commented

    Correct Answer
    A. /# This code is commented
    Explanation
    The given answer, "/# This code is commented," is not a valid comment in MySQL. In MySQL, comments can be made using the following formats: "/* This code is commented */", "# This code is commented", and "-- This code is commented". However, "/# This code is commented" is not a recognized comment format in MySQL.

    Rate this question:

  • 14. 

    Which of the following is not a class of constraint in SQL Server?

    • NOT NULL  

    • CHECK

    • NULL

    • UNIQUE

    Correct Answer
    A. NULL
    Explanation
    The correct answer is NULL. In SQL Server, NULL is not a class of constraint. The NOT NULL constraint ensures that a column cannot have a NULL value, the CHECK constraint specifies a condition that must be true for each row, and the UNIQUE constraint ensures that all values in a column are unique. However, NULL itself is not a constraint class, but rather a value that represents the absence of data.

    Rate this question:

Quiz Review Timeline (Updated): Aug 20, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 20, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 28, 2020
    Quiz Created by
    Diksha
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.