WGU D311 MICROBIOLOGY OBJECTIVE ASSESSMENT PRACTICE EXAM QUESTIONS WITH CORRECT DETAILED ANSWERS | ALREADY GRADED A+<RECENT VERSION>

WGU D311 MICROBIOLOGY OBJECTIVE ASSESSMENT PRACTICE EXAM QUESTIONS WITH CORRECT DETAILED ANSWERS | ALREADY GRADED A+&lt;RECENT VERSION&gt; 1) prokaryotic cell - ANSWER lacks a nucleus and membrane bound organelles 2) MySQL - ANSWER 'World' database, a database that is usually installed with ______. 3) Error Code - ANSWER MySQL Server returns an _____ ____ and description when an SQL statement is syntactically incorrect or the database cannot execute the statement. 4) Database Model - ANSWER Data structures that prescribe how data is organized. Operations that manipulate data structures. Rules that govern valid data. 5) Tuple - ANSWER An ORDERED collection of elements enclosed in parentheses. 6) Table - ANSWER A _____ has a name, a fixed tuple of columns, and a varying set of rows. 7) Column - ANSWER A ______ has a name and a data type. 8) Row - ANSWER Is an unnamed tuple of values. Each value corresponds to a column and belongs to the column's data type. 9) Data Type - ANSWER A ____ _____ is a named set of values, from which column values are drawn. 10) Union - ANSWER Selects all rows of two tables. 11) Aggregate - ANSWER Computes functions over multiple table rows, such as sum and count. 12) Relational Rules - ANSWER Rules that are logical constraints and ensure data is valid. 13) The standard language for Relational Databases... - ANSWER SQL is the standard language for relational databases, and is commonly supported in non-relational databases. 14) Literals (SQL Syntax) - ANSWER Explicit values that are string, numeric, or binary. Strings must be surrounded by single quotes or double quotes. Binary values are represented with x'0' where the 0 is any hex value. 15) Keywords (SQL Syntax) - ANSWER Words with special meaning. ex. SELECT, FROM, WHERE 16) Identifiers (SQL Syntax) - ANSWER Objects from the database like tables, columns, etc. ex. City, Name, Population 17) SQL Sublanguages - ANSWER Data Definition Language (DDL) defines the structure of the database. Data Query Language (DQL) retrieves data from the database. Data Manipulation Language (DML) manipulates data stored in a database. Data Control Language (DCL) controls database user access. Data Transaction Language (DTL) manages database transactions. 18) Cell - ANSWER A single column of a single row. 19) Not Ordered - ANSWER Rows 20) Data Independence - ANSWER Rule 7. Allows database administrators to improve query performance by changing the organization of data on storage devices, without affecting query results. 21) DROP TABLE - ANSWER Statement that deletes a table, along with all the table's rows, from a database. 22) ALTER TABLE - ANSWER Statement that adds, deletes, or modifies columns on an existing table. 23) INT - ANSWER 4 bytes 24) SMALLINT - ANSWER 2 bytes 25) BIGINT - ANSWER 8 bytes 26) TINYINT - ANSWER 1 byte 27) MEDIUMINT - ANSWER 3 bytes 28) % (Modulo) - ANSWER Divides one numeric value by another and returns the integer remainder 29) ^ - ANSWER Raises one numeric value to the power of another. 30) = - ANSWER Compares two values for equality. 31) != - ANSWER Compares two values for inequality. 32) NULL - ANSWER A special value that represents either unknown or inapplicable data. 33) INSERT Statement (Clauses) - ANSWER INTO clause names the table and columns where data is to be added. The keyword INTO is optional. VALUES clause specifies the column values to be added. 34) INSERT Statement (Syntax) - ANSWER INSERT [INTO] TableName (Column1, Column2, ...)VALUES (Value1, Value2, ...); 35) UPDATE Statement (Clauses) - ANSWER Uses the SET clause to specify the new column values. An optional WHERE clause specifies which rows are updated. Omitting the WHERE clause results in all rows being updated. 36) DELETE Statement (Keywords/Clauses) - ANSWER The FROM keyword is followed by the table name whose rows are to be deleted. An optional WHERE clause specifies which rows should be deleted. Omitting the WHERE clause results in all rows in the table being deleted. 37) TRUNCATE Statement - ANSWER Deletes all rows from a table.