Q&A Hero

Management

Q: Coding, testing, and debugging are part of the___________ phase of the Systems Development Life Cycle (SDLC).a. planningb. analysisc. detailed systems designd. implementation
Q: Discovery of user requirements, existing system evaluation, and logical system design are part of the________ phase of the Systems Development Life Cycle (SDLC).a. planningb. analysisc. detailed systems designd. implementation
Q: The initial assessment and the feasibility study are part of the Systems Development Life Cycle's (SDLC's)_________ phase.a. planningb. analysisc. detailed systems designd. implementation
Q: The traditional Systems Development Life Cycle (SDLC) is divided into ___________phases.a. twob. threec. fourd. five
Q: The process of creating an information system is known as____________ .a. systems developmentb. database developmentc. network developmentd. enterprise development
Q: Decentralized design is typical of relatively simple, small databases and can be successfully done by a single person. a. True b. False
Q: Physical design becomes simpler when data is distributed at different locations. a. True b. False
Q: The database administrator must be prepared to perform routine maintenance activities within the database. a. True b. False
Q: Evaluation of database performance is rendered easier by the fact there are no standards to measure it. a. True b. False
Q: The overall purpose of the database initial study is to create the conceptual design. a. True b. False
Q: Database performance is one of the least important factors in all database implementations. a. True b. False
Q: The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming. a. True b. False
Q: Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules. a. True b. False
Q: In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables. a. True b. False
Q: The main purpose of a backup is to guarantee database restoration following a hardware or software failure. a. True b. False
Q: The assignment of access rights may restrict operations on predetermined objects such as databases, tables, views, queries, and reports. a. True b. False
Q: After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations. a. True b. False
Q: To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact. a. True b. False
Q: The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process. a. True b. False
Q: A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance. a. True b. False
Q: A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC). a. True b. False
Q: The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs. a. True b. False
Q: In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary. a. True b. False
Q: The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC). a. True b. False
Q: During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.a. Trueb. False
Q: The detailed systems design phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient. a. True b. False
Q: Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC). a. True b. False
Q: In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system. a. True b. False
Q: In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase. a. True b. False
Q: The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system's functional areas, actual and potential problems, and opportunities. a. True b. False
Q: The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging. a. True b. False
Q: In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase. a. True b. False
Q: The Systems Development Life Cycle's (SDLC's) planning phase yields a general overview of the company and its objectives. a. True b. False
Q: The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.a. Trueb. False
Q: The Systems Development Life Cycle (SDLC) traces the history of an information system.a. Trueb. False
Q: The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management. a. True b. False
Q: The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models. a. True b. False
Q: The term "database development" is used to describe the process of database design and implementation. a. True b. False
Q: Systems analysis establishes the need for an information system and its extent. a. True b. False
Q: Explain the differences between a centralized and decentralized approach to database design.
Q: What are the classical approaches to database design?
Q: Explain the concept of logical design and list the steps involved.
Q: What are the factors affecting the purchasing decision for DBMS software?
Q: List and describe the different levels at which database backups can be performed.
Q: List and briefly describe the three types of system maintenance activities.
Q: _______________could become a very technical job that affects not only the accessibility of the data in the storage device(s) but also the performance of the system.
Q: The_____________ goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.
Q: When selecting DBMS ______________, items to consider include processors, RAM, and disk space.
Q: The term________ describes the strength of the relationships found among a module's entities.
Q: The term_____________ describes the extent to which modules are independent of one another.
Q: ___________________is the first stage in the database design process.
Q: A___________ is an information system component that handles a specific business function, such as inventory, orders, or payroll.
Q: Because real-world database design is generally done by teams, the database design is probably divided into major components known as____________ .
Q: A_______________ rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.
Q: From a database point of view, the collection of data becomes meaningful only when the ___________are defined.
Q: A designer must have a thorough understanding of the company's data types, extent, and uses in order to develop an accurate _____.
Q: The first step in_____________ is to discover the data element characteristics.
Q: The____________ stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.
Q: _____________allows the assignment of access rights to specific authorized users.
Q: ________________allow end users to access the database without being able to download the information from their workstations.
Q: Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.
Q: How are triggers critical to proper database operation and management?
Q: Describe the characteristics of an Oracle sequence.
Q: Describe the important features and applications of SQL functions
Q: What are the four different types of results that can be returned from a subquery?
Q: Explain the different basic types of join operations. What are they and how do they work?
Q: _________________is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.
Q: When the critical application code is isolated in a single program, ____________improves.
Q: A row-level trigger requires use of the keywords___________ and is executed once for each row affected by the triggering statement.
Q: Using Oracle___________ , a designer can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.
Q: In an Oracle sequence, the___________ pseudo-column retrieves the current value of a sequence.
Q: In MS Access, a designer can use the____________ data type to define a column in his table that will be automatically populated with unique numeric values.
Q: A(n)_________ routine pools multiple transactions into a single batch to update a master table field in a single operation.
Q: A(n)___________ view is a view that can be used to update attributes in the base table(s) that are used in the view.
Q: If the DBMS does not support the INTERSECT statement, one can use a(n)___________ subquery to achieve the same result.
Q: The syntax of the MINUS statement in Oracle is______________ .
Q: The ____________statement can be used to combine rows from two queries, returning only the rows that appear in both sets.
Q: A(n)__________ query can be used to produce a relation that retains the duplicate rows.
Q: The ___________statement combines the output of two SELECT queries.
Q: The syntax of the DECODE function starts with____________ .
1 2 3 … 1,015

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts