Hi Can i have answer fot this for Date Basi What keyword swi

Hi,

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 data_base is used to change the database.

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 date;

What is the SQL statement used to delete the OM database if it is already there? DROP DATABASE OM; will drop the database OM.

What keyword removes all data from a table? DELETE FROM table_name; will delete all data from the table.

Which data type are most primary keys? Integer datatype or string datatypes are used mostly for primary keys.

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

How do you specify, when creating a field, that the column must have a value? NOT NULL will make sure that the column will have a value for sure.

Indexes will automatically be created for which of the following?

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

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

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