WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150 QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED

WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150 QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED What are the two ways of using the LIKE command? - ...ANSWER... A% - The "%" means that any string of characters can follow afterwards. The percent sign represents zero or more arbitrary regular characters A_ - The _ means that there will be exac tly one letter following the A. The underscore represents a single arbitrary regular character. The default order for ORDER BY is ascending. How can you make it descending order? - ...ANSWER... The clause can include the term ASC at the end to make ascendi ng explicit or it can include DESC for descending order. Command to use AVG/SUM/MIN/MAX/COUNT aggregate functions? - ...ANSWER... SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name) FROM SALES WHERE Name = 'Matt'; There are two specifications to make in the SELECT statement to make a join work. - ...ANSWER... o One is that the tables to be joined must be listed in the FROM clause. o Two is that the join attributes in the tables being joined must be declared and match ed to each other in the WHERE clause. Example of JOIN CAUSE. - ...ANSWER...SELECT SPNAME FROM SALESPERSON, CUSTOMER WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM In 1970, Dr. _________ of IBM published in Communications of the ACM a paper entitled "A Relational Model of Data for Large Shared Data Banks." This paper marked the beginning of the field of relational databases. - ...ANSWER... Dr. CODD Commands to create and drop a table? - ...ANSWER... CREATE TABLE DROP TABLE The CREATE TABLE command lets you define constraints in two different places: - ...ANSWER... - When you create the column definition (known as a column constraint). - When you use the CONSTRAINT keyword (known as a table constraint). You can exclude rows with other types of conditions by using t he ______ operator. - ...ANSWER... NOT WHERE Location NOT IN ('WV', TN' 'CA'); WHERE Total NOT Between '1000', 2000'; WHERE Name NOT LIKE 'Ma%'; The _____ command tells the database system which database you're going to be using for the upcoming command s. - ...ANSWER... USE USE MainDatabase You can use the _______ statement to provide specified information about a database. - ...ANSWER... SHOW SHOW DATABASES - lists all databases in the database system instance. SHOW TABLES - lists all tables in the default database. SHOW COLUMNS FROM TableName - lists all columns in the TableName table of the default database. SHOW CREATE TABLE TableName - shows the CREATE TABLE statement for the TableName table of the default da tabase. The ALTAR Table adds, deletes, or modifies columns. What is the syntax for each of these? - ...ANSWER... ALTAR TABLE TableName