Home

In a relational schema, each tuple is divided into fields called

A. Relations

B. Queries

C. Domains

D. All of the above

Correct Answer : A.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

You can do it
  1. In 2NF
  2. In SQL, testing whether a subquery is empty is done using
  3. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  4. DROP is a statement in SQL.
  5. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  6. An advantage of views is
  7. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  8. ______is a preferred method for enforcing data integrity
  9. For correct behaviour during recovery, undo and redo operation must be
  10. What is a disjoint less constraint?
  11. Dependency preservation is not guaranteed in
  12. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  13. _____clause is an additional filter that is applied to the result.
  14. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  15. SQL server stores index information in the _____system table
  16. Which of the following concurrency control schemes is not based on the serializability property?
  17. As per equivalence rules for query transformation, selection operation distributes over
  18. A _____ is used to define overall design of the database
  19. The middleware databases in which the business rules act are applicable to _______ tier architectures
  20. Protection of data from unauthorized Disclosure results in loss of _______
  21. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  22. The one guideline to be followed while designing the database is

  23. A PHP Error was encountered

    Severity: Notice

    Message: iconv_strlen(): Detected an illegal character in input string

    Filename: compat/mbstring.php

    Line Number: 77

    Backtrace:

    File: /var/www/html/application/views/discuss.php
    Line: 226
    Function: character_limiter

    File: /var/www/html/application/helpers/viewloader_helper.php
    Line: 1359
    Function: view

    File: /var/www/html/application/controllers/Questions.php
    Line: 484
    Function: load_guest

    File: /var/www/html/index.php
    Line: 315
    Function: require_once

    If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship between X and Y is
  24. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  25. The normal form that is not necessarily dependency preserving is
  26. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  27. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  28. The rule that a value of a foreign key must appear as a value of some specific table is called a
  29. The normalization was first proposed by .
  30. Which of the following is not comparison operator?