Consider the following SQL statement: Create table Cars( CarID varchar(8), CarName varchar(20), CarColour varchar(8), YearOfPurchase integer, Weight integer, primary key (CarID), check(YearOfPurchase in (1990, 2000, 2005, 2010))); Which among the following will cause an integrity constraint violation in the Cars table? Note: Insertions are done in the order of the options given.

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

Database Management Systems · Quiz 1 · 7 Jul 2024 · May 2024 term

Question 3: Consider the following SQL statement: Which among the fol…

Question 3

+3 marksOne correct option

Consider the following SQL statement:

sql

1Create table Cars(
2CarID varchar(8),
3CarName varchar(20),
4CarColour varchar(8),
5YearOfPurchase integer,
6Weight integer,
7primary key (CarID),
8check(YearOfPurchase in (1990, 2000, 2005, 2010)));

Which among the following will cause an integrity constraint violation in the Cars table?

Note: Insertions are done in the order of the options given.

Show answer

Correct answer

See the whole paper Take it as a mock test

Question 3 of 15 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 7 Jul 2024, in the May 2024 term (IIT M DIPLOMA AN EXAM QDD2 7 July 2024). It carries 3 marks.

More questions from this paper

Q1Consider the table Champions_League for given subquestions | Name | Age | Team | Country | Goals | |---|---|---|---|---…
Q2Consider the table Champions_League for given subquestions | Name | Age | Team | Country | Goals | |---|---|---|---|---…
Q4Figure question
Q5Figure question
Q6Consider the following relations: players(pid, name, age, jersey_no)\ teams(team_name, matches, points, p…
Q7Consider the following data for given subquestions: | Driver_ID | Name | Team | Salary | |---|---|---|---| | 55 | Carlo…
Q8Consider the following data for given subquestions: | Driver_ID | Name | Team | Salary | |---|---|---|---| | 55 | Carlo…
Q9Which of the following statement(s) is/are correct?
Q10Consider the E-R diagram given in Figure 1 and answer the subquestions. Identify the correct relational schema for the …
Q11Consider the E-R diagram given in Figure 1 and answer the subquestions. Identify the correct relational schema for the …
Q12Consider the E-R diagram given in Figure 1 and answer the subquestions.
Q13Consider the tables r and s. | A | B | C | D | |---|---|---|---| | p | 1 | p | a | | q | 2 | r | a | | r | 4 | q | b | …
Q14Consider a relational schema:\ Parts(Pid, Pname, Price, Quantity)\ Vendors (Vid, Vname, Location, Pid) Co…
Q15Consider the following table which has three attributes: X, Y and Z, where X is the primary key and Z is the foreign ke…