Home

For using a specific database …………… command is used.

A. use database

B. database name use

C. Both A & B

D. None of them

You can do it
  1. _____clause is an additional filter that is applied to the result.
  2. A top-to-bottom relationship among the items in a database is established by a
  3. ____specifies a search condition for a group or an aggregate.
  4. Cascading rollback is avoided in all protocol except
  5. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  6. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  7. Which is the best file organization when data is frequently added or deleted from a file?
  8. Shadow paging has
  9. The data in the database at a particular moment of time is called the _______
  10. Relational Algebra does not have
  11. _____is a full form of SQL.
  12. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  13. If an entity can belong to only one lower level entity then the constraint is
  14. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  15. SQL server stores index information in the _____system table
  16. It is an abstraction through which relationships are treated as higher level entities
  17. Data independence means
  18. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  19. The normal form that is not necessarily dependency preserving is
  20. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  21. Change Staff table by removing default of Assistant for position column
  22. What is data integrity?
  23. HSAM stands for ……….
  24. Union operator is a :
  25. Which of the following aggregate functions does not ignore nulls in its results?.
  26. According to the levels of abstraction, the schema at the intermediate level is called
  27. The data models defined by ANSI/SPARC architecture are
  28. The default level of consistency in SQL is
  29. Which of the following ensures the atomicity of the transaction?
  30. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…