Home

Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are

A. distinct values

B. cannot have NULL

C. both (A) & (B)

D. same as primary key

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. In SQL the word natural can be used with
  2. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  3. The values of the attribute describes a particular
  4. For using a specific database …………… command is used.
  5. Isolation of the transactions is ensured by
  6. operator is used to compare a value to a list of literals values that have been specified.
  7. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  8. The keyword to eliminate duplicate rows from the query result in SQL is
  9. Wait-for graph is used for
  10. The data models defined by ANSI/SPARC architecture are
  11. DROP is a statement in SQL.
  12. A data type or format is specified for each _________
  13. For correct behaviour during recovery, undo and redo operation must be
  14. Which of the following is a reason to model data?
  15. The graphical representation of a query is .
  16. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  17. Relational Algebra does not have
  18. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  19. It is an abstraction through which relationships are treated as higher level entities
  20. A transaction is in state after the final statement has been executed.
  21. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  22. Immediate database modification technique uses
  23. Which of the following addressing modes permits relocation without any change over in the code?
  24. HSAM stands for ……….
  25. The data in the database at a particular moment of time is called the _______
  26. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  27. If a transaction T has obtained an exclusive lock on item Q, then T can
  28. Key to represent relationship between tables is called
  29. Which of the following statement on the view concept in SQL is invalid?
  30. Checkpoints are a part of