Intelligent SQL Subjective Assessment Test
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!
- 1.
SQL stands for__- A.
Structured query language
- B.
Software query language
- C.
Structured questionnaire language
- D.
Standard query language
- 2.
Which of these stores and manages SQL triggers?
- A.
Tables
- B.
Scala
- C.
Groovy
- D.
DMBS
- 3.
Data which are updated in a view are__ in a table
- A.
Cleaned
- B.
Deleted
- C.
Removed
- D.
Updated
- 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
- 5.
Which of these is a physical structure containing pointers to a data?
- A.
Insert
- B.
Views
- C.
Index
- D.
Table
- 6.
What are the two parts of SQL?
- A.
DML and DMBS
- B.
DMBS and DDL
- C.
DDL and DML
- D.
DML and JAVA
- 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
- 8.
All of these are queries and commands on the DML part of SQL except__
- A.
Select
- B.
Update
- C.
Drop table
- D.
Delete
- 9.
In what objects are the data stored in RDBMS?
- A.
Columns
- B.
Tables
- C.
Views
- D.
Doc
- 10.
What processe is used optimize databases to remove potential for redundancy?
- A.
Nomination
- B.
Normalization
- C.
Nomination
- D.
Notifystack
Questions: 42 | Attempts: 11025 | Last updated: Mar 22, 2022
-
Sample QuestionWhich SQL function is used to count the number of rows in a SQL query?
Questions: 23 | Attempts: 6050 | Last updated: May 10, 2022
-
Sample QuestionWhich SELECT statement should you use if you want to display unique combinations of thePOSITION and MANAGER values from the EMPLOYEE table?
Questions: 10 | Attempts: 3726 | Last updated: Mar 21, 2022
-
Sample QuestionWhen did SQL appear
Back to top