Online Access Free Data-Management-Foundations Practice Test

Which keyword determines if a value is within a range of values?

• A.BETWEEN
• B.LIKE
• C.OR
• D.IN

How can a primary key constraint be added after the table is created?

• A.By using an INSERT INTO clause
• B.By using an UPDATE clause
• C.By using an ALTER clause
• D.By using the CREATE TABLE statement

Which keyword or clause indicates the desired sequence when displaying a set of records returned from a SELECT statement?

• A.BETWEEN
• B.LIKE
• C.DISTINCT
• D.ORDER BY

Which clause or statement in a CREATE statement ensures a certain range of data?

• A.WHERE
• B.FROM
• C.SET
• D.CHECK

Which capability should databases maintain to simplify the use of SQL with a general-purpose language?

• A.The storage manager to interpret low-level file-system commands
• B.The ability to reverse results if needed
• C.The query processor to deliver results
• D.The use of an application programming interface