C170 - Data Management Applications V4.0 - Quiz 3 – WGU

Document Content and Description Below

C170 - Data Management Applications V4.0 - Quiz 3 – WGU If integer values are relatively small, what should be used instead of INT? Answer- SMALLINT What is the SQL command that allows a user to list the contents of a table? Answer- SELECT What is the process the DBMS uses to verify that only registered users access the database? Answer- Authentication What command is used to list the contents of a table? Answer- SELECT T/F ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause Answer- True Some RDBMSs automatically make the necessary conversions to eliminate case sensitivity. Answer- Fact What operator is used to check whether an attribute value lies within two bounds? Answer- BETWEEN What operation is performed when data are retrieved from more than one table at a time? Answer- Join The CHECK constraint checks that a specified condition exists. Answer- Fact What is the SQL function that gives the arithmetic mean for a specific column Answer- AVG The data type DATE stores the date in what format? Answer- Julian SQL commands can be inserted on a single line of multiple lines. Answer- Fact If a new column is added to a table that already has rows, the existing rows will default to a value of null for the new column Answer- Fact Most SQL implementations are case-sensitive Answer- Fact What is the SQL command that allows a user to permanently save data changes? Answer- COMMIT What command is used to delete an index? Answer- DROP INDEX 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- Fact What command deletes a table from a database? Answer- DROP TABLE What command lists all the contents of the PRODUCT table? Answer- SELECT * FROM PRODUCT The conditional LIKE should be used in conjunction with wildcard characters Answer- Fact What specification is used to avoid having duplicated values in a column? Answer- UNIQUE According to the rules of precedence, which of the following computations should be completed first? Answer- Performing operations within parentheses

[Show More]

Last updated: 3 years ago

Preview 1 out of 2 pages

Buy Now

Instant download

We Accept:

Preview image of C170 - Data Management Applications V4.0 - Quiz 3 – WGU document

Buy this document to get the full access instantly

Instant Download Access after purchase

Buy Now

Instant download

We Accept:

Report Copyright Violation

Also available in bundle (1)

Click Below to Access Bundle(s)

WGU C170 FULL SOLUTION PACK FLASHCARD(Over 12 different exams with complete solution)

C170 - Data Management Applications V4.0 - Quiz 3 - WGU WGU C170 - PRE-ASSESSMENT LATEST 2021 GRADED A+ Data Management Applications C170 with complete solution WGU C170 Terms With Complete Solution W...

By Nutmegs 3 years ago

$13