Saint Leo COM506 Midterm exam

    0

    Saint Leo COM506 Midterm exam

    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

    object-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 command’s 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 <table name> command.

    Question 39 options:

    True

    False

    Question 40

    When using the Oracle TO_NUMBER function to convert a character string into a number, __________ represents a digit.

    Question 40 options:

                                                                                                                                      Order Now