• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 5 páginas
Examen

Wgu C170 Complete Latest Basic Sql Based Questions And Answers

Document preview thumbnail
Vista previa 2 fuera de 5 páginas

WGU C170 COMPLETE LATEST BASIC SQL BASED QUESTIONS AND ANSWERS

Vista previa del contenido

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

Información del documento

Subido en
22 de abril de 2025
Número de páginas
5
Escrito en
2024/2025
Tipo
Examen
Contiene
Preguntas y respuestas
$12.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
EduSprint
3.9
(8)
Vendido
70
Seguidores
5
Artículos
7078
Última venta
3 días hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes