SQL for Desktop Applications Assessment
The SQL Desktop Database Usage test covers aspects of using the ANSI standard version of SQL with typical problems encountered by programmers using desktop databases. It concentrates on demonstrating an understanding of how to use SQL Syntax for data retrieval and management. This test is appropriate to administer to programmers. Tests for SQL for Client-Server Applications, SQL Server 7.0 for Developers and ANSI SQL are also available. Total Questions 42 Question Types Multiple Choice Competencies Tested Updating TablesRetrieving DataSQL UsageAggregationPredicatesOperatorsJoinsWHERE ClausesSELECTQueriesSortingQuery ToolsUnionsTransaction ControlJOINRemoving RecordsUpdatesAggregatesSyntaxCorrelated Subqueries Tasks Tested Data ChangesAdding DataRemoving RecordsAdding RecordsRetrieving DataSearching TablesSortingJoinsUnionsData IntegrityDeleting DataModifying DataSummarizing DataInserting DataINSERT data