# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 2056844175

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Explain the behavior of subqueries when null values are retrieved.

Definition

Explanation should include the reason why no rows may be returned when the subquery encounters null values. Evaluate the results of nulls on multi-row subqueries, using

  • IN
  • ANY
  • ALL.

Related Standards of Learning

English

10.5

The student will read, interpret, analyze, and evaluate nonfiction texts.
  1. Analyze text features and organizational patterns to evaluate the meaning of texts.
  2. Recognize an author’s intended audience and purpose for writing.
  3. Skim materials to develop an overview and locate information.
  4. Compare and contrast informational texts for intent and content.
  5. Interpret and use data and information in maps, charts, graphs, timelines, tables, and diagrams.
  6. Draw conclusions and make inferences on explicit and implied information using textual support as evidence.
  7. Analyze and synthesize information in order to solve problems, answer questions, and generate new knowledge.
  8. Analyze ideas within and between selections providing textual evidence.
  9. Summarize, paraphrase, and synthesize ideas, while maintaining meaning and a logical sequence of events, within and between texts.
  10. Use reading strategies throughout the reading process to monitor comprehension.

11.5

The student will read, interpret, analyze, and evaluate a variety of nonfiction texts including employment documents and technical writing.
  1. Apply information from texts to clarify understanding of concepts.
  2. Read and correctly interpret an application for employment, workplace documents, or an application for college admission.
  3. Analyze technical writing for clarity.
  4. Paraphrase and synthesize ideas within and between texts.
  5. Draw conclusions and make inferences on explicit and implied information using textual support.
  6. Analyze multiple texts addressing the same topic to determine how authors reach similar or different conclusions.
  7. Analyze false premises, claims, counterclaims, and other evidence in persuasive writing.
  8. Recognize and analyze use of ambiguity, contradiction, paradox, irony, sarcasm, overstatement, and understatement in text.
  9. Generate and respond logically to literal, inferential, evaluative, synthesizing, and critical thinking questions about the text(s).

Mathematics

COM.3

The student will write program specifications that define the constraints of a given problem.

Other Related Standards

Microsoft Imagine Academy Resources

[3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1

[4.019] Access 2010: Modify Database Tables—Lesson 3

[5.037] Access 2010: Project 5