Try the fastest way to create flashcards

SQL

5.0 (1 review)
Get a hint
What is SQL?
Click the card to flip 👆
1 / 253
1 / 253

Students also viewed

SQL
Teacher168 terms
Profile Picture
Veronika_Delvaux
Chapter 3
15 terms
Profile Picture
Hshdhdhdhdc
SQL
Teacher78 terms
Profile Picture
Kyle_Morrow9
Week 3 5.4.3 Configure a RAID Array
14 terms
Profile Picture
Just_Johnny3
SQL Commands
Teacher34 terms
Profile Picture
bo_sun_choi
APCSP 123321
38 terms
Profile Picture
JONATHANWALKER123
General MLE
271 terms
Profile Picture
ds_get_even
AWS Security
15 terms
Profile Picture
idontknow8744
NEW Comptia 3.1 Troubleshooting solutions p3
16 terms
Profile Picture
Shiphrah17
CS-041 Final Study Guide
66 terms
Profile Picture
abrarihtiram
Introduction to Coding
Teacher26 terms
Profile Picture
Cari_Chapman9
Quiz 6: Unit 5
10 terms
Profile Picture
ldburleson3
Terms in this set (253)
What is SQL?
SQL stands for Structured Query Language. SQL lets you access and manipulate databases.
What can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
Can SQL retrieve data from a database?
Yes, SQL can retrieve data from a database
Can SQL execute queries against a database?
Yes, SQL can execute queries against a database
Can SQL can insert records in a database?
Yes, SQL can insert records in a database
Can SQL update records in a database?
Yes, SQL can update records in a database
Can SQL delete records from a database?
Yes, SQL can delete records from a database
Can SQL create new databases?
Yes, SQL can create new databases
Can SQL create new tables in a database?
Yes, SQL can create new tables in a database
Can SQL create stored procedures in a database?
Yes, SQL can create stored procedures in a database
Can SQL create views in a database?
Yes, SQL can create views in a database
Can SQL set permissions on tables, procedures, and views?
Yes, SQL can set permissions on tables, procedures, and views
What is RDBMS?
RDBMS stands for Relational Database Management System.
What is the Basis of SQL?
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
Where is the data stored in RDBMS?
The data in RDBMS is stored in database objects called tables.