DBMS

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

published on November 21, 20171 response 0

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. 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

Select * from employee
What type of statement is this?

a) DML
b) DDL
c) View
d) Integrity constraint
a

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

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

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