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

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

Buy this Document to get the Full Access Instantly

Provided by Students Who Aced it

We Verify Document Content to Gurantee Accuracy

Buy Now

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 4 years ago

$13