Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

26 Cards in this Set

  • Front
  • Back
What statement is used to query the database and retrieve selected data that match the criteria that you specify?
When matching strings with Like the comparision values must be show how?
Strings must be in single quotes.
What are the rules for table names?
They must start with a letter and can be followed by letters, numbers, or underscores - not to exceed a total of 30 characters in length. Do not use any SQL reserved keywords as names for tables or column names (such as "select", "create", "insert", etc).
Data type holds number value with a max number of column digits specified in parenthesis.
What is a "unique" constraint"?
It specifies that no two records can have the same value in a particular column.
What is the syntax for the insert statement?
insert into "tablename"
values (first_value,...last_value);
The table name that follows the _____ keyword from specifies the table that will be queried to retrieve the desired results.
To make a new table what SQl statment is used?
create table
Name all SQL data types.
Data type holds a date value.
The two most popular constraints are what?
not null" which specifies that a column can't be left blank, and "primary key". A "primary key" constraint defines a unique identification of each record (or row) in a table.
The _____ clause (optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword.
The ____ pattern matching operator can also be used in the conditional selection of the where clause. It is a very powerful operator that allows you to select only rows that are the same as what you specify.
What is the syntax of the Create Table statement?
create table "tablename"
("column1" "data type",
"column2" "data type",
"column3" "data type");
Variable type holds fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
Data type holds number value with a maximum number of digits of "size" total, with a maximum number of "d" digits to the right of the decimal.
The ____ statement is used to insert or add a row of data into the table.
When inserting new records into the database what are the rules for how the actual values to be inserted to should handled?
Strings should be enclosed in single quotes, and numbers should not.
What are the conditional selections used in the where clause
= Equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
<> Not equal to
The ____ can be used as a wild card to match any possible character that might appear before or after the characters specified.
percent sign "%"
What are optional in the Create Table statement?
Data type holds variable-length character string. Max size is specified in parenthesis.
What are constraints?
When tables are created, it is common for one or more columns to have ___ associated with them. A _____is basically a rule associated with a column that the data entered into that column must follow.
To insert records into a table, enter the key words ____ followed by the table name.
insert into
The ___ statement is used to update or change records that match a specified criteria. This is accomplished by carefully constructing a where clause.
What is the syntax for the Update statement?
update "tablename"
set "columnname" =
[,"nextcolumn" =
where "columnname"
OPERATOR "value"
[and|or "column"
OPERATOR "value"];

[] = optional