Modern Database Management - Final Study S
Which type of file is easiest to update? hashed sequential clustered indexed
*A. Hashed*
Given the functional dependency (A, B) → C, then ________. A) A and B together → C B) A → C C) B → A D) Both A and B are correct
A and B together -> C
Which of the following is true about the functional dependency (A, B) → (C, D)? A) A is the determinant of C. B) A and B together are determined by C and D together. C) A and B together determine D. D) C and D together determine A.
A and B together determine D
A relation is in second normal form (2NF) if and only if it is in 1NF and ________. A) all non-key attributes are determined by the entire primary key B) there are no non-key attributes determined by another non-key attribute C) every attribute is a candidate key D) every candidate key is a determinant
All non-key attributes are determined by the entire primary key
In which data model would a code table appear?
Physical
Ternary
The figure below is an example of mapping which type of relationship? A) First B) Second C) Unary D) Ternary
Which of the following is NOT true about the functional dependency A → (X, Y)? A) X is functionally dependent on A. B) A determines Y. C) X and Y together determine A. D) X and Y are functionally dependent on A.
X and Y together determine A
All of the following are valid datatypes in Oracle 11g EXCEPT: A) varchar2. B) boolean. C) blob. D) number
boolean
A determinant that determines all the other columns in a relation is a ________. A) record B) surrogate key C) foreign key D) candidate key
candidate key
An advantage of partitioning is: A) efficiency. B) remote optimization. C) extra space and update time. D) increase redundancy.
efficiency.
A constraint between two attributes is called a(n): A) functional relation. B) attribute dependency. C) functional dependency. D) functional relation constraint
functional dependency
While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the: A) user. B) CEO. C) XML. D) operating system.
operating system
explain plan.
A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers and join tables to prepare query results is the:
An appropriate datatype for adding a sound clip would be: A) VarChar. B) Char. C) Blob. D) Date.
Blob
The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called: A) fifth normal form. B) fourth normal form. C) Boyce-Codd normal form. D) sixth normal form.
Boyce-Codd normal form.
An appropriate datatype for one wanting a fixed-length type for last name would include: A) VarChar. B) Char. C) Blob. D) Date.
Char
Sensitivity testing involves:
Checking to see if missing data will greatly impact results
In the SQL language, the __________ statement is used to make table definitions.
Create table
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space
Data Integrity
Physical database design decisions must be made carefully because of impacts on:
Data accessibility, response times, security
A component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated:
Data integrity
The relational data model consists of which components?
Data structure, Data manipulation, and Data integrity
A detailed coding scheme recognized by system software for representing organizational data is called a:
Data type
The value a field will assume unless the user enters an explicit value for an instance of that field is called a:
Default value
If the removal of facts about one entity results in the unintentional loss of data about another entity, this is referred to as a(n) ________. A) normalization anomaly B) insertion anomaly C) update anomaly D) deletion anomaly
Deletion anomaly
A nonkey attribute is also called a(n): A) column. B) unimportant datum. C) descriptor. D) address.
Descriptor
The attribute on the left-hand side of the arrow in a functional dependency is the:
Determinant
A continguous section of disk storage space is called a(n):
Extent
The smallest unit of application data recognized by system software is a:
Field
A _________ is a technique for physically arranging the records of a file on secondary storage devices.
File organization
When all multivalued attributes have been removed from a relation, it is said to be in: first normal form second normal form Boyce-Codd normal form third normal form
First normal form
When all multivalued attributes have been removed from a relation, it is said to be in: A) first normal form. B) second normal form. C) Boyce-Codd normal form. D) third normal form
First normal form
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
Foreign key
A constraint between two attributes is called a(n): A) functional relation. B) attribute dependency. C) functional dependency. D) functional relation constraint
Functional dependency
Which type of file is easiest to update? A) Sequential B) Hashed C) Indexed D) Clustered
Hashed
An attribute that may have more than one meaning is call a:
Homonym
Which of the following is an objective of selecting a data type?
Improve data integrity
Which of the following is an objective of selecting a data type? A) Represent a small number of possible values B) Maximize storage space C) Limit security D) Improve data integrity
Improve data integrity
Candidate
In the figure below, Customer_ID in the CUSTOMER Table is which type of key? A) Composite B) Candidate C) Standard D) Grouped
TRUE.
In the figure below, each employee has exactly one manager. Answer : T / F
COMPOSITE
In the figure below, the primary key for "Order Line" is which type of key? A) Composite B) Foreign C) Standard D) Grouped
An associative entity
In the figure below, what is depicted? A) A one-to-one relationship B) A unary relationship C) A one-to-many relationship D) An associative entity
Recursive foreign
In the figure below, what type of key is depicted? A) Primary B) Recursive primary C) Composite D) Recursive foreign
Strong entity/weak entity
In the figure below, what type of relationship do the relations depict? A) Strong entity/weak entity B) Multivalued C) Composite foreign key D) One-to-many
one-to-Many
In the figure below, what type of relationship do the relations depict? A) Strong entity/weak entity B) One-to-many C) Ternary D) Many-to-many
A domain definition consists of the following components EXCEPT: domain name data type integrity constraints size
Integrity constraints
An index on columns from two or more tables that come from the same domain of values is called a:
Join index
All of the following are the main goals of normalization EXCEPT: A) minimize data redundancy. B) simplify the enforcement of referential integrity. C) maximize storage space. D) make it easier to maintain data
Maximize Storage Pace
All of the following are that main goals of normalization EXCEPT: A. minimize data redundancy. B. simplify the enforcement of referential integrity. C. maximize storage space. D. make it easier to maintain data.
Maximize storage space
Which of the following are properties of relations? A) Each attribute has the same name. B) No two rows in a relation are identical. C) There are multivalued attributes in a relation. D) All columns are numeric
No two rows in a relation are identical.
While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the:
Operating system
In which data model would a code table appear? A) Conceptual B) Logical C) Physical D) Data layout
Physical
A ________ is a field of data used to locate a related field or record.
Pointer
An attribute (or attributes) that uniquely identifies each row in a relation is called a:
Primary key
________ partitioning is a method in which each partition is defined by a range of values for one or more columns of a normalized table
Range
A ________ limits the set of permissible values a field may assume.
Range control
An integrity control supported by a DBMS is:
Range control
Ensures that a value of a field exists in another database table
Referential integrity
A rule that states that each foreign key value must match a primary key value in the other relation is called the: A. referential integrity constraint. B. key match rule. C. entity key group rule. D. foreign/primary match rule
Referential integrity constraint
A component is always used in only one item.
Referring to the figure below, which of the following is NOT true? A) A component is part of an item. B) A component is always used in only one item. C) A component can be part of an item. D) A component may be used in many items
A two-dimensional table of data is called a:
Relation
Which of the following violates the atomic property of relations? A) Sam B) Hinz C) Sam Hinz D) Atomic
Sam Hinz
A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?
Second
One field or combination of fields for which more than one record may have the same combination of values is called a(n):
Secondary key
________ is often used to decide whether or not missing data can be ignored
Sensitivity testing
Which type of file is most efficient with storage space? Clustered Indexed Sequential Hashed
Sequential
Which type of file is most efficient with storage space? A) Sequential B) Hashed C) Indexed D) Clustered
Sequential
Two or more attributes having different names but the same meaning are called:
Synonyms
Within Oracle, the named set of storage elements in which physical files for database tables may be stored is call a:
Tablespace
________ partitioning distributes the columns of a table into several separate physical records. A) Horizontal B) Crossways C) Vertical D) Final
Vertical
A relation that contains minimal redundancy and allows easy use is considered to be: A) clean. B) simple. C) complex. D) well-structured.
Well-structured
All of the following are common denormalization opportunities EXCEPT: A) two entities with a one-to-one relationship. B) a one-to-many relationship. C) a many-to-many relationship with nonkey attributes. D) reference data.
a one-to-many relationship
An alternative name for an attribute is called a(n): A) synonym. B) alias. C) alternate attribute. D) related characteristic
alias
If a table is designed so that every determinant is a candidate key, then that relation is in ________. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Boyce-Codd Normal Form
boyce codd normal form
Which of the following is not true about a relation? A) Has rows containing data about an entity B) Has columns containing data about attributes of the entity C) Has cells that hold only a single value D) Can have two identical rows
can have two identical rows
A(n) ________ is defined by the tables and column of columns by which the tables are joined
cluster
A method to allow adjacent secondary memory space to contain rows from several tables is called: A) cluttering. B) clustering. C) concatenating. D) compiling.
clustering
A method to allow adjacent secondary memory space to contain rows from several tables is called: concatenating. clustering. cluttering. compiling
clustering
A combination of two or more columns used to identify particular rows in a relation is a ________. A) record B) composite key C) foreign key D) surrogate key
composite key
A primary key that consists of MORE THAN ONE ATTRIBUTE IS CALLED A: A) foreign key. B) composite key. C) multivalued key. D) cardinal key.
composite key
In the SQL language, the ________ statement is used to make table definitions. A) create session B) create table C) create index D) select
create table
When a regular entity type contains a multivalued attribute, one must: A) create a single relation with multiple lines for each instance of the multivalued attribute. B) create two new relations, one containing the multivalued attribute. C) create two new relations, both containing the multivalued attribute. D) delete the relation and start over.
create two new relations, one containing the multivalued attribute.
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space. A) query design B) programmer productivity C) data integrity D) data integration
data integrity
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space. A. query design B. programmer productivity C. data integrity D. data integration
data integrity
________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. A) Business rule constraint B) Data integrity C) Business integrity D) Data structure
data integrity
________ can be built into the physical structure of fields for many database management systems
data integrity controls
A form of denormalization where the same data are purposely stored in multiple places in the database is called: data replication advanced placement data duplication horizontal partitioning
data replication
A form of denormalization where the same data are purposely stored in multiple places in the database is called: A) data duplication. B) data replication. C) advanced placement. D) horizontal partitioning
data replication.
A ________ is a detailed coding scheme recognized by system software, such as a DBMS, for representing organizational data A) DBMS code. B) data type. C) SQL. D) DB layout.
data type
A detailed coding scheme recognized by system software for representing organizational data is called a(n): A) DBMS code. B) data type. C) SQL. D) DB layout.
data type
The value a field will assume unless the user enters an explicit value for an instance of that field is called a: default value range control null value gurand
default value
________ problems are encountered when removing data with transitive dependencies. A) Insertion B) Modification C) Deletion D) Merging
deletion
Designing physical files requires ________ of where and when data are used in various ways. keys hints descriptions maps
descriptions
Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints
descriptions
A nonkey attribute is also called a(n): A) column. B) unimportant datum. C) descriptor. D) address.
descriptor
Given the functional dependency A → (B, C), A is a(n) ________. A) independent variable B) dependent variable C) determinant D) composite determinant
determinant
Given the functional dependency (A, B) → C, (A, B) is a ________. A) dependent variable B) determinant C) composite determinant D) Both B and C are correct
determinant AND composite determinant
The attribute on the left-hand side of the arrow in a functional dependency is the: A) candidate key. B) determinant. C) foreign key. D) primary key.
determinate
In most cases, the goal of ________ dominates the design process. A. efficient data processing B. quick pointer updates C. security D. shorter design times
efficient data processing
In most cases, the goal of ________ dominates the design process. A) efficient data processing B) security C) quick pointer updates D) shorter design times
efficient data processing
A factor to consider when choosing a file organization is: A) inefficient data retrieval. B) DDL. C) efficient storage. D) DML.
efficient storage.
A primary key whose value is unique across all relations is called a(n): A) global primary key. B) inter-table primary key. C) enterprise key. D) foreign global key
enterprise key
The ________ states that no primary key attribute may be null. A) referential integrity constraint B) entity integrity rule C) partial specialization rule D) range domain rule
entity integrity rule
A relation is in domain/key normal form if ________. A) every key of the relation is a logical consequence of the definition of constraints and determinants B) every key of the relation is a logical consequence of the definition of constraints and domains C) every constraint on the relation is a logical consequence of the definition of keys and determinants D) every constraint on the relation is a logical consequence of the definition of keys and domains
every constraint on the relation is a logical consequence of the definition of keys and domains
A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________. A) all non-key attributes are determined by the entire primary key B) there are no non-key attributes determined by another non-key attribute C) every attribute is a candidate key D) every determinant is a candidate key
every determinant is a candidate key
A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers and join tables to prepare query results is the: A) explain plan. B) show optimization. C) explain query. D) analyze query
explain plan
A contiguous section of disk storage space is called a(n): sector tablespace extent track
extent
A contiguous section of disk storage space is called a(n): A) track. B) sector. C) extent. D) tablespace.
extent
A disadvantage of partitioning is: A) simplicity. B) remote optimization. C) extra space and update time. D) shorter technology spans.
extra space and update time
A disadvantage of partitioning is:
extra space and update time.
An attribute is also known as a ________. A) table B) relation C) row D) field
field
The smallest unit of application data recognized by system software is a: A) field. B) row. C) data type. D) column.
field
A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices. A) physical pointer B) retrieval program C) file organization D) update program
file organization
A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.
file organization
A table that meets the definition of a relation is in ________. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Boyce-Codd Normal Form
first normal form
Saying that two entities are functionally dependent means that ________. A) the entities are always connected by a mathematical equation B) for one of the entities, if we are given the value of that entity, we can determine the value of one other entity C) for both of the entities, if we are given the value of one entity, we can determine the value of the other entity D) the functional dependency will have to be removed through normalization.
for one of the entities, if we are given the value of that entity, we can determine the value of one other entity
A key consisting of one or more columns that is a primary key in another relation is a ________. A) composite key B) candidate key C) foreign key D) surrogate key
foreign key
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) link attribute. B) link key. C) foreign key. D) foreign attribute.
foreign key
Referential integrity constraints are used to limit the possible values of a ________. A) composite key B) candidate key C) foreign key D) surrogate key
foriegn key
If a relation is in BCNF, and each multivalued dependency has been moved to a relation of its own, then the first relation is in ________. A) Third Normal Form B) Boyce-Codd Normal Form C) Fourth Normal Form D) Domain/key normal form
fourth normal form
The normal form which deals with multivalued dependencies is called: A) fifth normal form. B) fourth normal form. C) Boyce-Codd normal form. D) sixth normal form.
fourth normal form.
A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a: A) hashed file organization. B) hash key. C) multi-indexed file organization. D) hash index table
hash index table
In which type of file is multiple key retrieval not possible? A) Sequential B) Hashed C) Indexed D) Clustered
hashed
A routine that converts a primary key value into a relative record number is called a(n)______
hashing algorithm
A(n) ________ is a routine that converts a primary key value into a relative record number. index pointer program hashing algorithm record index calculator pointing algorithm
hashing algorithm
A(n) ________ is a routine that converts a primary key value into a relative record number. A) record index calculator B) index pointer program C) hashing algorithm D) pointing algorithm
hashing algorithm
A file organization where files are not stored in any particular order is considered a: A) hashed file organization. B) hash key. C) multi-indexed file organization. D) heap file organization
heap file organization
A(n) ________ overrides whatever query plan Oracle would naturally create for a query based upon the query optimizer.
hint
An attribute that may have more than one meaning is called a(n): A) homonym. B) alias. C) double defined attribute. D) synonym.
homonym
Distributing the rows of data into separate files is called ________
horizontal partitioning
Distributing the rows of data into separate files is called: normalization file allocation vertical partitioning horizontal partitioning
horizontal partitioning.
Distributing the rows of data into separate files is called: A) normalization. B) horizontal partitioning. C) vertical partitioning. D) file allocation.
horizontal partitioning.
A table or other data structure used to determine the location of rows in a file that satisfy some condition is called a(n)______
index
Having to enter facts about two entities when we want to enter facts about only one is an example of ________. A) insertion anomaly B) update anomaly C) deletion anomaly D) normalization anomaly
insertion anomaly
A domain definition consists of all of the following components EXCEPT: A) domain name. B) data type. C) integrity constraints. D) size.
integrity constraints
An index on columns from two or more tables that come from the same domain of values is called a(n) ________ index
join
An index on columns from two or more tables that come from the same domain of values is called a: A) bitmap index. B) multivalued index. C) join index. D) transaction index
join index.
A combination of one or more columns used to identify particular rows in a relation is a ________. A) record B) field C) key D) tuple
key
Because data table row locations are dictated by the hashing algorithm, only one ________ can be used for hashing-based retrieval
key
The need to ________ relations commonly occurs when different views need to be integrated. A) metadata B) system C) drop D) merge
merge
________ are anomalies that can be caused by editing data in tables. A) Insertion B) Deletion C) Modification D) Creation
modification
A relation is in fourth normal form if it is in BCNF and it has no ________. A) transitive dependencies B) multivalued dependencies C) partial dependencies D) deletion dependencies
multivalued dependencies
All of the following are horizontal partitioning methods in Oracle EXCEPT: A) key range partitioning. B) hash partitioning. C) multivalued partitioning. D) composite partitioning
multivalued partitioning
The entity integrity rule states that: A) no primary key attribute can be null. B) referential integrity must be maintained across all entities. C) each entity must have a primary key. D) a primary key must have only one attribute
no primary key attribute can be null.
A requirement to begin designing physical files and databases is: A. normalized relations. B. physical tables created. C. implementation complete. D. all datatypes determined
normalized relations
A requirement to begin designing physical files and databases is: A) normalized relations. B) physical tables created. C) implementation complete. D) all datatypes determined.
normalized relations
In general, each relation should have ________. A) one and only one theme B) one or more themes C) exactly two themes D) one or two themes
one and only theme
Understanding the steps involved in transforming EER diagrams into relations is important because: A) one must be able to check the output of a CASE tool. B) there are rarely legitimate alternatives from which to choose. C) CASE tools can model any situation. D) CASE tools model hypothetical business problems
one must be able to check the output of a CASE tool.
A strategy for breaking apart queries and running each part on separate processors is called
parallel query processing
A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called: A) multiple partition queries. B) perpendicular query processing. C) parallel query processing. D) query optimization.
parallel query processing.
A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency. A) partial key-based B) partial functional C) cross key D) merged relation
partial functional
________ database specification indicates all the parameters for data storage that are then input to database implementation. A) Logical B) Physical C) Schematic D) Conceptual
physical
A(n) ________ is a field of data used to locate a related field or record.
pointer
A(n) ________ is a field of data used to locate a related field or record. A) key B) index C) lock D) pointer
pointer
An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) column. B) foreign field. C) primary key. D) duplicate key.
primary key
When designing a database, one of the candidate keys in a relation is selected as the ________. A) composite key B) primary key C) foreign key D) surrogate key
primary key
A ________ limits the set of permissible values a field must assume
range control
An integrity control supported by a DBMS is: A) substitute estimates. B) security. C) range control. D) GUI guards.
range control
A ________ is used to limit the possible values of a foreign key. A) composite key B) surrogate key C) functional dependency D) referential integrity constraint
referential integrity constraint
A rule that states that each foreign key value must match a primary key value in the other relation is called the: A) referential integrity constraint. B) key match rule. C) entity key group rule. D) foreign/primary match rule.
referential integrity constraint.
A two-dimensional table of data sometimes is called a: A) group. B) set. C) declaration. D) relation.
relation
A tuple is also known as a ________. A) table B) relation C) row D) field
row
A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? A) First B) Second C) Third D) Fourth
second
A ________ key is one field or a combination of fields for which more than one record may have the same combination of values
secondary
One field or combination of fields for which more than one record may have the same combination of values is called a(n): A) secondary key. B) index. C) composite key. D) linked key
secondary key
A form of database specification which maps conceptual requirements is called: A) logical specifications. B) response specifications. C) security specifications. D) physical specifications
security specifications
A key decision in the physical design process is: A. ignoring the size of the database. B. deciding the e-r diagrams. C. deciding on the monitor. D. selecting structures.
selecting structures
A key decision in the physical design process is: A) ignoring the size of the database. B) selecting structures. C) deciding on the monitor. D) deciding the e-r diagrams
selecting structures
The only reason(s) for having relations is to ________. A) store instances of functional dependencies B) store equation components C) store equation results D) Both B and C are correct
store instances of functional dependencies
An artificial column added to a relation to serve as the primary key is a ________. A) composite key B) candidate key C) foreign key D) surrogate key
surrogate key
Two or more attributes having different names but the same meaning are called: A) homonyms. B) aliases. C) synonyms. D) alternate attributes.
synonyms
A relation is also known as a(n) ________. A) table B) tuple C) relationship D) attribute
table
Data is represented in the form of: A) data trees. B) tables. C) data notes. D) chairs.
tables
A ________ is a named set of disk storage elements in which physical files for database tables may be stored
tablespace
Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n): A) extent. B) table. C) tablespace. D) partition
tablespace
A candidate key must satisfy all of the following EXCEPT: The key must uniquely identify the row The key must indicate the row's position in the table The key must be nonredundant Each nonkey attribute is functionally dependent One of the primary key.
the key must indicate the row's position in the table
A candidate key must satisfy all of the following conditions EXCEPT: A) the key must uniquely identify the row. B) the key must indicate the row's position in the table. C) the key must be nonredundant. D) each nonkey attribute is functionally dependent upon it.
the key must indicate the row's position in the table
Which of the following is true for a relation? A) Entities in a column vary as to kind. B) The order of the columns is important. C) The order of the rows is unimportant. D) More than one column can use the same name.
the order of the rows is uninmportant
A relation is in third normal form (3NF) if and only if it is in 2NF and ________. A) all non-key attributes are determined by the entire primary key B) there are no non-key attributes determined by another non-key attribute C) every attribute is a candidate key D) every candidate key is a determinant
there are no non-key attributes determined by another non-key attribute
A method for handling missing data is to: delete the associated row. track missing data with special reports perform insensitivity testing. substitute with random numbers for the missing data.
track missing data with special reports
A method for handling missing data is to: A) substitute with random numbers for the missing data. B) track missing data with special reports. C) perform insensitivity testing. D) delete the associated row
track missing data with special reports.
Database access frequencies are estimated from: random number generation security violations user logins transaction volumes
transaction volumes
Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) random number generation
transaction volumes
A functional dependency between two or more nonkey attributes is called a: A) partial functional dependency. B) partial nonkey dependency. C) transitive dependency. D) partial transitive dependency.
transitive dependency
Denormalization is the process of transforming normalized relations into ________ physical record specifications
unnormalized
Suppose that you need to update one value of the column SalesCost in a relation. The way the relation is constructed, this value actually needs to be changed in three different rows. However, you only change the value in two of the rows. You have just created a(n) ________. A) normalization anomaly B) insertion anomaly C) update anomaly D) deletion anomaly
update anomaly
All of the following are objectives when selecting a data type *EXCEPT*: represent all possible values support all data manipulations improve data integrity use a lot of storage space
use a lot of storage space
All of the following are objectives when selecting a data type EXCEPT: A) represent all possible values. B) improve data integrity. C) support all data manipulations. D) use a lot of storage space
use a lot of storage space
________ distributes the columns of a table into several separate physical records
vertical partitioning
A relation that contains minimal redundancy and allows easy use is considered to be: A) clean. B) simple. C) complex. D) well-structured
well-structured
Horizontal partitioning makes sense: when only one category is allowed when partitions must be organized the same when less security is needed when different categories of a table's rows are processed separately
when different categories of a table's rows are processed separately
Horizontal partitioning makes sense: A) when different categories of a table's rows are processed separately. B) when less security is needed. C) when partitions must be organized the same. D) when only one category is allowed
when different categories of a table's rows are processed separately.
Indexes are most useful for columns that frequently appear in ________ clauses of SQL statements
where
