PRELIM EXAM (SCC)

What field in the database table identifies the unique identity of the records?

• Identity key

• Field key

• Primary key

• Record key

What query command is used to display the list of fields in the existing tables?

• show tables;

• show table [table name];

• describe [table name];

• describe table [table name];

What query command is used to delete the existing database in the database list?

• remove database [database name];

• delete database [database name];

• dropped database [database name];

• None of the above

What query command is correct when we would like to delete a field name in the table?

• alter table tablename

  -- delete fieldname;

• alter table tablename

  -- drop fieldname;

• drop table tablename;

• drop table fieldname;

What query command is correct when we would like to add a field name in the table?

• alter table tablename

  -- insert fieldname;

• alter table tablename

  -- add fieldname;

• alter table

  -- add fieldname;

• alter table

  -- insert fieldname;

What query command is correct when we would like to change the name of the existing table?

• alter table tablename

  -- alter newtablename;

• alter table tablename

  -- rename newtablename;

• alter table

  -- change newtablename;

• alter table

  -- change name newtablename;

What query command is used to add table inside the database?

• insert

• add

• create

• update

What query command is used to delete existing field name inside the table?

• drop

• remove

• delete

• erase

What query command is used to display the list of fields in the existing tables?

• show tables;

• show table [table name];

• describe [table name];

• describe table [table name];

What does INSERT query command used for?

• To insert table fields.

• To insert values in the table fields.

• To insert field names in the table.

• To insert database in the table.