Cit 225 final exam Study guides, Class notes & Summaries

A subquery can return a result set, a column of one or more rows, or a single ______________________. - Answer- cell In many cases, a subquery can be restated as a/an _____________ - Answer- join A correlated subquery is a subquery that is executed once for each ______________________ in the outer query. - Answer- row, row processed When you code a subquery in a FROM clause, it returns a result set that can be referred to as an _____________________________ view. - Answer- inline If ...

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 nam...

The NWBC found that 16.5% of women-owned businesses did not pro- vide any employee ben- efits. What sample size could be 99% confident that the estimated (sam- ple) proportion is within 6 percentage points of the true population propor- tion? Question Suppose a market re- searcher wants to deter- mine the current percent- age of online shoppers who are males. How many online shoppers should the researcher survey in order to be 90% confident that the estimated (sam- ple) proportion is within 3 p...