MySQL Online Aptitude Test 1

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 Rushikesh
R
Rushikesh
Community Contributor
Quizzes Created: 4 | Total Attempts: 4,175
| Attempts: 2,318
SettingsSettings
Please wait...
  • 1/15 Questions

    What does SQL stands for?

    • Structure query language
    • Strong question language
    • Structured question language
    • Separate query language
Please wait...
About This Quiz

The test contains 15 questions and there is no time limit.
The test is not official, it's just a nice way to see how much you know, or don't know, about SQL.

Count Your Score
You will get 1 point for each correct answer. At the end of the Quiz, your total score will be displayed. Maximum score is 15 points.
Good luck

MySQL Online Aptitude Test 1 - Quiz

Quiz Preview

  • 2. 

    What is the use of SQL?

    • Storing data in database

    • Manipulating data in database

    • Retrieving data in database

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    SQL (Structured Query Language) is a programming language used for managing and manipulating relational databases. It is used for various purposes such as storing data in databases, manipulating data by performing operations like inserting, updating, and deleting records, and retrieving data by querying the database using SELECT statements. Therefore, the correct answer is "All of the above" as SQL is used for all these purposes in database management.

    Rate this question:

  • 3. 

    Which SQL statement is used to extract data from the database?

    • SELECT

    • ACCESS

    • OPEN

    • GET

    Correct Answer
    A. SELECT
    Explanation
    The SELECT statement is used in SQL to extract or retrieve data from a database. It allows you to specify the columns and tables you want to retrieve data from, as well as any filters or conditions for the data. The SELECT statement is one of the fundamental and most commonly used statements in SQL for querying and retrieving data.

    Rate this question:

  • 4. 

    Which SQL statement is used to return only different values?

    • DUPLICATE

    • DISTINCT

    • DIFFERENT

    • SELECT

    Correct Answer
    A. DISTINCT
    Explanation
    The correct answer is DISTINCT. The DISTINCT keyword is used in SQL to retrieve only unique values from a column or set of columns in a table. It eliminates duplicate values and returns a result set with distinct values. Therefore, the DISTINCT keyword is the appropriate SQL statement to use when you want to return only different values.

    Rate this question:

  • 5. 

    Which command is used to insert a new records in the table?

    • ADD

    • INSERT INTO

    • INSERT

    • NEW

    Correct Answer
    A. INSERT INTO
    Explanation
    The correct answer is "INSERT INTO". This command is used to insert new records into a table in a database. It allows you to specify the table name and the values that should be inserted into the corresponding columns. By using the "INSERT INTO" command, you can add new data to your table and expand your database with additional records.

    Rate this question:

  • 6. 

    Which of the right syntax for DISTINCT SQL statement?

    • SELECT DIFFERENT column1, column2, ... FROM table_name;

    • SELECT DISTINCT column1, column2, ... WHERE table_name;

    • SELECT DISTINCT column1, column2, ... FROM table_name;

    Correct Answer
    A. SELECT DISTINCT column1, column2, ... FROM table_name;
    Explanation
    The correct answer is "SELECT DISTINCT column1, column2, ... FROM table_name;". This is the correct syntax for using the DISTINCT keyword in an SQL statement. It allows you to retrieve unique values from the specified columns in the table_name.

    Rate this question:

  • 7. 

    You can add a row using SQL in a database with which of the following?

    • ADD

    • CREATE

    • INSERT

    • MAKE

    Correct Answer
    A. INSERT
    Explanation
    In SQL, the INSERT statement is used to add a new row or multiple rows into a table in a database. It allows you to specify the values for each column in the new row(s) being added. The INSERT statement is commonly used to add data into an existing table. Therefore, the correct answer is INSERT.

    Rate this question:

  • 8. 

    Which command is used to modify column name or table structure?

    • MODIFY

    • ADD

    • CHANGE

    • ALTER

    Correct Answer
    A. ALTER
    Explanation
    The ALTER command is used to modify the column name or table structure in a database. It allows for changes to be made to the existing structure of a table, such as adding or deleting columns, modifying column data types, or renaming columns. This command provides flexibility in altering the structure of a table without having to recreate it entirely.

    Rate this question:

  • 9. 

    Which command is used to change or update data in a table?

    • CHANGE

    • ALTER

    • UPDATE

    • MODIFY

    Correct Answer
    A. UPDATE
    Explanation
    The correct answer is UPDATE. The UPDATE command is used to modify or change data in a table. It allows you to update specific columns or rows in the table based on specified conditions. This command is commonly used in SQL to make changes to existing data in a database table.

    Rate this question:

  • 10. 

    Which keyword is used with UPDATE command to change the value?

    • CHANGE

    • MODIFY

    • ADD

    • SET

    Correct Answer
    A. SET
    Explanation
    The keyword used with the UPDATE command to change the value is SET. This keyword is followed by the column name and the new value that we want to update in the database table. Using the SET keyword allows us to specify exactly which column we want to update and what value we want to change it to.

    Rate this question:

  • 11. 

    The command to remove rows from a table 'CUSTOMER' is:

    • REMOVE FROM CUSTOMER

    • DROP FROM CUSTOMER

    • DELETE FROM CUSTOMER WHERE

    • UPDATE FROM CUSTOMER

    Correct Answer
    A. DELETE FROM CUSTOMER WHERE
    Explanation
    The correct answer is "DELETE FROM CUSTOMER WHERE." This command is used to remove rows from a table called 'CUSTOMER' based on certain conditions specified in the WHERE clause. It allows for selective removal of rows, making it a suitable command for deleting specific data from the table.

    Rate this question:

  • 12. 

    Which keyword is used with ALTER command to delete a column?

    • DROP

    • DELETE

    • REMOVE

    • CHANGE

    Correct Answer
    A. DROP
    Explanation
    The keyword used with the ALTER command to delete a column is DROP. This keyword is used to remove a specific column from a table in a database. Using the DROP keyword allows for the deletion of the column and all associated data within it.

    Rate this question:

  • 13. 

    The wildcard in a WHERE clause is useful when?

    • An exact match is necessary in a SELECT statement.

    • An exact match is not possible in a SELECT statement.

    • An exact match is necessary in a CREATE statement.

    • An exact match is not possible in a CREATE statement.

    Correct Answer
    A. An exact match is not possible in a SELECT statement.
    Explanation
    The wildcard in a WHERE clause is useful when an exact match is not possible in a SELECT statement. The wildcard, represented by the "%" symbol in SQL, allows for pattern matching and searching for partial matches or unknown values in a column. It can be used with the LIKE operator to find records that match a specific pattern or contain a certain substring. This is especially helpful when searching for records that have similar characteristics but may not have an exact match in the database.

    Rate this question:

  • 14. 

    The SQL WHERE clause?

    • Limits the column data that are returned

    • Limits the row data are returned

    • Both A and B are correct

    • Neither A nor B are correct

    Correct Answer
    A. Limits the row data are returned
    Explanation
    The correct answer is "Limits the row data that are returned". The WHERE clause in SQL is used to filter rows based on specified conditions. It allows you to specify a condition that must be met for a row to be included in the result set. By using the WHERE clause, you can limit the rows that are returned from a table based on certain criteria, such as a specific column value or a combination of column values. Therefore, the WHERE clause limits the row data that is returned, not the column data.

    Rate this question:

  • 15. 

    Which command is used to specify the number of records to return?

    • SELECT

    • SELECT TOP

    • EXTRACT

    • SELECT SPECIFIC

    Correct Answer
    A. SELECT TOP
    Explanation
    The command "SELECT TOP" is used to specify the number of records to return in a SQL query. It allows you to limit the result set to a specific number of rows, which can be useful when you only need a certain number of records from a large table. By using the "SELECT TOP" command, you can easily retrieve a specific number of records based on your requirements.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 04, 2017
    Quiz Created by
    Rushikesh
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.