Intelligent SQL Subjective Assessment Test
Here you 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!
- 1.
![SQL stands for__ - ProProfs]( "SQL stands for__")
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? - ProProfs]( "Which of these stores and manages SQL triggers?")
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 - ProProfs]( "Data which are updated in a view are__ in a table")
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? - ProProfs]( "Which of the following is not true?")
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? - ProProfs]( "Which of these is a physical structure containing pointers to a data?")
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? - ProProfs]( "What are the two parts of SQL?")
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 - ProProfs]( "Why is truncate faster than delete in SQL? Because")
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__ - ProProfs]( "All of these are queries and commands on the DML part of SQL except__")
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? - ProProfs]( "In what objects are the data stored in RDBMS?")
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? - ProProfs]( "What processe is used optimize databases to remove potential for redundancy?")
What processe is used optimize databases to remove potential for redundancy?- A.
Nomination
- B.
Normalization
- C.
Nomination
- D.
Notifystack
Questions: 42 | Attempts: 9018 | Last updated: Mar 19, 2021
-
Sample QuestionWhich SQL function is used to count the number of rows in a SQL query?
Questions: 10 | Attempts: 3515 | Last updated: Mar 2, 2019
-
Sample QuestionWhen did SQL appear
Questions: 26 | Attempts: 2578 | Last updated: Jan 24, 2013
-
Sample QuestionWhich SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?
Back to top