Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

Number of attributes of its relation schema.
Number of tuples stored in the relation.
Number of entries in the relation.
Number of distinct domains of its relation schema.

Correct answer: Number of attributes of its relation schema.

Solution

The degree, or arity, of a relation in a relational database refers to the number of attributes (or columns) in its schema, which defines the structure of the data within that relation.

Related GATE Technical questions

Which one of the following sequences when stored in an array at locations A[1],..., A[10] forms a max-heap?
Let SLLdel be a function that deletes a node in a singly-linked list given a pointer to the node and a pointer to the head of the list. Similarly, let DLLdel be another function that deletes a node in a doubly-linked list given a pointer to the node and a pointer to the head of the list. Let n denote the number of nodes in each of the linked lists. Which one of the following choices is TRUE about the worst-case time complexity of SLLdel and DLLdel?
Consider the Deterministic Finite-state Automaton (DFA) A shown below. The DFA runs on the alphabet {0,1}, and has the set of states {s,p,q,r}, with s being the start state and p being the only final state. Which one of the following regular expressions correctly describes the language accepted by A?
Suppose two hosts are connected by a point-to-point link and they are configured to use Stop-and-Wait protocol for reliable data transfer. Identify in which one of the following scenarios, the utilization of the link is the lowest.
An algorithm has to store several keys generated by an adversary in a hash table. The adversary is malicious who tries to maximize the number of collisions. Let k be the number of keys, m be the number of slots in the hash table, and k > m. Which one of the following is the best hashing strategy to counteract the adversary?
The output of a 2-input multiplexer is connected back to one of its inputs as shown in the figure. Match the functional equivalence of this circuit to one of the following options.

⚔️ Practice GATE Technical free + battle 1v1 →