• ¿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 4 fuera de 66 páginas
Examen

WGU C170, Full Study Pack Latest Update

Document preview thumbnail
Vista previa 4 fuera de 66 páginas

WGU C170, Full Study Pack Latest Update WGU C170, Full Study Pack Latest Update

Vista previa del contenido

C170, WGU Full Study Pack
A salesperson is authorized to sell many products and a product can be sold by many salespersons.
Which kind of binary relationship does this scenario describe? - correct answers Many-to-many
Which two examples are attributes? - correct answers An employee number
A meeting code
Which delete rule sets column values in a child table to a missing value when the matching data is
deleted from the parent table? - correct answers Set-to-Null
member_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,
Which two columns are created as something other than variable-length strings in this statement? - correct answers member_id
expiration
This database table has ten different employee numbers in the first column. Employee_ID is the primary
C170, WGU Full Study Pack key. In addition, it has ten different names in the second column and two office addresses repeated five
times each in the third column.
Which action should be used to translate this data into third normal form? - correct answers Move the data from the third column into its own table.
A database manager starts to convert data that has been normalized into a form that conforms to the
relational model. A simple primary key has been established and all the repeating groups have been
deleted.
In which form is this data? - correct answers Second normal form
Two attributes in two related tables have the exact same domain of values. The attribute is a primary
key in one table.
Which kind of key is the attribute in the other table? - correct answers Foreign
SELECT PRODNUM, PRODNAME
FROM PRODUCT
Which line should be added to the end of the statement to return the product numbers and product
names for products that cost 20 dollars? - correct answers WHERE PRODCOST=20;
C170, WGU Full Study Pack What does WHERE identify in a basic SQL SELECT statement? - correct answers
The rows to be included
Refer to the given SQL statement.
SELECT EMPNUM
FROM EMPLOYEE
Which line added to the end of the statement returns employee numbers of at least 1000? - correct answers WHERE EMPNUM >= 1000;
SELECT PRODNUM, SUM(QUANTITY)
FROM SALESPERSON
Which line, when added to the end of the statement, returns the total number of each kind of product
by product number? - correct answers GROUP BY PRODNUM;
Which data definition language statement affects databases or objects in them? - correct answers ALTER
What does the DELETE statement do? - correct answers It removes rows from a table.
Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an INSERT statement? - correct answers The VALUES list must contain a value for each non-null valued column in the
table.
C170, WGU Full Study Pack CREATE TABLE mytbl
(
f FLOAT(10,4),
c CHAR(15) NOT NULL DEFAULT 'none',
i TINYINT UNSIGNED NULL
);
Which kind of data type is FLOAT in this statement? - correct answers Decimal
Which two SQL data types can represent images or sounds? - correct answers TINYBLOB
BINARY
CREATE TABLE CUSTOMER
(CustomerID INT NOT NULL AUTO_INCREMENT,
LastName VARCHAR(100) NOT NULL,
FirstName VARCHAR(100) NOT NULL,
PRIMARY KEY ( CustomerID ));
Which component of the command indicates the table's name? - correct answers CUSTOMER
Which method creates an empty copy of a table and then populates it from the original table? - correct answers CREATE TABLE ... LIKE followed by INSERT INTO ... SELECT :
ALTER TABLE tbl_name action [, action ] ... ;
C170, WGU Full Study Pack

Información del documento

Subido en
30 de mayo de 2023
Número de páginas
66
Escrito en
2022/2023
Tipo
Examen
Contiene
Preguntas y respuestas
$16.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.
Lectjosh
3.9
(13)
Vendido
88
Seguidores
68
Artículos
6002
Última venta
2 meses 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