On which of the following distinct numbers of digits is the hexadecimal numbering system based?
Correct Answer: B
Question 117
Which of the following BEST explains the use of float over integer to store monetary values?
Correct Answer: D
Float is a data type that can store decimal or fractional numbers, such as 3.14, 0.5, or -2.75. Float would be the best data type to use for storing monetary values because monetary values often involve decimals, such as $1.99, 0.25,or-5.50. Integer is a data type that can only store whole numbers, such as 1, 0, or -2. Integer would not be suitable for storing monetary values that have decimals. The other options are not data types that can store numerical values. References: CompTIA IT Fundamentals+ Study Guide: Exam FC0-U61, Second Edition, Chapter 4: Programming Concepts and Data Structures, page 146.
Question 118
Which of the following describes the concept of a database record?
Correct Answer: B
Explanation The concept of a database record is best described as a collection of fields about the same object. A database record is a row in a table that represents an instance of an entity, such as a customer, an order, a product, etc. A database record consists of one or more fields that store data about the attributes of the entity, such as name, address, phone number, quantity, price, etc. A database record can be uniquely identified by a primary key, which is a field or a combination of fields that do not repeat in the table. A collection of rows, columns, and constraints is not the concept of a database record, but rather the concept of a database table. A database table is a structure that organizes data into rows and columns. Each row represents a record, and each column represents a field. A database table can have constraints that define the rules and restrictions for the data in the table, such as primary keys, foreign keys, unique keys, check constraints, etc. A collection of schemas within the same database is not the concept of a database record, but rather the concept of a database instance. A database instance is a set of memory structures and processes that manage and access a database. A database instance can contain one or more schemas, which are collections of objects that belong to a user or an application in the database, such as tables, views, indexes, etc. A collection of tables within different schemas is not the concept of a database record, but rather the concept of a database relationship. A database relationship is a connection between two tables that share common data. A database relationship can be established by using foreign keys, which are fields that reference the primary keys of another table. A database relationship can be one-to-one, one-to-many, or many-to-many depending on how many records in each table are related to each other. References: The Official CompTIA IT Fundamentals (ITF+) Student Guide (Exam FC0-U61), Chapter 6: Database Fundamentals
