DBMS This set of Database Questions & Answers focuses on ” SQL Basics and SQL Data Definition” Unnati published on November 21, 20172 responses 0 « Previous Next » Questions in vertical order 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 employeeWhat 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
