Basic DB
Intro to SQL
Queries
SQL-Server Management Studio
Wild Card
100
Two-dimensional structure with rows and columns.
What is a table?
100
The SQL statements that define the database.
What is DDL?
100
Specifies how data is sorted in a results set.
What is the ORDER BY clause?
100
Specify the database in the dropdown in SQL-Server Management Studio or use the 'Use database' syntax.
How do you specify the database that you are using for a query?
100
[Name with space]
What is the syntax to identify a field-name that includes a space?
200
This uniquely identifies a row in a table.
What is a primary key?
200
Define what data looks like and how it can be used.
What is a data type?
200
In a SQL query, specifies the table that data is selected from.
What is the FROM clause?
200
A tool that 'helps' you write queries.
What is the query design window?
200
'Invented' the relational database.
Who is E.F. Codd?
300
A type of database that 'relates' tables to each other.
What is a relational database
300
a virtual table
What is a view.
300
Selects everything from the Personnel table.
What does the following query do? SELECT * FROM Personnel;
300
Right click on a SQL-Server object.
Hw can you easily perform a variety of functions in SQL-Server Management Studio?
300
NOT AND OR
What is the order of operations for compound WHERE statements?
400
Contains the smallest unit of meaningful information in a row/record.
What is a field?
400
The subset of SQL used to select and update the data in a database.
What is DML?
400
Allows you to specify pattern matches for data retrieval values.
What does IN allow you to do in SQL?
400
TEMPDB
Which of the system databases is used by SQL-Server as a temporary workspace?
400
Use the syntax /* */ or --
How do you add comments to SQL?
500
Processing is divided between client and server.
What is a client-server system?
500
SQL-Server dialect.
What is Transact-SQL (T-SQL)?
500
WHERE Weight is between 2000 and 3000 OR Where Weight is > 1999 and < 3001 OR WHERE Weight is >= to 2000 and <=3000
What WHERE clause will select weight values between 2000 and 3000?
500
Click the 'EXECUTE' command on the toolbar.
How do you 'run' a SQL Query?
500
* % _
What are wild card characters in SQL?
M
e
n
u