OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P8

OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P8: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Review Questions 281 13. The following table describes the DEPARTMENTS table Column Name dept_id dept_name mgr_id location_id Key Type pk Nulls Unique NN FK Table Datatype NUMBER VARCHAR2 NUMBER NUMBER Length 4 30 6 4 Default Value None None None 99 Which of the following INSERT statements will raise an exception A. INSERT INTO departments dept_id dept_name location_id VALUES 280 Security 1700 B. INSERT INTO departments VALUES 280 Security 1700 C. INSERT INTO departments VALUES 280 Corporate Giving 266 1700 D. None of these statements will raise an exception. 14. Refer to the DEPARTMENTS table structure in question 13. Two SQL statements are shown here. Choose the best option that describes the SQL statements. INTO departments dept_id dept_name mgr_id VALUES 280 Security 1700 INTO departments dept_id dept_name mgr_id location_id VALUES 280 Security 1700 NULL A. Statements 1 and 2 insert the same values to all columns in the table. B. Statements 1 and 2 insert different values to at least one column in the table. C. The location_id column must be included in the column list of statement 1. D. A NULL value cannot be inserted explicitly in statement 2. 282 Review Questions 15. The SALES table contains the following data SELECT channel_id COUNT FROM sales GROUP BY channel_id C COUNT T 12000 I 24000 How many rows will be inserted into the NEW_CHANNEL_SALES table with the following SQL statement INSERT FIRST WHEN channel_id C THEN INTO catalog_sales prod_id time_id promo_id amount_sold VALUES prod_id time_id promo_id amount_sold WHEN channel_id I THEN INTO internet_sales prod_id time_id promo_id amount_sold VALUES prod_id time_id promo_id amount_sold WHEN channel_id IN I T THEN INTO new_channel_sales prod_id time_id promo_id amount_sold VALUES prod_id time_id promo_id amount_sold SELECT channel_id prod_id time_id promo_id amount_sold FROM sales A. 0 B. 12 000 C. 24 000 D. 36 000 16. How many rows will be counted in the last SQL statement that follows .