ISDS 3003 FINAL
Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters? A. % (percent sign) B. ; (semi-colon) C. ! (exclamation mark) D. ? (question mark) E. _ (underscore)
A. % (percent sign)
Which of the following functional dependency diagrams accurately represents the following situation:• A campus has many buildings.• Each building has a unique name.• Each building has many rooms.• All rooms in any given building are numbered sequentially starting at "101."• Each room has a certain capacity, although many rooms in the same building or different buildings may have the same capacity.• Each room is assigned to a single department.• A department may have many rooms in one or more buildings, each with the same or different capacities. A. (BuildingName, RoomNumber) → (Capacity, Department) B. (BuildingName, Capacity) → (Department, RoomNumber) C. (Department, Capacity) → (BuildingName, RoomNumber) D. BuildingName → (RoomNumber, Capacity, Department) E. RoomNumber → (BuildingName, Department, Capacity)
A. (BuildingName, RoomNumber) → (Capacity, Department)
Given only the following excerpt of an E-R model:Which of the following is known to be true? A. A single instance of ENTITY B may be related to many instances of ENTITY A. B. There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment. C. A single instance of ENTITY A must be related to many instances of ENTITY B. D. ENTITY A has a minimum cardinality of one. E. The degree of the relationship is "many."
A. A single instance of ENTITY B may be related to many instances of ENTITY A.
The creation of a database and its tables is a function of which component of the database system? A. DBMS B. Users C. Application D. Web server E. Database
A. DBMS
What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database? A. Dirty reads B. Nonrepeatable reads C. Unlocked reads D. Serialized reads E. Phantom reads
A. Dirty reads
Which of the following problems associated with storing data in a list is avoided by storing data in a relational database? A. Duplication of data items B. Incorrect data typing C. Lack of necessary bandwidth D. Running out of memory storage E. CPU processing inefficiencies
A. Duplication of data items
a table that meets the requirements of a relation is said to be in which normal form? A. First normal form B. Relational normal form (RNF) C. Second normal form D. Boyce-Codd normal form E. Domain/key normal form
A. First normal form
Which of the following is not one of the five SQL built-in functions? A. MODE B. AVG C. SUM D. COUNT E. MAX
A. MODE
Which of the following is the correct technique for representing a 1:N relationship in the relational model? A. The key of the entity on the one side is placed into the relation for the entity on the manyside. B. The key of the entity on the many side is placed into the relation for the entity on the one side. C. An intersection relation is created, and the keys from both parent entities are placed as keys in the intersection relation. D. The key of either relation can be placed into the other relation. E. The key of the child is placed into the relation of the parent.
A. The key of the entity on the one side is placed into the relation for the entity on the manyside.
Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column? A. WHERE Hours BETWEEN 10 AND 50 B. WHERE Hours = 10 and Hours = 50 C. WHERE Hours = MIN(10) and MAX(50) D. WHERE Hours RANGE 10 TO 50 E. WHERE Hours IN [10, 50]
A. WHERE Hours BETWEEN 10 AND 50
Each attribute of an entity becomes a ________ of a table. A. column B. primary key C. foreign key D. alternate key E. either primary key or alternate key
A. column
Microsoft SQL server is an example of a: A. database management system B. list manager C. table D. data manipulation system E. database
A. database management system
Star schemas have a ________ at the center of the star. A. fact table B. dimension table C. map table D. reduce table E. None of these
A. fact table
An ACID transaction is one that is all but ________. A. guaranteed B. consistent C. durable D. atomic E. isolated
A. guaranteed
Whether a lock applies to data at the record level, page level, table level, or database level is referred to as ________. A. lock granularity B. serializable locking C. lock phasing D. lock sharing E. lock exclusivity
A. lock granularity
The order of the columns returned by an SQL SELECT statement is determined by the ________ A. order they are listed in following SELECT B. ORDER BY clause C. order they are listed in following FROM D. SORT BY clause E. order they are listed in following WHERE
A. order they are listed in following SELECT
The identifier of the entity becomes the ________ of the corresponding table. A. primary key B. foreign key C. supertype D. subtype E. either primary key or foreign key
A. primary key
A relational database stores data in the form of: A. tables B. lists C. columns D. forms E. spreadsheets
A. tables
SQL statements used to construct views cannot contain ________. A. the ORDER BY clause B. the SELECT clause C. the LIKE keyword D. the WHERE clause E. the FROM clause
A. the ORDER BY clause
Dimensional databases are used to track historical data and therefore must have a ________. A. time dimension B. customer dimension C. sales dimension D. either time dimension or customer dimension E. both time dimension and customer dimension
A. time dimension
An SQL virtual table is called a ________. A. view B. embedded SQL statement C. trigger D. stored procedure E. CHECK constraint
A. view
Select the best answer to describe a 1:N relationship. The foreign key must be placed in the child relation. The N side of the relationship is called the child. The 1 side of the relationship is called the parent. All of the above are true of a 1:N relationship.
All of the above are true of a 1:N relationship.
Database backup and recovery is an important job of database administrators. Which of the following are true of the transaction log? A log of data changes must be kept in chronological order. Before and after images of database records should be kept in the log. Before images are used in the rollback method and after images are used in the rollforward method. All of the choices are true.
All of the choices are true.
Database security is broken into 2 parts: authentication and authorization. Which of the following statements is true? Authorization assigns the authenticated user specific permissions to specific activities on the system using SQL GRANT statements. Authentication grants permissions using SQL Data Control Language.
Authorization assigns the authenticated user specific permissions to specific activities on the system using SQL GRANT statements.
Based on the tables below, which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo, CustName, RepName? A. SELECT CustNo, CustName, RepNameFROM SALESREP, CUSTOMERWHERE CustNo=*; B. CREATE VIEW CustomerSalesRep ASSELECT CustNo, CustName, RepNameFROM SALESREP, CUSTOMERWHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo; C. SELECT CustNo, CustName, RepNameFROM SALESREP, CUSTOMERWHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo; D. CREATE VIEW CustomerSalesRep ASSELECT CustNo, CustName, RepNameFROM SALESREP, CUSTOMERWHERE CustNo=*; E. SELECT CustNo, CustName, RepNameFROM SALESREP, CUSTOMER;
B. CREATE VIEW CustomerSalesRep ASSELECT CustNo, CustName, RepNameFROM SALESREP, CUSTOMERWHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
Conditions after the WHERE keyword require single quotes around the values for columns that have which data type? A. Date/Time B. Char C. Decimal D. Numeric E. Integer
B. Char
Computer systems fail for which of the following reasons except? A. People make mistakes. B. Databases randomly changed field values. C. Electrical power fails. D. Hardware breaks. E. Programs have bugs.
B. Databases randomly changed field values.
Which SQL keyword can be used in conjunction with wildcards to select partial values? A. SELECT B. LIKE C. SUBSTRING D. FIND E. SEARCH
B. LIKE
A Business Intelligence (BI) reporting system that uses extensions to SQL is ________. A. PHP B. OLAP C. cluster analysis D. regression analysis E. RFM analysis
B. OLAP
Which of the following would not be an example of database metadata? A. Properties of columns B. Queries against records in the database tables C. Properties of tables in a database D. Names of tables in a database E. Names of columns in a database and their associated tables
B. Queries against records in the database tables
Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system? A. User interviews B. Referential integrity constraints C. Use cases D. Forms E. Business rules
B. Referential integrity constraints
Given the tableCUSTOMER(CustID, Name, PhoneNum, AcctBalance)what is the standard SQL query phrase to retrieve the Name and Phone Number of customers? A. SELECT (Name, PhoneNum) B. SELECT Name, PhoneNum C. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum) D. SELECT * E. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
B. SELECT Name, PhoneNum
Given the tableCUSTOMER(CustID, Name, PhoneNum, AcctBalance)what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?
B. WHERE AcctBalance > 50
In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates ________. A. a minimum cardinality of mandatory B. a minimum cardinality of optional C. a maximum cardinality of one D. a maximum cardinality of many E. Both a minimum cardinality of optional and a maximum cardinality of one
B. a minimum cardinality of optional
The number of entity classes involved in a relationship is known as the relationship's ________. A. maximum cardinality B. degree C. class D. minimum cardinality E. ordinality
B. degree
The first step of the normalization process is to ________. A. identify all the determinants of a relation B. identify all the candidate keys of a relation C. identify all the foreign keys of a relation D. split the relation into two or more new relations E. identify all the functional dependencies of a relation
B. identify all the candidate keys of a relation
Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of all except ________. A. standardized processing B. increased network throughput C. specialization among developers D. less work E. greater security
B. increased network throughput
SQL statements used to construct views cannot contain ________. A. the SELECT clause B. the ORDER BY clause C. the LIKE keyword D. the FROM clause E. the WHERE clause
B. the ORDER BY clause
The difference between BI systems and operational systems are: BI systems support management's analysis and operational systems support primary business activities such as an inventory control system. Operational systems process data purchased from data vendors and BI systems do not. Operational systems process BI system data. BI systems use a DBMS to insert, modify and delete data and operational systems do not.
BI systems support management's analysis and operational systems support primary business activities such as an inventory control system.
Which of the following is the correct technique for representing a N:M relationship using the relational model? A. An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation. B. An intersection relation is created with a surrogate key, which is placed in each of the parent entities. C. An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation. D. The key from either relation is placed as a foreign key in the other relation. E. None of these
C. An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? A. REDUCE B. SORT C. DISTINCT D. UNIQUE E. ORDER BY
C. DISTINCT
Which of the following is true about a shared lock? A. It is more restrictive than an implicit lock. B. It must use a two-phase locking scheme. C. It allows reads to the locked item. D. It allows only two transactions to update a record simultaneously. E. It locks the item from all access.
C. It allows reads to the locked item.
Which of the following data types used in SQL would define a numeric field of the pattern 99.99? A. Integer(5,2) B. Numeric(5,2) C. Numeric(4,2) D. Numeric(2,2) E. Integer(2,2)
C. Numeric(4,2)
Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field? A. SORT BY Department DESC B. SORT BY Department C. ORDER BY Department DESC D. SORT BY Department REVERSE E. REVERSE Department
C. ORDER BY Department DESC
Which of the following terms is synonymous with "tuple"? A. Field B. Relation C. Row D. Attribute E. Table
C. Row
What role does the Web browser play in a Web database application? A. Hardware support B. Bug-reporting System C. Web user interface D. Microchip accelerator E. Back-end Database Management System
C. Web user interface
a primary key is a: A. not required to be unique B. always automatically generated by the DBMS C. a candidate key D. comprised of exactly one attribute E. used to represent columns in relationships
C. a candidate key
A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called: A. a functional dependency B. a key matching constraint C. a referential integrity constraint D. normalization E. synchronization
C. a referential integrity constraint
A relational database is: A. a collection of forms and reports that support a given purpose B. a set of metadata C. a self-describing collection of related tables D. a library of queries and data files for querying E. a set of applications and the data sets for those applications
C. a self-describing collection of related tables
Data mining applications are used to accomplish all of the following tasks except ________. A. incorporate results into some other report/system B. facilitate decision making C. classify entities D. make predictions E. perform what-if analysis
C. classify entities
The representation of the content, relationships, and constraints of the data needed to support the system requirements is the ________. A. application program B. relation design C. data model D. data view E. implementation
C. data model
The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________. A. transaction logging B. reprocessing C. rollforward D. checkpointing E. rollback
C. rollforward
In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that: A. the relation needs to be broken into two or more new relations B. surrogate keys in the relation may not be correctly linked to other relations C. the relation is well formed D. referential integrity constraints concerning the relation need to be established E. the relation needs to have foreign keys added in order to be correctly linked to other relations
C. the relation is well formed
SQL views are used for all except ________. A. to layer built-in functions B. to hide complicated SQL syntax C. to backup preexisting tables D. to display the results of computations E. to hide columns or rows
C. to backup preexisting tables
In which steps of the SDLC does the database design process take place? Select all that apply. Component Design System Maintenance System Definition Implementation Requirements Analysis
Component Design Implementation Requirements Analysis
What is not a reason to use the SQL ALTER TABLE statement? A. Add columns B. Add constraints C. Modify columns D. Add triggers E. Drop columns
D. Add triggers
Business Intelligence (BI) systems do which of the following? A. Analyze current and past activities B. Predict future events C. Record and process transactions D. Both Analyze current and past activities and Predict future events E. Support routine operational activities
D. Both Analyze current and past activities and Predict future events
Business Intelligence (BI) reporting systems can do which of the following operations? A. Filter data B. Group data C. Modify data D. Both Filter data and Group data E. Secure data
D. Both Filter data and Group data
Which of the following cannot be done using the CONSTRAINT phrase? A. Define a foreign key. B. Establish a referential integrity constraint. C. Defining a name for the constraint. D. Define an attribute to be NOT NULL. E. Create a single attribute primary key.
D. Define an attribute to be NOT NULL.
Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY? A. DISTINCT B. WHERE C. SORT D. HAVING E. LIKE
D. HAVING
Which of the following would be a reason to denormalize a relation? A. Relax security B. Lack of design time C. End user preference D. Improve performance E. None of these
D. Improve performance
Which of the following is not true about null values? A. A null value can mean that no value for the field is appropriate. B. A null value is ambiguous. C. A null value can mean that the value is known to be blank. D. Null values cannot be avoided. E. A null value can mean that the value is unknown.
D. Null values cannot be avoided.
Which type of join, although not included in standard SQL, was created to allow unmatched rows to appear in the result of a join operation? A. INNER JOIN B. OPEN JOIN C. COMBINE JOIN D. OUTER JOIN E. ODD JOIN
D. OUTER JOIN
What is the first stage in the logical process flow of a User-Defined function? A. Preprocess parameter values B. Output to calling SQL statement C. Arrange results into a formal ResultSet D. Receive input from calling SQL statement E. Process parameter values to create result(s)
D. Receive input from calling SQL statement
SQL stands for: A. Structured Question Language B. Standard Question Language C. Structural Question Language D. Structured Query Language E. Standard Query Language
D. Structured Query Language
Given the tablesTABLE_A (Attribute1, Attribute2, Attribute3)TABLE_B (Attribute4, Attribute5, Attribute6)as shown in the figure below, which of the following would display the correct placement of foreign keys in the relational model? A. TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)TABLE _B (Attribute4, Attribute5, Attribute6) B. TABLE _A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6) C. TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6)TABLE _B (Attribute4, Attribute5, Attribute6) D. TABLE_A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1) E. TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
D. TABLE_A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
Which of the following terms is synonymous with "relation"? A. Tuple B. Record C. Row D. Table E. Attribute
D. Table
Stored procedures have the advantage of all choices except ________. A. decreased network traffic B. code sharing C. greater security D. data integrity through distributed copies E. SQL optimized by the DBMS compiler
D. data integrity through distributed copies
When the primary key of one relation is placed into a second relation, it is called a ________. A. field key B. relocated key C. candidate key D. foreign key E. referential integrity
D. foreign key
The Microsoft Access 2019 data type of AutoNumber is used when there is a specific need for a: A. primary key B. secondary key C. spare key D. surrogate key E. foreign key
D. surrogate key
A relational database stores data in the form of ________. A. forms B. spreadsheets C. columns D. tables E. lists
D. tables
_________ systems employ sophisticated statistical and mathematical techniques used for what-if analyses, predictions, and decisions. Data Mining Transactional Systems RFM Analysis Operational Systems
Data Mining
Given the relations:STUDENT (SID, StudentName, Major, AdvisorID)ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each student is assigned to one advisor, which of the following is true? A. SID is both a primary key and a foreign key. B. Major is a candidate key. C. AdvisorName is a determinant. D. Phone is a candidate key. E. AdvisorID is a foreign key.
E. AdvisorID is a foreign key
The SQL statement used to delete a view from a database is ________. A. DELETE VIEW ViewName B. DROP EXISTING VIEW ViewName C. ALTER VIEW ViewName AS D. ALTER EXISTING VIEW ViewName AS E. DROP VIEW ViewName
E. DROP VIEW ViewName
Given the below functional dependency,MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)which of the following statements is not known to be true? A. ShelfLife is functionally dependent on MedicineCode. B. Manufacturer is functionally dependent on MedicineCode. C. MedicineCode is a determinant. D. MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage). E. MedicineName is a determinant
E. MedicineName is a determinant
Regarding Big Data, what does the term NoSQL really mean? A. No SQL used B. Notational Query Language C. Non-Blocking Query Language D. NortonOS Query Language E. Nonrelational Database
E. Nonrelational Database
What relationship pattern is illustrated in the following schema?EMPLOYEE (EmployeeID, OfficePhone, Manager)Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE A. Intersection relationship B. Supertype/subtype relationship C. Strong entity relationship D. Association relationship E. Recursive relationship
E. Recursive relationship
Which of the following is not true about surrogate keys? A. They can be problematic when combining databases. B. The DBMS will not allow their values to be changed. C. They have no meaning to the users. D. They are identifiers that are supplied by the system, not the users. E. They are nonunique within a table.
E. They are nonunique within a table.
Which of the following is not a basic element of the E-R Model? A. Identifiers B. Relationships C. Entities D. Cardinalities E. Use cases
E. Use cases
Which of the following is not a basic element of the E-R Model? A. Relationships B. Entities C. Cardinalities D. Identifiers E. Use cases
E. Use cases
Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query? A. SELECT B. GROUP BY C. ORDER BY D. FROM E. WHERE
E. WHERE
When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be, the transaction is said to be ________. A. locked B. consistent C. logical D. isolated E. atomic
E. atomic
During the normalization process, the remedy for a relation that is not well formed is to: A. convert it into a list B. combine it with another relation that is well formed C. create a surrogate key D. create a functional dependency E. break it into two or more relations that are well formed
E. break it into two or more relations that are well formed
A key that contains more than one attribute is called a: A. candidate key B. complex key C. n-key D. multi-key E. composite key
E. composite key
The representation of the content, relationships, and constraints of the data needed to support the system requirements is the ________. A. application program B. relation design C. implementation D. data view E. data model
E. data model
The purpose of concurrency control is to ________. A. ensure that triggers do not invoke stored procedures B. ensure that each form has a corresponding report C. ensure that ASPs do not duplicate JSPs D. ensure that stored procedures do not invoke triggers E. ensure that one user's work does not interfere with another's
E. ensure that one user's work does not interfere with another's
When there is a ___________ relationship, an intersection table must be created that will contain the primary keys of each of the other two tables as a composite primary key. -1:N -N:M -1:1 -All of the above.
N:M
Assume the database actions of recording a new order to be: Change customer record, increasing the value of amount owed Change the salesperson record, increasing the value of Commission Due Insert the new-order record into the database Which of the following will ensure that all three steps are processed, or none at all are processed? Perform the transaction as a series of independent steps. Perform the transaction as an atomic transaction using SQL transaction control language.
Perform the transaction as an atomic transaction using SQL transaction control language.
In the relationship displayed below, which entity is required (has a minimum cardinality of 1)? both ITEM and SUPPLIER SUPPLIER Neither ITEM nor SUPPLIER ITEM
SUPPLIER
Dimensional databases use which of the following database structures? Normalized Model Relational Model Star Schema Hierarchical Model
Star Schema
Which of the following is a limitation of using an SQL subquery? a. The WHERE clause cannot be used with the SQL subquery. b. The results (column values) must come from a single table. c. Only 1 subquery may be used in a select statement. d. Only one column can be displayed in the results.
b. The results (column values) must come from a single table
Which of the following are true about implicit joins? Check all true choices. a. An implicit join is an inner join. b. Implicit joins are NOT supported by My SQL. c. The JOIN ON clause is not used in an implicit join. d. It is an older way of joining tables used before the SQL-92 standards.
c. The JOIN ON clause is not used in an implicit join. d. It is an older way of joining tables used before the SQL-92 standards. a. An implicit join is an inner join.
SQL provides two different techniques for querying data from multiple tables. Select the 2 ways from the choices below. a. the SQL join b. the SQL alter c. the SQL connect d. the SQL subquery
d. the SQL subquery, a. the SQL join
An _________________ is a collection of entities and provides the structure of the entities in that class. identifier entity class attribute entity instance
entity class
