Exam (elaborations)
INF2603 ALL CHAPTER STUDY FLASH CARDS FOR EXAM
- Institution
- University Of South Africa (Unisa)
INF2603 flash cards for all chapters to study for exam
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
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
Content preview
INF2603 FLASH CARDS EXAMSTUDY 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
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 EFT, 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 this summary 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 this summary for R50,00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53022 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now