INF2603 FLASH CARDS EXAM
STUDY 2021
,3/26/2019 Basic SQL Flashcards | Quizlet
Basic SQL
43 terms slyfoxtoo
Terms in this set (43)
___ is the process the Authentication
DBMS uses to verify
that only registered
users access the
database.
Most SQL True
implementations yield
case-insensitive
searches.
True
False
A(n) ___ is a logical schema
group of database
objects, such as tables
and indexes, that are
related to each other.
If integer values are SMALLINT
relatively small, ___
must be used instead
of INT.
Using the ___ CREATE INDEX
command, SQL
indexes can be
https://quizlet.com/183228442/basic-sql-flash-cards/ 1/10
,3/26/2019 Basic SQL Flashcards | Quizlet
created on the basis of
any selected attribute.
Entity integrity is True
enforced automatically
when the primary key
is specified in the
CREATE TABLE
command sequence.
True
False
An alias is especially recursive
useful when a table
must be joined to itself
in a(n) ___ query.
The data format for CHAR and VARCHAR
SQL character is _____.
VARCHAR only
alphanumeric
CHAR only
CHAR and VARCHAR
DATE() and SYSDATE Oracle
are special functions
that return today s
date in MS Access and
___, respectively.
___ words are words Reserved
used by SQL to
perform specific
functions.
The ___ specification is UNIQUE
used to avoid having
duplicated values in a
column.
A(n) ___ , also known as subquery
a nested query or an
https://quizlet.com/183228442/basic-sql-flash-cards/ 2/10
, 3/26/2019 Basic SQL Flashcards | Quizlet
inner query, is a query
that is embedded (or
nested) inside another
query.
Which of the following SELECT DISTINCT V_CODE
queries is used to list a FROM PRODUCT;
unique value for
V_CODE, where the list
will produce only a list
of those values that
are different from one
another?
SELECT ONLY V_CODE
FROM PRODUCT;
SELECT UNIQUE
V_CODE
FROM PRODUCT;
SELECT DIFFERENT
V_CODE
FROM PRODUCT;
SELECT DISTINCT
V_CODE
FROM PRODUCT;
The SQL data restricts the selection of grouped rows based on a
manipulation condition.
command HAVING:
modifies an attribute's
values in one or more
table's rows.
groups the selected
rows based on one or
more attributes.
https://quizlet.com/183228442/basic-sql-flash-cards/ 3/10
STUDY 2021
,3/26/2019 Basic SQL Flashcards | Quizlet
Basic SQL
43 terms slyfoxtoo
Terms in this set (43)
___ is the process the Authentication
DBMS uses to verify
that only registered
users access the
database.
Most SQL True
implementations yield
case-insensitive
searches.
True
False
A(n) ___ is a logical schema
group of database
objects, such as tables
and indexes, that are
related to each other.
If integer values are SMALLINT
relatively small, ___
must be used instead
of INT.
Using the ___ CREATE INDEX
command, SQL
indexes can be
https://quizlet.com/183228442/basic-sql-flash-cards/ 1/10
,3/26/2019 Basic SQL Flashcards | Quizlet
created on the basis of
any selected attribute.
Entity integrity is True
enforced automatically
when the primary key
is specified in the
CREATE TABLE
command sequence.
True
False
An alias is especially recursive
useful when a table
must be joined to itself
in a(n) ___ query.
The data format for CHAR and VARCHAR
SQL character is _____.
VARCHAR only
alphanumeric
CHAR only
CHAR and VARCHAR
DATE() and SYSDATE Oracle
are special functions
that return today s
date in MS Access and
___, respectively.
___ words are words Reserved
used by SQL to
perform specific
functions.
The ___ specification is UNIQUE
used to avoid having
duplicated values in a
column.
A(n) ___ , also known as subquery
a nested query or an
https://quizlet.com/183228442/basic-sql-flash-cards/ 2/10
, 3/26/2019 Basic SQL Flashcards | Quizlet
inner query, is a query
that is embedded (or
nested) inside another
query.
Which of the following SELECT DISTINCT V_CODE
queries is used to list a FROM PRODUCT;
unique value for
V_CODE, where the list
will produce only a list
of those values that
are different from one
another?
SELECT ONLY V_CODE
FROM PRODUCT;
SELECT UNIQUE
V_CODE
FROM PRODUCT;
SELECT DIFFERENT
V_CODE
FROM PRODUCT;
SELECT DISTINCT
V_CODE
FROM PRODUCT;
The SQL data restricts the selection of grouped rows based on a
manipulation condition.
command HAVING:
modifies an attribute's
values in one or more
table's rows.
groups the selected
rows based on one or
more attributes.
https://quizlet.com/183228442/basic-sql-flash-cards/ 3/10
