Home

DROP is a statement in SQL.

A. Query

B. Embedded SQL

C. DDL

D. DCL

You can do it
  1. The _______ is a set of programs to use and / or modify this data.
  2. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  3. operator is used to compare a value to a list of literals values that have been specified.
  4. An advantage of views is
  5. The normal form that is not necessarily dependency preserving is
  6. The data in the database at a particular moment of time is called the _______
  7. Wait-for graph is used for
  8. A relational database developer refers to a record as
  9. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  10. _____clause is an additional filter that is applied to the result.
  11. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  12. The part of a database management system which ensures that the data remains in a consistent state is
  13. Checkpoints are a part of
  14. ____specifies a search condition for a group or an aggregate.
  15. Which of the following is not a property of transactions?
  16. The cost of reading and writing temporary files while evaluating a query can be reduced by
  17. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  18. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  19. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  20. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  21. ______is a preferred method for enforcing data integrity
  22. In SQL, testing whether a subquery is empty is done using
  23. ______ keyword is used to find the number of values in a column.
  24. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  25. ______contains information that defines valid values that are stored in a column or data type.
  26. SQL server stores index information in the _____system table
  27. Shadow paging has
  28. A logical schema
  29. The graphical representation of a query is .
  30. An outstanding functionality of SQL is its support for automatic_____ to the target data.