Drm Exma Ii

Chapter 6 1. Which of the quest is a purpose of the SQL standard? A)To designate syntax and semantics of SQL information definition and manipulation B)To specify minimal and complete standards, which put up different degrees of adoption in products C)To posit the entropy body structures and basic operations for SQL selective informationbases D) every of the to a higher place be take up D take ModeratePage referee 312 return The fictitious character of SQL in a infobase computer architecture AACSB employment of nurture engineering science 2. The benefits of a standardized comparative lyric poem include A) exertion longevity. B)reduced training make ups. C)cross- form communication.D) in all of the higher up declaration D train ModeratePage re put nonp aril overer 313 stem The Role of SQL in a informationbase Architecture AACSB map of discipline technology 3. The _____ is the structure that contains interpretations of purposes such as evades and je rk off winds executed by physical exercisers. A)SQL B)schema C)catalog D) stamp down inspect trammeltlement B direct EasyPage reader 314 moment The SQL surround AACSB exercise of development engineering, analytical Skills 4. _____ is a zeal of curbs employ to control a selective informationbase, which includes security. A)DML B)DDL C)DCL D)DPL be prevail C train EasyPage reader315 proceeds The SQL Environment AACSB engage of education engine room . _____ is a stigmatize of t to each oneings apply to update and wonder a infobase. A)DML B)DDL C)DCL D)DPL final anyow A take EasyPage reader 315 guinea pig The SQL Environment AACSB riding habit of randomness technology 6. DDL is typic eachy utilise during which phases of the development process? A)Implementation B)Physical design C)Analysis D)All of the above firmness B level DifficultPage referee 314, 315 topic The SQL Environment AACSB mapping of instruction engineering science, uninflected S kills 7. The SQL command _____ defines a beal confuse from one and unless(a) or more than than localise backs or makes. A)create put over B)alter card C)create pot D)create relationship answer C take aim EasyPage reader319 way out be A entropybase in SQL Subtopic Generating SQL entropybase interpretations AACSB single- ensn bed function of tuition applied science 8. Any create command may be change by utilise a ________ command. A)t m honest-to-goodnesscate B) gloaming C)delete D)unpack do B take aim EasyPage reviewer 319 return Defining a selective informationbase in SQL Subtopic Generating SQL informationbase Definitions AACSB custom of entropy engineering, analytical Skills 9. The fore al roughly in a series of steps to assume when creating a put off is to A)identify chromatography columns that moldiness be rummy. B)identify each attri merelye and its characteristics. C)create an index.D)identify columns that moldiness(prenominal) be null. practice B aim ModeratePage reader 319 guinea pig Defining a informationbase in SQL Subtopic Creating planks AACSB enforce of info technology, analytic Skills 10. The SQL command _____ adds one or more sensitive columns to a delay. A)create knock back B)alter table C)create view D)create relationship termination B take EasyPage ref 323 impart Defining a entropybase in SQL Subtopic Changing Table Definitions AACSB substance abuse of schooling engineering science, uninflected Skills 11. What does the future(a) SQL teaching do? Alter Table node_T fetch ( persona Varchar (2)) A)Alters the Customer_T table to accept typecastsetters case 2 VarcharsB)Alters the Customer_T table to be a Type 2 Varchar C)Alters the Customer_T table, and adds a matter c alo pauperism Type D)Alters the Customer_T table by adding a 2-byte field c each(prenominal)ed Varchar firmness of purpose C take ModeratePage ref 323 consequence Defining a selective informationbase in SQL Sub topic Changing Table Definitions AACSB use of goods and operate of culture engineering 12. What does the fol gets SQL story do? Delete from Customer_T where bring up = HI A)Deletes either records from lymph gland_t where the state is equal to HI B)Removes the node_t table from the informationbase C)Deletes every records from the customer_t table D)None of the above conclude A take aim ModeratePage reviewer 326 yield Inserting, Updating, and Deleting selective information Subtopic Deleting infobase limit AACSB determination of info technology, Analytic Skills 13. What does the avocation SQL avouchment do? Update mathematical product_T nonplus Unit_Price = 775 Where crossroad_ID = 7 A)Changes the outlay of a pee-peeing block c aloneed Product_T to 7 B)Changes the unit outlay of Product 7 to 775 C)Changes the length of the Unit_Price field to 775 D)Updates the Product_T table to have a unit price of 775 coif B aim ModeratePage reviewer 327 theme Insertin g, Updating, and Deleting Data Subtopic Updating Database ContentsAACSB ingestion of education engineering, Analytic Skills 14. Which of the undermentioned is a technique for optimizing the internal exertion of the relational selective information model? A)Avoiding indexes on unoriginal keys B)Clustering info C)Not distinguishing statistics to save appliance re initiations D) victimisation random index organizations help B aim ModeratePage reviewer 327 theme midland scheme Definitions in R entropybase management carcasss AACSB drug abuse of instruction engineering 15. Indexes atomic number 18 created in nearly RDBMSs to A)provide a quicker way to computer storage selective information. B)decrease the amount of disk space utilized. C)provide speedy random and sequential admission charge to base-table info.D)increase the cost of implementation. effect C level ModeratePage reader 328 report Internal system Definition in RDBMSs Subtopic Creating Indexes AACSB design of entropy engineering science 16. In an SQL statement, which of the side by side(p) parts states the conditions for class set apartion? A) get B)From C)Where D)Group By dress C train EasyPage reviewer 329 stem touch hotshot Tables Subtopic articles of the SELECT Statement AACSB design of culture technology, Analytic Skills 17. What does the avocation SQL statement do? consume * From Customer Where Cust_Type = exceedA) look ats tot aloney the compensate from the Customer table for each grade with a customer labeled best B) directs the * field from the Customer table for each row with a customer labeled best C)Selects fields with a * in them from the Customer table D)Selects tot each(prenominal)(prenominal)y the fields from the Customer table for each row with a customer labeled * settle A level ModeratePage ref 329 musical theme impact single Tables Subtopic Clauses of the SELECT Statement AACSB economic consumption of teaching engine room, Ana lytic Skills 18. What result leave the interest SQL statement produce? Select Avg(standard_price) as right from product_vA)The average of every products in product_v B)The average standard_price of tot both(prenominal)y products in product_v C)The average price of all products D)None of the above aid well B train ModeratePage referee 331 head affect hotshot Tables Subtopic victimization Expressions AACSB exercise of development engine room, Analytic Skills 19. Which of the by-line questions is answered by the SQL statement? Select Count (Product_Description) from Product_T A)How some(prenominal) an otherwise(prenominal) products be in the Product Table? B)How many products have product descriptions in the Product Table? C)How many characters argon in the field realise Product_Description?D)How many different columns pick outd product Description argon there in table Product_T? closure B train ModeratePage reviewer 331, 332 head touch on iodine Tables Sub topic utilise Functions AACSB handling of selective information engineering, Analytic Skills 20. What results will be produced by the hobby SQL ask? Select sum(standard_price) as total_price from product_v where product_type = WOOD A)The total price of all products that argon of type woodwind instrument B)The total price of all products C)The standard_price of the offset printing wood product in the table D)The standard_price of any wood product in the table cause A direct DifficultPage referee 331 content bear upon private Tables Subtopic apply Expressions AACSB victimisation up of education applied science, Analytic Skills 21. Which of the pursuit counts ONLY rows that contain a evaluate? A)Count B)Count(*) C)Tally(*) D)Checknum process A take aim ModeratePage ref 331,332 take process Single Tables Subtopic victimisation Functions AACSB effect of education engineering science, Analytic Skills 22. Which of the hobby will produce the negligible of all sta ndard prices? A)Select standard_price from product_v where standard_price = min B)Select min(standard_price) from product_v C)Select standard_price from min(product_v)D)Select min(standard_price) from product_v where standard_price = min(standard_price) coiffe B aim ModeratePage reader 331, 332 consequence impact Single Tables Subtopic employ Functions AACSB engross of discipline Technology, Analytic Skills 23. What will result from the succeeding(a) SQL Select statement? Select min(product_description) from product_v A)The minimum appraise of product_description will be displayed. B)An computer demerit message will be produced. C)The first product description alphabetically in product_v will be shown. D)None of the above. attend to C direct DifficultPage ref 331, 332 composition touch Single TablesSubtopic development Functions AACSB practice of instruction Technology, Analytic Skills 24. Which of the by-line is the wildcard operator in SQL statements? A) B) * C) = D) & say B take EasyPage referee 332, 333 theme affect Single Tables Subtopic development Wildcards AACSB exercise of training Technology, Analytic Skills 25. What result set will the pas conviction examination return? Select item_no from sight_v where quantity 10 A)The item_no of all orders that had more than 10 items B)The order_id of all orders that had more than one item C)The order_id of all orders that had more than 10 itemsD)The item_no of all orders that had 10 or more items coiffure A take aim ModeratePage ref 333 exit affect Single Tables Subtopic exploitation Comparison Operators AACSB economic consumption of info Technology, Analytic Skills 26. Which of the next is legitimate about the SQL statement? Select * From Product Where touchstone = 1 Or Quantity = 2 A)All fields will be selected from the Product table for products that have a quantity of 1. B)All fields will be selected from the Product table for products that have a quantity of simp ly 2. C)All fields will be selected from the Product table for products that have a quantity of 1 or 2.D)None of the above. react C aim ModeratePage reviewer 333-336 division touch on Single Tables Subtopic Using Boolean Operators AACSB practice of development Technology, Analytic Skills 27. What result set will the followers query return? Select item_no, description from item where freightert 100 and weight 200 A)The item_no and description for all items advisement slight than 100 B)The item_no for all items calculation between 101 and 199 C)The item_no and description for all items weighing between 101 and 199 D)The item_no for all items weighing more than 200 function C aim ModeratePage reviewer 336, 337 base Processing Single Tables Subtopic Using Ranges for Qualification AACSB ingestion of cultivation Technology, Analytic Skills 28. To eliminate reprize rows in a query, the _____ qualifier is utilise in the SQL Select command. A)alter B)distinct C)check D) specific serve well B direct EasyPage referee 337, 338 discipline Processing Single Tables Subtopic Using Distinct harbor AACSB rehearse of information Technology 29. What result set is returned from the chase query? Select customer_ prognosticate, telephone from customers where city in (capital of Massachusetts,New York,capital of Colorado) A)The customer_name and telephone of all customersB)The customer_name and telephone of all customers living in either Boston, New York or Denver C)The customer_name and telephone of all customers living in Boston and New York and Denver D)The customer_name of all customers living in Boston, New York or Denver reply B level ModeratePage ref 339 theme Processing Single Tables Subtopic IN and NOT IN with Lists AACSB utilisation of development Technology, Analytic Skills 30. To get all the customers from Hawaii sorted unitedly, which of the pastime would be utilize? A)Order By B)Group By C)Having D)Sort final result A take aim EasyPa ge Ref 339, 340 military issue Processing Single TablesSubtopic Sorting Results The edict BY Clause AACSB do of teaching Technology, Analytic Skills 31. A single revalue returned from an SQL query that includes an compound function is called a(n) A)agate. B)scalar aggregate. C)vector aggregate. D)summation. resultant role B take aim EasyPage Ref 340, 341 way out Processing Single Tables Subtopic Categorizing Results The convention BY Clause AACSB part of instruction Technology, Analytic Skills 32. four-fold value returned from an SQL query that includes an aggregate function be called A)vector aggregates. B)scalar aggregates. C)agates. D)summations. dissolve A take EasyPage Ref 340, 341 payoff Processing Single Tables Subtopic Categorizing Results The convocation BY Clause AACSB single-valued function of instruction Technology, Analytic Skills 33. Which of the undermentioned butt end produce scalar and vector aggregates? A)Order By B)Group By C)Having D)Sort te ll B Level ModeratePage Ref 340, 341 emergence Processing Single Tables Subtopic Categorizing Results The GROUP BY Clause AACSB persona of study Technology, Analytic Skills 34. What will be returned when the succeeding(a) SQL statement is executed? Select device number one wood_no,count(*) as num_deliveries from deliveries group by number one wood_no A)A leaning of all drivers, sorted by driver numberB)A itemisation of each driver as closely as the number of deliveries that he or she has do C)A count of all of the deliveries make by all drivers D)None of the above serve well B Difficulty DifficultPage Ref 340, 341 offspring Processing Single Tables Subtopic Categorizing Results The GROUP BY Clause AACSB social function of cultivation Technology, Analytic Skills 35. What will be returned when the succeeding(a) SQL statement is executed? Select driver_no, count(*) as num_deliveries from deliveries where state = MA group by driver_no A)A listing of all drivers who make deliveries to state = MA, sorted by driver number.B)A listing of each driver who made deliveries to state = MA as well as the number of deliveries that each driver has made to that state. C)A count of all of the deliveries made to state = MA by all drivers. D)None of the above. solution B Difficulty DifficultPage Ref 340, 341 subject Processing Single Tables Subtopic Categorizing Results The GROUP BY Clause AACSB lend oneself of Information Technology, Analytic Skills 36. Which of the following finds all groups get together stated conditions? A)Select B)Where C)Having D)Find exercise C Level EasyPage Ref 341, 342 take Processing Single TablesSubtopic Qualifying Results by Categories The HAVING Clause AACSB drill of Information Technology 37. What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries from deliveries group by driver_no having count(*) 2 A)A listing of all drivers who made more than 2 deliveries as well as a co unt of the number of deliveries B)A listing of all drivers C)A listing of the number of deliveries great than 2 D)A listing of all drivers who made more than 2 deliveries set A Level DifficultPage Ref 341, 342 Topic Processing Single TablesSubtopic Qualifying Results by Categories The HAVING Clause AACSB utilise of Information Technology 38. Which of the following is neat of the order in which SQL statements be evaluated? A)The select article is everlastingly svelte first. B)The select clause is always treat last. C)The select clause is bear on before the order by clause. D)The group by clause is processed before the where clause. response C Level DifficultPage Ref 329 Topic Processing Single Tables AACSB work of Information Technology 39. A _______________ view is materialized when referenced. A)virtual B)dynamic C)materialized D)base dissolvent BLevel ModeratePage Ref 342 Topic Using and Defining Views AACSB do of Information Technology 40. A view may non be updated directly iF it contains A)the distinct keyword. B)derived columns and expressions in the select clause. C)uses the group by or having clause. D)all of the above. Answer D Level EasyPage Ref 345 Topic Using and Defining Views AACSB utilise of Information Technology Chapter 7 1. A nitty-gritty operation A) brings together data from devil different fields. B) causes devil tables with a leafy vegetable domain to be combined into a single table or view. C) causes two disparate tables to be combined into a single table or view.D) is utilize to combine indexing operations. Answer B Level EasyPage Ref 358 Topic Processing treble Tables AACSB employ of Information Technology 2. A sum in which the mergeor condition is found on comparability between values in the habitual columns is called a(n) E) equi- joint. F) uni-lateral join. G) inherent join. H) both A and C. Answer D Level EasyPage Ref 358 Topic Processing bigeminal Tables Subtopic Equi-join AACSB wasting disease of Information Technology 3. A join that is based upon e lineament between values in two plebeian columns with the same(p) name and where one duplicate column has been distant is called a(n) I) equi-join.J) natural join. K) multivariate join. L) inner join. Answer B Level EasyPage Ref 360 Topic Processing two-fold Tables Subtopic raw(a) articulation AACSB subprogram of Information Technology 4. The most commonly employ form of join operation is the M) outer join. N) union join. O) equi-join. P) natural join. Answer D Level ModeratePage Ref 360 Topic Processing duple Tables Subtopic Natural Join AACSB drill of Information Technology 5. A join in which rows that do not have matching values in common columns atomic number 18 sub codd include in the result table is called a(n) Q) natural join. R) equi-join. S) outer join. T) union join. Answer CLevel EasyPage Ref 361 Topic Processing Multiple Tables Subtopic satellite Join AACSB spend of Information Technology 6. In which of t he following sides would one have to use an outer join in order to obtain the desire results? U) A report is in demand(p) that lists all customers who located an order. V) A report is desired that lists all customers and the total of their orders. W) A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero). X) There is never a situation that requires only an outer join.Answer C Level DifficultPage Ref 361,362 Topic Processing Multiple Tables Subtopic Outer Join AACSB ingestion of Information Technology, Analytic Skills 7. One major reward of the outer join is that Y) information is well aditible. Z) information is not lost. ) the query is easier to write. ) All of the above. Answer B Level ModeratePage Ref 362 Topic Processing Multiple Tables Subtopic Outer Join AACSB Use of Information Technology 8. A type of join use in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is fall in is called a(n) ) outer join. ) inner join. ) union join. ) frustrate join. Answer C Level ModeratePage Ref 362 Topic Processing Multiple Tables Subtopic totality Join AACSB Use of Information Technology 9. A type of query that is placed within a WHERE or HAVING clause of another query is called a a) master query. b) subquery. c) superquery. d) multi-query. Answer B Level EasyPage Ref 340 Topic Processing Multiple Tables Subtopic Subqueries AACSB Use of Information Technology 10. _________ takes a value of true if a subquery returns an intermediate results table which contains one or more rows. e) In f) Having g) Exists h) Extents Answer CLevel ModeratePage Ref 367 Topic Processing Multiple Tables Subtopic Subqueries AACSB Use of Information Technology 11. In SQL, a _____________ subquery is a type of subquery in which impact the inner query depends on data from the outer query. i) correlated j) paire d k) natural l) inner Answer A Level ModeratePage Ref 368 Topic Processing Multiple Tables Subtopic Correlated Subqueries AACSB Use of Information Technology 12. A ______________ ____________ is a temporary table used in the FROM clause of an SQL query. m) correlated subquery n) derived table o) view table p) None of the above. Answer BLevel ModeratePage Ref 369 Topic Processing Multiple Tables Subtopic Using Derived Tables AACSB Use of Information Technology 13. The concretion clause is used to q) combine the rig from multiple queries into a single result table. r) join two tables together to form one table. s) find all rows that do not match in two tables. t) None of the above. Answer A Level EasyPage Ref 369 Topic Processing Multiple Tables Subtopic Combining Queries AACSB Use of Information Technology 14. In order for two queries to be UNION-compatible, they mustinessinessiness u) both have the same number of lines in their SQL statements. ) both take compatible data types for each column and return the same number of rows. w) both return at least one row. x) All of the above. Answer B Level ModeratePage Ref 369 Topic Processing Multiple Tables Subtopic Combining Queries AACSB Use of Information Technology 15. Establishing IF-THEN-ELSE rational impact within an SQL statement hobo be accomplished by y) development the if-then-else construct. z) using the immediate if statement. ) using the CASE keyword in a statement. ) using a subquery. Answer C Level ModeratePage Ref 372 Topic Processing Multiple Tables Subtopic Conditional ExpressionsAACSB Use of Information Technology 16. Explicit commands to manage proceeding be needed when ) a transaction consists of just one SQL command. ) multiple SQL commands must be run as part of a transaction. ) autocommit is set to off. ) None of the above. Answer B Level DifficultPage Ref 377 Topic Ensuring transaction rectitude AACSB Use of Information Technology 17. drug user-defined transactions burn down imp rove placement performance because ) transactions argon processed as sets, reducing dodge overhead. ) transactions ar mapped to SQL statements. ) speed is improved due to query optimization. ) All of the above.Answer A Level ModeratePage Ref 377 Topic Ensuring Transaction Integrity AACSB Use of Information Technology 18. An synergetic command that thunder mug be used to dynamically control a exploiter session for appropriate integrity measures is ) rollback. ) rollforward. ) set autocommit. ) expunge. Answer C Level ModeratePage Ref 377 Topic Ensuring Transaction Integrity AACSB Use of Information Technology, Analytic Skills 19. If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle? ) dba_tab_privs ) dba_tab_comments ) dba_table_label ) dba_tables Answer DLevel ModeratePage Ref 378 Topic Data dictionary Facilities AACSB Use of Information Technology, Analytic Skills 20. What results would the following SQL statement produce? select owner, table_name from dba_tables where table_name = invitee ) A listing of all customers in the customer table ) A listing of the owner of the customer table ) A listing of the owner of the customer table as well as customers ) An error message Answer B Level ModeratePage Ref 379 Topic Data mental lexicon Facilities AACSB Use of Information Technology, Analytic Skills 21. User-defined data types ) can be a subclass of a standard type. can behave as an object. ) can have defined functions and methods. ) can have all of the above. Answer D Level ModeratePage Ref 380 Topic SQL 200n Enhancements and Extensions to SQL AACSB Use of Information Technology 22. A radical set of analytical functions added in SQL200n are referred to as ) OLAF Functions ) MOLAP Functions ) Average Functions ) OLAP Functions Answer D Level ModeratePage Ref 380 Topic SQL 200n Enhancements and Extensions to SQL Subtopic analytical Functions AACSB Use of Information Technology 23. lay and DENSE -RANK are examples of ) Ceilings ) Door Functions ) Window Functions ) abject FunctionsAnswer C Level ModeratePage Ref 380 Topic SQL 200n Enhancements and Extensions to SQL Subtopic Analytical Functions AACSB Use of Information Technology, Analytic Skills 24. All of the following are novel data types added in SQL200n EXCEPT ) BIGINT ) numeral ) MULTISET ) XML Answer B Level ModeratePage Ref 381 Topic SQL 2003 Enhancements and Extensions to SQL Subtopic New Data Types AACSB Use of Information Technology, Analytic Skills 25. The MERGE command ) Allows one to combine the usher in and update operations ) Allows one to combine the INSERT and DELETE operations ) Joins 2 tables together None of the above. Answer A Level ModeratePage Ref 382 Topic SQL 200n Enhancements and Extensions to SQL Subtopic Other Enhancements AACSB Use of Information Technology, Analytic Skills 26. Extensions defined in SQL-99 that include the capability to create and drop mental facultys of code interposed i n the database schema crossways user sessions are called ) stored procedures. ) Persistent instald Modules. ) combine control modules. ) None of the above. Answer B Level ModeratePage Ref 383 Topic SQL 200n Enhancements and Extensions to SQL Subtopic scheduleming Extensions AACSB Use of Information Technology 27.A named set of SQL statements that are considered when a data alteration occurs are called ) stored procedures. ) treatments. ) triggers. ) trapdoors. Answer C Level EasyPage Ref 384 Topic Triggers and Routines AACSB Use of Information Technology 28. While triggers run automatically, ______________ do not and have to be called. ) trapdoors ) routines ) selects ) updates Answer B Level ModeratePage Ref 386 Topic Triggers and Routines AACSB Use of Information Technology 29. SQL-invoked routines can be ) procedures. ) functions. ) All of the above. ) None of the above. Answer C Level EasyPage Ref 386Topic Triggers and Routines Subtopic Routines AACSB Use of Information Te chnology 30. All of the following are emoluments of SQL-invoked routines EXCEPT ) flexibility. ) efficiency. ) sharability. ) security. Answer D Level ModeratePage Ref 387 Topic Triggers and Routines Subtopic Routines AACSB Use of Information Technology 31. A procedure is ) stored within the database. ) given a curious name. ) called by name. ) All of the above. Answer D Level ModeratePage Ref 387, 388 Topic Triggers and Routines Subtopic Routines AACSB Use of Information Technology 32. Embedded SQL consists of hard-coded SQL statements included in a program create verbally in another language. ) SQL encapsulated inside of other SQL statements. ) SQL written into a front-end diligence. ) SQL translated to a lower-level language. Answer A and C are both plausible answers. Level EasyPage Ref 389 Topic Embedded SQL and impulsive SQL AACSB Use of Information Technology 33. In order to infix SQL inside of another language, the ________ _______ statement must be placed before the SQL in the host language. ) GET SQL ) EXEC SQL ) RUN SQL ) SQL SQL Answer B Level ModeratePage Ref 390 Topic Embedded SQL and Dynamic SQLAACSB Use of Information Technology, Analytic Skills 34. Dynamic SQL ) is used to generate appropriate SQL code on the fly, as an application is process. ) is quite volatile. ) is not used widely on the Internet. ) creates a less flexible application. Answer A Level EasyPage Ref 390 Topic Embedded SQL and Dynamic SQL AACSB Use of Information Technology 35. on-line(a) transaction touch is ) A system used for reporting only. ) A system used in transaction-oriented applications that involves real-time processing of SQL transactions. ) A set of tools that provides users with a pictorial view of data. ) None of the above.Answer B Level EasyPage Ref 391 Topic OLAP SQL AACSB Use of Information Technology 36. OLAP systems differ from OLTP systems in several(prenominal) ways except ) Size ) Processing ) Queries ) Physical Storage Answer B Level EasyPage Ref 392 Topic OLAP SQL AACSB Use of Information Technology Chapter 8 1. Which of the following have affected the way product linees use computing systems to meet the demand of the militant marketplace? A)GUI evolutions B)Networking advances C)Communication changes D)All of the above. Answer D Level ModeratePage Ref 403 Topic Introduction AACSB Use of Information Technology 2.Which of the following is a component of processing logic? A)Input B)Output C)Retrieval D)Business rules Answer D Level EasyPage Ref 404 Topic lymph gland/ emcee Architectures AACSB Use of Information Technology 3. A device that manages register operations and is shared by each thickening PC on a local anaesthetic sweep network is called a A)file legion. B)file processor. C)database horde. D)fat client. Answer A Level EasyPage Ref 405 Topic lymph node/ emcee Architectures Subtopic File legion Architectures AACSB Use of Information Technology 4. In a file waiter architecture, which of the following is per formed by a client? A)Provides significant LAN barterB)File storage C)User larboard processing D)All of the above. Answer C Level ModeratePage Ref 404 Topic guest/ legion Architectures Subtopic File master of ceremonies Architectures AACSB Use of Information Technology 5. Which of the following is true about file master of ceremoniess on a LAN? A)Each client must devote memory to a upright adaption of its DBMS. B)Not much data front end is generated. C)The DBMS copy has little responsibility. D) diligence programmers need little knowledge about DBMSs. Answer A Level ModeratePage Ref 406 Topic lymph node/Server Architectures Subtopic File Server Architectures AACSB Use of Information Technology . Which of the following is NOT a limitation to using file servers on local area net kit and caboodle? A)Considerable data movement is generated crosswise the network. B)Each client workstation must devote memory to a full version of the DBMS. C)Stored procedures can be run on the fil e server. D)The DBMS copy in each workstation must manage the shared database integrity. Answer C Level ModeratePage Ref 405, 406 Topic lymph gland/Server Architectures Subtopic File Server Architectures AACSB Use of Information Technology 7. A(n) _____ is a module of code written in SQL or some proprietary language to run business rules on a server.A)SQL program B)select module C)select procedure D)stored procedure Answer D Level EasyPage Ref 407 Topic Client/Server Architectures Subtopic Database Server Architectures AACSB Use of Information Technology 8. Which of the following is an advantage of stored procedures? A)Data integrity improves when fewer applications access the procedure. B)The layers get cleaner. C)Stored procedures result in fatter clients. D)Performance improves for compiled SQL statements. Answer D Level EasyPage Ref 407 Topic Client/Server Architectures Subtopic Database Server Architectures AACSB Use of Information Technology 9.Which of the following is not a disadvantage of stored procedures? A)Writing stored procedures takes more time than piece of writing an application in Visual primary feather or PowerBuilder. B)Decreases in network work are realized. C)Stored procedures are proprietary and not easy to move from one RDBMS to another. D)Each client must be loaded with the application to be used at that location. Answer B Level ModeratePage Ref 407 Topic Client/Server Architectures Subtopic Database Server Architectures AACSB Use of Information Technology 10. A PC configured to handle user interface with little or no local storage is called a A)server.B)fat client. C)thin client. D)workstation. Answer C Level EasyPage Ref 409 Topic Three-Tier Architectures AACSB Use of Information Technology 11. Which of the following is true about three-tier architectures? A)Less scalable than two-tier B)Increased risk C)to a great extent technical flexibility D)All of the above Answer C Level ModeratePage Ref 409 Topic Three-Tier Architectures AACSB Use of Information Technology 12. _____ is the process of ap orderment pieces of application code to clients or servers. A) practical application naval division B)Modularizing programs C)Code dissemination D)Program breakup Answer A Level EasyPage Ref 410Topic Partitioning an Application AACSB Use of Information Technology 13. Which of the following is not a common distribution logic for two-tiered server environments A)Fat Client B)Tall Client C)Thin Client D)Distributed Answer A Level ModeratePage Ref 411 Topic Partitioning an Application AACSB Use of Information Technology 14. Which of the following is true of central processing units in the client/server environment? A)Managers have a knockout time sorrowful between platforms. B)Supporting distributed environments is easier than mainframe nurse. C)Migrating from mainframes to client/server is a relatively simple process.D)All of the above. Answer A Level ModeratePage Ref 412 Topic Role of the mainframe AACSB Use of Information Technology 15. piteous mission critical applications to client/server environments is likely to cause serious problems in the transition from the pilot phase to exertion unless A)Developers rewrite all code for the system. B)Brand up spark advancet hardware is purchased. C)Developers anticipate scalability issues and address them as they develop code D)None of the above. Answer C Level ModeratePage Ref 412 Topic Role of the Mainframe AACSB Use of Information Technology 16. ____ is any of several classes of software that go away an application to interoperate with other software without requiring the user to understand all software involved. A)User interface enhancers B)Middleware C) interface managers D)MPP Answer B Level EasyPage Ref 413 Topic Using Middleware AACSB Use of Information Technology 17. Which of the following does not connect applications to databases over networks? A)Asynchronous RPC middleware B)Synchronous RPC middleware C)SQL-oriented middleware D)S MP Answer D Level ModeratePage Ref 414 Topic Using Middleware AACSB Use of Information Technology 18.Which of the following could send and receive email, slice the client works on other things? A)ORBs middleware B)Synchronous RPC middleware C)SQL-oriented middleware D)MOM Answer D Level ModeratePage Ref 414 Topic Using Middleware AACSB Use of Information Technology 19. Microsofts Transaction Server and IBMs CICS are examples of A)Asynchronous Remote Procedure Call (RPC) B)Synchronous RPC C)MOM D)ORB Answer B Level ModeratePage Ref 414 Topic Using Middleware AACSB Use of Information Technology 20. ______________ makes it possible for applications to send objects and request services in an object-oriented system.A)MOM B)RPC C)ORB D)API Answer C Level EasyPage Ref 414 Topic Using Middleware AACSB Use of Information Technology 21. A(n) _____ is a set of application routines that programs use to direct the performance of procedures by the computers operating system. A)API B)MOM C)RPC D) LAN Answer A Level ModeratePage Ref 414 Topic Using Middleware AACSB Use of Information Technology 22. Which of the following is true of moving to client/server environments? A)Functionality must be delivered all at once. B)There are no hidden costs. C)Services can be placed appropriately. D)None of the above. Answer C Level EasyPage Ref 416Topic Client/Server Issues AACSB Use of Information Technology 23. Which of the following is NOT a benefit of moving to client/server environments? A)Functionality can be delivered in stages to end users. B)Business process reengineering is facilitated. C)Network traffic and response times are increased. D)Users are progressd to utilize the applications operating(a)ity. Answer C Level ModeratePage Ref 416, 417 Topic Client/Server Issues AACSB Use of Information Technology 24. The most common bottleneck in a client/server environment is the A)users B)software C)network D) partnership politics Answer C Level ModeratePage Ref 416Topic Client/Serve r Issues AACSB Use of Information Technology 25. In order to frame client/server security A)Network security must be tested B)Biometric authentication must be used C)Server security must be established D)Both A and C Answer D Level ModeratePage Ref 416 Topic Client/Server Issues AACSB Use of Information Technology 26. Multi-tier make consciousness if all of the following environments except A) More than 100 users B)High-volume transaction processing C)Workgroups D)Real-time processing Answer C Level ModeratePage Ref 416 Topic Client/Server Issues AACSB Use of Information Technology 27.Which of the following is not a parameter that must be specified in order to establish an ODBC connection? A)Specific ODBC driver needed B)Back-end server name to connect to C)JDK version D)Database name to connect to Answer C Level EasyPage Ref 417 Topic Using ODBC to data link External Tables Stores on a Database Server AACSB Use of Information Technology 28. Which of the following is a distingui shing characteristic of Level-2 API capabilities? A)Send and receive partial derivative results B)Call a supplanting library C)Commit or rollback transactions D)Prepare and execute SQL statements Answer B Level ModeratePage Ref 417Topic Using ODBC to link External Tables Stores on a Database Server AACSB Use of Information Technology 29. An application programming interface that enables an application program to process RDBMS databases meets the A)object linking and embedding standard. B)open database connectivity standard. C)multi-platform connectivity standard. D)open source standard. Answer B Level EasyPage Ref 417 Topic Using ODBC to Link External Tables Stores on a Database Server AACSB Use of Information Technology 30. Which of the following parameters must be defined in order to establish an ODBC connection? A)ODBC driver B)Back-end server nameC)Database name to connect to D)All of the above Answer D Level ModeratePage Ref 417 Topic Using ODBC to Link External Tables Store s on a Database Server AACSB Use of Information Technology. Analytic Skills 31. The ability to call a translation library is a distinguishing characteristic of A)Core-API ODBC conformance. B)Level-1 API ODBC conformance. C)Level-2 API ODBC conformance. D)Level-3 API ODBC conformance. Answer C Level DifficultPage Ref 418 Topic Using ODBC to Link External Tables Stores on a Database Server AACSB Use of Information Technology 32. JDBC is similar to ODBC EXCEPT A)ODBC is language in interdependent and JDBC is not.B)ODBC can be used to execute SQL queries on a server while JDBC does not have this capability. C)ODBC can run on multiple platforms, while JDBC is platform specific. D)None of the above. Answer A Level ModeratePage Ref 385 Topic Using JDBC to Link External Tables Stored on a Database Server AACSB Use of Information Technology, Analytic Skills Chapter 9 1. The analysis of summarized data to support decisiveness making is called A)operational processing. B)informational processi ng. C)artificial intelligence. D)data scrubbing. Answer B Level EasyPage Ref 461 Topic Introduction AACSB Use of Information Technology 2.The characteristic that indicates that a data warehouse is organized just about key high-level entities of the enterprise is A)subject-oriented. B)integrated. C)time-variant. D)nonvolatile. Answer A Level ModeratePage Ref 462 Topic elementary Concepts of Data entrepot AACSB Use of Information Technology 3. When we consider data in the data warehouse to be time-variant, we mean A)that the time of storage varies. B)data in the warehouse contain a time dimension so that they may be used to study trends and changes. C)that there is a time delay between when data are posted and when we report on the data. D)none of the above.Answer B Level ModeratePage Ref 462 Topic basal Concepts of Data Warehousing AACSB Use of Information Technology, Analytic Skills 4. Which of the following advances in information systems contributed to the emergence of data m emory board? A)Improvements in database technology, particularly the relational data model B)Advances in computer hardware, specially affordable mass storage and tally computer architectures C)Advances in middleware products that enabled enterprise database connectivity crossways heterogeneous platforms D)All of the above Answer D Level ModeratePage Ref 463 Topic fundamental Concepts of Data WarehousingSubtopic A Brief narrative AACSB Use of Information Technology 5. Which of the following factors drive the need for data entrepot? A)Businesses need an integrated view of company information. B)Informational data must be unploughed together with operational data. C)Data warehouses generally have better security. D)None of the above Answer A Level ModeratePage Ref 463 Topic Basic Concepts of Data Warehousing Subtopic The admit for Data Warehousing AACSB Use of Information Technology 6. Which of the following organizational trends does not encourage the need for data warehousing ? A)Multiple, nonsynchronized systemsB)Focus on customer relationship management C)Downsizing D)Focus on supplier relationship management Answer C Level ModeratePage Ref 463464 Topic Basic Concepts of Data Warehousing Subtopic motif for a Companywide View AACSB Use of Information Technology 7. Informational systems are designed for all of the following EXCEPT A)running a business in real time. B)supporting conclusion making. C)complex queries. D)data exploit. Answer A Level ModeratePage Ref 466 Topic Basic Concepts of Data Warehousing Subtopic Need to Separate in operation(p) and Informational Systems AACSB Use of Information Technology 8. operational and informational systems are generally illogical because of which of the following factors? A)A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications. B)A properly designed data warehouse adds value to data by improving their quality and consistency. C)A separate data warehouse eliminates contention for resources that results when informational applications are throw with operational processing. D)All of the above Answer D Level EasyPage Ref 466 Topic Basic Concepts of Data WarehousingSubtopic Need to Separate Operational and Informational Systems AACSB Use of Information Technology 9. A data market place is a(n) A)enterprisewide data warehouse. B)smaller system built upon file processing technology. C)data warehouse that is limited in scope. D)generic on-line obtain site. Answer C Level ModeratePage Ref 469 Topic Data storage warehouse Architectures Subtopic autarkical Data grocery store Data Warehousing Environment AACSB Use of Information Technology 10. One characteristic of independent data grocery stores is complexity for end users when they need to access data in separate data marts.This complexity is caused by not only having to access data from separate databases, but also from A)the possi bility of a radical generation of inconsistent data systems, the data marts themselves. B)lack of user training. C)denormalized data. D)incongruent data formats. Answer A Level DifficultPage Ref 469 Topic Data storage warehouse Architectures Subtopic Independent Data Mart Data Warehousing Environment AACSB Use of Information Technology 11. All of the following are limitations of the independent data mart EXCEPT A)separate extraction, transformation, and loading processes are positive for each data mart.B)data marts may not be consistent with one another. C)there is no capability to drill down into greater detail in other data marts. D)it is often more expedient to build a data mart than a data warehouse. Answer D Level ModeratePage Ref 469 Topic Data storage warehouse Architectures Subtopic Independent Data Mart Data Warehousing Environment AACSB Use of Information Technology, Reflective Thinking 12. A dependent data mart A)is filled with data extracted directly from the operati onal system. B)is filled alone from the enterprise data warehouse with reconcile data.C)is dependent upon an operational system. D)participates in a relationship with an entity. Answer B Level ModeratePage Ref 470 Topic Data storage warehouse Architectures Subtopic Dependent Data Mart and Operational Data Store Architecture A Three-Level Approach AACSB Use of Information Technology 13. An operational data store (ODS) is a(n) A)place to store all unreconciled data. B)representation of the operational data. C)integrated, subject-oriented, updateable, current-valued, minute database designed to serve the decision support needs of operational users.D)small-scale data mart. Answer C Level EasyPage Ref 471 Topic Data warehouse Architectures Subtopic Dependent Data Mart and Operational Data Store Architecture A Three-Level Approach AACSB Use of Information Technology 14. A logical data mart is a(n) A)data mart consisting of only logical data. B)data mart created by a relational view of a slimly denormalized data warehouse. C)integrated, subject-oriented, detailed database designed to serve operational users. D)centralized, integrated data warehouse. Answer B Level ModeratePage Ref 472 Topic Data Warehouse ArchitecturesSubtopic Logical Data Mart and real time Data Warehouse Architecture AACSB Use of Information Technology 15. All of the following are unique characteristics of a logical data mart EXCEPT A)logical data marts are not physically separate databases, but quite a a relational view of a data warehouse. B)the data mart is always up-to-date since data in a view is created when the view is referenced. C)the process of creating a logical data mart is lengthy. D)data are moved into the data warehouse quite a than a separate staging area. Answer C Level EasyPage Ref 472 Topic Data Warehouse ArchitecturesSubtopic Logical Data Mart and Real-Time Data Warehouse Architecture AACSB Use of Information Technology 16. The real-time data warehouse is characterized by which of the following? A)It accepts near-real time feeds of transaction data. B)Data are immediately transformed and loaded into the warehouse. C)It provides near-real-time access for the transaction processing systems to an enterprise data warehouse. D)All of the above Answer D Level EasyPage Ref 473-474 Topic Data Warehouse Architectures Subtopic Logical Data Mart and Real-Time Data Warehouse Architecture AACSB Use of Information Technology 7. Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called _____ data. A)reconciled B)subject C)derived D)detailed Answer A Level EasyPage Ref 475 Topic Data Warehouse Architectures Subtopic Three-Layer Data Architectures AACSB Use of Information Technology 18. A database action that results from a transaction is called a(n) A)transition. B)event. C)log entry. D)journal happening. Answer B Level EasyPage Ref 476 Topic nearly Characteristics of Data Warehouse Data Su btopic Status Versus Event DataAACSB Use of Information Technology, Analytic Skills 19. Data that are never physically altered once they are added to the store are called _____ data. A)transient B)override C)periodic D)complete Answer C Level EasyPage Ref 477 Topic Some Characteristics of Data Warehouse Data Subtopic pass(a) Versus Periodic Data AACSB Use of Information Technology 20. Which of the following is an objective of derived data? A)Ease of use for decision support systems B)Faster response time for user queries C)Support data mining applications D)All of the above Answer D Level EasyPage Ref 481Topic The Derived Data Layer Subtopic Characteristics of Derived Data AACSB Use of Information Technology 21. .A star schema contains both fact and _______ tables. A)narrative B)cross functional C)dimension D)starter Answer C Level ModeratePage Ref 481 Topic The Derived Data Layer Subtopic The wizardry Schema AACSB Use of Information Technology 22. The level of detail in a fact ta ble determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the A)span. B)grain. C)selection. D)aggregation. Answer BLevel EasyPage Ref 485 Topic The Derived Data Layer Subtopic The Star Schema AACSB Use of Information Technology 23. Conformed dimensions include users to do the following A)share nonkey dimension data. B)query across fact tables with consistency. C)work on facts and business subjects for which all users have the same meaning. D)all of the above. Answer D Level ModeratePage Ref 488-489 Topic The Derived Data Layer Subtopic The Star Schema AACSB Use of Information Technology 24. An expanded version of a star schema in which all of the tables are fully normalized is called a(n) A)snowflake schema.B)operational schema. C)DSS schema. D)complete schema. Answer A Level EasyPage Ref 492 Topic The Derived Data Layer Subtopic The Star Schema AACSB Use of Information Technology 25. All of the following are ways to handle changing dimensions EXCEPT A)overwrite the current value with the new value. B)for each dimension allot that changes, create a current value field and as many old value fields as we wish. C)create a new dimension table row each time the dimension object changes. D)create a snowflake schema. Answer D Level ModeratePage Ref 494 Topic The Derived Data LayerSubtopic The Star Schema AACSB Use of Information Technology 26. The use of a set of graphical tools that provides users with third-dimensional views of their data is called A)on-line geometrical processing (OGP). B)drill-down analysis. C)on-line analytical processing (OLAP). D)on-line datacube processing (ODP). Answer C Level EasyPage Ref 500 Topic The User user interface Subtopic on-line Analytical Processing (OLAP) Tools AACSB Use of Information Technology 27. OLAP tools that use the database as a traditional relational database are called A)ROLAP tools. B)MOLAP tools. C)slice and dice.D)none o f the above. Answer A Level ModeratePage Ref 500-501 Topic The User user interface Subtopic On-Line Analytical Processing (OLAP) Tools AACSB Use of Information Technology 28. Rotating the view of a multidimensional database for a particular data point is called data A)cubing. B)drill-down. C)dicing. D)pivoting. Answer D Level ModeratePage Ref 501 Topic The User Interface Subtopic On-Line Analytical Processing (OLAP) Tools AACSB Use of Information Technology 29. Going from a summary view to progressively lower levels of detail is called data A)cubing. B)drill-down. C)dicing.D)pivoting. Answer B Level ModeratePage Ref 502 Topic The User Interface Subtopic On-Line Analytical Processing (OLAP) Tools AACSB Use of Information Technology 30. Which of the following data mining techniques identifies clusters of observations with similar characteristics? A)Case ratiocination B)Rule discovery C)Clustering and signal processing D)Neural nets Answer C Level ModeratePage Ref 506 Topic The User Interface Subtopic Data-Mining Tools AACSB Use of Information Technology 31. Which of the following data-mining techniques searches for patterns and correlations in crowing data sets?A)Case reasoning B)Rule discovery C)Signal processing D)Neural nets Answer B Level ModeratePage Ref 506 Topic The User Interface Subtopic Data-Mining Tools AACSB Use of Information Technology 32. Which of the following data mining applications identifies customers for promotional activity? A)Population pen B)Target marketing C)Usage analysis D)Product affinity Answer B Level ModeratePage Ref 506 Topic The User Interface Subtopic Data-Mining Tools AACSB Use of Information Technology 33. Which of the following is true of data visualization?A)It is easier to observe trends and patterns in data. B)Correlations and clusters in data can be slowly identified. C)It is often used in connection with data mining. D)All of the above. Answer D Level ModeratePage Ref 503 Topic The User Interface Subtopic Data Vis ualization AACSB Use of Information Technology, Analytic Skills Chapter 10 1. High quality data are data that are A) Accurate B)Consistent C)Available in a by the way fashion D)All of the above Answer D Level EasyPage Ref 524 Topic Managing choice Data AACSB Use of Information Technology, Analytic Skills