Quiz
IS301 - Intro to Database Management Systems
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (200)
1The _____ serve(s) as the intermediary between the user and the database.
- Aa. DBMS
- Bb. metadata
- Cc. end-user data
- Dd. programming language
2_____ data exist in the format in which they are collected.
- Aa. Structured
- Bb. Semistructured
- Cc. Unstructured
- Dd. Historical
3A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.
- Aa. query
- Bb. operating system
- Cc. database management system
- Dd. application program
4Data constitute the building blocks of information.
- ATrue
- BFalse
5A data warehouse can store data derived from many sources.
- ATrue
- BFalse
6The database structure in a DBMS is stored as a _____ .
- Aa. file
- Bb. collection of files
- Cc. set of key/value pairs
- Dd. collection of queries
7Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.
- ATrue
- BFalse
8End-user data is _____ .
- Aa. raw facts about the end-user
- Bb. raw facts of interest to the end-user
- Cc. data about data
- Dd. accurate, relevant and timely information
9Corporations use only structured data.
- ATrue
- BFalse
10The DBMS reveals much of the database's internal complexity to the application programs and users.
- ATrue
- BFalse
11XML data is _____ .
- Aa. structured
- Bb. multistructured
- Cc. unstructured
- Dd. semistructured
12_____ data are the result of formatting to facilitate storage, use and generation of information.
- Aa. Structured
- Bb. Semistructured
- Cc. Unstructured
- Dd. Historical
13A _____ database supports data distributed across several different sites.
- Aa. single-user
- Bb. multiuser
- Cc. centralized
- Dd. distributed
14A(n) _____ database is used by an organization and supports many users across many departments.
- Aa. desktop
- Bb. workgroup
- Cc. enterprise
- Dd. transactional
15Accurate, relevant, and timely information is the key to _____ .
- Aa. data management
- Bb. good decision making
- Cc. knowledge
- Dd. understanding
16Which TWO of the following answers are key disadvantages of the modular approach to providing information systems?
- Aa. decreased performance
- Bb. increased complexity
- Cc. decreased quality
- Dd. increased maintenance
17The _____ model uses the concept of inheritance.
- Aa. relational
- Bb. network
- Cc. object-oriented
- Dd. entity relationship
18A manager and a programmer usually have the same view of the same data.
- ATrue
- BFalse
19A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
- Aa. entity
- Bb. attribute
- Cc. relationship
- Dd. constraint
20M:N relationships are not appropriate in a relational model.
- ATrue
- BFalse
21End-user interfaces require the end user to manually generate SQL code.
- ATrue
- BFalse
22An implementation-ready data model should contain a description of the data structure that will store the end-user data.
- ATrue
- BFalse
23A(n) _____ model represents a global view of the database as viewed by the entire organization.
- Aa. external
- Bb. conceptual
- Cc. internal
- Dd. physical
24In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
- ATrue
- BFalse
25_____ are normally expressed in the form of rules.
- Aa. Attributes
- Bb. Entities
- Cc. Relationships
- Dd. Constraints
26Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
- ATrue
- BFalse
27Which of the following is true of business rules?
- Aa. They allow the designer to set company policies with regard to data.
- Bb. They allow the designer to develop business processes.
- Cc. They can serve as a communication tool between the users and designers.
- Dd. They provide a framework for the company's self actualization.
28Database designers determine the data and information that yield the required understanding of the entire business.
- ATrue
- BFalse
29Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.
- ATrue
- BFalse
30Students and classes have a _____ relationship.
- Aa. one-to-one
- Bb. one-to-many
- Cc. many-to-one
- Dd. many-to-many
31Hard disk drives are mechanical devices with moving parts whereas Random Access Memory (RAM) chips are solid state devices. Regarding virtual memory on database servers, which of the following is closest to the performance difference between them?
- Aa. RAM is 100 times slower than a hard disk
- Bb. RAM is 200 times slower than a hard disk
- Cc. A hard disk is 100 times slower than RAM
- Dd. A hard disk is 200 times slower than RAM
32An application programming interface (API) is a standard tool that provides data structure _____ relative to an application.
- Aa. keys
- Bb. performance
- Cc. dependence
- Dd. independence
33Which two of the following data problems are relational databases intended to minimize?
- Aa. frequent null entries
- Bb. frequent duplicate entries
- Cc. storage of data in tables
- Dd. user-accessible queries
34In a relational database, you cannot implement a _____ relationship between two entities, such as STUDENT and COURSE. Some modeling tools will not allow the designer to draw an Entity Relationship Diagram (ERD) that contains such a relationship.
- Aa. One-to-Many
- Bb. Many-to-Many
- Cc. One-to-One
- Dd. Many-to-One
35The key to correctly determining the cardinality of a relationship between two entities is to evaluate the relationship from _____ .
- Aa. the "One" end of the relationship
- Bb. the "Many" end of the relationship
- Cc. the entity that will have the most members (e.g. more STUDENTS than COURSES)
- Dd. both ends - each entity in turn
36The preferred relationship cardinality in a relational database implementation is _____ .
- Aa. 1:1
- Bb. 1:M
- Cc. 1:R
- Dd. M:N
37A(n) _____ is bidirectional.
- Aa. attribute
- Bb. entity
- Cc. relationship
- Dd. constraint
38Which data model has the highest level of abstraction?
- Aa. Object-oriented
- Bb. Entity relationship
- Cc. Relational
- Dd. Hierarchical
39A(n) _____ is anything about which data are to be collected and stored.
- Aa. attribute
- Bb. entity
- Cc. relationship
- Dd. constraint
40A(n) _____ is the equivalent of a field in a file system.
- Aa. attribute
- Bb. entity
- Cc. relationship
- Dd. constraint
41In the _____ model, each parent can have many children, but each child has only one parent.
- Aa. hierarchical
- Bb. network
- Cc. relational
- Dd. entity relationship
42The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
- Aa. hierarchical
- Bb. network
- Cc. object-oriented
- Dd. entity-relationship
43Business rules are derived from _____ .
- Aa. a detailed description of an organization's operations.
- Bb. standards and practices developed over the years
- Cc. managers' recommendations
- Dd. governmental oversight organization standards
44The relational model is hardware-dependent and software-independent.
- ATrue
- BFalse
45If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).
- ATrue
- BFalse
46Character data can contain any character or symbol intended for mathematical manipulation.
- ATrue
- BFalse
47A foreign key must exist in both tables that have a relationship.
- ATrue
- BFalse
48The SELECT operator yields a vertical subset of a table.
- ATrue
- BFalse
49As rare as 1:1 relationships should be, certain conditions absolutely require their use.
- ATrue
- BFalse
50DBMSs use indexes for many different purposes.
- ATrue
- BFalse
51In a database context, the word _____ indicates the use of the same attribute name to label different attributes.
- Aa. redundancy
- Bb. homonym
- Cc. duplicate
- Dd. synonym
52A(n) ____ is an ordered arrangement of keys and pointers.
- Aa. table
- Bb. superkey
- Cc. relationship
- Dd. index
53Codd's rule of ____ states:
Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns).- Aa. Nonsubversion
- Bb. Logical Data Independence
- Cc. Comprehensive Data Sublanguage
- Dd. Integrity Independence
54In a database context, a(n) ____ indicates the use of different names to describe the same attribute.
- Aa. entity
- Bb. duplicate
- Cc. synonym
- Dd. homonym
55Controlled ____ makes a relational database work.
- Aa. relations
- Bb. logic
- Cc. chaos
- Dd. redundancy
56When you define a table's primary key, the DBMS automatically creates a(n) ____ index on the primary key column(s) you declared.
- Aa. key
- Bb. incomplete
- Cc. unique
- Dd. primary
57The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
- Aa. HAS VALUE
- Bb. NOT NULL
- Cc. MUST HAVE VALUE
- Dd. NOT EMPTY
58A ____ is any key that uniquely identifies each row.
- Aa. superkey
- Bb. special
- Cc. selective
- Dd. candidate
59The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.
- Aa. meta dictionary
- Bb. schema
- Cc. data dictionary
- Dd. system catalog
60A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).
- Aa. equal
- Bb. unique
- Cc. foreign
- Dd. natural
61A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.
- Aa. relational dictionary
- Bb. logical schema
- Cc. relational schema
- Dd. data dictionary
62A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.
- Aa. table
- Bb. rowset
- Cc. attribute
- Dd. intersection
63In the context of a database table, the statement "A ____ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.
- Aa. contains
- Bb. is related to
- Cc. owns
- Dd. determines
64Any attribute that is part of a key is known as a ____ .
- Aa. key attribute
- Bb. logical attribute
- Cc. key determiner
- Dd. selector
65A ____ contains at least all of the attribute names and characteristics for each table in the system.
- Aa. data dictionary
- Bb. relational schema
- Cc. logical schema
- Dd. join
66All primary key entries are unique, and no part of a primary key may be ____ .
- Aa. zero
- Bb. a foreign key
- Cc. null
- Dd. a candidate key
67A key design theme is that once the business rules have been identified, the database should reflect these rules by capturing the maximum possible ____ , also known as ____ .
- Aa. semantics
- Bb. data
- Cc. information
- Dd. meaning
68In order to avoid making null entries, another option is to use a "placeholder", such as -99 for an agent code where no agent has yet been assigned to a customer. This type of "placeholder" is properly known as ____ .
- Aa. flag
- Bb. placeholder
- Cc. nil
- Dd. substitution
69You began with a dataset that occupied 60 columns in a single table. In order to achieve the ideal of completely minimalized nulls or redundancy, you have broken this data into 13 related tables that would make E.F. Codd proud. A potential problem with this design is that it may have a(n) ____ problem.
- Aa. substitution
- Bb. inversion
- Cc. RDBMS
- Dd. performance
70A design problem that can occur is by trying to include too many different attributes in a single table, some of the attributes can end up shared between tables, but not through Primary Key (PK) / Foreign Key (FK) relationships. As a result the database is prone to ____ anomalies.
- Aa. performance
- Bb. update
- Cc. null
- Dd. tuple
71Attributes do not have a domain
- ATrue
- BFalse
72All simple attributes are also single-valued.
- ATrue
- BFalse
73Entities are types of attributes.
- ATrue
- BFalse
74A weak entity has a primary key that is partially or totally derived from the parent entity relationship.
- ATrue
- BFalse
75The ER diagram represents the conceptual database as viewed by the end user.
- ATrue
- BFalse
76You should always load data from the 1 side of a 1:M relationship.
- ATrue
- BFalse
77Ideally, a primary key is composed of several attributes.
- ATrue
- BFalse
78An ER model is dependent on that database type.
- ATrue
- BFalse
79Relationships operate only in one direction.
- ATrue
- BFalse
80The ER model may refer to a specific table row as an "entity occurrence."
- ATrue
- BFalse
81When the PK of on entity contains the PK of a related entity, the relationship is _____.
- Aa. missing
- Bb. weak
- Cc. strong
- Dd. neutral
82A strong relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
- ATrue
- BFalse
83In an ER diagram, primary keys may be indicated by the letters PK and by ____ .
- Aa. underlining
- Bb. italics
- Cc. bolding
- Dd. the letter case
84A derived attribute ____ .
- Aa. must be stored physically within the database
- Bb. has many values
- Cc. is typically not physically stored within the database
- Dd. must be based on the value of three or more attributes
85The ____ type of attribute cannot be created in a DBMS.
- Aa. derived
- Bb. multivalued
- Cc. simple
- Dd. composite
86A ____ relationship exists when two entities are associated.
- Aa. unary
- Bb. binary
- Cc. ternary
- Dd. weak
87____ attributes can have many values.
- Aa. Composite
- Bb. Simple
- Cc. Single-valued
- Dd. Multivalued
88Making sure all ____ are identified is a very important part of a database designer's job.
- Aa. business rules
- Bb. cardinalities
- Cc. derived attributes
- Dd. relationships
89Another word for existence-independent is _____ .
- Aa. weak
- Bb. alone
- Cc. unary
- Dd. strong
90The ____ attribute(s) make up the primary key in the table definition:
CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM).
Assume, CRS_CODE and CLASS_SECTION are underlined.- Aa. CRS_CODE
- Bb. CLASS_SECTION
- Cc. CRS_CODE and CLASS_SECTION
- Dd. CLASS
91An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
- Aa. existence
- Bb. relationship
- Cc. business
- Dd. weak
92A relationship is an association between ____ .
- Aa. objects
- Bb. entities
- Cc. databases
- Dd. fields
93A(n) ____ might be represented with a single-valued attribute.
- Aa. person's phone number(s)
- Bb. person's driver's license number
- Cc. employee's educational background
- Dd. car' color
94Attributes may share a ____ .
- Aa. name
- Bb. domain
- Cc. location
- Dd. table
95A ____ relationship exists when three entities are associated.
- Aa. unary
- Bb. binary
- Cc. ternary
- Dd. weak
96The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.
- Aa. mandatory
- Bb. optional
- Cc. multivalued
- Dd. single-valued
97The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.
- ATrue
- BFalse
98Because a transitive dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.
- ATrue
- BFalse
99Normalization produces a higher normal form.
- ATrue
- BFalse
100Normalization works through a series of stages called normal forms.
- ATrue
- BFalse
101A determinant is any attribute whose value determines other values within a row.
- ATrue
- BFalse
102A table is in 2NF if it is in 1NF and it includes no partial dependencies.
- ATrue
- BFalse
103Normalization is a process that is used for grouping attributes into entities.
- ATrue
- BFalse
104Dependency diagrams are very helpful in getting a bird's-eye view of all relationships among a table's attributes.
- ATrue
- BFalse
105It is possible for a table in 2NF to exhibit transitive dependency, where one or more non-key attributes functionally determine other non-key attributes.
- ATrue
- BFalse
106Unnormalized database tables often lead to various data redundancy disasters in production databases.
- ATrue
- BFalse
107Dependencies based on only a part of a composite primary key are called ____ dependencies.
- Aa. primary
- Bb. composite
- Cc. partial
- Dd. incomplete
108Normalization represents a micro view of the ____ within the ERD.
- Aa. forms
- Bb. relationships
- Cc. attributes
- Dd. entities
109An atomic attribute ____ .
- Aa. cannot exist in a relational table
- Bb. displays multiplicity
- Cc. is always chosen to be a foreign key
- Dd. cannot be further subdivided
110From a structural point of view, 2NF is better than ____ .
- Aa. 4NF
- Bb. 3NF
- Cc. BCNF
- Dd. 1NF
111A relational table must not contain a(n) ____ .
- Aa. attribute
- Bb. entity
- Cc. repeating group
- Dd. relationship
112Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
- Aa. owns
- Bb. determines
- Cc. controls
- Dd. derives from
113Granularity refers to ____ .
- Aa. the level of detail represented by the values stored in a table's row
- Bb. the number of rows in a table
- Cc. the size of the table
- Dd. the number of attributes in a table
114A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____ .
- Aa. 3NF
- Bb. 2NF
- Cc. 1NF
- Dd. 4NF
115An attribute that is part of a key is known as a(n) ____ attribute.
- Aa. important
- Bb. nonprime
- Cc. prime
- Dd. entity
116Data redundancy produces ____ .
- Aa. slower lookups
- Bb. data integrity problems
- Cc. robust design
- Dd. efficient storage use
117From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
- Aa. granular
- Bb. derived
- Cc. atomic
- Dd. historical
118For most business transactional databases, we should normalize relations into ____ .
- Aa. 2NF
- Bb. 1NF
- Cc. 3NF
- Dd. 6NF
119A table that is in 2NF and contains no transitive dependencies is said to be in ____ .
- Aa. 1NF
- Bb. 3NF
- Cc. 2NF
- Dd. 4NF
120A table that displays data redundancies yields ____ .
- Aa. more attributes
- Bb. more entities
- Cc. fewer attributes
- Dd. anomalies
121A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.
- Aa. atomic attribute
- Bb. repeating group
- Cc. partial dependency
- Dd. transitive dependency
122In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies.
- Aa. dependency
- Bb. Chen
- Cc. functionality
- Dd. ER
123If you have three different transitive dependencies, ____ different determinant(s) exist.
- Aa. one
- Bb. two
- Cc. three
- Dd. four
1241NF, 2NF, and 3NF are ____ .
- Aa. anomalies
- Bb. atomic attributes
- Cc. repeating groups
- Dd. normalization stages
125The conflicts between design efficiency and processing speed are often resolved through ____ .
- Aa. conversion from 2NF to 3NF
- Bb. conversion from 1NF to 2NF
- Cc. compromises that include denormalization
- Dd. conversion from 3NF to 4NF
126If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have ____ based on this composite candidate key, even when the primary key chosen is a single attribute.
- Aa. redundancy
- Bb. partial dependencies
- Cc. Boyce-Codd Normal Form
- Dd. time-variance
127Although 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.
- ATrue
- BFalse
128Data type selection is usually dictated by the nature of the data and by the intended use.
- ATrue
- BFalse
129The ANSI SQL standards are also accepted by the ISO.
- ATrue
- BFalse
130The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.
- ATrue
- BFalse
131To list all the contents of the PRODUCT table, you would use ____ .
- Aa. LIST * FROM PRODUCT;
- Bb. SELECT * FROM PRODUCT;
- Cc. DISPLAY * FROM PRODUCT;
- Dd. SELECT ALL FROM PRODUCT;
132Some RDBMSs, such as Oracle, automatically ____ data changes when issuing data definition commands.
- Aa. COMMIT
- Bb. ROLLBACK
- Cc. UNSAVE
- Dd. UPDATE
133The SQL aggregate function that gives the average for the specific column is ____ .
- Aa. COUNT
- Bb. AVG
- Cc. MAX
- Dd. SUM
134The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.
- Aa. DELETE FROM PRODUCT
WHERE P_CODE = 'BRT-345'; - Bb. REMOVE FROM PRODUCT
WHERE P_CODE = 'BRT-345'; - Cc. ERASE FROM PRODUCT
WHERE P_CODE = 'BRT-345'; - Dd. ROLLBACK FROM PRODUCT
WHERE P_CODE = 'BRT-345';
- Aa. DELETE FROM PRODUCT
135COUNT is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.
- ATrue
- BFalse
136You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
- ATrue
- BFalse
137A database language enables the user to perform complex queries designed to transform the raw data into useful information.
- ATrue
- BFalse
138The special operator used to check whether an attribute value is within a range of values is ____ .
- Aa. BETWEEN
- Bb. NULL
- Cc. LIKE
- Dd. IN
139Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
- Aa. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE <'1558-QW1'; - Bb. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = [1558-QW1] - Cc. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = {1558-QW1} - Dd. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = (1558-QW1)
- Aa. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
140To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attributes do not match.
- ATrue
- BFalse
141SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
- ATrue
- BFalse
142Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
- Aa. SELECT ONLY V_CODE
FROM PRODUCT; - Bb. SELECT UNIQUE V_CODE
FROM PRODUCT; - Cc. SELECT DIFFERENT V_CODE
FROM PRODUCT; - Dd. SELECT DISTINCT V_CODE
FROM PRODUCT;
- Aa. SELECT ONLY V_CODE
143When you issue the DELETE FROM tablename command without specifying a WHERE condition, _____ .
- Aa. no rows will be deleted
- Bb. the first row will be deleted
- Cc. the last row will be deleted
- Dd. all rows will be deleted
144If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.
- ATrue
- BFalse
145Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21377 or V_CODE = 24288?
- Aa. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE <= 24288 - Bb. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE => 24288 - Cc. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE > 24288 - Dd. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE = 24288
- Aa. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
146You cannot insert a row containing a null attribute value using SQL.
- ATrue
- BFalse
147When joining three or more tables, you need to specify a join condition for one pair of tables.
- ATrue
- BFalse
148String comparisons are made from left to right.
- ATrue
- BFalse
149Which query will output the table contents when the value of V_CODE is not equal to 21344?
- Aa. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <> 21344; - BB. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <= 21344; - Cc. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344; - Dd. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE => 21344;
- Aa. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
150The ____ special operator is used to check whether an attribute value is null.
- Aa. BETWEEN
- Bb. IS NULL
- Cc. LIKE
- Dd. IN
151A(n) ____ is an alternate name given to a column or table in any SQL statement.
- Aa. alias
- Bb. data type
- Cc. stored function
- Dd. trigger
152The ____ command is used with the ALTER TABLE command to modify the table by deleting a column.
- Aa. DROP
- Bb. REMOVE
- Cc. DELETE
- Dd. ERASE
153The special operator used to check for similar character strings is ____ .
- Aa. BETWEEN
- Bb. IS NULL
- Cc. LIKE
- Dd. IN
154Which query will output the table contents when the value of P_PRICE is less than or equal to 10?
- Aa. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE <> 10; - Bb. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE <= 10; - Cc. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE => 10; - Dd. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE = 10;
- Aa. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
155Date procedures are often more software-specific than other SQL procedures.
- ATrue
- BFalse
156Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.
- ATrue
- BFalse
157What does SQL stand for?
- Aa. Structured Query Language
- Bb. Specific Query Language
- Cc. Special Query Language
- Dd. Subjective Question Language
158SQL functions fit into which of the following two broad categories?
- Aa. Data Dictionary Language and Data Management Language
- Bb. Data Definition Language and Data Manipulation Language
- Cc. Data Manipulation Language and Data Dictionary Language
- Dd. None of these choices are correct
159Why is SQL relatively easy to learn?
- Aa. End users and programmers don't need to know the physical data storage format that take place when a SQL command is executed.
- Bb. It is a nonprocedural language.
- Cc. It has a vocabulary of less than 100 words.
- Dd. All of these choices are correct.
160Which of the following two tasks must be completed before you can use a new RDBMS?
- Aa. Decide what queries you will execute
- Bb. "Create the database structure" and "Create the tables that will hold the end user data"
- Cc. Create the tables that will hold the end user data
- Dd. Create the database structure
161____ is the process the DBMS uses to verify that only registered uses across the database.
- Aa. Verification
- Bb. Normalization
- Cc. Authentication
- Dd. Denormalization
162In the SQL environment, a _____ is a logical group of database objects - such as tables and indexes - that are related to each other and which usually belong to a single user or application.
- Aa. partition
- Bb. schema
- Cc. diagram
- Dd. disk
163The _____ SQL data type is used for variable-length data and allows you to store characters up to L characters long, leaving no unused spaces.
- Aa. TEXT(L)
- Bb. CHAR(L)
- Cc. VAR(L)
- Dd. VARCHAR(L)
164Which of the following attributes would be best defined as a CHAR data type?
- Aa. P_DESCRIPT (Product Description)
- Bb. V_CODE (Vendor Code [PK])
- Cc. P_DATE (for stocking date)
- Dd. V_STATE (2-character State code)
165What type of integrity is enforced when a primary key is declared?
- Aa. Referential Integrity
- Bb. Dataset Integrity
- Cc. Entity Integrity
- Dd. Attribute Integrity
166Is it preferable to use a DATE data type to store date data or a character data type?
- Aa. CHAR data type
- Bb. Neither "DATE data type" or "CHAR data type"
- Cc. DATE data type
- Dd. It doesn't matter - either is the same
167An attribute that contains only digits may be properly defined as _____ when the values are nominal; that is, the values do not have numerical significance but serve only as labels such as ZIP codes and telephone numbers.
- Aa. NUMERIC(L,D)
- Bb. TEXT(L)
- Cc. INTEGER
- Dd. CHAR(L)
168In a 1:M relationship, you must always create the table for the ____ side first.
- Aa. "1"
- Bb. "M"
- Cc. It doesn't matter
- Dd. Both at the same time
169A RDBMS automatically enforces referential integrity for ____ .
- Aa. primary keys
- Bb. composite keys
- Cc. foreign keys
- Dd. surrogate keys
170Which of the following is NOT an ANSI SQL standard constraint?
- Aa. CHECK
- Bb. UNIQUE
- Cc. DEFAULT
- Dd. All of these choices are ANSI SQL standard constraints.
171The CREATE TABLE command lets you define constraints in which places?
- Aa. when you use the ALTER keyword (known as a database constraint)
- Bb. when you create the column definition (known as a column constraint)
- Cc. when you use the CONSTRAINT keyword (known as a table constraint)
- Dd. "when you create the column definition (known as a column constraint)" an "when you use the CONSTRAINT keyword (known as a table constraint)" only
172It is important to remember when you create a primary key, the DBMS automatically creates a ____ .
- Aa. composite index
- Bb. foreign key
- Cc. unique index
- Dd. composite key
173Which of the following is the correct way to insert a row into the PRODUCT table (which has five attributes total) using a NULL for the last attribute?
- Aa. INSERT INTO PRODUCT VALUE(value1, value2, value3, value4, NULL)
- Bb. INSERT INTO PRODUCT VALUE(value1, value2, value2, value4,)
- Cc. INSERT INTO PRODUCT VALUE(value1, value2, value2, value4, "")
- Dd. All of these choices are correct.
174It is important to remember that any changes made to a table are not saved on disk until you close the database, close the program you are using, or use the _____ command.
- Aa. ROLLBACK
- Bb. COMMIT
- Cc. END
- Dd. SET
175Which wildcard character can be used in a SELECT command to list all attributes and all rows of a particular table?
- Aa. #
- Bb. all
- Cc. *
- Dd. &
176_____ undoes any changes since the last COMMIT command and brings the data back to the values that existed before the changes were made.
- Aa. COMMIT
- Bb. ROLLBACK
- Cc. SET
- Dd. END
177Assume that you perform the following actions:
Step 1. CREATE a table called SALES
Step 2. INSERT 10 rows in the SALES table
Step 3. UPDATE two rows in the SALES table
Step 4. Execute the ROLLBACK command
Which of the steps 1-3 above will be undone as a result of issuing the ROLLBACK command?- Aa. Step 1 only
- Bb. Step 1, Step 2, and Step 3
- Cc. Step 2 and Step 3 only
- Dd. None of them will be undone.
178A(n) ____ is a query that is embedded or nested inside another query.
- Aa. subquery
- Bb. outer query
- Cc. multi-query
- Dd. masked query
179You can select partial table contents by placing restrictions on the rows to be included in the output by using the _____ clause to add conditional restrictions to the SELECT statement that limit the rows and returned by the query.
- Aa. ORDER BY
- Bb. WHERE
- Cc. INTO
- Dd. FROM
180You can use _____ with table attributes in a column list or in a conditional expression to obtain restricted output from a query.
- Aa. set rules
- Bb. alphabetic letters
- Cc. arithmetic operators
- Dd. greek letters
181As you perform mathematical operations on attributes, it is important to remember the _____ .
- Aa. set rules
- Bb. multiplication symbol
- Cc. rules of expressions
- Dd. rules of precedence
182Which of the following is the correct way to rewrite the WHERE clause WHERE V_STATE IN ('TN', 'FL', 'GA') without the use of the IN special operator?
- Aa. WHERE V_STATE IS 'TN' OR V_STATE IS 'FL' OR V_STATE IS 'GA'
- Bb. WHERE V_STATE = 'TN' OR V_STATE = 'FL' OR V_STATE = 'GA'
- Cc. WHERE V_STATE IS 'TN' OR 'FL' OR 'GA'
- Dd. WHERE V_STATE = 'TN' OR 'FL' OR 'GA'
183All changes in the table structure are made by using the _____ command, followed by a keyword that produces the specific change you want to make.
- Aa. SET TABLE
- Bb. ALTER COLUMN
- Cc. CHANGE TABLE
- Dd. ALTER TABLE
184Which of the following are valid keywords that can be used with the ALTER TABLE command to produce specific changes you want to make to a table?
- Aa. ADD, CHANGE, DELETE
- Bb. ADD, MODIFY, DROP
- Cc. INSERT, MODIFY, DELETE
- Dd. ADD, MODIFY, DELETE
185To make changes to data in the columns of existing rows, you would use the ____ command.
- Aa. SET
- Bb. UPDATE
- Cc. INSERT
- Dd. CHANGE
186A table can be deleted from the database using the _____ command if it is not the "one" side of any relationship.
- Aa. DROP TABLE
- Bb. CHANGE TABLE
- Cc. DELETE TABLE
- Dd. ALTER TABLE
187The _____ clause is especially useful when the listing order is important to you in the output of a query.
- Aa. SET ORDER
- Bb. ORDER BY
- Cc. ASCENDING
- Dd. SET BY
188Select which answers explain why the two following commands produce different results.
SELECT DISTINCT COUNT (V_CODE) FROM PRODUCT;
SELECT COUNT (DISTINCT V_CODE) FROM PRODUCT;- Aa. The second command applies the DISTINCT keyword to the V_CODE's before the count is taken so only unique values are counted.
- Bb. The first command executes the COUNT function to count the number of the values in V_CODE including duplicate values, and then the DISTINCT keyword only allows one count of that value to be displayed.
- Cc. The difference is in the order of operations.
- Dd. All of these choices are correct.
189The _____ function is used to tally the number of non-null values of an attribute. It can also be used in conjunction with the DISTINCT clause.
- Aa. COUNT
- Bb. DELETE
- Cc. MULTIPLY
- Dd. ADD
190Which of the following explains the difference between the COUNT aggregate function and the SUM aggregate function?
- Aa. SUM can only be applied to numeric values
- Bb. SUM adds the values together
- Cc. COUNT returns the number of values without regard to what the values are.
- Dd. All of these choices are correct.
191Rows can be grouped into smaller collections quickly and easily using the _____ clause within the SELECT statement.
- Aa. COLLECT
- Bb. SUM
- Cc. ORDER BY
- Dd. GROUP BY
192Which of the following best describes the difference between GROUP BY and ORDER BY in SQL queries?
- Aa. ORDER BY sorts the rows being returned by the query, while GROUP BY collects the rows into collections to be acted on by aggregate functions.
- Bb. ORDER BY cannot be used if the aggregate functions are included in the query, but GROUP BY can be used even if aggregate functions are included in the query.
- Cc. There is no difference because GROUP BY and ORDER BY are alternative clauses to do the same thing.
- Dd. GROUP BY sorts the rows returned by the query based on the values of a single attribute, while ORDER BY can sort the rows by multiple attributes.
193Which of the following is/are true when using the GROUP BY clause with a SELECT statement?
- Aa. The GROUP BY clause columnist can include any columns from the tables in the FROM clause of the SELECT statement, even if they do not appear in the SELECT's columnist.
- Bb. The GROUP BY clause's columnist must include all non-aggregate function columns in the SELECT's columnist.
- Cc. The SELECT's columnist must include a combination of column names and aggregate functions.
- Dd. All of these choices are correct.
194A _____ is a join in which a table is joined to itself.
- Aa. duplicate join
- Bb. self join
- Cc. inner join
- Dd. recursive join
195When a DBMS sends back a response to an application, this is called a _____ .
- Aa. Query
- Bb. Metadata
- Cc. Query result set
- Dd. Data inconsistency
196Description of data characteristics and the set of relationships that link data within a database is the ______ .
- Aa. DBMS
- Bb. Data management
- Cc. Query
- Dd. Metadata
197An attribute in a specific row that directly determines other values in that row is a _____ .
- Aa. Determinant
- Bb. Dependent
- Cc. Primary Key
- Dd. Foreign Key
198What is the entity that is used to transform a M:N relationship into two 1:M relationships?
- Aa. Associative entity
- Bb. Bridge entity
- Cc. Composite Entity
- Dd. All of the above
199What relationship cannot be implemented between two entities?
- Aa. 1:M
- Bb. M:N
- Cc. M:M
- Dd. 1:1
200You have three active tables:
STUDENT - unique records for each student via STUDENT_ID
COURSE - unique record for each course offered via COURCE_ID
ENROLL - courses that each student is enrolled in
Assuming appropriate PK/FK table relationships are in place, if a student is taking 15 hours in 3 classes, what is the relationship between STUDENT and ENROLL?- Aa. 1:M
- Bb. M:1
- Cc. 1:1
- Dd. M:N
Information
- Description
- Business Analyst IS301 Quiz on IS301 - Intro to Database Management Systems, created by Jamey Cendana on 24/03/2022.
- Author
- Jamey Cendana
- Language
- English
- Views
- 21
- Tags
- Rating
- No ratings yet Rate this quiz