ANSI SQL Assessment

This test is intended to gauge the working knowledge of the test taker in ANSI SQL. The test covers such topics as joins, constraints, data modeling, data definition, retrieving data, indexes, data modification, subqueries, and the basic rules of ANSI SQL. Assessments for Data Communications Concepts and Data Warehousing Concepts are also available.  Total Questions 39 Question Types Multiple Choice Competencies Tested ANSI SQL ClauseANSI SQL ConceptANSI SQL Code ExecutionANSI SQL Syntax Tasks Tested Restrict RowsTypes of JoinsJoining Multiple TablesSelectionUndo DML ChangesJoinsDelete Table DataDMLSubqueriesRemove ConstraintsTransaction ControlSingle Row FunctionsAdd Column to TableSequenceConstraints and Foreign KeysConstraints and IndexesArithmetic OperatorsIndexesRead ConsistencyDrop ObjectsGrouping DataEvaluating CodeGrouping and Sorting DataBasic SELECT StatementFull Outer JoinsLeft Outer JoinsSelect StatementsAggregate FunctionRol