TEST BANK FOR Database Systems Design, Implementation, & Management 13th Edition By Coronel and Morris
Exam (elaborations) TEST BANK FOR Database Systems Design, Implementation, & Management 13th Edition By Coronel and Morris
INF2603 EXAM PACK 2024
All for this textbook (7)
Written for
University of South Africa (Unisa)
INF2603 - Databases I (INF2603)
All documents for this subject (41)
4
reviews
By: lindiswagum41 • 1 year ago
By: johan449 • 3 year ago
Just a printout of Quizlet website
By: stormwilliams • 1 year ago
By: coetzeelanie • 2 year ago
Seller
Follow
StudyNotes20
Reviews received
Content preview
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.
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StudyNotes20. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.75. You're not tied to anything after your purchase.