Course Name: Introduction to Database

Section A: Multiple Choice Questions [ 10 questions x I mark - 10 marks] Choose the correct answer for all of the following questions. You must mark your final answers in the provided grid. 1. The principle of the relational data model consists of a. representing the data in a tree structure b. representing the data by a CDM c. representing the data by tables d. representing the data by functional dependencies 2. In which of the below level of backup, all the database objects are backed up completely? a. Full b. Differential c. Transaction log d. Incremental 3. Which Oracle data type is able to hold alphanumeric data where the size is variable? a. INTEGER b. LONG c. CHAR d. VARCHAR2 4. Which operator of relational algebra can be applied en two relations of different schemas? a. II b. c. - d. DC 5. The correct SQL syntax to remove a column from a table is a. ALTER TABLE \{tablename\} DELETE COLUUN \{column_name\} b. ALTER TABLE \{tablename\} REMOVE COLUMN \{column_name\} c. ALTER TABLE \{tablename; CHANGE COLUMN \{column_name) d. ALTER TABLE \{tablename\} DROP COLUMN \{column_name\} 6. Which SQL join expression of the following returns the Cartesian product between tables? a. INNER JOIN b. LEFT OUTER JOIN c. RIGHT OUTER JOIN d. CROSS JOIN 7. Which one of following WHERE conditions allows you to get all products manufactured in the year 2016 ? a. WHERE DATE >= *31-Dec-2015 AND DATE c= "31-Dec-2016" b. WHERE DATE >= '01-fan-2016' AND DATE