Question Question 1 The __________ holds a database of domain names and their respective IP addresses. Question 1 options: SQL DNS OS HPPT Question 2 A(n) __________ key is a field with values that are not chosen as a primary key, but can be used in cases where the primary key is not available. Question 2 options: composite alternate relational control Question 3 The __________ relationship is the ideal type of relationship within a relational database schema. Question 3 options: many-to-one one-to-one many-to-many one-to-many Question 4 __________ consistency refers to the accuracy and reliability of data within a database. Question 4 options: Object Backup Read Store Question 5 True or False? Corporations use only structured data. Question 5 options: True False Question 6 A(n) __________ is an application that acts as the interface for the Internet, providing a way for people to interact with and view pages on the World Wide Web. Question 6 options: DNS HTTP Web browser Web server Question 7 True or False? An operational database is sometimes referred to as an enterprise database. Question 7 options: True False Question 8 A __________ database is a storage model in which common entities are stored within separate tables that use unique key identifiers to build relationships among these entities. Question 8 options: network relational hierarchical flat Question 9 A(n) __________ model is a two-dimensional list of data entries, where all data within a field are understood to be similar, and all data within a record are understood to be related to one another. Question 9 options: object flat relational network Question 10 True or False? Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. Question 10 options: True False Question 11 Which of the following is true of NoSQL databases? Question 11 options: They do not support distributed database architectures. They do not support very large amounts of sparse data. They are not based on the relational model. They are geared toward transaction consistency rather than performance Question 12 __________ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false. Question 12 options: Predicate Index Relational Database Question 13 NoSQL databases __________. Question 13 options: provide fault tolerance are geared toward transaction consistency, not performance are based on the relational model support only small amounts of sparse data Question 14 In the relational model, __________are important because they are used to ensure that each row in a table is uniquely identifiable. Question 14 options: logical structures indexes keys relations Question 15 Which of the following is a disadvantage of the hierarchical data model? Question 15 options: It does not promote data sharing. It does not have standards. It does not promote data integrity. It is not efficient with 1:M relationships. Question 16 True or False? As rare as 1:1 relationships should be, certain conditions absolutely require their use. Question 16 options: True False Question 17 True or False? The DIVIDE operation uses one single-column table (e g , column a) as the divisor and one two-column table (e g , columns a and b) as the dividend. Question 17 options: True False Question 18 The __________ data model uses the concept of inheritance. Question 18 options: entity relationship obje
ct-oriented relational network Question 19 Which of the following types of HDFS nodes stores all the metadata about a file system? Question 19 options: Map node Data node Client node Name node Question 20 A(n) __________enables a database administrator to describe schema components. Question 20 options: unified modeling language (UML) query language extensible markup language (XML) data definition language (DDL) Question 21 To generate a surrogate key, Microsoft Access uses a(n) __________ data type. Question 21 options: character AutoNumber identity sequence Question 22 A(n) __________ exists when there are functional dependencies such that XY is functionally dependent on WZ, X is functionally dependent on W, and XY is the primary key. Question 22 options: transitive dependency atomic attribute partial dependency repeating group Question 23 True or False? In implementation terms, an entity is existence-dependent if it has a mandatory primary key. Question 23 options: True False Question 24 A table where every determinant is a candidate key is said to be in __________. Question 24 options: BCNF 1NF 4NF 2NF Question 25 True or False? The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity. Question 25 options: True False Question 26 An atomic attribute __________ Question 26 options: displays multiplicity is always chosen to be a foreign key cannot exist in a relational table cannot be further subdivided Question 27 True or False? Unary relationships are common in manufacturing industries. Question 27 options: True False Question 28 True or False? The process of database design is a sequential process. Question 28 options: True False Question 29 True or False? To implement a small database, a database designer must know the 1 and the M sides of each relationship and whether the relationships are mandatory or optional. Question 29 options: True False Question 30 True or False? In Chen notation, there is no way to represent cardinality. Question 30 options: True False Question 31 True or False? To list the contents of a table, you must use the DISPLAY command. Question 31 options: True False Question 32 True or False? Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the commands components. Question 32 options: True False Question 33 True or False? Mathematical operators cannot be used to place restrictions on character-based attributes. Question 33 options: True False Question 34 True or False? ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. Question 34 options: True False Question 35 Which of the following is the syntax for the UNION query? Question 35 options: query + query UNION: query query query UNION query UNION (query, query) Question 36 Which of the following is a statement in SQL that combines rows from two queries and returns only the rows that appear in the first set but not in the second? Question 36 options: UNION ALL MINUS UNION INTERSECT Question 37 True or False? You cannot insert a row containing a null attribute value using SQL. Question 37 options: True False Question 38 __________ is a string function that returns the number of characters in a string value. Question 38 options: LENGTH CONCAT UCASE SUBSTRING Question 39 True or False? Any changes made to the contents of a table are not physically d on disk until you use the