Question 1:
The SQL command that causes a table to be built in a database is ______,
make table
select table
build table
create table
Question 2
The SQL command that returns how many records are in a set of data without displaying any data is _____.
tabulate
select count(*)
sum product(*)
return count(*)
Question 3
The SQL command that removes a table from the database is ____.
delete table
drop table
remove table
destroy table
Question 4
The SQL command that causes a series of SQL manipulations to be applied to the database permanently is ______.
permanence
make it so
apply
Commit
Question 5
The SQL command that backs out database changes that have not yet been made permanent is _____.
deselect
undo
rollback
do over
Question 6
The SQL command used to add or change data in a table is ____.
modify
change
update
alter
Question 7
The SQL command used to change the design of a table is _____.
change
update
modify
alter
Question 8
The SQL command used to add data records to a table is _____.
include
add record
insert
new record
Question 9
The characters "*", "%", and "_", when used in a query, are called ____
ASCII characters
special characters
symbols
wildcard characters
Question 10
The SQL command to remove (a) record(s) from a table is _____.
eliiminate row
remove
delete
drop
Question 11
SQL stands for _______.
select query language
system query level
structured query language
system query language
Question 12
The SQL statement used to arrange the output of a query in alphabetical order is _______.
arrange ascending
sort ascending
order by descending
order by ascending
Question 13
When designing a database, if you have two tables with a many-to-many relationship with one another, it is a best practice to insert a _____ between them to mitigate the relationship.
data stint
bridge entity
divider
cardinality mark
Question 14
ERD is an acronym for ________.
entity relational database
entity reserved database
entity relationship diagram
enterprise resource database
Question 15
In an ERD, a displayed property that assigns a specific value to the range of allowed entity occurrences associated with a single occurrence of a related entity is _________.
relationship
cardinality
one-to-many
many-to-one
Question 16
In SQL, a question or task asked by an end user of a database is called a _____.
query
action
update
Request
Question 17
In SQL, a type of operation used to yield results from two different tables based on specified criteria is called a _______.
blend
query
join
select statement
Question 18
What is a NULL in a database?
A blank field
A field with a very low value
The absence of a value
A field that has been deleted
Question 19
What clause would you add to an SQL query if the result would yield duplicate values, and you wanted only one instance of each unique value to be returned?
distinct
redundant
unique
no duplicates
Question 20
In the following statement to create a table, what values can be stored in the P-CODE field:
CREATE TABLE PRODUCT (
P-CODE VARCHAR(10) NOT NULL,
P-DESCRIPT VARCHAR(35),
P_PRICE NUMBER(8,2) );
characters and numbers
numbers only
variable characters only
characters only
Question 21
In the following statement to create a table, what does the number after the comma signify for the P-PRICE field?
CREATE TABLE PRODUCT (
P-CODE VARCHAR(10) NOT NULL,
P-DESCRIPT VARCHAR(35),
P_PRICE NUMBER(8,2) );
the number of decimal places stored
the actual data for that field
the second dimension of an array
the total numbers that can be stored