WGU D191 Exam With 100% Correct Answers 2023

WGU D191 Exam With 100% Correct Answers 2023 -d flag Specifies the database name in the psql command. -h flag Specifies the hostname of the database in the psql command. -p flag Specifies the database port in the psql command. ANALYZE command Collects statistics about tables and indices and stores them in internal tables. boolean A data type used to represent true or false. COPY command Transfers data from a database to a file, or from a file to a database. COUNT function Returns the number of rows without a NULL value in the column. cross join Returns every possible combination of rows from the first table and the second table. DISTINCT keyword Eliminates all the duplicate records and fetches only unique records. EXPLAIN command Displays the plan for a query before it is executed. FROM clause Specifies the database tables or views involved in the SELECT statement. GROUP BY clause Divides the rows of a dataset into multiple groups based on some sort of key. HAVING clause Enables a user to specify conditions that filter which group results appear in the output. inner join Selects all rows from both participating tables as long as there is a match between the columns. interquartile range Refers to the difference between the first quartile and the third quartile. JavaScript Object Notation An open standard text format for storing data of varying complexity. left outer join Returns all the records from the first table and only matching records from the second table. LIMIT clause Sets an upper limit on the number of tuples returned by SQL. n-quantiles A set of n-1 points used to divide a variable into n groups. ORDER BY keyword Sorts the rows and columns of the database table. OVER keyword Specifies the partitioning, ordering, and window on which the analytic function operates. PARTITION BY keyword Divides the result set into partitions and performs computation on each subset of the partitioned data. pg_cancel_backend command Causes the interpreter to end the query specified by the process ID (pid). pg_sleep command Allows the SQL interpreter to essentially do nothing for the next defined period of time. qualitative data The data that can be arranged categorically based on the attributes and properties of a thing. relational database A database that utilizes the relational model of data. right outer join Returns all records from the right table (table2), and the matched records from the left table (table1).