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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Restrict (or specify) data containing nulls, using the IS (NOT) NULL clause.

Definition

Restriction should include the use of
  • IS NULL to test for unavailable, unassigned, or unknown data
  • IS NOT NULL, which tests for data that is present in the database.

Related Standards of Learning

Mathematics

COM.7

The student will select and call library functions to process data, as appropriate.

COM.13

The student will implement various mechanisms for performing iteration with an algorithm

Other Related Standards

Microsoft Imagine Academy Resources

[3.177] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 3

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

[5.035] Access 2010: Project 3

NBEA Achievement Standards for Information Technology

Sort, prioritize, and retrieve data from databases.