SQL Subjective Assessment Test

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 Cripstwick
C
Cripstwick
Community Contributor
Quizzes Created: 636 | Total Attempts: 835,032
| Attempts: 381
SettingsSettings
Please wait...
  • 1/10 Questions

     What does SQL stand for?

    • Structured query language
    • Software query language
    • Structured questionnaire language
    • Standard query language
Please wait...
About This Quiz

Take our SQL Subjective Assessment Test, designed to evaluate your understanding and skills in SQL, focusing on your ability to solve real-world problems through subjective, open-ended questions. Here, you will be challenged with scenarios that require strategic thinking and problem-solving abilities.

Each question is crafted to assess how well you can apply SQL techniques to practical situations. This approach helps ensure that you are not only proficient in SQL syntax but also capable of utilizing SQL to analyze data and derive meaningful insights effectively.

This quiz is ideal for anyone looking to deepen their SQL knowledge or prepare for job roles that require advanced SQL skills. Our quiz offers a comprehensive and rigorous testing experience.

SQL Subjective Assessment Test - Quiz

Quiz Preview

  • 2. 

    What happens to data updated in a view within the underlying table?

    • Cleaned

    • Deleted

    • Removed

    • Updated

    Correct Answer
    A. Updated
    Explanation
     When data are updated in a view, the corresponding data in the underlying table are also updated. A view is like a window or a specific presentation of data from one or more tables. Changes made through a view directly affect the base table since the view is just a query on the table. This ensures that the database remains consistent, whether modifications are made directly to the table or through the view.

    Rate this question:

  • 3. 

    What are the two parts of SQL? 

    • DML and DMBS

    • DMBS and DDL

    • DDL and DML

    • DML and JAVA

    Correct Answer
    A. DDL and DML
    Explanation
    SQL, or Structured Query Language, is primarily divided into two parts: DDL (Data Definition Language) and DML (Data Manipulation Language). DDL includes commands that define the database structure, such as CREATE, ALTER, and DROP, which help in creating and modifying tables and database schemas. DML comprises commands that are used for managing data within those tables, including INSERT, UPDATE, DELETE, and SELECT. Understanding these two parts is essential for effectively managing and utilizing databases.

    Rate this question:

  • 4. 

    In what objects are the data stored in an RDBMS?

    • Columns

    • Tables

    • Views

    • Doc

    Correct Answer
    A. Tables
    Explanation
    In a Relational Database Management System (RDBMS), data are primarily stored in tables. Tables are structured in rows and columns, with each row representing a record and each column representing a field. This structure allows for the efficient organization, retrieval, and manipulation of data. Tables are the fundamental building blocks of an RDBMS, enabling it to manage data in a way that ensures data integrity and facilitates complex querying and analysis.

    Rate this question:

  • 5. 

    Which of these is not a query or command in the DML (Data Manipulation Language) part of SQL?

    • Select

    • Update 

    • Drop table

    • Delete

    Correct Answer
    A. Drop table
    Explanation
    "Drop table" is not a part of Data Manipulation Language (DML); it belongs to Data Definition Language (DDL). DML commands are used to manage data within table objects. These commands include "Select," "Update," and "Delete," which are used to retrieve, modify, and remove data, respectively. On the other hand, DDL commands such as "Drop table" are used to define and modify the structure of database objects like tables. "Drop table" specifically is used to permanently remove a table and all of its data from the database.

    Rate this question:

  • 6. 

    Which of these is a physical structure containing pointers to data?

    • Insert

    • Views 

    • Index

    • Table

    Correct Answer
    A. Index
    Explanation
    An index is a physical structure containing pointers to data. It helps speed up the retrieval of rows from a database table by providing quick access to the rows based on the index keys. This structure is particularly useful in improving the performance of queries, as it allows the database system to find data without scanning the entire table. An index is analogous to an index in a book, which directs you to the exact pages where the information you are looking for can be found, thereby saving time.

    Rate this question:

  • 7. 

    Which of these stores and manages SQL triggers? 

    • Tables

    • Scala

    • Groovy

    • DMBS

    Correct Answer
    A. DMBS
    Explanation
    DBMS, or Database Management System, is responsible for storing and managing SQL triggers. Triggers are special procedures that are automatically executed in response to certain events on a particular table or view in a database. These events can include insertions, updates, or deletions. A DBMS manages these triggers by activating them when their specific conditions are met, ensuring that automatic actions defined in the triggers are performed, which can help maintain data integrity and enforce business rules.

    Rate this question:

  • 8. 

    Why is truncate faster than delete in SQL?

    • It deletes only from the database.

    • It changes data instead of deleting them.

    • It writes the deleted records into rollback.

    • It moves data out of the database instead of deleting them.

    Correct Answer
    A. It writes the deleted records into rollback.
    Explanation
    Truncate is faster than delete in SQL because it does not generate a log for each deleted row and does not write the deleted records into the rollback segment. This is unlike the delete command, which logs each row it deletes, allowing the operation to be rolled back if necessary. Truncate effectively removes all rows in a table without logging the individual row deletions, making it a quicker operation when you don’t need to keep a record of the deletions for recovery or auditing purposes.

    Rate this question:

  • 9. 

    Which of the following statements about views in SQL is not true?

    • The result of using a view are permanently stored in the database

    • Views are created by standard T-SQL select command

    • The result of using a view are not permanently stored in the database

    • Views can be used for deleting rows

    Correct Answer
    A. The result of using a view are permanently stored in the database
    Explanation
    The statement that the results of using a view are permanently stored in the database is not true. Views in SQL are virtual tables that are not stored permanently; they are defined by a query and only display results when they are accessed. A view dynamically generates data from its underlying tables each time it is queried, without storing the data itself. This makes views useful for simplifying complex queries and providing a specific look at the data without altering the underlying structure or content of the database.

    Rate this question:

  • 10. 

    What process is used to optimize databases by removing the potential for redundancy?

    • Nomination

    • Normalization

    • Nomination

    • Notifystack

    Correct Answer
    A. Normalization
    Explanation
    Normalization is the process used to optimize databases by removing redundancy and potential for data anomalies. It involves organizing the fields and tables of a database to minimize duplication of information and to segregate data in a way that one fact is stored only once. Normalization typically occurs in several stages, each termed a "normal form," which systematically reduce data redundancy and improve data integrity. This process ensures that the database is efficient and that updates to the data do not lead to inconsistencies.

    Rate this question:

Quiz Review Timeline (Updated): Jun 24, 2024 +

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

  • Current Version
  • Jun 24, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 20, 2018
    Quiz Created by
    Cripstwick
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.