stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Introduction to SQL Flashcards | StudBud
Explore
/
Introduction to SQL
Introduction to SQL
15 terms
·
StudBud Administration
·
52 plays
#SQL
Flashcards
15 cards
F
Practice quiz
P
Host live
L
Questions
15
Answers
1
Which SQL version is used primarily by banks?
Oracle
SQLite
SQL Server
MySQL
2
What keyword is used in an SQL statement to fetch data from a DB?
Search
Select
Fetch
Retrive
3
Which is the most popular SQL version for web development?
MySQL
Oracle
SQLite
SQL Server
4
What keyword is used to join rows from other tables if the condition is TRUE?
True Join
Inner Join
Row Join
Outer Join
5
What keyword is used to collaborate with 'SELECT' to arrange identical data into groups?
Group By
Outer Join
Join Select
Inner Join
6
____ specifies conditions on which rows should be selected based on the conditions you specify.
Group By
True
This
Having
7
Which frameworks utilise SQL?
web development
databases
Physical Computing
Web and databases
8
What is a benefit of SQLite?
It is lite
When the query is found, it lights up
It is able to store an entire database in a single file.
It is not dependant on the RDBMS
9
What is SQL?
Structured Query Language
Sequel
Smooth Quantum Language
Some Quatifiable Language
10
What SQL version is a popular choice for phones, MP3 players, etc?
SQL Server
Oracle
SQLite
MySQL
11
What keyword is used to create a new table?
Create Table
Create
Set Table
Table Create
12
What SQL keyword filters the result to include only rows where the following
condition
is true?
Filter This
Filter
Only
Where
13
Which keyword is used to combine two conditions, producing a result only if both are true?
From
Real
True True
And
14
What is Structured Query Language?
A language to manage data stored in a RDMS
A language to structure data types
A query option for programming languages
A programming language for databases
15
Which SQL version is used primarily for Windows operating systems?
SQLite
Oracle
SQL Server
MySQL
