organize and visualize the contents of a database while following some standard
rules that facilitate fast response between the database and the user side.
After getting introduced to the concept of data, databases, and DBMS/RDBMS, we
can finally get introduced to SQL. SQL or Structured Query Language is basically
the language that we (the user) use to communicate with the Databases and get
our required interpretation of data out of it. It is used for storing, manipulating, and
retrieving data out of a database.
SQL Features
SQL allows us to interact with the databases and bring out/manipulate data within
it. Using SQL, we can create our own databases and then add data into these
databases in the form of tables.
The following functionalities can be performed on a database using SQL:
Create or Delete a Database.
Create or Alter or Delete some tables in a Database.
SELECT data from tables.
INSERT data into tables.
UPDATE data in tables.
DELETE data from tables.
Create Views in the database.
Execute various aggregate functions.
Useful Resources
DBMS Interview
SQL Cheat Sheet
SQL Queries
Database Testing
Complete Technical Interview Guide
SQL Books
SQL Projects
SQL IDEs
SQL Commands
Learn SQL
SQL MCQs
Events|Powered By
Software Dev
Data Science
All Events
Multi-threading & Concurrency using Java
Starts on: 08:00 PM, 13 April 2023 (IST)
5227 Registered
Know More
Register Now
Behavioural Round Interviews in Tech
Starts on: 07:00 PM, 14 April 2023 (IST)
215 Registered
Know More
Register Now
Roadmap to a Data-Engineering role
Starts on: 05:00 PM, 16 April 2023 (IST)
1214 Registered
Know More
Register Now
Building scalable systems using Docker & Kubernetes
Starts on: 08:00 PM, 18 April 2023 (IST)
6027 Registered
Know More
Register Now
Low Level Design of Payment apps
Starts on: 08:00 PM, 20 April 2023 (IST)
1011 Registered
Know More
Register Now
System Design of Real-Time Stock Market Trading Platforms
Starts on: 05:00 PM, 23 April 2023 (IST)
42 Registered
Know More
Register Now
View All
1.
Which of the following are some common RDBMS in use?
Oracle
MySQL
HeidiSQL
All of the above
Check Answer
2.
What command is used to create a new table in SQL?
CREATE TABLE
BUILD TABLE
GENERATE TABLE
None of the above
Check Answer
3.
What does the following statement in SQL do?
DROP TABLE student;
Deletes a table called student.
Creates a table called student.
Check if there is a table called student.
None of the above.
Check Answer
4.
Which of the following are types of Unicode character string types in SQL?
nchar
ntext
Both A and B
None of the above
Check Answer
5.
What does BLOB in SQL stand for?
Binary Large Objects
Big Large Objects
Binary Language for Objects
None of the above
Check Answer
6.
Which of the following datatype is most appropriate for storing a string of up to
255 characters?
TEXT
TINY TEXT
BLOB
BINARY
Check Answer
