Home

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

A. i-only

B. ii-only

C. Both of them

D. None of them

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

You can do it
  1. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  2. The values of the attribute describes a particular
  3. The drawback of shadow paging technique are
  4. As per equivalence rules for query transformation, selection operation distributes over
  5. Which of the following statement on the view concept in SQL is invalid?
  6. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  7. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  8. Which of the following is not a recovery technique?
  9. Which of the following addressing modes permits relocation without any change over in the code?
  10. The cost of reading and writing temporary files while evaluating a query can be reduced by
  11. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  12. Cascading rollback is avoided in all protocol except
  13. DBMS helps achieve
  14. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  15. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  16. In SQL the word natural can be used with
  17. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  18. Union operator is a :
  19. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  20. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  21. The clause alter table in SQL can be used to
  22. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  23. _____ database is used to provide statistical information or summaries of values based on various criteria.
  24. The part of a database management system which ensures that the data remains in a consistent state is
  25. In 2NF
  26. When an E-R diagram is mapped to tables, the representation is redundant for
  27. An advantage of the database management approach is
  28. DROP is a statement in SQL.
  29. The normalization was first proposed by .
  30. The data in the database at a particular moment of time is called the _______