Can i have answer fot this for Date Basi What keyword switch

Can i have answer fot this for Date Basi

What keyword switches the focus from the current database being used to another database?

Write the SQL statement to add a date field named last_contact_date to the vendors table in the database currently being used.

What is the SQL statement used to delete the OM database if it is already there?

What keyword removes all data from a table?

Which data type are most primary keys?

In order to delete a foreign key constraint, you must know its _________.

How do you specify, when creating a field, that the column must have a value?

Indexes will automatically be created for which of the following?

When inserting into a primary key column with automatic number generation, use __________ as the data value.

What keyword specifies that a primary key\'s value must be different for each row?

When creating a primary key column, use ___________ to generate sequential numbers as the value.

Solution

What keyword switches the focus from the current database being used to another database?
   -> USE DatabaseName;

Write the SQL statement to add a date field named last_contact_date to the vendors table in the database currently being used.
   -> ALTER TABLE vendors
       ADD last_contact_date column-definition;

What is the SQL statement used to delete the OM database if it is already there?
   -> DROP DATABASE OM;

What keyword removes all data from a table?
   -> DELETE * FROM table_name;

Which data type are most primary keys?
   -> int

In order to delete a foreign key constraint, you must know its _________.
   -> table name and FOREIGN_KEY_NAME

How do you specify, when creating a field, that the column must have a value?
   -> when creating a field, that the column must have \"NOT NULL\" in column defination.

Indexes will automatically be created for which of the following?
   -> You have not specified what are the following options.

When inserting into a primary key column with automatic number generation, use __________ as the data value.
   -> start value of the primary key

What keyword specifies that a primary key\'s value must be different for each row?
   -> UNIQUE (keyword in your column definition).

When creating a primary key column, use ___________ to generate sequential numbers as the value.
   -> AUTO_INCREMENT