Intelligent SQL Subjective Assessment Test

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Cripstwick

Cripstwick

Community Contributor

Quizzes Created: 636 | Total Attempts: 733,305

Questions: 10 | Attempts: 338 | Updated: Aug 31, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Intelligent SQL Subjective Assessment Test - Quiz

Here we are with an intelligent SQL subjective assessment test to help evaluate your knowledge and skills of SQL using a descriptive approach. Let's see what you got! Please make sure to read all the questions very carefully before attempting. All the questions carry one mark. You are expected to attempt all the questions in the quiz. Your final scores will be given once the quiz is completed. There is no time bar on the quiz. Hope you learn and have fun with the quiz. All the very best!

Questions and Answers

1.

SQL stands for__
- A.
  
  Structured query language
- B.
  
  Software query language
- C.
  
  Structured questionnaire language
- D.
  
  Standard query language
Correct Answer
A. Structured query language

Explanation
SQL stands for Structured Query Language. It is a programming language that is used to manage and manipulate relational databases. It is designed to communicate with databases and retrieve, insert, update, and delete data. SQL is widely used in the field of database management and is considered the standard language for relational database management systems.

Rate this question:
2.

Which of these stores and manages SQL triggers?
- A.
  
  Tables
- B.
  
  Scala
- C.
  
  Groovy
- D.
  
  DMBS
Correct Answer
D. DMBS

Explanation
A Database Management System (DBMS) is responsible for storing and managing SQL triggers. Triggers are database objects that are associated with a table and are executed automatically when a specific event occurs, such as an insert, update, or delete operation on the table. The DBMS is responsible for storing and managing these triggers, ensuring that they are executed correctly and at the appropriate times.

Rate this question:
3.

Data which are updated in a view are__ in a table
- A.
  
  Cleaned
- B.
  
  Deleted
- C.
  
  Removed
- D.
  
  Updated
Correct Answer
D. Updated

Explanation
When data is updated in a view, it means that the information in the view has been changed or modified. This updated data is not physically stored in the view itself, but rather it reflects the changes made to the underlying table. Therefore, the correct answer is "Updated" because the data in the view is updated based on the changes made in the table.

Rate this question:
4.

Which of the following is not true?
- A.
  
  The result of using a view are permanently stored in the database
- B.
  
  Views are created by standard T-SQL select command
- C.
  
  The result of using a view are not permanently stored in the database
- D.
  
  Views can be used for deleting rows
Correct Answer
A. The result of using a view are permanently stored in the database

Explanation
Views are not permanently stored in the database. They are virtual tables that are created based on the result of a query, and the data in the view is not physically stored. Instead, the view is dynamically generated each time it is queried. This allows for efficient data retrieval and manipulation without the need to store redundant data.

Rate this question:
5.

Which of these is a physical structure containing pointers to a data?
- A.
  
  Insert
- B.
  
  Views
- C.
  
  Index
- D.
  
  Table
Correct Answer
C. Index

Explanation
An index is a physical structure that contains pointers to data. It is used to improve the efficiency of data retrieval operations by allowing quick access to specific data records based on certain criteria. The index contains key values and corresponding pointers to the actual data location, making it easier and faster to locate and retrieve specific data.

Rate this question:
6.

What are the two parts of SQL?
- A.
  
  DML and DMBS
- B.
  
  DMBS and DDL
- C.
  
  DDL and DML
- D.
  
  DML and JAVA
Correct Answer
C. DDL and DML

Explanation
The two parts of SQL are DDL (Data Definition Language) and DML (Data Manipulation Language). DDL is used to define and modify the structure of the database, including creating tables, altering table structures, and defining constraints. DML is used to manipulate the data within the database, including inserting, updating, and deleting records. DML is often used in conjunction with programming languages like Java to interact with the database.

Rate this question:
7.

Why is truncate faster than delete in SQL? Because
- A.
  
  It deletes only from the database
- B.
  
  It changes data instead of deleting them
- C.
  
  It writes the deleted records into rollback
- D.
  
  It moves data out of the database instead of deleting them
Correct Answer
A. It deletes only from the database

Explanation
Truncate is faster than delete in SQL because it only deletes data from the database, whereas delete changes data instead of deleting it. Truncate does not generate any rollback data, making it faster as it does not need to write deleted records into rollback. On the other hand, delete moves data out of the database instead of deleting it, which can be a slower process.

Rate this question:
8.

All of these are queries and commands on the DML part of SQL except__
- A.
  
  Select
- B.
  
  Update
- C.
  
  Drop table
- D.
  
  Delete
Correct Answer
C. Drop table

Explanation
The correct answer is "Drop table." The other options, Select, Update, and Delete, are all valid queries and commands in the Data Manipulation Language (DML) part of SQL. The Drop table command, on the other hand, is a Data Definition Language (DDL) command used to delete a table from the database.

Rate this question:
9.

In what objects are the data stored in RDBMS?
- A.
  
  Columns
- B.
  
  Tables
- C.
  
  Views
- D.
  
  Doc
Correct Answer
B. Tables

Explanation
In an RDBMS (Relational Database Management System), data is stored in tables. Tables consist of rows and columns, with each row representing a record and each column representing a specific attribute or field of the data. Tables provide a structured and organized way to store and retrieve data in a relational database.

Rate this question:
10.

What processe is used optimize databases to remove potential for redundancy?
- A.
  
  Nomination
- B.
  
  Normalization
- C.
  
  Nomination
- D.
  
  Notifystack
Correct Answer
A. Nomination

Explanation
Normalization is the process used to optimize databases and remove potential redundancy. It involves organizing data in a database to minimize duplication and improve efficiency. By breaking down data into smaller, logical units and eliminating redundant information, normalization helps to ensure data integrity and consistency. This process helps in reducing data redundancy, improving data consistency, and enhancing database performance.

Rate this question: