DBMS and SQL Questions and Answers 4 DBMS and SQL Questions and Answers 4 In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.TRUEFALSEWhich of the following projects reflects a database being designed from existing data?A database that will combine two databases currently used by the Production DepartmentA database designed to generate reports for a new Production Department based on manufacturing processA database using the Production Department's spreadsheetsNone of the above is correctFor creating a relationship, how many possible types of actions are to be considered while enforcing min. cardinalities?ThreeFourFiveSixWhich of the following is the most common types of databases?WorkgroupPersonalEnterpriseDepartmentLanguage that adds programming elements in SQL Server 2000 like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:VB.NetTRANSACT SQLVisual BasicCOBOLAn important benefit of three-tier architecture is:Results in a thinner client and database serverNew modules can be built to support specific business needsPerformance improves for compiled SQL statementsAll of the above.Which prefixes are available to Oracle triggers?:new only:old onlyBoth :new and :oldNeither :new nor :oldEven though Java is machine-independent, JSPs are not.TRUEFALSEWhich of the following is true about triggers?You do not create them with SQLThey execute against only some applications that access a databaseThey cannot cascade (cause another trigger to fire)They have an event, condition, and actionA distributed database is which of the following?A loose collection of file that is limited to one locationOne logical database that is spread to multiple locations and is interconnected by a networkOne logical database which is limited to one location onlyA loose collection of file that is spread to multiple locations and is interconnected by a network
