C170 - Data Management Applications V4.0 - Quiz 3 – WGU, Graded A+

C170 - Data Management Applications V4.0 - Quiz 3 – WGU, Graded A+ 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? AnswerAuthentication 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 Show Less