D427 - Database Management Applications
Study online at https://quizlet.com/_e8n7eu
1. The definition of how data in a Schema
database will be organized.
2. The basis of interacting with data- - Create
bases can be defined using the - Read
CRUD acronym. What does CRUD - Update
stand for? - Delete
3. What is the DATE datatype syn- DATE: YYYY-MM-DD
tax?
DATETIME: YYYY-MM-DD HH:MM:SS
What is the DATETIME datatype
syntax?
4. What does DECIMAL(3,2) indicate? It will have 3 numbers before the decimal and 2 after.
5. a series of commands stored Stored Procedures
on the database. This allows the
reuse of long or detailed queries
instead of writing them for each
use. It also provides a safe way to
deal with sensitive data, especial-
ly with those unfamiliar with SQL
syntax.
6. involves instructing the DBMS Data definition language (DDL)
software on what tables will be in
the database, what attributes will
be in the tables, which attributes
will be indexed, and so forth.
7. refers to the four basic operations data manipulation languages (DMLs)
that can and must be performed
, D427 - Database Management Applications
Study online at https://quizlet.com/_e8n7eu
on data stored in any DBMS (or
in any other data storage arrange-
ment, for that matter): data re-
trieval, data update, insertion of
new records, and deletion of exist-
ing records.
8. What would the SELECT statement SELECT *
look like if you use a BETWEEN. FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;
9. What would the SELECT statement SELECT *
look like if you use a IN. FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
10. What would the SELECT statement SELECT *
look like if you use a LIKE. FROM CUSTOMER
WHERE HQCITY LIKE 'W%';
11. What are the two ways of using A% - The "%" means that any string of characters can
the LIKE command? follow afterwards. The percent sign represents zero or
more arbitrary regular characters
A_ - The _ means that there will be exactly one letter
following the A. The underscore represents a single ar-
bitrary regular character.
12. The default order for ORDER BY is The clause can include the term ASC at the end to make
ascending. How can you make it ascending explicit or it can include DESC for descending
descending order? order.
13.
, D427 - Database Management Applications
Study online at https://quizlet.com/_e8n7eu
Command to use SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
AVG/SUM/MIN/MAX/COUNT ag- FROM SALES
gregate functions? WHERE Name = 'Matt';
14. There are two specifications to o One is that the tables to be joined must be listed in the
make in the SELECT statement to FROM clause.
make a join work. o Two is that the join attributes in the tables being joined
must be declared and matched to each other in the
WHERE clause.
15. Example of JOIN CAUSE. SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM
16. In 1970, Dr. _________ of IBM pub- Dr. CODD
lished in Communications of the
ACM a paper entitled "A Relational
Model of Data for Large Shared
Data Banks." This paper marked
the beginning of the field of rela-
tional databases.
17. Commands to create and drop a CREATE TABLE
table?
DROP TABLE
18. The CREATE TABLE command lets - When you create the column definition (known as a
you define constraints in two dif- column constraint).
ferent places: - When you use the CONSTRAINT keyword (known as a
table constraint).
19. NOT
WHERE Location NOT IN ('WV', TN' 'CA');
Study online at https://quizlet.com/_e8n7eu
1. The definition of how data in a Schema
database will be organized.
2. The basis of interacting with data- - Create
bases can be defined using the - Read
CRUD acronym. What does CRUD - Update
stand for? - Delete
3. What is the DATE datatype syn- DATE: YYYY-MM-DD
tax?
DATETIME: YYYY-MM-DD HH:MM:SS
What is the DATETIME datatype
syntax?
4. What does DECIMAL(3,2) indicate? It will have 3 numbers before the decimal and 2 after.
5. a series of commands stored Stored Procedures
on the database. This allows the
reuse of long or detailed queries
instead of writing them for each
use. It also provides a safe way to
deal with sensitive data, especial-
ly with those unfamiliar with SQL
syntax.
6. involves instructing the DBMS Data definition language (DDL)
software on what tables will be in
the database, what attributes will
be in the tables, which attributes
will be indexed, and so forth.
7. refers to the four basic operations data manipulation languages (DMLs)
that can and must be performed
, D427 - Database Management Applications
Study online at https://quizlet.com/_e8n7eu
on data stored in any DBMS (or
in any other data storage arrange-
ment, for that matter): data re-
trieval, data update, insertion of
new records, and deletion of exist-
ing records.
8. What would the SELECT statement SELECT *
look like if you use a BETWEEN. FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;
9. What would the SELECT statement SELECT *
look like if you use a IN. FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
10. What would the SELECT statement SELECT *
look like if you use a LIKE. FROM CUSTOMER
WHERE HQCITY LIKE 'W%';
11. What are the two ways of using A% - The "%" means that any string of characters can
the LIKE command? follow afterwards. The percent sign represents zero or
more arbitrary regular characters
A_ - The _ means that there will be exactly one letter
following the A. The underscore represents a single ar-
bitrary regular character.
12. The default order for ORDER BY is The clause can include the term ASC at the end to make
ascending. How can you make it ascending explicit or it can include DESC for descending
descending order? order.
13.
, D427 - Database Management Applications
Study online at https://quizlet.com/_e8n7eu
Command to use SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
AVG/SUM/MIN/MAX/COUNT ag- FROM SALES
gregate functions? WHERE Name = 'Matt';
14. There are two specifications to o One is that the tables to be joined must be listed in the
make in the SELECT statement to FROM clause.
make a join work. o Two is that the join attributes in the tables being joined
must be declared and matched to each other in the
WHERE clause.
15. Example of JOIN CAUSE. SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM
16. In 1970, Dr. _________ of IBM pub- Dr. CODD
lished in Communications of the
ACM a paper entitled "A Relational
Model of Data for Large Shared
Data Banks." This paper marked
the beginning of the field of rela-
tional databases.
17. Commands to create and drop a CREATE TABLE
table?
DROP TABLE
18. The CREATE TABLE command lets - When you create the column definition (known as a
you define constraints in two dif- column constraint).
ferent places: - When you use the CONSTRAINT keyword (known as a
table constraint).
19. NOT
WHERE Location NOT IN ('WV', TN' 'CA');
