In Tuple Relational Calculus, to express the query “Find the set of all tuples S such that F(S) is true”, how can we write this?
A. {S >> F(S)}
B. {S | F(S)}
C. {S → F(S)}
D. {S = F(S)}
Junior Auditor Paper held on 08-07-2023
Junior Auditor Past Paper 08-07-2023
The purpose of normalization is to identify a suitable set of relations that support the data requirements of an enterprise. Following are the characteristics of a suitable set of relations EXCEPT:
A. The minimal number of attributes necessary to support the data requirements of the enterprise.
B. Attributes with a close logical relationship (described as functional dependency) are found in the same relation.
B. Implementation of a method that depends on the type of the object it is applied to (overriding).
C. Minimal redundancy with each attribute represented only once with the important exception of attributes that form all or part of foreign keys, which are essential for the joining of related relations.
In which network topology, one long cable acts as a backbone to link all the devices in a network?
A. Ring Topology
B. Mesh Topology
C. Node Topology
D. Bus Topology
Which of the following describes the relationship between members of the subclasses and indicates whether it is possible for a member of a superclass to be a member of one, or more than one, subclass?
A. Composition
B. Participation constraint
C. Aggregation constraint
D. Disjoint constraint
What is the overall time complexity of the merge sort algorithm?
A. O(n log n)
B. O(log n)
C. O(n)
D. Olog(n)
In which of the following communication mode, each station can both transmit and receive, but not at the same time? When one device is sending, the other can only receive and vice versa.
A. Half-Duplex
B. Full-Duplex
C. Simplex
D. Both A and B
Which of the following is the Preprocessor Directive in C++?
A. using namespace std;
B. #include <iostream>
C. // comments
D. variable
Which of the following is the Average Case Time Complexity for the Bubble sort algorithm?
A. O(n log n)
B. O(n²)
C. O(n)
D. O(n log² n)