DBMS 110 Final Exam Questions and Answers (verified answers)
1 view 0 purchase
Course
DBMS
Institution
DBMS
DBMS 110 Final Exam Questions and Answers (verified answers)
The _____ command defines a default value for a column when no value is given. -ANSW- DEFAULT
A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but als...
DBMS 110 Final Exam Questions and Answers
(verified answers)
The _____ command defines a default value for a column when no value is given. -
ANSW- DEFAULT
A(n) _____ join returns not only the rows matching the join condition (that is, rows with
matching values in the common columns) but also the rows with unmatched values. -
ANSW- outer
The conditional LIKE must be used in conjunction with wildcard characters. True or
False? -ANSW- True
You cannot insert a row containing a null attribute value using SQL. True or False? -
ANSW- False
The ANSI SQL standards are also accepted by the ISO. True or False? -ANSW- True
What type of command does this SQL statement use?
SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE=VENDOR. V_CODE -ANSW- old-style join
A(n) _____ is an alternate name given to a column or table in any SQL statement. -
ANSW- alias
Oracle users can use the Access QBE (query by example) query generator. True or
False? -ANSW- False
Comparison operators cannot be used to place restrictions on character-based
attributes. True or False? -ANSW- False
The COMMIT command does not permanently save all changes. In order to do that, you
must use SAVE. True or False? -ANSW- False
A(n) _____ join will select only the rows with matching values in the common
attribute(s). -ANSW- natural
Which query is used to list a unique value for V_CODE, where the list will produce only
a list of those values that are different from one another? -ANSW- SELECT DISTINCT
V_CODE
, FROM PRODUCT;
The SQL aggregate function that gives the number of rows containing non-null values
for a given column is _____. -ANSW- COUNT
String comparisons are made from left to right. True or False? -ANSW- True
According to the rules of precedence, which of the following computations should be
completed first? -ANSW- Operations within parentheses
The special operator used to check whether an attribute value matches a given string
pattern is _____. -ANSW- LIKE
How many rows would be returned from a cross join of tables A and B, if A contains 8
rows and B contains 18? -ANSW- 144
If a designer wishes to create an inner join, but the two tables do not have a commonly
named attribute, he can use a(n) _____ clause. -ANSW- JOIN ON
An alias cannot be used when a table is required to be joined to itself in a recursive
query. True or False? -ANSW- False
The SQL command that allows a user to permanently save data changes is _____. -
ANSW- COMMIT
Which comparison operator indicates a value is not equal? -ANSW- < >
Numeric functions take one numeric parameter and return one value. True or False? -
ANSW- True
All SQL commands must be issued on a single line. True or False? -ANSW- False
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
True or False? -ANSW- True
The COUNT function is designed to tally the number of non-null "values" of an attribute,
and is often used in conjunction with the DISTINCT clause. True or False? -ANSW-
True
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE
clause. True or False? -ANSW- True
The benefits of the web as a data access platform arise from its cross-platform
functionality and the simplicity of its interface. True or False? -ANSW- True
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 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 smartchoices. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
