SQL Commands Answers

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components. True False The _____ command permanently saves all changes—such as rows added, attributes modified, and rows deleted—made to any table in the database. COMMIT SELECT ROLLBACK UPDATE In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up. transaction log backup conservative backup differential backup adaptive backup The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables. indexed core relation base Which comparison operator indicates a value is not equal? < <= >= <> An alias cannot be used when a table is required to be joined to itself in a recursive query. True False The _____ command is used to restore the database to its previous condition. ROWCOUNT BACKUP COMMIT ROLLBACK Systems analysis establishes the need for an information system and its extent. True False A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. True False The result of the _____ 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. analysis implementation detailed systems design maintenance The DECLARE section in the trigger is used to declare any variables used inside the trigger code. True False "Should the existing system be replaced?" is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC). planning analysis implementation maintenance Which statement describes a feature of Oracle sequences? Oracle sequences are tied to columns and tables. Oracle sequences generate a character string that can be assigned to tables. An Oracle sequence uses the identity column property to automatically number rows. Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database. Which of the following is a hardware-induced database failure? Memory chip errors Viruses Malware Abortion due to deadlock All SQL commands must be issued on a single line. True False Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns. reserved unique null character The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging. True False The _____ command restricts the selection of grouped rows based on a condition. DISPLAY HAVING FROM CONVERT The SQL command that allows a user to permanently save data changes is _____. INSERT SELECT COMMIT UPDATE A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance. True False Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC). planning analysis detailed systems design implementation The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming. True False The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE. True False Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity. True False In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase. True False _____ is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance. Conceptual design Network design Logical design Physical design Comparison operators cannot be used to place restrictions on character-based attributes. True False Most SQL implementations yield case-insensitive searches. True False Training principles and methodologies are planned during the _____ phase of the Systems Development Life Cycle (SDLC). maintenance implementation analysis detailed systems design In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks. True False