Home

SQL server stores index information in the _____system table

A. system indexes

B. syst indexes

C. sys indexes

D. sysind

You can do it
  1. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  2. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  3. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  4. In an E-R diagram double lines indicate
  5. Which of the following is not a consequence of non-normalized database?
  6. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  7. The values of the attribute describes a particular
  8. A _____ is a logical unit of database processing that includes one or more data access operations that…
  9. Which of the following is not a property of transactions?
  10. The statement that is executed automatically by the system as a side effect of the modification of the…
  11. DBMS helps achieve
  12. Which of the following is a reason to model data?
  13. A top-to-bottom relationship among the items in a database is established by a
  14. Data independence means
  15. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  16. In an ER model,_____ is described in the database by storing its data.
  17. Maximum height of a B+ tree of order m with n key values is
  18. Grant and revoke are _____ statements.
  19. The clause alter table in SQL can be used to
  20. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  21. In multiple granularity of locks SIX lock is compatible with
  22. Which of the following is not a consequence of concurrent operations?
  23. Isolation of the transactions is ensured by
  24. The _______ is a set of programs to use and / or modify this data.
  25. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  26. What is a disjoint less constraint?
  27. Which of the following is not comparison operator?
  28. Which of the following addressing modes permits relocation without any change over in the code?
  29. Cascading rollback is avoided in all protocol except
  30. The cost of reading and writing temporary files while evaluating a query can be reduced by