Question 24 What is meant by the term "transaction processing"? a. processing over a network b. processing by a bank or other financial institution c. grouping database changes into one unit of work that must succeed or fail together d. pre-processing data with a separate program before it is saved in the database 2 points Question 25 You can choose to increment a sequence by a number other than 1 when each next value is retrieved. True False 2 points Question 26 If no candidate keys exist in a table, which of the following is used? a. surrogate key b. dummy key c. foreign key d. index key 2 points Question 27 What will happen when the following query is executed: UPDATE student SET s_class='SR'; a. All records in the student table will be updated b. No records in the student table will be updated c. An error will occur d. The first record in the student table will be updated 2 points Question 28 The SYSDATE function supplies the current date from the system. True False 2 points Question 29 As a general rule, database developers should use a personal database only for ____ applications. a. business b. experimental c. mission-critical d. non-mission-critical 2 points Question 30 Which of the following is not required when creating a table? a. table size b. table name c. column names d. column data types 2 points Question 31 To view the time to a date on a report/screen, use the format model ____. a. TO_DATE('08/29/2012 6:00 PM', 'MM/DD/YYYY HH:MI PM') b. TO_CHAR('08/29/2012 6:00 PM', 'MM/DD/YYYY HH:MI PM') c. TO_DATE('08/29/2012 6:00 PM', 'MM/DD/YYYY HH:MM PM') d. TO_DATE('6:00 PM', 'HH:MM PM') 2 points Question 32 Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table? a. MODIFY TABLE CONSTRAINT DISABLE faculty_loc_id_fk; b. ALTER TABLE faculty DISABLE faculty_loc_id_fk; c. MODIFY TABLE faculty DISABLE faculty_loc_id_fk; d. ALTER TABLE faculty DISABLE CONSTRAINT faculty_loc_id_fk; 2 points Question 33 The Oracle DBMS stores columns of all data types in the same amount of space. True False 2 points Question 34 To add data to the database, use the ____ command. a. OPEN b. ADD c. ADD_DATA d. INSERT 2 points Question 35 The following search condition would match the column value Sunday: WHERE value LIKE Sun% True False 2 points Question 36 A ____ key is a field in a relational database table whose value must be unique for each row. a. foreign b. primary c. secondary d. link 2 points Question 37 The Truncate TABLE command does not write any data to the transaction log. True False 2 points Question 38 A composite key only has one column True False 2 points Question 39 Which command would correctly insert the SYSDATE into the table using MM-DD-YYYY format? a. INSERT INTO TABLE (MYDATE) VALUES (TO_CHAR(SYSDATE), 'MM-DD-YYYY')) b. INSERT INTO TABLE (MYDATE) VALUES (TO_DATE(SYSDATE), 'MM-DD-YYYY'); c. INSERT INTO TABLE (MYDATE) VALUE (SYSDATE); d. INSERT INTO TABLE (MYDATE) VALUE (TO_DATE(SYSDATE), 'MM-DD-YYYY')) 2 points Question 40 When declaring a NUMBER data type, scale is the total number of digits both to the left and to the right of the decimal point. True False 2 points Question 41 A personal database like Microsoft Access should only be used for non-mission-critical applications. True False 2 points Question 42 A ____ key is a column that you create to be the records primary key identifier. a. foreign b. secondary c. surrogate d. composite 2 points Question 43 What is the correct command used to insert today's date into a date field/type on a table ? a. INSERT INTO TABLE (TODAYSDATE) VALUES (GETDATE()); b. INSERT INTO TABLE (TODAYSDATE) VALUES (SYSDATE); c. INSERT INTO TABLE (TODAYSDATE) VALUES (CURRDATE); d. INSERT INTO TABLE (TODAYSDATE) VALUES (DATE()); 2 points Question 44 A ____ dependency means that a field is dependent on another field within the table that is not the primary key field. a. indirect b. direct c. transitive d. partial 2 points Question 45 How would you tell what constraints exist within your user schema? a. DESCRIBE USER_TABLES; b. DESCRIBE USER_CONSTRAINTS; c. SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS; d. SELECT CONSTRAINTS FROM USER_OBJECTS; 2 points Question 46 In a data file, fields are also called ____. a. columns b. records c. rows d. entities 2 points Question 47 Which of the following declares a column named name that always contains exactly 30 characters? a. VARCHAR2(30) name b. CHAR(30) name c. name VARCHAR2(30) d. name CHAR(30) 2 points Question 48 If you omit the search condition in the delete query no record will be deleted. True False 2 points Question 49 When viewing this date 07/28/2012 on a report/screen, which format model will be used? a. TODATE('07/28/2012', 'MM/DD/YYYY') b. TO_CHAR('07/28/2012', 'MM/DD/YYYY') c. TOCHAR('07/28/2012', 'MM/DD/YYYY') d. TO_DATE('07/28/2012', 'MM/DD/YYYY') 2 points Question 50 Using the CHAR data type causes a column value to be padded to the maximum declared size of the column. True False 2 points Click Save and Submit to save and submit. Click Save All Answers to save all answers.