Q1. Let columns (c1, c2) together be a primary key in table T1. Which of the following statement(s) is/are true

1. c2 independently can have a default value constraint

2. A column c3 of T2 can be a foreign key constraint referring to column c2 of T1

3. c1 can be independently unique and cannot take null values

4. c2 can be independently unique and cannot take null values

Q2. Let T1(c1, c2, c3) be a table with c1 as primary key. Data is being loaded from a local file consisting of 10 records. Assume that first two records are duplicate records in the file. Which one of the statement(s) is/are true?

1. All records in the local file must honour primary key constraint on c1. Otherwise, none of the records from the local file will be loaded into the table.

2. Except the first two records in the local file, rest of the eight records will be loaded into the table.

3. A warning will be issued by the database that there are two records in the local file that violate primary key constraint, however, all the 10 records will be loaded into the table.

4. A warning will be issued by the database that there is one record in the local file that is violating primary key constraint, those nine records which do not violate constraint are loaded into the table.