Download LIS 3784 Final Exam Test Bank Newest Edition 2025-2026. Questions & Correct Verified Answe and more Exams Database Management Systems (DBMS) in PDF only on Docsity!
LIS 3784 Final Exam Test Bank Newest
Edition 2025-2026. Questions & Correct
Verified Answers. Graded A
-Atomicity - required that all statements by completed as one logical unit -Consistency- transaction won't violate constraints -Isolation- the data being used in the execution of a transaction cannot be used by a second transaction until the first one is complete -Durability- transaction changes cannot be undone or lost once they are made -Serializability - will happen sequentially โ ANS What do the ACIDS words mean? "old-style" join โ ANS The following SQL statement uses a(n) ____. SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; -cross join -relational set operator -"old-style" join -outer join 15 - ANSAssume you are using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the
CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator? 7 10 15 17 17 - ANSAssume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator? 7 10 15 17 1NF - ANSA 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 ____. -1NF -2NF -3NF -4NF
96 - ANSHow many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 12? 108 20 92 96 A single SQL statement in an application program or transaction - ANSWhat is a database request? a. A series of SQL statements that implement all of the business rules in an application. b. One or more SQL statements that implement one business rule. c. A single SQL statement in an application program or transaction. d. A transaction. a super key with no repeated attribute - ANScandidate key access rights - ANSCh9Q16: The assignment of ________ may restrict operations on predetermined objects such as databases, tables, views, queries and reports. -password security -audit trails -diskless workstations -access rights
alias - ANSCh7Q21: A(n) ________ is an alternate name given to a column or table in any SQL statement. -data type -alias -trigger -stored function all rows will be deleted - ANSCh7Q13: What happens when you issue the DELETE FROM tablename command without specifying a WHERE condition? -no rows will be deleted -all rows will be deleted -the first row will be deleted -the last row will be deleted an artificial key that is made when you do not have a natural primary key - ANSsurrogate key analysis - ANSCh9Q3: "What are the requirements of the current system's end users?" is a question asked during the ________ phase of the SDLC. -analysis -planning -maintenance -implementation analysis - ANSUser requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
-atomicity, durability, consistency, isolation, and serializability Audit trails - ANSCh9Q17: ________ are usually provided by the DBMS to check for access violations. -Audit trails -Diskless workstations -Access rights -Security devices BETWEEN - ANSCh7Q24: The ________ operator is used to define a range limit. -BETWEEN -NULL -IN -LIKE cannot be further subdivided - ANSAn atomic attribute ____. -cannot exist in a relational table -cannot be further subdivided -displays multiplicity -is always chosen to be a foreign key Centralized - ANSCh9Q20: ________ design is productive when the data component is composed of a relatively small number of objects and procedures. -Denormalized -Decentralized
-Centralized -Normalized CHAR and VARCHAR - ANSSQL character data format(s) is(are) ____. -CHAR and VARCHAR -VARCHAR only -Alphanumeric -CHAR only CHAR and VARCHAR2 - ANSCh7Q6: ________ is/are SQL character data type(s). -VARCHAR2 only -ALPHANUMERIC -CHAR only -CHAR and VARCHAR CHAR(15) - ANSCh8Q3: Which data type is considered compatible with VARCHAR(35)? -CHAR(15) -DATE -TINYINT -INT coding - ANSCh9Q19: Which activity in the SDLC is parallel to implementation and loading in the DBLC? -analysis -detailed design
-RETRIEVE
-ASSIGN
-UPDATE
-COMMIT
COMMIT - ANSWhen a(n) ________ statement is reached, all changes are permanently recorded within the database. a. DONE b. EXIT c. COMMIT d. ROLLBACK COMMIT - ANSWhen the end of a program is reached, all changes are permanently recorded within the database; this action is equivalent to issuing the ________ statement. a. EXIT b. BYE c. COMMIT d. ROLLBACK consistent - ANSA ________ database state is one in which all data integrity constraints are satisfied. a. fixed b. secure c. complete d. consistent
cross - ANSCh8Q16: The statement SELECT * FROM T1, T2 produces a(n) ________ join. -natural -full -cross -equi- database administrator - ANSCh9Q15: Once the data have been loaded into the database, the ________ tests and fine-tunes the database to ensure that it performs as expected. -database administrator -systems administrator -programmer -manager database analysis and requirements - ANSCh9Q8: Which of the conceptual design steps determines end-user views, outputs, and transaction- processing requirements? -database analysis and requirements -distributed database design -data model verification -entity-relationship modeling and normalization database level, table level, page level, roll level - ANSWhat are the 4 types of database locks? DELETE FROM PRODUCT
Durability - ANS________ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure. a. Consistency b. Isolation c. Atomicity d. Durability entity-relationship modeling and normalization - ANSCh9Q9: Which of the conceptual design steps defines entities, attributes, and relationships? -distributed database design -entity-relationship modeling and normalization -data model verification -database analysis and requirements EXISTS - ANSCh7Q25: The ________ operator is used to check whether an attribute has a value. -IN -BETWEEN -LIKE -EXISTS FORMAT - ANSCh7Q8: In Oracle, the ________ command is used to place a $ in front of a numeric value. -CHAR -CONVERT -DISPLAY -FORMAT
full outer - ANSCh8Q17: A ________ join of two tables returns rows with matching values and includes all rows from both tables with unmatched values. -full outer -natural -cross -left outer identifies rows in a table (basically the header) - ANSsuperkey identify the ER model's central entity - ANSCh9Q12: The first step in the ER model verification process is to ________. -identify each module's internal transaction requirements -identify each module and its components -identify the ER model's central entity -verify all processes against the ER model identify, analyze, and refine the business rules - ANSCh9Q10: The first step in developing the conceptual model using ER diagrams is to ________. -identify, analyze, and refine the business rules -complete the initial ER diagram -define the attributes, primary keys, and foreign keys for each of the entities -normalize the entities
-outer inner - ANSWhen using a(n) ____ join, only rows that match the given criteria are returned. -full -inner -outer -set inner, left outer, right outer, full outer, cross - ANSWhat are the 5 types of joins? input/output (I/O) operations - ANSEach database request generates several ________. a. input/output (I/O) operations b. transactions c. business processes d. SQL statements INSERT - ANSCh7Q1: The SQL command that lets you insert data into a table, one row at a time, is ________. -SELECT -COMMIT -UPDATE -INSERT
integrity - ANSAll transactions are controlled and executed by the DBMS (subject to some limitations) to guarantee database ________. a. uniqueness b. integrity c. consistency d. design INTERSECT - ANSCh8Q10: The ________ statement can be used to combine rows from two queries, returning only the rows that appear in both sets. -UNION -MINUS -UNION ALL -INTERSECT IS NULL - ANSCh7Q23: The ________ operator is used to check whether an attribute value is null. -LIKE -IN -BETWEEN -IS NULL Isolation - ANS____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. -Serializability -Atomicity
d. table logical - ANSA transaction is a ____ unit of work that must be either entirely completed or aborted. -timed -practical -logical -physical logical - ANSCh9Q13: The ________ design is used to translate the conceptual design into the internal model for a selected database management system. -logical -physical -network -time maintenance - ANSEvaluation, maintenance, and enhancement are part of the ____ phase of the SDLC. -planning -maintenance -detailed systems design -implementation maintenance and evolution - ANSCh9Q5: The last phase in the Database Life Cycle is ________.
- implementation and loading
- testing and evaluation
- maintenance and evolution
- operation make decisions about adding derived attributes to satisfy processing requirements - ANSCh9Q11: During the Entity-Relationship modeling process, the designer must ________. -avoid all ternary relationships -delete the ER diagram -make decisions about the placement of primary keys in 1:1 relationships -make decisions about adding derived attributes to satisfy processing requirements MINUS - ANSCh8Q1: ________ is a relational set operator. -MINUS -ALL -EXISTS -PLUS MINUS - ANSCh8Q11: The ________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second. -MINUS -UNION ALL -INTERSECT -UNION
