In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)"˜ ORDER BY[NAME];what does [TYPE]=5 indicate? A)the statement is selecting query objects in an Access system table B)the statement would like to display only 5 names C)the statement is selecting table objects in an Access system table D)the statement will select records in groups of 5

Question

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)<>"˜ ORDER BY[NAME];what does [TYPE]=5 indicate?
A)the statement is selecting query objects in an Access system table
B)the statement would like to display only 5 names
C)the statement is selecting table objects in an Access system table
D)the statement will select records in groups of 5

Quizplus · Accepted Answer

In Microsoft Access, the MSysObjects table stores information about database objects. A [TYPE] value of 5 indicates that the object is a query.

In the SQL Statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5