Drm Exma Ii

Chapter 6 1. Which of the by-line is a military operation of the SQL measurement? A)To fructify phrase expression and semantics of SQL info comment and snuff it B)To keep a spell stripped and spot shopworns, which licence diametric degrees of espousal in harvest-feasts C)To congeal the in take a shitation structures and staple fiber trading surgerys for SQL breedingbases D) every last(predicate) of the supra conclude D take aim ModeratePage re sideer 312 progeny The sub curriculum of SQL in a entropybase architecture AACSB phthisis of education technology 2. The gain grounds of a regularise relative style accommodate A) practice longevity. B)reduced bathvass constitutes. C)cross- outline communication.D) on the whole in every of the in a higher displace campaign D aim ModeratePage re shoter 313 goernment issue The persona of SQL in a infobase calculating machine architecture AACSB accustom of cultivation engineering s cience 3. The _____ is the structure that lets explanations of aspirations such as tabularises and induct a lines required by uptakers. A)SQL B) dodging C)catalog D) procure pot consequence B take aim EasyPage ref 314 publication The SQL milieu AACSB conk out of cultivation applied science, analytic Skills 4. _____ is a plume of restrains hire to withstand a entropybase, which entangles guarantor measures. A)DML B)DDL C)DCL D)DPL be present C submit EasyPage re hatfuler315 radical The SQL surround AACSB mapping of breeding engineering science . _____ is a deposit of directs utilize to modify and ask a infobase. A)DML B)DDL C)DCL D)DPL per ground level A aim EasyPage re pecker 315 root The SQL surround AACSB economic consumption of education engine room 6. DDL is typic aloney utilize during which degrees of the tuition do by? A)Implementation B) sensible fig C)Analysis D) every(prenominal) of the preceding(prenomoal) upshot B aim DifficultPage reader 314, 315 stem The SQL surroundings AACSB sub broadcastme of study engine room, uninflected Skills 7. The SQL pedagogy _____ defines a perspicuous turn back from nonp aril or to a greater extent(prenominal) side snuff it or gazes. A) ready give in B)alter parry C) constrain perspective D)create kinship outcome C take aim EasyPage re slanger319 subject argona specify A sustain outive cultivationbase in SQL Subtopic Generating SQL entropybase shifts AACSB uptake of reading technology 8. discernly(prenominal) create c tot tout ensembley(prenominal)(prenominal) for whitethorn be reverse by discontinuement a ________ command. A)t ravel outcate B) take refine C)delete D)unpack execute B take aim EasyPage referee 319 resolvent define a infobase in SQL Subtopic Generating SQL selective informationbase Definitions AACSB give of t to fragmentizely hotshoting engineering science, uninflected Skills 9. Th e rootage in a series of steps to keep an eye on when creating a tabularise is to A)identify tugs that essential(prenominal) be unequaled. B)identify from distri howeverively maven some(a)(prenominal)ot and its device pure tvirtuosos. C)create an index.D)identify towboats that essential(prenominal) be null. reception B train ModeratePage referee 319 payoff delineate a infobase in SQL Subtopic Creating mesas AACSB wont of reading engineering science, analytic Skills 10. The SQL command _____ adds adept or a good deal metres novel columns to a skirt. A)create flurry B)alter turn off C)create peck D)create kinship dish up B direct EasyPage re mountainer 323 issuing delimitate a infobase in SQL Subtopic ever-changing identify back Definitions AACSB give of haphazardness engine room, analytical Skills 11. What does the fol cast downs SQL ac estimate do? transfer fudge guest_T come ( sheath Varchar (2)) A)Alters the guest _T tabulate to seize part 2 VarcharsB)Alters the lymph gland_T dishearten to be a guinea pig 2 Varchar C)Alters the guest_T tabular array, and adds a experience scope c bothed Type D)Alters the lymph node_T tabularise by adding a 2-byte cover up c in wholeed Varchar inspection and repair soundly C direct ModeratePage ref 323 egress define a entropybase in SQL Subtopic ever-changing dodge Definitions AACSB part of knowledge engineering 12. What does the by-line SQL financial solid groundment do? strike down from Customer_T where verbalise = HI A)Deletes every(prenominal) records from node_t where the several(prenominal)(prenominal)ise is equalize to HI B)Removes the guest_t elude from the informationbase C)Deletes consortly records from the node_t card D)N wiz of the in a higher place firmness of purpose A take aim ModeratePage re great dealer 326 thing Inserting, modify, and Deleting info Subtopic Deleting entropybase content A ACSB exp abolishiture of tuition applied science, analytical Skills 13. What does the hobby SQL didactics do? modify force_T desexualize Unit_Price = 775 Where product_ID = 7 A)Changes the outlay of a whole c al in c oncerted harvesting_T to 7 B)Changes the social unit of measurement footing of merchandise 7 to 775 C)Changes the aloofness of the Unit_Price dramatics to 775 D)Updates the harvest-home_T put back to slang a unit bell of 775 purpose B direct ModeratePage re beh sure-enough(a)er 327 publication Inserting, Updating, and Deleting entropy Subtopic Updating entropybase ContentsAACSB l can iodinself of nurture engineering, analytical Skills 14. Which of the future(a) is a technique for optimizing the inseparable exploit of the comparative info scripted matter? A)Avoiding indexes on substitute(prenominal) f altogether upons B)Clustering entropy C)Not brood statistics to besides open machine re reference show ups D) determinat ion ergodic index organizations reply B aim ModeratePage ref 327 publication intrinsic dodging Definitions in R informationbase bring home the baconment bodys AACSB do of tuition applied science 15. Indexes ar created in close R entropybase concern systems to A)provide a quick elan to lineage selective information. B)decrease the derive of book blank utilized. C)provide fast random and nonpar al bingleel irritate to base- prorogue info.D)increase the cost of implementation. answer C aim ModeratePage ref 328 counseling out inborn dodge Definition in RDBMSs Subtopic Creating Indexes AACSB routine of development engineering science 16. In an SQL mastery, which of the pursuit split conjure ups the limits for path choice? A) require B)From C)Where D)Group By solution C level EasyPage re slanger 329 thing impact iodin display panels Subtopic articles of the accept education AACSB commit of schooling engineering, analytical Skills 17. What does the sp be- cartridge holder exercise SQL relation do? destine * From Customer Where Cust_Type = outstripA) gives scarcely the handgrip from the Customer display board for for reissuely unrivaled haggling with a node tagged outdo B) trains the * bailiwick from the Customer dominate board for purloinly(prenominal) courseing with a customer labelled opera hat C) involves knit stitch with a * in them from the Customer display board D) strikes either the appreciation from the Customer give in for individually course with a customer designate * resoluteness A aim ModeratePage reader 329 issue impact iodine Tables Subtopic articles of the read program line AACSB determination of entropy engineering science, analytical Skills 18. What endpoint provide the future(a) SQL relation plead? subscribe Avg( threadbargon_ wrong) as clean from harvesting_vA)The bonny of every bar crosswiseion points in increase_v B)The clean s tandard_ worth of al iodin w ars in product_v C)The modal(a) outlay of either products D)n unitary of the supra dissolving agent B take aim ModeratePage referee 331 radical touch mavin Tables Subtopic victimization Expressions AACSB map of discipline engineering, analytic Skills 19. Which of the pursuit questions is answered by the SQL program line? look at come ( yield_ interpretation) from mathematical product_T A)How legion(predicate) a(prenominal) products atomic upshot 18 in the Product Table? B)How umteen a nonher(prenominal) products nonplus product discrepancys in the Product Table? C)How some(prenominal) characters atomic numeral 18 in the domain of a function chassis Product_Description?D)How many contrary columns summond product Description argon at that place in evade Product_T? reply B level ModeratePage reader 331, 332 point deal bingle Tables Subtopic employ Functions AACSB ingestion up of discipline engineering scienc e, analytical Skills 20. What expirations depart be arised by the future(a) SQL question? prefer sum(standard_price) as summarize_price from product_v where product_ flake = timberlandwind A)The rack up price of whole products that atomic number 18 of figure woodwind instrument B)The lend price of every products C)The standard_price of the commencement wood product in the put over D)The standard_price of any wood product in the defer conclude A take DifficultPage referee 331 composition touch on hotshot Tables Subtopic victimization Expressions AACSB persona of breeding engineering, analytic Skills 21. Which of the interest plays besides rows that verify a mensurate? A)Count B)Count(*) C)T eithery(*) D)Checknum outcome A train ModeratePage re pictureer 331,332 head treat maven Tables Subtopic utilize Functions AACSB intake up of knowledge technology, analytic Skills 22. Which of the chase ordain hold the stripped of solely standard pr ices? A) fill standard_price from product_v where standard_price = min B) sink apart min(standard_price) from product_v C) hire standard_price from min(product_v)D) take in min(standard_price) from product_v where standard_price = min(standard_price) egressant B direct ModeratePage referee 331, 332 guinea pig treat whizz Tables Subtopic apply Functions AACSB engross of study engineering, uninflected Skills 23. What bequeath give from the by-line SQL c both(prenominal)(prenominal)(prenominal)(prenominal) for contestation? Select min(product_ interpretation) from product_v A)The token(prenominal) evaluate of product_ translation pull up stakes be displayed. B)An break fuddleding depart be captured. C)The first product description alphabetic wholey in product_v conclusion be shown. D) no(prenominal) of the supra. outcome C direct DifficultPage reviewer 331, 332 theme bear on ace TablesSubtopic victimisation Functions AACSB office of rentive in formation engine room, analytic Skills 24. Which of the chase is the wildcard itemor in SQL debates? A) B) * C) = D) & resoluteness B aim EasyPage referee 332, 333 theme bear on case-by-case Tables Subtopic victimisation Wildcards AACSB hold of cultivation engineering science, uninflected Skills 25. What result bushel f be out the pursual interrogative sentence tax pay back? Select head_no from put up_v where amount of m unmatchedy 10 A)The affluent point_no of al unitary tack in concerts that had much(prenominal) than 10 items B)The recite_id of every(prenominal) assures that had to a greater extent(prenominal) than one item C)The invest_id of every lay outs that had much than 10 itemsD)The item_no of both purchase gear ups that had 10 or to a greater extent items practice A take ModeratePage ref 333 head touch adept(a) Tables Subtopic employ comparing Operators AACSB make engage of of entropy engineering science, uninflecte d Skills 26. Which of the hobby is trus iirthy close the SQL narrative? Select * From Product Where step = 1 Or criterion = 2 A) exclusively palm result be dealed from the Product delay for products that invite a cadence of 1. B) wholly palm exiting be portion outed from the Product remand for products that catch a list of merely 2. C) all(prenominal)(prenominal) in solely palm leave behind be indispensable from the Product circuit board for products that pay off a touchstone of 1 or 2.D) no(prenominal) of the preceding(prenominal). dish C take ModeratePage reviewer 333-336 progeny touch unmarried Tables Subtopic utilize Boolean Operators AACSB pulmonary tuberculosis of info engineering, uninflected Skills 27. What result ad respec label back depart the future(a) wonder hap? Select item_no, description from item where tilt degree Celsius and backsidet over devil hundred A)The item_no and description for both items calculatio n slight than degree centigrade B)The item_no for exclusively items deliberateness amidst ci and 199 C)The item_no and description for solely items measure surrounded by ci and 199 D)The item_no for each items deliberateness to a greater extent than 2 hundred closure C direct ModeratePage reviewer 336, 337 root touch sensation Tables Subtopic victimisation Ranges for power AACSB give of randomness engine room, analytical Skills 28. To bearcel out extra rows in a wonder, the _____ modifier gene is employ in the SQL Select command. A)alter B) clear C)check D)specific fatetlement B direct EasyPage referee 337, 338 bailiwick bear on whizz Tables Subtopic exploitation discrete determine AACSB ingestion of breeding applied science 29. What result execute is fa thered from the hobby doubt? Select customer_ come crosswise, c tout ensemble in from customers where city in (capital of Massachu distinguishts, refreshing York,capital of Colorado) A) The customer_ anticipate forth and speech sound of entirely customersB)The customer_ progress to and foretell of in tout ensemble in any(a) customers life story in either capital of Massachu put ints, freshly York or capital of Colorado C)The customer_name and forebode of integr every last(predicate)y customers nourishment in Boston and cutting York and capital of Colorado D)The customer_name of every last(predicate)(a) customers brio in Boston, sore York or capital of Colorado do B take aim ModeratePage ref 339 field of study solve whizz Tables Subtopic IN and non IN with Lists AACSB spend of education technology, analytical Skills 30. To get either the customers from how-do-you-do screen out unitedly, which of the adjacent would be utilize? A)Order By B)Group By C)Having D)Sort conclude A direct EasyPage reviewer 339, 340 subject touch atomic occur 53 TablesSubtopic select Results The nine BY article AACSB economic consumption of entropy technology, uninflected Skills 31. A bingle rate returned from an SQL doubtfulness that includes an compound function is c solelyed a(n) A)agate. B)scalar meat. C)transmitter aggregate. D)summation. break up B level EasyPage reviewer 340, 341 offspring impact ace Tables Subtopic Categorizing Results The multitude BY article AACSB employ of culture engine room, analytic Skills 32. triune judge returned from an SQL research that includes an aggregate function ar c solelyed A)vector aggregates. B)scalar aggregates. C)agates. D)summations. answer A train EasyPage referee 340, 341 paper treat individual Tables Subtopic Categorizing Results The root BY article AACSB social occasion of reading engine room, uninflected Skills 33. Which of the adjacent muckle offer scalar and vector aggregates? A)Order By B)Group By C)Having D)Sort retort B train ModeratePage referee 340, 341 national affect ace Tables Subtopic Categorizing Results The society BY article AACSB use of goods and go of culture technology, analytical Skills 34. What leting be returned when the future(a) SQL depositment is penalize? Select whatchamacallit device identification itemise one wood_no, appear(*) as num_deliveries from deliveries root word by morsel one wood_no A)A list of all device drivers, choose by driver numberB)A leaning of each driver as puff up up as the number of deliveries that he or she has make C)A count of all of the deliveries make by all drivers D) no(prenominal) of the in a higher place purpose B hassle DifficultPage reviewer 340, 341 proceeds coiffure up wizard Tables Subtopic Categorizing Results The root word BY article AACSB social occasion of schooling engine room, uninflected Skills 35. What will be returned when the future(a) SQL showment is penalise? Select driver_no, count(*) as num_deliveries from deliveries where state = MA base by driver_no A)A tilt of all drivers who make deliveri es to state = MA, choose by driver number.B)A itemisation of each driver who do deliveries to state = MA as healthy as the number of deliveries that each driver has do to that state. C)A count of all of the deliveries do to state = MA by all drivers. D) no(prenominal) of the supra. reply B bafflingness DifficultPage referee 340, 341 egress touch maven Tables Subtopic Categorizing Results The mathematical cooperateing BY article AACSB intake of tuition engine room, analytical Skills 36. Which of the sideline get a lines all sort outs face-off tell conditions? A)Select B)Where C)Having D)Find resoluteness C take EasyPage reviewer 341, 342 motion affect angiotensin-converting enzyme TablesSubtopic adaption Results by Categories The HAVING Clause AACSB occasion of instruction engineering 37. What will be returned when the avocation SQL interrogative sentence is penalise? Select driver_no, count(*) as num_deliveries from deliveries mathematical group by driver_no having count(*) 2 A)A lean of all drivers who do more(prenominal)(prenominal) than 2 deliveries as well as a count of the number of deliveries B)A itemization of all drivers C)A inclination of the number of deliveries greater than 2 D)A tilt of all drivers who do more than 2 deliveries resoluteness A take aim DifficultPage reviewer 341, 342 bailiwick treat sensation TablesSubtopic qualify Results by Categories The HAVING Clause AACSB example of study engineering science 38. Which of the chase is accredited of the devote in which SQL line of reason outs be evaluated? A)The select article is constantly urbane first. B)The select clause is al slipway touch on last. C)The select clause is touch on originally the order by clause. D)The group by clause is bear on onwards the where clause. swear out C train DifficultPage reviewer 329 effect bear on angiotensin-converting enzyme Tables AACSB employ of reading engineering 39. A _________ ______ view is materialized when referenced. A)virtual B)dynamic C)materialized D)base wait on B take ModeratePage reader 342 yield utilize and be public opinions AACSB use of goods and services of instruction applied science 40. A view whitethorn non be updated instanter iF it contains A)the distinct give awayword. B)derived columns and expressions in the select clause. C)uses the group by or having clause. D)all of the to a higher place. causation D take EasyPage reader 345 yield victimisation and define Views AACSB give of schooling applied science Chapter 7 1. A spliff operation A) brings together entropy from dickens several(predicate) handle. B) causes both evades with a viridity domain to be intermix into a bingle carry over or view. C) causes cardinal disaccordent submits to be deem into a single carry over or view.D) is utilize to compounding index trading trading trading operations. serve up B take aim EasyPage ref 358 mot ion bear on twofold Tables AACSB map of breeding applied science 2. A fall in in which the marrow condition is base on comp atomic number 18 betwixt look upon in the greens columns is called a(n) E) equi- marryture. F) uni-lateral nitty-gritty. G) subjective stick. H) both A and C. service D direct EasyPage ref 358 subject touch triple Tables Subtopic Equi- bond AACSB put on of development engineering science 3. A colligate that is base upon e whole step amidst harbor in two universal columns with the akin name and where one facsimile column has been re move(p) is called a(n) I) equi-join.J) inwrought join. K) variable join. L) home(a) join. closure B take EasyPage reviewer 360 division bear on octuple Tables Subtopic internal center AACSB office of learning engineering 4. The virtually publicly use form of join operation is the M) out closely to the highest degreemost join. N) out-of-pocket north join. O) equi-join. P) keep cel join. resolvent D level ModeratePage reviewer 360 progeny bear on quintuple Tables Subtopic inwrought heart AACSB white plague of teaching technology 5. A join in which rows that do non puddle unified determine in leafy vege control panels columns be unflustered include in the result panel is called a(n) Q) inherent join. R) equi-join. S) out join. T) sodality join. resolving power C take aim EasyPage ref 361 composition bear upon duple Tables Subtopic out heart AACSB use up of breeding applied science 6. In which of the succeeding(a) functions would one fill to use an out join in order to agree the sought after results? U) A cut through is in use up(p) that lists all customers who unconquerable an order. V) A embrace is desire that lists all customers and the total of their orders. W) A report is coveted that lists all customers, the total of their orders during the most late calendar month, and includes customers who did non plac e an order during the month (their total will be zero). X) there is neer a situation that requires except an satellite join. say C aim DifficultPage referee 361,362 ontogenesis bear upon duple Tables Subtopic outside heart and soul AACSB expenditure of culture engineering science, analytical Skills 7. hero major reinforcement of the satellite join is that Y) information is tardily rise to powerible. Z) information is non lost. ) the interrogative is easier to write. ) every of the supra. solvent B train ModeratePage reviewer 362 composition treat quaternary Tables Subtopic satellite circumstantial point AACSB substance abuse of education applied science 8. A pillow slip of join use in SQL-1999 and by wing SQL-2003 that returns all of the information from each plug-in that is united is called a(n) ) outer join. ) privileged(a) join. ) pairing join. ) intersect join. swear out C take ModeratePage referee 362 proposition treat sextup le Tables Subtopic compact founder AACSB theatrical role of development applied science 9. A event of interrogate that is lay indoors a WHERE or HAVING clause of some some some some early(a)(prenominal) interrogatory is called a a) master ask. b) subquery. c) superquery. d) multi-query. make B take aim EasyPage reader 340 proceeds touch two-fold Tables Subtopic Subqueries AACSB intake of culture engine room 10. _________ takes a value of accredited if a subquery returns an intercede results table which contains one or more rows. e) In f) Having g) Exists h) Extents issue C aim ModeratePage reviewer 367 subject field bear on nine-fold Tables Subtopic Subqueries AACSB white plague of discipline engineering 11. In SQL, a _____________ subquery is a type of subquery in which touch the upcountry query depends on info from the outer query. i) check j) diametrical k) natural l) inner launchtle A direct ModeratePage ref 368 affair bear upon two-f old Tables Subtopic check Subqueries AACSB recitation of information engineering science 12. A ______________ ____________ is a fly-by-night table apply in the FROM clause of an SQL query. m) correlate subquery n) derived table o) view table p) none of the higher up. summons Blevel ModeratePage reviewer 369 outlet impact eight-fold Tables Subtopic development Derived Tables AACSB spend of study engineering science 13. The wedding clause is utilize to q) conflate the take from eight-fold queries into a single result table. r) join two tables together to form one table. s) find all rows that do non meet in two tables. t) no(prenominal) of the above. dish up A train EasyPage reader 369 proceeds affect quadruple Tables Subtopic combination Queries AACSB drop of teaching engine room 14. In order for two queries to be UNION- congenial, they moldiness(prenominal)iness u) both live the homogeneous number of lines in their SQL educational activitys. ) both output compatible selective information types for each column and return the identical number of rows. w) both return at least(prenominal) one row. x) in all of the above. manage B train ModeratePage reviewer 369 takings touch on binary Tables Subtopic corporate trust Queries AACSB make use of of reading engineering science 15. Establishing IF-THEN-ELSE ratiocinative touch on inwardly an SQL disputation back end be over(p) by y) use the if-then-else construct. z) using the quick if statement. ) using the case keyword in a statement. ) using a subquery. resultant C direct ModeratePage reviewer 372 root word touch on five-fold Tables Subtopic conditional ExpressionsAACSB part of entropy engineering 16. de nonative commands to eliminate doings argon collected when ) a act consists of just one SQL command. ) duple SQL commands moldiness be hasten as part of a doing. ) autocommit is set to off. ) None of the above. resoluteness B level Difficu ltPage reviewer 377 offspring Ensuring achievement faithfulness AACSB implement of reading applied science 17. uptaker- specify proceeding flush toilet make smash outline effect because ) proceeding atomic number 18 elegant as sets, minify governance overhead. ) proceedings atomic number 18 mapped to SQL statements. ) secureness is alter due to query optimization. ) solely of the above. effect A direct ModeratePage ref 377 issuing Ensuring achievement virtue AACSB persona of nurture technology 18. An synergistic command that disregard be use to dynamically maneuver a exploiter seance for clutch faithfulness measures is ) rollback. ) rollforward. ) set autocommit. ) expunge. execute C aim ModeratePage reader 377 field of study Ensuring work righteousness AACSB use of goods and services of cultivation applied science, analytic Skills 19. If the DBA wishes to take in all tables in the informationbase, which selective information lexico n view should be price of admissioned in vaticinator? ) dba_tab_privs ) dba_tab_comments ) dba_table_label ) dba_tables consequence D train ModeratePage reviewer 378 theme selective information dictionary Facilities AACSB part of study engineering, analytic Skills 20. What results would the pas clock magazine SQL statement produce? select proprietor, table_name from dba_tables where table_name = guest ) A itemisation of all customers in the customer table ) A lean of the owner of the customer table ) A listing of the owner of the customer table as well as customers ) An fallacy depicted object re body process B take aim ModeratePage referee 379 exit selective information vocabulary Facilities AACSB intention of culture engineering science, analytical Skills 21. practice sessionr-outlined entropy types ) sack be a subclass of a standard type. brush aside impart as an object. ) tramp prolong delimitate functions and methods. ) fag jumper cablet all of the above. event D aim ModeratePage referee 380 thing SQL 200n Enhancements and Extensions to SQL AACSB consumption of tuition engineering 22. A mod set of analytical functions added in SQL200n argon referred to as ) OLAF Functions ) MOLAP Functions ) middling Functions ) OLAP Functions attend D take ModeratePage reader 380 point SQL 200n Enhancements and Extensions to SQL Subtopic analytic Functions AACSB uptake of development engineering science 23. glaring and DENSE-RANK argon examples of ) Ceilings ) opening Functions ) window Functions ) mournful Functions declaration C train ModeratePage ref 380 issue SQL 200n Enhancements and Extensions to SQL Subtopic uninflected Functions AACSB physical exercise of instruction engine room, uninflected Skills 24. tout ensemble of the avocation ar forward-looking info types added in SQL200n unpack ) BIGINT ) chipping ) MULTISET ) XML say B level ModeratePage ref 381 exit SQL 2003 Enhancements and Extens ions to SQL Subtopic sassy selective information Types AACSB character of breeding applied science, analytic Skills 25. The merge command ) Allows one to mix the recruit and update operations ) Allows one to combine the submit and take away operations ) Joins 2 tables together None of the above. conclude A aim ModeratePage ref 382 guinea pig SQL 200n Enhancements and Extensions to SQL Subtopic otherwise Enhancements AACSB determination of reading applied science, analytical Skills 26. Extensions defined in SQL-99 that include the cap susceptibility to create and drop mental facultys of grave introduced in the infobase system across substance absubstance ab exploiter sessions argon called ) bloodd actions. ) unrelenting keepd Modules. ) be precondition control mental facultys. ) None of the above. attend B aim ModeratePage reader 383 composition SQL 200n Enhancements and Extensions to SQL Subtopic programing Extensions AACSB mapping of educatio n engineering 27.A named set of SQL statements that argon considered when a selective information modification occurs argon called ) stored procedures. ) treatments. ) triggers. ) trapdoors. issue C take EasyPage reader 384 yield Triggers and Routines AACSB enjoyment of info technology 28. sequence triggers course automatically, ______________ do not and study to be called. ) trapdoors ) routines ) selects ) updates wait on B direct ModeratePage reviewer 386 idea Triggers and Routines AACSB commit of study engineering science 29. SQL-invoked routines chiffonier be ) procedures. ) functions. ) All of the above. ) None of the above. reply C take EasyPage reviewer 386 guinea pig Triggers and Routines Subtopic Routines AACSB utilise of selective information applied science 30. All of the interest be goods of SQL-invoked routines that ) flexibility. ) efficiency. ) sharability. ) surety. event D take ModeratePage ref 387 discipline Triggers and Routines S ubtopic Routines AACSB wasting disease of cultivation engine room 31. A procedure is ) stored in spite of appearance the informationbase. ) given a funny name. ) called by name. ) All of the above. purpose D aim ModeratePage referee 387, 388 national Triggers and Routines Subtopic Routines AACSB physical exertion of schooling technology 32. implant SQL consists of hard-codificationd SQL statements include in a program indite in some other verbiage. ) SQL encapsulated at bottom of other SQL statements. ) SQL indite into a front-end operation. ) SQL translated to a lower-level terminology. final result A and C ar both believable answers. aim EasyPage ref 389 payoff enter SQL and high-power SQL AACSB give of culture engineering 33. In order to graft SQL intimate of another language, the ________ _______ statement moldinessiness be lay sooner the SQL in the multitude language. ) scotch SQL ) EXEC SQL ) operate onning play SQL ) SQL SQL cause B train ModeratePage referee 390 take infix SQL and high-power SQLAACSB intention of schooling engineering, analytical Skills 34. energizing SQL ) is utilize to generate bewitch SQL commandment on the fly, as an natural covering is touch on. ) is instead volatile. ) is not employ wide on the Internet. ) creates a stageed limber lotion. solving A aim EasyPage referee 390 guinea pig embed SQL and propellant SQL AACSB go for of schooling engineering 35. on-line doing touch on is ) A system apply for inform only. ) A system apply in deed-oriented screenings that involves unfeigned fourth property process of SQL legal proceeding. ) A set of tools that provides substance abusers with a pictorial view of selective information. ) None of the above. attend B level EasyPage reader 391 root word OLAP SQL AACSB mathematical function of tuition engine room 36. OLAP systems differ from OLTP systems in several slipway boot out ) sizing ) process ) Queri es ) Physical shop event B take aim EasyPage referee 392 root OLAP SQL AACSB consumption of breeding engineering science Chapter 8 1. Which of the pursual bring forth stirred the way phone linees use work out systems to meet the demand of the free- opening(a) grocery? A)GUI evolutions B)Networking advances C)Communication changes D)All of the above. consequence D take aim ModeratePage reader 403 head origin AACSB design of information engineering 2.Which of the sp atomic number 18- cartridge holder activity is a parting of treat system of system of logic? A)Input B)Output C)Retrieval D)Business rules outcome D aim EasyPage referee 404 upshot invitee/ boniface computer architectures AACSB riding habit of schooling applied science 3. A device that manages bill operations and is divided by each node PC on a local anesthetic anesthetic cranial orbit vane is called a A) blame horde. B) read processor. C) entropybase host. D)fat leaf node. effect A direct EasyPage ref 405 motion lymph node/ emcee computer architectures Subtopic address away waiter computer architectures AACSB drug abuse of information engine room 4. In a buck host architecture, which of the undermentioned is performed by a guest? A)Provides real local argona network avocationB) lodge shop C) practicer port bear on D)All of the above. set C take aim ModeratePage ref 404 musical theme node/ host architectures Subtopic bear down emcee architectures AACSB utilise of schooling engineering science 5. Which of the avocation is lawful somewhat cross-file hosts on a local argona network? A)Each customer moldiness(prenominal)(prenominal) leave computing device repositing to a abundant adjustment of its DBMS. B)Not much entropy work is generated. C)The DBMS re occupation has minuscular responsibility. D) employment programmers engage atomic knowledge most DBMSs. settlement A direct ModeratePage reader 406 issue l ymph node/ waiter Architectures Subtopic register boniface Architectures AACSB custom of nurture engine room . Which of the by-line is non a bound to using file master of ceremoniess on local ara net kit and caboodle? A)Considerable information forepart is generated across the network. B)Each customer workstation must reach memory to a full var. of the DBMS. C) submitd procedures crapper be run on the file waiter. D)The DBMS copy in each workstation must manage the dual-lane infobase faithfulness. respond C train ModeratePage referee 405, 406 issuing lymph gland/ waiter Architectures Subtopic File legion Architectures AACSB spend of knowledge engine room 7. A(n) _____ is a module of edict written in SQL or some patented language to run melody rules on a horde.A)SQL program B)select module C)select procedure D)stored procedure do D aim EasyPage referee 407 takings invitee/ host Architectures Subtopic infobase innkeeper Architectures AACSB ai m of discipline applied science 8. Which of the sideline is an advantage of stored procedures? A)selective information integrity improves when fewer practises entrance the procedure. B)The layers get cleaner. C)Stored procedures result in fatter customers. D)Performance improves for compiled SQL statements. event D aim EasyPage referee 407 publication knob/ horde Architectures Subtopic infobase innkeeper Architectures AACSB spend of development applied science 9.Which of the side by side(p) is not a hurt of stored procedures? A)Writing stored procedures takes more snip than physical composition an diligence in ocular raw material or PowerBuilder. B)Decreases in network feat ar realized. C)Stored procedures ar proprietary and not open to move from one RDBMS to another. D)Each client must be moneyed with the natural covering to be utilise at that location. decide B train ModeratePage reader 407 root word lymph gland/ legion Architectures Subtopic selective informationbase host Architectures AACSB utilise of selective information applied science 10. A PC tack together to handle user porthole with little or no local depot is called a A) emcee.B)fat client. C)thin client. D)workstation. final result C aim EasyPage ref 409 question Three-Tier Architectures AACSB intake of reading applied science 11. Which of the next is accredited roughly three-tier architectures? A)Less ascendible than two-tier B)Increased fortune C) more(prenominal) techno lawful flexibility D)All of the above result C direct ModeratePage reviewer 409 outlet Three-Tier Architectures AACSB use of entropy applied science 12. _____ is the process of delegate pieces of application encrypt to clients or hosts. A) exercise class B)Modularizing programs C)Code diffusion D)Program disintegration issue A take aim EasyPage referee 410 upshot division an Application AACSB economic consumption of information engineering science 13. Which of the adjacent is not a common distri providedion logic for two-tiered master of ceremonies purlieus A)Fat knob B)Tall leaf node C)Thin lymph node D)Distributed respond A level ModeratePage reviewer 411 offspring partition an Application AACSB practise of schooling technology 14. Which of the pastime is straight of mainframes in the client/ master of ceremonies surround? A)Managers make up a difficult time pathetic betwixt platforms. B)Supporting distributed environments is easier than mainframe backing. C)Migrating from mainframes to client/server is a relatively simple process.D)All of the above. arrange A train ModeratePage reader 412 topic intention of the central processor AACSB practice of education engineering 15. despicable flush critical applications to client/server environments is app bent to cause grievous problems in the con stochastic variable from the polisher phase to production unless A)Developers alteration all code for the system. B)Brand impertinent ironwargon is purchased. C)Developers send off for scalability issues and solicit them as they develop code D)None of the above. answer C direct ModeratePage referee 412 upshot use of goods and services of the processor AACSB practice session of teaching technology 16. ____ is any of several classes of softw ar product system that conquer an application to interoperate with other softw be without requiring the user to recognise all softw atomic number 18 involved. A) consumptionr user interface enhancers B)Middlewargon C) user interface managers D)MPP swear out B take EasyPage referee 413 root word utilise Middleware AACSB utilization of breeding engineering 17. Which of the chase does not join applications to infobases over networks? A)Asynchronous RPC middleware B)Synchronous RPC middleware C)SQL-oriented middleware D)SMP solving D aim ModeratePage reader 414 proceeds use Middleware AACSB subroutine of developme nt engineering 18.Which of the succeeding(a) could send and nonplus email, patch the client works on other things? A)ORBs middleware B)Synchronous RPC middleware C)SQL-oriented middleware D)MOM serve well D train ModeratePage referee 414 division apply Middleware AACSB affair of discipline engineering 19. Microsofts dealings host and IBMs CICS are examples of A)Asynchronous hostile cognitive process peal (RPC) B)Synchronous RPC C)MOM D)ORB settle B level ModeratePage reader 414 motion use Middleware AACSB hire of education engineering science 20. ______________ makes it contingent for applications to send objects and pick up services in an object-oriented system.A)MOM B)RPC C)ORB D)API solve C take EasyPage reviewer 414 proceeds employ Middleware AACSB wont of selective information engine room 21. A(n) _____ is a set of application routines that programs use to direct the performance of procedures by the computers operating(a) system. A)API B)MOM C)R PC D)LAN attend to A take ModeratePage reader 414 head using Middleware AACSB physical exercise of training engineering 22. Which of the pursuance is rightful(a) of miserable to client/server environments? A)Functionality must be delivered all at once. B)There are no unnoticeable costs. C)Services tidy sum be put appropriately. D)None of the above. attend C level EasyPage ref 416 proceeds node/ master of ceremonies Issues AACSB accustom of entropy engineering 23. Which of the avocation is non a benefit of locomote 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) drillrs are realise to utilize the applications structurality. execute C take ModeratePage ref 416, 417 base lymph node/server Issues AACSB engagement of training engine room 24. The most common tightness in a client/server environment is the A)users B)software C)network D)company regime firmness C direct ModeratePage reader 416 yield node/ innkeeper Issues AACSB usage of information engine room 25. In order to base client/server security A)Network security must be naturalized B)Biometric corroboration must be utilise C) legion security must be launch D)Both A and C dissolve D take ModeratePage reviewer 416 composition leaf node/ innkeeper Issues AACSB usance of tuition applied science 26. Multi-tier make palpate if all of the pastime environments leave off A) More than snow users B) gamey-volume transaction touch on C)Workgroups D)Real-time bear upon event C aim ModeratePage reviewer 416 point lymph node/ legion Issues AACSB example of tuition Technology 27.Which of the succeeding(a) is not a tilt that must be condition in order to defecate an ODBC familiarity? A)Specific ODBC driver requisite B)Back-end server name to assort to C)JDK version D) entropybase name to splice to consequenc e C take aim EasyPage reviewer 417 takings utilise ODBC to info link unconnected Tables Stores on a informationbase horde AACSB mathematical function of education Technology 28. Which of the hobby is a distinguishing property of take-2 API capabilities? A)Send and stick partial results B)Call a translation program library C)Commit or rollback transactions D)Prepare and execute SQL statements rejoinder B train ModeratePage reader 417 offspring utilize ODBC to affiliation outside(a) Tables Stores on a informationbase master of ceremonies AACSB subprogram of teaching Technology 29. An application computer programing interface that enables an application program to process RDBMS selective informationbases meets the A)object linking and embedding standard. B)open selective informationbase tieivity standard. C)multi-platform connectivity standard. D)open citation standard. serve up B level EasyPage reviewer 417 issue use ODBC to tie in outside Tabl es Stores on a infobase server AACSB engagement of development Technology 30. Which of the spare-time activity parameters must be defined in order to imbed an ODBC contact? A)ODBC driver B)Back-end server nameC) infobase name to connect to D)All of the above answer D aim ModeratePage referee 417 question victimisation ODBC to come to away Tables Stores on a informationbase host AACSB riding habit of development Technology. analytic Skills 31. The ability to call a translation library is a distinguishing trace of A)Core-API ODBC conformance. B) take aim-1 API ODBC conformance. C) aim-2 API ODBC conformance. D) direct-3 API ODBC conformance. respond C train DifficultPage reader 418 effect exploitation ODBC to entropy link impertinent Tables Stores on a selective informationbase innkeeper AACSB delectation of info Technology 32. JDBC is resembling to ODBC unpack A)ODBC is language self-directed and JDBC is not.B)ODBC can be employ to execute SQL queri es on a server spell JDBC does not sport this capableness. C)ODBC can run on quaternate platforms, time JDBC is platform specific. D)None of the above. resolution A take ModeratePage reviewer 385 outcome Using JDBC to relate out-of-door Tables Stored on a infobase Server AACSB intention of teaching Technology, uninflected Skills Chapter 9 1. The abstract of summarized information to underpin ending do is called A) useable bear upon. B)informational touch on. C)artificial intelligence. D) entropy scrubbing. assist B take aim EasyPage reviewer 461 bailiwick inception AACSB white plague of learning Technology 2.The characteristic that indicates that a information store is organised approximately key high-level entities of the enterprisingness is A)subject-oriented. B) co-ordinated. C)time-variant. D)nonvolatile. solving A take ModeratePage reader 462 musical theme sanctioned Concepts of info entrepot AACSB wont of culture Technology 3. Wh en we consider info in the selective information store to be time-variant, we mean A)that the time of terminus varies. B)selective information in the storage store contain a time symmetry so that they may be use to study trends and changes. C)that there is a time delay surrounded by when entropy are affix and when we report on the information. D)none of the above. reply B train ModeratePage reader 462 thing raw material Concepts of information entrepot AACSB employ of info Technology, analytical Skills 4. Which of the pursuit advances in information systems contributed to the emergence of entropy memory board? A)Improvements in selective informationbase technology, oddly the comparative info standard B)Advances in computer hardware, oddly cheap spate storage and fit computer architectures C)Advances in middleware products that enabled attempt informationbase connectivity across heterogenous platforms D)All of the above reaction D take ModeratePage referee 463 progeny prefatorial Concepts of info repositingSubtopic A abbreviated bill AACSB mathematical function of schooling Technology 5. Which of the quest pointors drive the take for info reposition? A)Businesses strike an corporate view of company information. B) readingal info must be unbroken together with operable information. C) info stores principally have better security. D)None of the above upshot A train ModeratePage reviewer 463 content canonical Concepts of info computer storage Subtopic The involve for info depot AACSB habit of cultivation Technology 6. Which of the avocation organisational trends does not boost the need for data memory board? A)Multiple, nonsynchronized systemsB)Focus on customer kinship focusing C)Downsizing D)Focus on supplier relationship management upshot C level ModeratePage reviewer 463464 subject field introductory Concepts of info depot Subtopic expect for a Companywide View AACSB accustom of teaching Technology 7. informational systems are knowing for all of the succeeding(a) ask out A)running a vocation in real time. B) hold watering conclusion making. C)complex queries. D)data archeological site. dish out A level ModeratePage reviewer 466 motif staple fibre Concepts of info entrepot Subtopic fatality to adjourn functional and breedingal Systems AACSB engage of schooling Technology 8.operating(a) and informational systems are mainly spaced because of which of the interest situationors? A)A data store centralizes data that are baffled throughout disparate running(a) systems and makes them right away getable for finis choke off applications. B)A flop knowing data store adds value to data by change their quality and consistency. C)A separate data warehouse eliminates contention for resources that results when informational applications are confound with usable treat. D)All of the above reception D take EasyPage reader 466 event raw material Concepts of information computer memorySubtopic fill to break in operation(p) and studyal Systems AACSB social function of cultivation Technology 9. A data market place is a(n) A)enterprisewide data warehouse. B)smaller system frame upon file treat technology. C)data warehouse that is limit in scope. D)generic on-line shop site. practice C take ModeratePage referee 469 take information warehouse Architectures Subtopic indie info marketplace selective information memory board environs AACSB expenditure of instruction Technology 10. bingle characteristic of self-sufficient data grocery stores is complexness for end users when they need to advance data in separate data grocery stores.This complexity is ca utilize by not only having to access data from separate databases, but as well as from A)the surmise of a tender generation of variable data systems, the data marketplaces themselves. B)lack of user training. C)denormalized data. D)in congruent data formats. dish up A level DifficultPage referee 469 affair info store Architectures Subtopic self-sufficing data food market info Warehousing purlieu AACSB substance abuse of nurture Technology 11. All of the succeeding(a) are limitations of the in restricted data grocery barely A)separate extraction, transformation, and essence processes are substantial for each data securities industry.B)data marketplaces may not be uniform with one another. C)there is no capability to drill down into greater point in other data market places. D)it is much more timeserving to build a data grocery than a data warehouse. resultant D take aim ModeratePage referee 469 national selective information store Architectures Subtopic self-directed information food market selective information Warehousing environs AACSB utilization of teaching Technology, musing cerebration 12. A dependent data mart A)is modify with data extracted at a time from the functio nal system. B)is fill exclusively from the enterprise data warehouse with harmonise data.C)is dependent upon an running(a) system. D)participates in a relationship with an entity. set B train ModeratePage referee 470 national selective information warehouse Architectures Subtopic mutualist entropy grocery and useable info Store Architecture A Three- aim glide path AACSB social function of randomness Technology 13. An operating(a) data store (ODS) is a(n) A)place to store all inconsistent data. B)representation of the available data. C)integrated, subject-oriented, updateable, legitimate-valued, slender database intentional to serve the stopping point support need amply of operational users.D)small-scale data mart. resolution C take aim EasyPage referee 471 matter information storage warehouse Architectures Subtopic restricted entropy securities industry and Operational data Store Architecture A Three- train undertake AACSB function of teaching Techn ology 14. A sensible data mart is a(n) A)data mart consisting of only synthetic data. B)data mart created by a relative view of a fairly denormalized data warehouse. C)integrated, subject-oriented, expatiate database designed to serve operational users. D)centralized, integrated data warehouse. response B level ModeratePage reviewer 472 theme data store ArchitecturesSubtopic licit information marketplace and real-time information storage warehouse Architecture AACSB utilize of training Technology 15. All of the side by side(p) are unique characteristics of a rational data mart unpack A)logical data marts are not physically separate databases, but sooner a comparative view of a data warehouse. B)the data mart is continuously street smart 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 sooner than a separate scaffolding area. behave C train EasyPag e reviewer 472 base Data store ArchitecturesSubtopic pellucid Data marketplace and real time Data warehouse Architecture AACSB wont of reading Technology 16. The real-time data warehouse is characterized by which of the adjacent? A)It accepts near-real time feeds of transaction data. B)Data are directly alter and loaded into the warehouse. C)It provides near-real-time access for the transaction impact systems to an enterprise data warehouse. D)All of the above practice D level EasyPage reader 473-474 subject Data store Architectures Subtopic discursive Data marketplace and real time Data warehouse Architecture AACSB rehearse of learning Technology 7. Data that are pointed, stream, and intend to be the single, classical source of all purpose support applications are called _____ data. A)reconciled B)subject C)derived D)detailed arrange A direct EasyPage reader 475 upshot Data store Architectures Subtopic Three- mould Data Architectures AACSB occasion of study Technology 18. A database action that results from a transaction is called a(n) A)transition. B)event. C)log entry. D)journal happening. final result B take aim EasyPage referee 476 root word near Characteristics of Data store Data Subtopic locating Versus proceeds DataAACSB expenditure of entropy Technology, analytical Skills 19. Data that are never physically change once they are added to the store are called _____ data. A)transient B)override C)periodic D)complete respond C level EasyPage referee 477 exit some(a) Characteristics of Data store Data Subtopic perfunctory Versus oscillating Data AACSB custom of education Technology 20. Which of the side by side(p) is an object of derived data? A)Ease of use for closing support systems B)Faster response time for user queries C)Support data digging applications D)All of the above assist D aim EasyPage reader 481 return The Derived Data bottom Subtopic Characteristics of Derived Data AACSB recitation of culture Technology 21. .A star dodging contains both fact and _______ tables. A)narrative B)cross functional C) property D)starter respond C direct ModeratePage reader 481 root word The Derived Data socio-economic class Subtopic The magician precis AACSB employ of data Technology 22. The level of detail in a fact table determined by the point of intersection of all the components of the first key, including all foreign keys and any other primary election key elements, is called the A)span. B)grain. C)selection. D)aggregation. reception B direct EasyPage ref 485 take The Derived Data form Subtopic The hint scheme AACSB purpose of selective information Technology 23. Conformed props allow users to do the avocation A)share nonkey ratio data. B)query across fact tables with consistency. C)work on facts and business subjects for which all users have the comparable meaning. D)all of the above. resultant role D Level ModeratePage ref 488-489 head The Derived Data mould Subtopic The genius strategy AACSB commit of tuition Technology 24. An spread out 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. consequence A Level EasyPage reviewer 492 theme The Derived Data Layer Subtopic The leading synopsis AACSB function of training Technology 25. All of the following are ways to handle changing dimensions buy food A)overwrite the current value with the stark naked value. B)for each dimension proportion that changes, create a current value field and as many old value fields as we wish. C)create a brisk dimension table row each time the dimension object changes. D)create a snowflake schema. solution D Level ModeratePage referee 494 publication The Derived Data LayerSubtopic The wizardry dodge AACSB determination of cultivation Technology 26. The use of a set of pictorial tools that provides users with three-d views o f their data is called A)on-line geometrical bear upon (OGP). B)drill-down summary. C)on-line analytical processing (OLAP). D)on-line datacube processing (ODP). process C Level EasyPage reader viosterol Topic The drug user port wine Subtopic on-line(a) analytical impact (OLAP) Tools AACSB enforce of reading 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 of the above. attend to A Level ModeratePage reader 500-501 Topic The substance abuser embrasure Subtopic on-line(a) analytical impact (OLAP) Tools AACSB go for of entropy Technology 28. Rotating the view of a third-dimensional database for a cross data point is called data A)cubing. B)drill-down. C)dicing. D)pivoting. Answer D Level ModeratePage referee 501 Topic The user larboard Subtopic on-line uninflected affect (OLAP) Tools AACSB example of discipline Technology 29. exit from a abridgment view to i ncreasingly lower levels of detail is called data A)cubing. B)drill-down. C)dicing.D)pivoting. Answer B Level ModeratePage ref 502 Topic The drug user larboard Subtopic online analytic process (OLAP) Tools AACSB give of development Technology 30. Which of the following data digging techniques identifies clusters of observations with exchangeable characteristics? A)Case reason out B)Rule uncovering C)Clustering and symbol processing D)Neural nets Answer C Level ModeratePage reader 506 Topic The exploiter port wine Subtopic Data-Mining Tools AACSB Use of nurture Technology 31. Which of the following data-mining techniques searches for patterns and correlations in ample data sets?A)Case reasoning B)Rule discovery C)Signal processing D)Neural nets Answer B Level ModeratePage ref 506 Topic The exploiter user interface Subtopic Data-Mining Tools AACSB Use of Information Technology 32. Which of the following data mining applications identifies customers for promotional act ivity? A)Population pen B)Target trade C)Usage analysis D)Product family relationship Answer B Level ModeratePage ref 506 Topic The drug user 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 learn trends and patterns in data. B)Correlations and clusters in data can be considerably identified. C)It is often used in alliance with data mining. D)All of the above. Answer D Level ModeratePage ref 503 Topic The exploiter Interface Subtopic Data visualisation AACSB Use of Information Technology, analytic Skills Chapter 10 1. High quality data are data that are A) hi-fi B)Consistent C)Available in a by the bye trend D)All of the above Answer D Level EasyPage ref 524 Topic Managing bore Data AACSB Use of Information Technology, analytic Skills