CSE MCQs :: DBMS MCQs
- Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
- 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 ?
- Create table employee (name varchar ,id integer) What type of statement is this ?
- Select * from employee What type of statement is this?
- The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
- An attribute A of datatype varchar(20) has the value "Avi . The attribute B of datatype char(20) has value Reed .Here attribute A has ____ spaces and attribute B has ____ spaces .
- To remove a relation from an SQL database, we use the ______ command.
- Delete from r; r “ relation This command performs which of the following action ?
- Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this ?
- Updates that violate __________ are disallowed .
Whatsapp
Facebook
