ICT285 PASS Week 4

What is the correct syntax for creating a table?

• NEW TABLE table_name (
      column1 datatype,
      column2 datatype,
      column3 datatype,
     ....
  );

• CREATE TABLE table_name (
      column1 datatype,
      column2 datatype,
      column3 datatype,
     ....
  );

• CREATE table_name TABLE (
      column1 datatype,
      column2 datatype,
      column3 datatype,
     ....
  );

• NEW table_name TABLE (
      column1 datatype,
      column2 datatype,
      column3 datatype,
     ....
  );

How to make values for the LastName attribute never equal to NULL in the CREATE TABLE statement?

• LastName CHAR(25) NOT NULL

• LastName CHAR(25) NEVER NULL

• LastName CHAR(25) NULL

How do you make WorkID a primary key in the CREATE TABLE statement?

• CONSTRAINT WorkID PRIMARY KEY

• CONSTRAINT PRIMARY KEY(WorkID)

• CONSTRAINT WorkPK PRIMARY KEY(WorkID)

• PRIMARY KEY(WorkID)

How do you make ArtistID in the WORK table a foreign key for ArtistID in the ARTIST table?

• CONSTRAINT ArtistFK FOREIGN KEY(ArtistID) REFERENCES tutorials.ARTIST(ArtistID)

• CONSTRAINT ArtistFK FOREIGN KEY REFERENCES tutorials.ARTIST(ArtistID)

• CONSTRAINT ArtistFK FOREIGN KEY (ArtistID) REFERENCES (ArtistID)

• CONSTRAINT FOREIGN KEY(ArtistID) REFERENCES tutorials.ARTIST(ArtistID)

In the CREATE TABLE statement, how can you add a constraint to ensure DateOfBirth values are between 1900 and 2100?

• CONSTRAINT CHECK ((DateOfBirth >= 1900) AND (DateOfBirth <=2100))

• CONSTRAINT ValidBirthYear CHECK ((DateOfBirth >= 1900) AND (DateOfBirth <=2100))

• CONSTRAINT ValidBirthYear CHECK ((DateOfBirth >= 1900) OR (DateOfBirth <=2100))

• CONSTRAINT ValidBirthYear ((DateOfBirth >= 1900) OR (DateOfBirth <=2100))

In the CREATE TABLE statement, how can you add a constraint to ensure Nationality values can only be French or German?

• CONSTRAINT CHECK

  (Nationality ON ('French', 'German'))

• CONSTRAINT NationalityValues CHECK

  (Nationality EXISTS ('French', 'German'))

• CONSTRAINT Nationality IN ('French', 'German'))

• CONSTRAINT NationalityValues CHECK

  (Nationality IN ('French', 'German'))

What is the correct syntax for inserting data into a table?

• INSERT table_name (column1, column2, column3, ...) INTO
  VALUES (value1, value2, value3, ...);

• INSERT VALUES (value1, value2, value3, ...) INTO table_name (column1, column2, column3, ...);

• INSERT INTO table_name (column1, column2, column3, ...)
  VALUES (value1, value2, value3, ...);

• INSERT (value1, value2, value3, ...) INTO table_name (column1, column2, column3, ...);

How can we insert values (777, Steve, 2) into the attached table?

• INSERT INTO EMP

  VALUES (111, 'Steve', 2);

• INSERT VALUES INTO EMP

  (111, 'Steve', 2);

• INSERT EMP

  VALUES (111, 'Steve', 2);

• INSERT VALUES (111, 'Steve', 2) INTO EMP;

What is the correct syntax for updating existing records from a table?

• UPDATE table_name
  SET column1 = value1, column2 = value2, ...
  WHERE condition;

• UPDATE table_name
  SELECT column1 = value1, column2 = value2, ...
  WHERE condition;

• UPDATE table_name

  WHERE condition
  SET column1 = value1, column2 = value2, ...;
  

• FROM table_name
  UPDATE column1 = value1, column2 = value2, ...
  WHERE condition;

How can you exclusively update employee 111's name to Robert?

• UPDATE EMP

  SET EName = 'Robert'

  WHERE D# = 1;

• UPDATE EMP

  SET E# = 111

  WHERE EName = 'Robert';

• UPDATE EMP

  SET EName = 'Robert'

  WHERE D# = 2;

• UPDATE EMP

  SET EName = 'Robert'

  WHERE E# = 111;