Q.1
DDL commands are:-
  • DROP
  • CREATE
  • DELETE
  • Both A & B
Q.2
Pattered matching in SELECT command can be done using:-
  • _
  • %
  • &
  • Both A & B
Q.3
Examples of DBMS software are:-
  • MySQL
  • ORACLE
  • FOXPRO
  • All of above
Q.4
Uniquely identifies the record ,includes NULL also
  • primary key
  • unique key
  • candidate key
  • alternate key
Q.5
Delete * from empl;
  • Deletes all tuples.
  • updates the table emp with null.
  • Destroys the table.
Q.6
When you want to use a join between columns that are in the same table, you use what type of join?
  • UNION
  • OUTER JOIN
  • LEFT JOIN
  • SELF JOIN
Q.7
When retrieving data in a particular table, we use the_____________ statement.
  • ORDER BY
  • FETCH
  • SELECT DISTINCT
  • SELECT FROM
0 h : 0 m : 1 s