stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
SQL Assessment: MTG Data Analytics Bootcamp Flashcards | StudBud
Explore
/
SQL Assessment: MTG Data Analytics Bootcamp
SQL Assessment: MTG Data Analytics Bootcamp
18 terms
·
StudBud Administration
·
5 plays
Let this quiz inspire your own quiz for formative assessment.
Flashcards
18 cards
F
Practice quiz
P
Host live
L
Questions
18
Answers
1
BANANA falls under what data type
date
decimal
varchar
Integer
2
What is a primary key in PostgreSQL?
A constraint that allows NULL values in a column.
A constraint that ensures each row in a table is unique
A column that can store both numeric and string values.
A column that stores only unique integer values
3
What command is used to create a new database in PostgreSQL?
NEW DATABASE
ADD DATABASE
CREATE DATABASE
INSERT DATABASE
4
A primary key accept duplicate data
True
False
5
Which language is commonly used to interact with a Database?
Python
Ruby
Java
SQL
6
What is a database?
where we keep information
where we find information
all of the above
where we organise information
7
What is the purpose of the ORDER BY clause in a SQL query?.
It joins multiple tables together.
It specifies which columns to display in the result.
It filters the results based on a condition.
It sorts the results in a specified order.
8
DATE is a type of data
False
True
9
Foriegn key allowed to have duplicate information and data
True
False
10
SQL means
Structured Question Language
Structured Query Laegue
Stored Query Language
Structured Query Language
11
Which of the following is NOT a valid data type in PostgreSQL?
String
Date
Interger
Decimal
12
TIME is a data type
True
False
13
Primary Key has unique values
True
False
14
Which SQL command is used to retrieve data from a table in PostgreSQL?
SELECT
GET
SEARCH
FETCH
15
NAME is a varchar
False
True
16
23.24km is what data type
date
integer
decimal
varchar
17
ERD means
Enternity Relationship Diagram
Entity Relation Diagram
Entity Relative Diagram
Entity Relationship Diagram
18
What is PostgreSQL?
A relational database management system
A programming language
A web development framework
A version control system
