Online Access Free Data-Management-Foundations Practice Test

How many bytes of storage does a BIGINT data type hold in MySQL?

• A.8 bytes
• B.3 bytes
• C.4 bytes
• D.1 byte

What is the first step of the analysis phase for designing a database?

• A.Implement attributes
• B.Determine cardinality
• C.Identify entities
• D.Draw an entity-relationship (ER) diagram

Which operation finds an entry containing a search value by repeatedly splitting the index in two?

• A.Fan-out
• B.Binary search
• C.Index scan
• D.Table scan

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

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

Which SELECT statement uses valid syntax for SQL?

• A.SELECT ALL column1, column2 FROM table_name;
• B.SELECT column1, column2 WHERE condition FROM table_name;
• C.SELECT column1, column2 FROM table_name;
• D.SELECT "column name", "column name" FROM "table name" WHERE "column name"