DBMS

This set of Database Questions & Answers focuses on ” SQL Basics and SQL Data Definition”

published on November 21, 2017
1/5

1. Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?

a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
b)DDL
2/5

2. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?

a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
3/5

Select * from employee
What type of statement is this?

a) DML
b) DDL
c) View
d) Integrity constraint
a
4/5

The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

a) Fixed, equal
b) Equal, variable
c) Fixed, variable
d) Variable, equal
c
5/5

To remove a relation from an SQL database, we use the ______ command.

a) Delete
b) Purge
c) Remove
d) Drop table
d