SQL Basics
A systematic storage of related or closely-related information.
What is a database?
The default file exention for Databases assigned by SQLite
What is .db?
The SQL command used to insert data into a give table WITHOUT ALTERING the table columns themself?
What is INSERT INTO?
A programming language that allows users to interact with and manage relational databases
What is Structured Query Language (SQL)?
The NULL value is a ____, but not a _____.
What is SQLite Storage class, SQL data type?
The default file extention for PROJECTS assigned by SQLite
What is .sqbpro?
The data type most suitable for use with Primary Keys?
What is Integer data type?
Software systems used to store, retrieve, and run queries on data
What is a Relational Database Management Systems (RDBMS)?
Would be the data type to store 00005 while ensuring all digits are maintained?
The required file extension when importing tables from Excel files into CSV Files
What is Comma Separated Value Files (.csv)?
The statement is used to return only distinct (different) values from a table.
What is the SELECT DISTINCT function?
SQLite is an example of a ____ flavor of SQL. Oracle is an example of a ____ flavor of SQL.
What is open source and commercial?
The BLOB Storage Class can hold up to how many bytes of data?
What is up to 65,535 bytes of data?
Saves changes made to a Database File using the ___ command, saves changes made to a Project File using the ___ command, saves changes made to all open Database/Project Files using the ___ command
What is Write Changes, Save Project, Save All?
The IN statement is most commonly used in conjunction with what this statement (and it's negative)
What is WHERE/WHERE NOT?
When importing data, selecting the wrong ___ can often lead to improperly formatted data (data that's stuck together, etc.)
What is delimiter?
The five storage classes used in SQLite
What is Null, Integer, Real, Text, and Blob?
While in DB Browser, to export the results of a SQL query to csv, one must select this option from the taskbar in the "Execute SQL" tab?
What is "Save the Results View"?
The _____ is used when you want to return only records having pair on both sides, and you’ll use _____ when you need all records from the first table called in the statement, no matter if they have pair in the “right” table or not.
What is INNER JOIN, LEFT JOIN?