Special Quiz 2 - G9

The facility to identify and define database owner users, their functions, and roles.

• Database

• Security

• Server Objects

• Replication

Allows you to create database objects like table, index, view and function.

• USE

• CREATE

• ALTER

• DROP

This command is used to select any existing database in the SQL schema.

(a)  

Choose two(2) powerful commands of DML.

• SELECT

• USE

• INSERT

• CREATE

The facility that will allow you to have local subscription.

• Database

• Security

• Management

• Replication

This command is used to retrieve rows from table. It is most widely used command in SQL.

(a)  

This command adds one or more records to a database table.

• SELECT

• INSERT

• UPDATE

• DELETE

All are DML Commands EXCEPT:

• SELECT

• UPDATE

• INSERT

• DROP

It enables you to view, filter, insert, delete, and update data in your database.

• DML

• DDL

• DCL

• SQL

Choose the proper syntax for ALTER Command(to Add columns):

• ALTER TABLE[table name]

  ADD [column name][data type[null | not null]

  [column name][data type[null | not null]

• UPDATE[table name]

  SET[column name = value]

  WHERE[condition]

• DROP TABLE[table name];

• ALTER TABLE[table name]

  ALTER COLUMN [column_name][data type];