Database concepts and the Structured Query Language

The SQL used by front-end application programs to request data from the DBMS is called _______

• A. DML

• B .DDL

• C .VDL

• D. SDL

The command used to delete a particular column in a relation is ____________

• A.UPDATE TABLE

• B.TRUNCATE COLUMN

• C.ALTER , DROP

• D.DELETE COLUMN

Which of the following operations requires the relations to be union compatible?

• A.UNION

• B.INTERSECTION

• C.DIFFERENCE

• D.ALL OF THESE

The database language that allows us to access data in a database is called :

• A.DCL

• B.DML

• C.DDL

• D.None Of Above

Which data manipulation command is used to combines the records from one or more tables?

• A.SELECT

• B.PROJECT

• C.JOIN

• D.PRODUCT

Which of the following is a legal expression in SQL?

• A.SELECT NULL FROM SALES;

• B.SELECT NAME FROM SALES;

• C.SELECT * FROM SALES WHEN PRICE = NULL;

• D.SELECT # FROM SALES;

DCL provides commands to perform actions like

• A.Change the structure of Tables

• B.Insert, Update or Delete Records and Values

• C.Authorizing Access and other control over Database

• D.None of Above

Which data type can store unstructured data in a column?

• A.RAW

• B.CHAR

• C.NUMERIC

• D.VARCHAR

The virtual table that its created by data from the result of an SQL 'Select' statement is called _________

• A.View

• B.Synonym

• C.Sequence

• D.Transaction

What is the full form of DDL ?

• A.Dynamic Data Language

• B.Detailed Data Language

• C.Data Definition Language

• D.Data Derivation Language