• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 5 pages
Exam (elaborations)

Wgu C170 Complete Latest Basic Sql Based Questions And Answers

Document preview thumbnail
Preview 2 out of 5 pages

WGU C170 COMPLETE LATEST BASIC SQL BASED QUESTIONS AND ANSWERS

Content preview

WGU C170 COMPLETE LATEST BASIC
SQL BASED QUESTIONS AND
ANSWERS
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. -
ANSWER-recursive
The ___________ condition is generally composed of an equality comparison between the foreign key
and the primary key of related tables. - ANSWER-join
A database language enables the user to create database and table structures to perform basic data
management chores. - ANSWER-TRUE
______________________ is the process the DBMS uses to verify that only registered users access the
database. - ANSWER-Authentication
Only numeric data types can be added and subtracted in SQL. - ANSWER-FALSE
A table can be deleted from the database by using the _______________________ command. -
ANSWER-DROP TABLE
To list all the contents of the PRODUCT table, a user would use ________________________________ -
ANSWER-SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. - ANSWER-FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. - ANSWER-
FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query. - ANSWER-
subquery
"The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,
V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE
match is ________________________________________________ - ANSWER-"SELECT P_DESCRIPT,
P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE
PRODUCT.V_CODE = VENDOR.V_CODE;"
In the SQL environment, the word ___________ covers both questions and actions. - ANSWER-query
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is
_______ - ANSWER-SUM
String comparisons are made from left to right. - ANSWER-TRUE
Date procedures are often more software-specific than other SQL procedures. - ANSWER-TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in a
_____________ statement. - ANSWER-SELECT
A(n) _________________ order sequence is a multilevel ordered sequence that can be created easily by
listing several attributes, separated by commas, after the ORDER BY clause. - ANSWER-cascading
Data type selection is usually dictated by the nature of the data and by the intended use. - ANSWER-
TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07. - ANSWER-
FALSE
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. - ANSWER-TRUE
Which of the following queries will use the given columns and column aliases from the PRODUCT table
to determine the total value of inventory held on hand? - ANSWER-"SELECT P_DESCRIPT, P_QOH,
P_PRICE, P_QOH*P_PRICE FROM PRODUCT;"

, A database language enables the user to perform complex queries designed to transform the raw data
into useful information. - ANSWER-TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively. - ANSWER-Oracle
Which of the following queries will output the table contents when the value of the character field
P_CODE is alphabetically less than 1558-QW1? - ANSWER-"SELECT P_CODE, P_DESCRIPT, P_QOH,
P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';"
The ____________________ command is used to restore the database to its previous condition. -
ANSWER-ROLLBACK;
According to the rules of precedence, which of the following computations should be completed first? -
ANSWER-Performing operations within parentheses
Which of the following queries will output the table contents when the value of V_CODE is equal to
21344? - ANSWER-"SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE
= 21344;"
Using the _____________________________ command, SQL indexes can be created on the basis of any
selected attribute. - ANSWER-CREATE INDEX
A specialty field in mathematics, known as ________________ algebra, is dedicated to the use of logical
operators. - ANSWER-Boolean
"The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table
in ascending order by P_PRICE is ___________________________________________________" -
ANSWER-"SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;"
Most SQL implementations yield case-insensitive searches. - ANSWER-FALSE
The _____________ constraint assigns a value to an attribute when a new row is added to a table. -
ANSWER-DEFAULT
The SQL data manipulation command HAVING:
______________________________________________________. - ANSWER-restricts the selection of
grouped rows based on a condition.
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. - ANSWER-
TRUE
The basic SQL vocabulary has fewer than ______ words. - ANSWER-100
The special operator used to check whether an attribute value is within a range of values is
____________ - ANSWER-BETWEEN
"The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial
is __________________________________________________ - ANSWER-"SELECT EMP_LNAME,
EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME,
EMP_FNAME, EMP_INITIAL;"
In a 1:M relationship, a user must always create the table for the ___ side first. - ANSWER-1
A table can be deleted from the database by using the ___________________________ command. -
ANSWER-DROP TABLE
Which of the following queries will list all the rows in which the inventory stock dates occur on or after
January 20, 2010? - ANSWER-"SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= '20-JAN-2010';"
To remove a row from the PRODUCT table, one must use the ___________________ command. -
ANSWER-DELETE
When a user issues the DELETE FROM tablename command without specifying a WHERE condition,
__________________________. - ANSWER-all rows will be deleted

Document information

Uploaded on
April 22, 2025
Number of pages
5
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$12.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
EduSprint
3.9
(8)
Sold
70
Followers
5
Items
7078
Last sold
3 days ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions