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