CIT 225 Final Exam Study Guide

The ____ JOIN returns all rows from the table on the left side of the join and only the rows that meet the join condition on the right side of the join. - Answer- LEFT Microsoft's "Active Directory" is a network database system. - Answer- FALSE The roots of SQL go all the way back to the 1970s. - Answer- TRUE SQL was initially created to be the language for which tasks involving data? - Answer- Generating, Manipulating, and Retrieving Data The following command creates a table named "test": CREATE TABLE test (test_id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,test_name VARCHAR(20)); - Answer- TRUE Relational databases always report how many rows you insert, update, or delete. - Answer- TRUE "Apache Directory Server" is a hierarchical database system. - Answer- TRUE The American National Standards Institute (ANSI) established SQL standards in which years? - Answer- 1986, 1992, 2016 A SELECT statement retrieves data. - Answer- TRUE SQL has been evolving to retrieve data from which sources? - Answer- Table, documents, flat file A modern "database system" can manage many gigabytes of data. - Answer- TRUE What syntax is used to create a temporary table? - Answer- CREATE TEMPORARY TABLE table_name The following query returns all columns from the language table. SELECT name FROM language; - Answer- FALSE The following query returns all columns from the language table. SELECT * FROM language; - Answer- TRUE You see the following when connecting to the mysqlsh Shell: MySQL