UGC NET June 2024 Computer Science and Application Exam: Previous Year Question Answers and Solutions

UGC NET June 2024 Computer Science and Application Exam: Previous Year Question Answers and Solutions

Q1➡ |
Which of the following is not an object Oriented Programming language?
i ➥ Pearl
ii ➥ Python
iii ➥ Small talk
iv ➥ SQL Plus
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q2➡ |
Shift-Reduce conflicts are resolved by:
i ➥ Left recursion
ii ➥ Ambiguity
iii ➥ Left factoring
iv ➥ Associativity and Precedence
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q3➡ |
A least integer n such that f(x) is O (xn ) for each of the following functions. Arrange following according to the value of n increasing order:
A. f(x) = 3x3 + (log x)4
B. f(x) = (x5 + x2 +1) / (x3 +1)
C. f(x) = (x3 + x2 +1) / (x2 +1)
D. f(x) = (x2 +5logx) / (x2 +1)

Choose the correct answer from the options given below:
i ➥ D, C, A, B
ii ➥ D, C, B, A
iii ➥ B, C, A, D
iv ➥ B, A, C, D
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q4➡ |
Arrange the following so that they can be placed in perfect/appropriate order.
A. Planning
B. Construction
C. Modeling
D. Communication
E. Deployment
Choose the correct answer from the options given below:
i ➥ A, B, C, D, E
ii ➥ D, A, C, B, E
iii ➥ A, D, B, C, E
iv ➥ B, C, D, A, E
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q5➡ |
Match List-I with
List – I
A. A→ aB|a, a T, A, B V
B. A→ BC|a, a T, A, B, C ∈ V
C. LL (1) grammar
D. Halting problem

List – II
I. Recursive Descent Parser
II. Turing Machine
III. Choamsky Normal Form
IV. Finite Automate

Choose the correct answer from the options given below:
i ➥ A-IV, B-III, C-I, D-II
ii ➥ A-III, B-I, C-II, D-IV
iii ➥ A-II, B-IV, C-III, D-I
iv ➥ A-IV, B-III, C-II, D-I
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q6➡ |
What is a perceptron in ANN?
i ➥ A double layer auto-associative neural network
ii ➥ A neural network that contains feedback
iii ➥ An auto-associative neural network
iv ➥ A single layer feed-forward neural network with pre-processing
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q7➡ |
Arrange the following examples of Artificial Intelligence (Al) in the order of increasing complexity:
A. Spam email detection using rule-based systems.
B. Handwritten digit recognition using shallow neural networks.
C. Image classification using convolutional neural networks.
D. Autonomous driving using reinforcement learning algorithms.

Choose the correct answer from the options given below:
i ➥ A, B, C, D
ii ➥ B, A, C, D
iii ➥ A, B, D, C
iv ➥ B, C, A, D
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q8➡ |
Match List-I with List-II:
List – I
Line coding scheme
A. NRZ-L
B. 2 B1Q
C. 4.D-PAM 5
D. MLT-3

List – II
Bandwidth (average)
I. B=N/4
II. B=N/8
III. B=N/3
IV. B=N/2

Choose the correct answer from the options given below:
i ➥ A-II, B-I, C-IV, D-III
ii ➥ A-IV, B-II, C-I, D-III
iii ➥ A-IV, B-I, C-II, D-III
iv ➥ A-III, B-IV, C-II, D-I
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q9➡ |
The order of steps of Address Translation in Linux Virtual Memory Scheme will be :
A. register
B. offset
C. Page directory
D. Page table
E. Page middle directory
Choose the correct answer from the options given below:
i ➥ B, A, D, E, C
ii ➥ A, C, E, D, B
iii ➥ D, C, A, B, E
iv ➥ C, A, D, E, B
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q10➡ |
If f(n) = 5f(n / 2) + 3 and f(1) = 7 is a recurrence relation where K is a positive integer, then f(2K) =
i ➥ 5K (31/4) – 3/4
ii ➥ 5K (29/4)
iii ➥ 2K (31/4) – 3/4
iv ➥ 2K (29/4)
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q11➡ |
The instruction LD ADR(X) which is equivalent to AC ← M[ADR + XR] is in:
i ➥ Direct Addressing Mode
ii ➥ Indirect Addressing Mode
iii ➥ Index Addressing Mode
iv ➥ Immediate Addressing Mode
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q12➡ |
For the following Parents in Figures (1) and (2):

Which is correct ?
i ➥ figure (2) is the two-point crossover of figure (1)
ii ➥ figure (2) is one point crossover of figure (1)
iii ➥ figure (2) is N point crossover of figure (1)
iv ➥ figure (2) is uniform crossover of figure (1)
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q13➡ |
The sequence of steps for a page replacement algorithm will be:
A. find a frame that is not currently being used
B. change the page table
C. use freed frame
D. no frame is free
Ε. free a frame

Choose the correct answer from the options given below:
i ➥ D, A, E, B, C
ii ➥ E, B, A, C, D
iii ➥ B, E, A, D, C
iv ➥ D, E, B, A, C
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q14➡ |
Match List – I with List II. f(n) = a f(n/b)+g(n) is a divide-and-conquer recurrence relation for the Listed-I algorithms, match their recurrence in Listed-II.
List – I
Divide-and-conquer based algorithms
A. Binary Search
B. Find the maximum and minimum of a sequence
C. Merge Sort
D. Fast Matrix Multiplication


List – II
Recurrence Relation
I. f(n)=7f(n/2)+15 n²/4
II. f(n)=2f(n/2)+n
III. f(n)=2f(n/2)+2
IV. f(n)=f(n/2)+2

Choose the correct answer from the options given below:
i ➥ A-I, B-II, C-III, D-IV
ii ➥ A-II, B-III, C-IV, D-I
iii ➥ A-III, B-IV, C-I, D-II
iv ➥ A-IV, B-III, C-II, D-I
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q15➡ |
Which of the following control problem does not exist, when processes unaware of each other during interaction?
i ➥ Mutual exclusion
ii ➥ Data coherence
iii ➥Starvation
iv ➥ Deadlock
Best Explanation:
Answer: (IV:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q16➡ |
The height of a binary search tree for the words banana, peach, apple, pear, coconut, mango, and papaya using alphabetical order is
i ➥ 2
ii ➥ 3
iii ➥4
iv ➥ 5
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q17➡ |
Match List-I with List-II:
List – I
A. Batch Multiprogramming
B. Time sharing
C. Monitor
D. Reentrant Procedures

List – II
I. allows more efficient use of main memory
II. user no longer has direct access to the processor
III. Maximize processor use
IV. Minimize response time

Choose the correct answer from the options given below:
i ➥ A-III, B-II, C-IV, D-I
ii ➥ A-III, B-IV, C-II, D-I
iii ➥ A-I, B-III, C-IV, D-II
iv ➥ A-II, B-I, C-IV, D-III
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line


Q18➡ |
Which of the following is the function of the semantic analysis phase of compilation process?
i ➥ Type conversion
ii ➥ Tokenization
iii ➥ Loop optimization
iv ➥ Data flow Analysis
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q19➡ |
For the regular languages and context-free languages which is not correct?
A. both are closed under union operation
B. both are closed under concatenation operation
C. both are closed under intersection operation
D. both are closed under complementation operation
E. both are closed under kleene star operation

Choose the most appropriate answer from the options given below:
i ➥ A and B Only
ii ➥ B and C Only
iii ➥ C and D Only
iv ➥ D and E only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q20➡ |
Match List-I with List-II:
List – I
A. Back Tracking
B. Infinite languages with matching numbers
C. Canonical LR Parser
D. Post Correspondence Problem

List – II
I. Automata
II. Undecidable Problem
III. Predictive Parser
IV. Large number of states

Choose the correct answer from the options given below:
i ➥ A-I, B-II, C-III, D-IV
ii ➥ A-II, B-IV, C-I, D-III
iii ➥A-IV, B-III, C-II, D-I
iv ➥ A-III, B-I, C-IV, D-II
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q21➡ |
The output of the following C++ Program is:
#include <stdio.h>
int main (void)
{
int x, *p;
x=30;
p=x;
print f (“%d”, *p);
return 0;
}
i ➥ 30
ii ➥ Value of x
iii ➥ Address of x
iv ➥ Error
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q22➡ |
Which of the following have truth values if the universe of discourse consists of all integers?
A. n∃m(n2 < m)
B. ∃nm(n < m2)
C. n∃m(n2 + m2 = 5)
D. n∃m(n2 + m2 = 6)
E. n∃m(m + n = 4n – m = 1)
Choose the correct answer from the options given below:
i ➥ A, B, C Only
ii ➥ B, C, E Only
iii ➥ C, D, E Only
iv ➥ B, D Only
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q23➡ |
Multiple Inheritance is permitted directly in
A. C++ 
B. Java
C. Python
D. VB.NET
E. BASIC
Choose the most appropriate answer from the options given below:
i ➥ A and B Only
ii ➥ A and C Only
iii ➥ B and D Only
iv ➥ A, C and E Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q24➡ |
The ratio of errors found before s/w delivery and to the total errors (before and after) is called:
i ➥  Accuracy
ii ➥ Specificity
iii ➥ Defect Removal efficiency
iv ➥ Throughput
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q25➡ |
Match List-I with List-II:
List – 1
A. RAID level-2
B. RAID level-3
C. RAID level-4
D. RAID level-6
List – II
I. block-interleaved
II. error-correcting-code
III. reed-Solomon codes
IV. bit-interleaved

Choose the correct answer from the options given below:
i ➥ A-I, B-III, C-IV, D-II
ii ➥ A-II, B-IV, C-I, D-III
iii ➥ A-IV, B-I, C-II, D-III
iv ➥ A-II, B-III, C-IV, D-I
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q26➡ |
Which of the followings sequence {an} are the solution of recurrence relation an=8an-1-16an-2?
A. an = 1
B. an= 2n
C. an= 4n
D. an= n4n
E. an=(-4)n
Choose the most appropriate answer from the options given below:
i ➥ A, B, C Only
ii ➥ B, C, D Only
iii ➥ C, D Only
iv ➥ C, D, E Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q27➡
Match List-I with List-II:
List – I
A. Thread spawn
B. Block thread
C. Jacketing
D. Flush
List – II
I. to convert a blocking system call into a nonblocking call.
II. To reclaim pages
III. The processor turns to the execution of another ready thread.
IV. The thread is provided with its own register context.

Choose the correct answer from the options given below:
i ➥ A-I, B-III, C-IV, D-II
ii ➥ A-IV, B-III, C-II, D-I
iii ➥ A-IV, B-III, C-I, D-II
iv ➥ A-II, B-I, C-IV, D-III
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q28➡ |
Which of the following is the Markup language?
A. HTML
B. XML
C. DHTML
D. LML
Ε. PML
Choose the correct answer from the options given below:
i ➥ B, C, D Only
ii ➥ A, C, D Only
iii ➥ A, C, D, E Only
iv ➥ A, B, C Only
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q29➡ |
Which of the followings are type of interface in an ATM network?
A. user-to-user
B. user-to-network
C. network-to-network
D. host-to-network
E. user-to-host
Choose the correct answer from the options given below:
i ➥ A and B Only
ii ➥ B and C Only
iii ➥ C and D only
iv ➥ D and E Only
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q30➡ |
For the fuzzy set A = {(x1, 0.3), (x2, 0.7), (x3, 0.4)), the complement of A would be represented as:
i ➥ {(x1, 0.4), (x2, 0.3), (x3, 0.1)}
ii ➥ {(x1, 0.3), (x2, 0.7), (x3, 0.4)}
iii ➥ {(x1, 0.7), (x2, 0.3), (x3, 0.6)}
iv ➥  {(x1, 0.21), (x2, 0.28), (x3, 0.12)}
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q31➡ |
The instructions
ADD R1, A, B
ADD R2, C, D
MUL X, R1, R2
evaluates the X = (A+B)*(C+D) in which of the following?
i ➥ 3- Address instructions
ii ➥ 2- Address instructions
iii ➥ 1- Address instructions
iv ➥ RISC instructions
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q32➡ |
An ambiguous grammar is one which has:
A. More than one derivation
B. More than one left most derivations
C. More than one right-most derivations
D. More than one Parse tree
E. More than one syntax tree
Choose the correct answer from the options given below:
i ➥ A and D Only
ii ➥ B and C Only
iii ➥ D and E Only
iv ➥ A and E Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q33➡ |
Back propagation is a learning technique that adjusts weights in the neural network by propagation  weight changes:
i ➥ Forward from source to hidden nodes
ii ➥ Backward from sink to source
iii ➥ Forward from source to sink
iv ➥ Backward from sink to hidden nodes
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q34➡ |
The Boolean expression for the following would be:
F(A, B, C) = (0, 2, 6)
d(A, B, C) = (1, 3, 5)
i ➥ A’C’ + BC’
ii ➥ B + AC’
iii ➥ B + AC’
iv ➥ A’ + BC’
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q35➡ |
Arrange the following in the correct order, so that they can follow a proper run time environment:
A. Programming statement
B. Compilation Compile
C. Memory allocation
D. Type of variable
E. Memory deallocation
Choose the correct answer from the options given below:
i ➥ A, B, C, D, E
ii ➥ A, B, D, C, E
iii ➥ B, A, D, C, E
iv ➥ C, D, B, E, A
Best Explanation:
Answer: (III)
Explanation: Upload Soon

Q36➡ |
A computer system with cache access time of 100 ns, a main memory access time of 1100 ns, and a hit ratio of 0.9, then average access time would be:
i ➥ 200 ns
ii ➥ 190 ns
iii ➥ 210 ns
iv ➥ 120 ns
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q37➡ |
An IPv4 packet has arrived with the first few hexadecimal digits as shown below. How many hops can this packet travel before being dropped? The data belong to what upper-layer protocol?
(540000 1800100110040601…….16
i ➥ 01 hops, TCP
ii ➥ 02 hops, UDP
iii ➥ 03 hops, ICMP
iv ➥ 04 hops, TCP
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q38➡ |
Arrange the following simple graphs based on number of spanning tree they have :
A. K3 [Complete Graph with 3 nodes]
B. K₁₄ [Complete Graph with 4 nodes] CO
C. K2, 2 (Complete bipartite graph of the 2 nodes in each partition)
D. C5 (Cycle graph of 5 nodes)
Choose the correct answer from the options given below:
i ➥ A, B, C, D
ii ➥ A, C, B, D
iii ➥ A, C, D, B
iv ➥ D, B, C, A
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q39➡ |
Match List-I with List-II:
List – I
A. Channelization protocol
B. Bit-oriented protocol
C. Random-access protocol
D. Controlled-access protocol
List – II
I. ALOHA
II. TDMA
III. Reservation
IV. HDLC
Choose the correct answer from the options given below:
i ➥ A-I, B-III, C-IV, D-II
ii ➥ A-II, B-IV, C-I, D-III
iii ➥ A-IV, B-III, C-II, D-I
iv ➥ A-III, B-IV, C-I, D-II
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q40➡ |
What is the total delay (latency) for a frame size of 10 million bits that is being set up on a link with 20 routers, each having a queuing time of 2 us and a processing time of 1 us? The length of the link is 5000 km. The speed of light inside the link is 2×108 m/s. The link has a bandwidth of 6 Mbps.
i ➥ 0.624050 s.
ii ➥ 1.691726 s.
iii ➥ 2.425080 s.
iv ➥ 1.714030 s.
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q41➡ |
How much time does an algorithm using 250 bit operations need if each bit operation takes 2-38 second of time?
i ➥ 1 hour
ii ➥ 10 minutes
iii ➥ 30 minutes
iv ➥ 1.5 hours
Best Explanation:
Answier: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q42➡ |  
Match List – I with List – II.

Choose the correct answer from the options given below:
i ➥ A-III, B-IV, C-II, D-I
ii ➥ A-III, B-IV, C-I, D-II
iii ➥ A-II, B-I, C-III, D-IV
iv ➥ A-II, B-I, C-IV, D-III
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q43➡ |
A bit string of length four is generated at random. What is probability that it contains at least two consecutive O’s given that first bit is 0?
i ➥ 1/2
ii ➥ 5/16
iii ➥ 5/8
iv ➥ 1/4
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q44➡ |
Services provided by point-to-point protocol (PPP):
A. frame format
B. establishment of the link
C. flow control
D. sequence numbering
E. authentication
Choose the correct answer from the options given below:
i ➥ A, B and E Only
ii ➥ A, C and D Only
iii ➥ D, E and B Only
iv ➥ B, C and D Only
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q45➡ |
Which of the following is/are true in case of tree locking?
A. It ensures shorter waiting times.
B. It ensures freedom from deadlock.
C. Transaction can lock data items earlier.
D. It does not ensure greater amount of concurrency.
Choose the correct answer from the options given below:
i ➥ A and B Only
ii ➥ C and D Only
iii ➥ B and C Only
iv ➥ A and D Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q46➡ |
Arrange the following sets in increasing order, on the basis of their cardinality:
A. A1 = {{1, 2} , {3}}
B. A2 = {{1}, {2}, {3}, {4}}
C. A3 = {{1, 2, 3, 4, 5, 6}}
D. A4 = {{1, 2}, {2, 3, 4} , {5}}
Ε. A5 = {{1} , {2}, {3}, {4}, {5}}
Choose the correct answer from the options given below:
i ➥ A, B, D, E, C
ii ➥ A, B, E, D, C
iii ➥ A, C, D, B, E
iv ➥ C, A, D, B, E
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q47➡ |
The Cardinality of a fuzzy set is:
i ➥ 0
ii ➥ finite
iii ➥ infinite
iv ➥ not known
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q48➡ |
Which of the following is not the goal of reverse Engineering?
i ➥ Cope with complexity
ii ➥ Recover lost information
iii ➥ Detect side effect
iv ➥ Data flow
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q49➡ |
The chairs of an auditorium are to be labelled with a letter followed by a positive two digits integer where labelling is starting with A01. How many maximum possible chair could be labelled in this way?
i ➥ 2600
ii ➥ 2574
iii ➥ 2340
iv ➥ 2366
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q50➡ |
Arrange in appropriate order, the construction of a finite automata :
A. Minimum State DFA
B. Regular Expression
C. NFA-ε
D. Problem Statement
E. DFA
Choose the correct answer from the options given below:
i ➥ B, C, E, A, D
ii ➥ D, B, C, E, A
iii ➥ C, E, B, A, D
iv ➥ A, D, C, B, E
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q51➡ |
A lower-triangular sparse matrix is one:
i ➥ in which all the non-zero elements lie only on the leading diagonal.
ii ➥ in which all the non-zero elements lie above the leading diagonal.
iii ➥ in which all the non-zero elements lie below the leading diagonal.
iv ➥ which is not defined for a sparse matrix.
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q52➡ |
The following code:
Stmt -> if expr then stmt else stmt | if expr then stmt
suffers from:
i ➥ Ambiguity
ii ➥ Left factoring
iii ➥ Left Recursion
iv ➥ λ-moves
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q53➡ |
Which of the following is not correct about virtual memory segmentation?
i ➥ It is not necessary to load all of the segments of a process.
ii ➥ It has no internal fragmentation.
iii ➥ It has large virtual address space.
iv ➥ It provides lower degree of multiprogramming.
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q54➡ |
Match List-I with List-II:
List – I

A. Union
B. Function
C. Interactive Environment
D. Output device
List – II
I. Virtual Reality
II. Shadow mask
III. Subroutine
IV. User defined data type
Choose the correct answer from the options given below:
i ➥ A-IV, B-III, C-I, D-II
ii ➥ A-IV, B-II, C-III, D-I
iii ➥ A-II, B-IV, C-I, D-III
iv ➥ A-I, B-III, C-IV, D-II
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q55➡ |
Z is set of integers, <Z, *> forms group if * is:
i ➥ * (a, b) = a + b + 2
ii ➥ * (a, b) = 2a + b
iii ➥ * (a, b) = (a + b) / 2
iv ➥ * (a, b) = a2 + b
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q56➡ |
Which of the following statements is/are false?
A. A user can assign privileges to any user on any relation.
B. A user can assign privileges to any user on its own relations only.
C. System error that leads attack to accessibility to the portion of database is an example of malicious
D. Passwords itself need to be secured from unauthorized access.
Choose the correct answer from the options given below:
i ➥ A and C Only
ii ➥ A and B Only
iii ➥ B and D Only
iv ➥ B and C Only
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q57➡ |
Which of the following is not a characteristics of a specialized embedded OS?
i ➥ real time scheduling policy
ii ➥ responds to external interrupts
iii ➥ provides special non-sequential files
iv ➥ provides fixed or variable sized partitions
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q58➡ |
What will be the order of the following fields in a frame relay ‘frame format’?
A. Flag
B. FCS
C. address
D. information
Choose the correct answer from the options given below:
i ➥ A, C, D, В
ii ➥ D, A, C, D (*as given in exam)
iii ➥ C, B, A, D
iv ➥ A, B, D, C
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q59➡ |
The techniques used to handle the phantom problem are
A. Time stamping
B. Index locking
C. Predicate locking
D. Execution indexing
Choose the correct answer from the options given below:
i ➥ A and B Only
ii ➥ B and C Only
iii ➥ A and D Only
iv ➥ C and D Only
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q60➡ |
The sequence of fields is an IP datagram will be :
A. flags
B. options
C. Protocol
D. Identification
E. Service type
Choose the correct answer from the options given below:
i ➥ E, D, A, C, В
ii ➥ D, A, B, C, E
iii ➥ D, E, C, B, A
iv ➥ E, C, D, A, В
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q61➡ |
The cyclomatic complexity of the following flow graph is:
i ➥ 3
ii ➥ 4
iii ➥ 10
iv ➥ 2
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q62➡ |
IP is responsible for __________communication while TCP is responsible for __________ communication.
i ➥ Node-to-node, Host-to-host
ii ➥ Process-to-process, Host-to-host
iii ➥ Socket-to-socket, Host-to-node
iv ➥ Host-to-Host, Process-to-process
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q63➡ |
Arrange the steps of Mathematical Modeling :
A. Solution fitting with data
B. Formulation Mathematically
C. Solve Mathematically
D. Repeat formulation if it fit worst with data
Ε. Interpretation results
Choose the correct answer from the options given below:
i ➥ B, C, A, D, E
ii ➥ B, A, D, C, E
iii ➥ D, A, B, C, E
iv ➥ E, D, C, A, B
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q64➡ |
In windows scheduling, which of the following option is correct?
i ➥ 4 non-real-time priorities
ii ➥ 8 non-real-time priorities
iii ➥ 12 non-real-time priorities
iv ➥ 16 non-real-time priorities
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q65➡ |
The I/O methods in which memory addresses and I/O addresses are distinct, is called :
A. Isolated I/O
B. Memory-Mapped I/O
C. Strobe Control
D. Handshaking
E. Interrupt
Choose the most appropriate answer from the options given below:
i ➥ A, B Only
ii ➥ C, D Only
iii ➥ C, E Only
iv ➥ B, E Only
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q66➡ |
What will be the ordering of typical steps when processing a high-level query?
A. Query optimizer
B. Runtime database processor
C. Scanning, passing and validating
D. Query code generator
Choose the correct answer from the options given below:
i ➥ D, A, C, B
ii ➥ C, A, D, B
iii ➥ C, D, B, A
iv ➥ D, C, B, A
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q67➡ |
Which of the following is tautology?
A. ( p v r) -> p
B. p -> (p ^ r)
C. ~ p -> (p -> r)
D. (p ^ r) -> (p -> r)
E. ~ (p -> r) -> p
Choose the correct answer from the options given below:
i ➥ A, B Only
ii ➥ A, B, C Only
iii ➥ B, C, D Only
iv ➥ C, D, E Only
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q68➡ |
Arrange the following from fastest to slowest in speed.
A. DRAM
B. SRAM
C. CPU Registers
D. Magnetic tapes
E. Hard disk
Choose the correct answer from the options given below:
i ➥ A, B, C, D, E
ii ➥ C, B, A, D, E
iii ➥ C, D, B, A, E
iv ➥ B, C, D, A, E
Best Explanation:
Answer: Marks to all
Explanation: Memory types from fastest to slowest in terms of speed:
C. (CPU Registers)
B. (SRAM)
A. (DRAM)
E. (Hard disk)
D. (Magnetic tapes)
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q69➡ |
The language of the following PDA would be :
δ(q0, a, z0) = (q0, aaaz0)
δ(q0, a, a) = (q0, aaaa)
δ(q0, b, a) = (q1, λ)
δ(q1, b, a) = (q1, λ)
δ(q1, ε, z0) = (qf, z0), where qf is a final state.
i ➥ {anbn|n>0}
ii ➥ {anb2n|n>0}
iii ➥ {amb3n|n>0}
iv ➥ {anb4n|n>0}
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q70➡ |
Regarding the subroutines, see the following sequence of tasks to be performed:
A. Turn on the interrupt facility on.
B. Service the device whose flag is set.
C. Save the contents of processor registers.
D. Check which flag is set.
Ε. Restore the contents of processor registers.
Choose the correct answer from the options given below:
i ➥ A, D, C, B, E
ii ➥ D, A, B, C, E
iii ➥ C, D, B, E, A
iv ➥ B, D, A, C, E
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q71➡ |
Match List-I with List-II:
List – I
A. Verification
B. Validation
C. Internal logic exercise
D. Software requirement exercise
List – II
I. White box Testing
II. Black box Testing
III. Quality Control
IV. Quality Assurance
Choose the correct answer from the options given below:
i ➥ A-IV, B-III, C-I, D-II
ii ➥ A-I, B-II, C-III, D-IV
iii ➥ A-IV, B-III, C-II, D-I
iv ➥ A-III, B-IV, C-I, D-II
Best Explanation:
Answer: (I):
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q72➡ |
The parameter Actual count is used in Genetic Algorithm (GA) for:
i ➥ Crossover
ii ➥ Mutation
iii ➥ Selecting population
iv ➥ Encoding the Genetic Algorithm
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q73➡ |
For the given two machines which of the following is correct?
i ➥ both Machines are DFAs
ii ➥ both are non-equivalent Machines
iii ➥ both are equivalent Machines
iv ➥ cannot be determined
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q74➡ |
The number of tokens in the following line:
for i in range (begin: end: step):
is:
i ➥ 4
ii ➥ 7
iii ➥ 8
iv ➥ 12
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q75➡ |
Which of the following structures of knowledge representation are the most purely syntactic?
A. Conceptual dependency
B. predicate logic
C. slot-and-filler
D. non-monotonic systems
Choose the correct answer from the options given below:
i ➥ A and B Only
ii ➥ B and C Only
iii ➥ B and D Only
iv ➥ C and D Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q76➡ |
In the Genetic Algorithm’s cross-over operation, the mask is used in?
i ➥ Three parent crossover
ii ➥ Two-parent crossover
iii ➥ Uniform crossover
iv ➥ N point crossover
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q77➡ |
Match List – I with List – II.
List – I
A. Complement
B. Ex-OR
C. Accumulator
D. Control Unit
List – II
I. Adder
II. Instruction decoding
III. Negative number representation
IV. Arithmetic and Logic operations
Choose the correct answer from the options given below:
i ➥ A-I, B-II, C-III, D-IV
ii ➥ A-III, B-II, C-I, D-IV
iii ➥ A-III, B-I, C-IV, D-II
iv ➥ A-IV, B-II, C-III, D-I
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q78➡ |
Arrange the following prefix expressions based on their values in increasing order :
A. +-*2/8432
B. ↑-*33*425
C. +-132123/6-42
D. *+3+3↑3+113 on
Choose the correct answer from the options given below:
i ➥ A, B, C, D
ii ➥ B, A, C, D
iii ➥ D, C, B, A
iv ➥ C, D, A, В
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q79➡ |
Which of the following is not the most common property in social network?
i ➥ Degree distribution follows scale-free
ii ➥ Average shortest path lengths are shorten in connected networks
iii ➥ Most of them are directed networks
iv ➥ Follows small-world property
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q80➡ |
For line drawing, which of the following algorithms are used?
A. DDA algorithm
B. Bresenham algorithm
C. Mid-point algorithm
D. Curve algorithm
Choose the most appropriate answer from the options given below:
i ➥ B and C Only
ii ➥ C and D Only
iii ➥ A and B Only
iv ➥ D and A Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q81➡ |
According to the Nyquist theorem, to produce the original analog signal, one necessary condition is:
i ➥ The sampling rate must be at least 2 times the highest frequency contained in the signal
ii ➥ The sampling rate must be at least 2 times the lowest frequency contained in the signal
iii ➥ The sampling rate must be at least 1/2 times the highest frequency contained in the signal
iv ➥ The sampling rate must be at least 1/2 times the lowest frequency contained in the signal
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q82➡ |
For the fuzzy sets A= {(x1 ,0.3), (x2 0.7), (x3, 0.4)) and B={(x1, 0.5), (x2, 0.2), (x3, 0.5)}, the A∩B would be :
i ➥ {(x1,0.3), (x2, 0.7), (x3, 0.4)}
ii ➥ {(x1, 0.5), (x2, 0.2), (x3, 0.5)}
iii ➥ {(x1, 0.5), (x2, 0.7), (x3, 0.5)}
iv ➥ {(x1, 0.3), (x2, 0.2), (x3, 0.4)}
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q83➡ |
The least values of a signed and unsigned data type variables requiring 8 bits, would be……..
i ➥ 0, 128
ii ➥ -128, 127
iii ➥ 0, 0
iv ➥ -128, 0
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q84➡ |
Which of the following are true for a complete binary tree?
A. It has always odd number of vertices.
B. With i internal vertices, it has i + 1 leaves.
C. With L leaves it has L-1 vertices.
D. With 2n-1 vertices, it has n leaves.
Choose the correct answer from the options given below:
i ➥ A, B, C Only
ii ➥ B, C Only
iii ➥ A, D Only
iv ➥ A, B, C, D
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q85➡ |
For making a memory of size 2048 × 8 bytes, by using the chips of size 128 × 4 bytes, the number of chips required is:
i ➥ 8
ii ➥ 16
iii ➥ 32
iv ➥ 64
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q86➡ |
Which of the following are sequential circuit?
A. Flip flop
B. Multiplexer
C. Counter
D. Decoder
E. Adder
Choose the correct answer from the options given below:
i ➥ B, D Only
ii ➥ A, C Only
iii ➥ C, E Only
iv ➥ D, A Only
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q87➡ |
Which of the followings are White box Testing?
A. Path Testing
B. Loop Testing
C. Regression Testing
D. Non-functional Testing
Choose the correct answer from the options given below:
i ➥ A and B Only
ii ➥ B and C Only
iii ➥ C and D Only
iv ➥ A and D Only
Best Explanation:
Answer: (I)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q88➡ |
Techniques for performing I/O:
A. Programmed I/O
B. Interrupt-driven I/O
C. Rotational I/O
D. Direct memory access
Ε. Channelized I/O
Choose the correct answer from the options given below:
i ➥ A and C Only
ii ➥ A, D and E Only
iii ➥ A, B and D Only
iv ➥ B and E Only
Best Explanation:
Answer: (III)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q89➡ |
For the software quality assurance, which of the followings are correct?
A. Execution of code
B. No execution of code
C. Preventive technique
D. A corrective technique
Choose the correct answer from the options given below:
i ➥ A, B Only
ii ➥ B, C Only
iii ➥ C, D Only
iv ➥ D, A Only
Best Explanation:
Answer: (II)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q90➡ |
Which of the following genetic algorithm operations is computationally most expensive?
i ➥ Convergence testing
ii ➥ Initial population creation
iii ➥ Selection of sub-population for mating
iv ➥ Reproduction to produce next generation
Best Explanation:
Answer: (IV)
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q91➡ |
Answer the following 5 questions based on the passage. (91-95)
A firm can produce two types of cloth say A and B. Three kind of wool are required for it, say red wool, green wool and blue wool. One unit length of type A cloth needs 2 yards of red and 3 yards of green wool. One unit length of type B cloth needs 3 yards of red wool, 2 yards of green wool, and 2 yards of blue wool. The firm has only a stock of 8 yards of red wool, 10 yards of green wool and 15 yards of blue wool. It is assumed that the income obtained from one unit length of type A and type B cloths are 30 and₹50, respectively.
 
When we formulate the LPP from the above-given passage. Which of the following is a objective function for its dual problem?
i ➥ Min P = 5u + 8v + 15w
ii ➥ Min P = 8u + 10v + 15w
iii ➥ Min P = 15u + 5v + 8w
iv ➥ Max P = 10u + 8v + 15w
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q92➡ |
Answer the following 5 questions based on the passage. (91-95)
A firm can produce two types of cloth say A and B. Three kind of wool are required for it, say red wool, green wool and blue wool. One unit length of type A cloth needs 2 yards of red and 3 yards of green wool. One unit length of type B cloth needs 3 yards of red wool, 2 yards of green wool, and 2 yards of blue wool. The firm has only a stock of 8 yards of red wool, 10 yards of green wool and 15 yards of blue wool. It is assumed that the income obtained from one unit length of type A and type B cloths are 30 and₹50, respectively.

Which of the following will be appropriate objectives function for the given problem?
i ➥ 2x+3y
ii ➥ 3x+2y+2z
iii ➥ 30x+50y
iv ➥ 3x+2y
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q93➡ |
Answer the following 5 questions based on the passage. (91-95)
A firm can produce two types of cloth say A and B. Three kind of wool are required for it, say red wool, green wool and blue wool. One unit length of type A cloth needs 2 yards of red and 3 yards of green wool. One unit length of type B cloth needs 3 yards of red wool, 2 yards of green wool, and 2 yards of blue wool. The firm has only a stock of 8 yards of red wool, 10 yards of green wool and 15 yards of blue wool. It is assumed that the income obtained from one unit length of type A and type B cloths are 30 and₹50, respectively.

How many Unit length used for cloth A when income is maximized?
i ➥ 0.8 unit
ii ➥ 2.4 unit
iii ➥ 2.8 unit
iv ➥ 3.0 unit
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q94➡ |
Answer the following 5 questions based on the passage. (91-95)
A firm can produce two types of cloth say A and B. Three kind of wool are required for it, say red wool, green wool and blue wool. One unit length of type A cloth needs 2 yards of red and 3 yards of green wool. One unit length of type B cloth needs 3 yards of red wool, 2 yards of green wool, and 2 yards of blue wool. The firm has only a stock of 8 yards of red wool, 10 yards of green wool and 15 yards of blue wool. It is assumed that the income obtained from one unit length of type A and type B cloths are 30 and₹50, respectively.

If x unit length of type A cloths and y unit length of type B cloths, then contains formulate for the LPP, is:
i ➥ y <= 7.5, 2x + 3y <= 8, 3y + 2x <= 10
ii ➥ y <= 7.5, 2x + 3y <= 8, 3x + 2y <= 10
iii ➥ 2x + 3y <= 8, 3x + 2y + 2z < 15
iv ➥ 2x + 3y <= 10, 3x + 2y <= 10, 2y <= 15
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q95➡ |
Answer the following 5 questions based on the passage. (91-95)
A firm can produce two types of cloth say A and B. Three kind of wool are required for it, say red wool, green wool and blue wool. One unit length of type A cloth needs 2 yards of red and 3 yards of green wool. One unit length of type B cloth needs 3 yards of red wool, 2 yards of green wool, and 2 yards of blue wool. The firm has only a stock of 8 yards of red wool, 10 yards of green wool and 15 yards of blue wool. It is assumed that the income obtained from one unit length of type A and type B cloths are 30 and₹50, respectively.

On the basis of available material, maximum total income is:
i ➥ ₹133.3
ii ➥ ₹124
iii ➥ ₹100
iv ➥ ₹153.3
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q96➡ |
Answer the following 5 questions based on the passage. (96-100)
A company is implementing a new database system to manage its customer information. The database contains tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representatives who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.

Which SQL query retrieves the total number of orders placed by a specific customer?
i ➥ Select COUNT (*) As total_orders from orders where customer_id = [Customer_ID];
ii ➥ Select COUNT (order_id) As total_orders from orders where customer_id = [Customer_ID];
iii ➥ Select COUNT (DISTINCT order_id) As total_orders from orders Where customer_id = [Customer_ID];
iv ➥ Select SUM (order_Id) As total_orders from orders where customer_id = [Customer_ID];
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q97➡ |
Answer the following 5 questions based on the passage. (96-100)
A company is implementing a new database system to manage its customer information. The database contains tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representatives who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.

Based on the passage, which of the following statements is true?
i ➥ Each customer can place only one order
ii ➥ Each sales representative can manage multiple customer accounts
iii ➥ Each order can be associated with only one product
iv ➥ The database does not include a table for products
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q98➡ |
Answer the following 5 questions based on the passage. (96-100)
A company is implementing a new database system to manage its customer information. The database contains tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representatives who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.
Which of the following tables is likely to have a foreign key referencing another table in the database system implemented by the company?
i ➥ Customers
ii ➥ Orders
iii ➥ Products
iv ➥ Sales representatives
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q99➡ |
Answer the following 5 questions based on the passage. (96-100)
A company is implementing a new database system to manage its customer information. The database contains tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representatives who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.

Which SQL query retrieves the total number of distinct customers who have placed orders?
i ➥ Select COUNT (DISTINCT customer_id) As total_customers From orders;
ii ➥ Select COUNT (*) As total_customers from customers;
iii ➥ Select COUNT (DISTINCT order_id) As total_customers from orders;
iv ➥ Select COUNT (DISTINCT customer_id) As total_customers from customers;
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Q100➡ |
Answer the following 5 questions based on the passage. (96-100)
A company is implementing a new database system to manage its customer information. The database contains tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representatives who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.

Which of the following best describes the relationship between the “orders” table and the “Customers” table in the company’s database system?
i ➥ One-to-One
ii ➥ One-to-Many
iii ➥ Many-to-One
iv ➥ Many-to-Many
Best Explanation:
Answer:
Explanation: Upload Soon
More DiscussionExplanation On YouTubeLearn Topic WiseHelp-Line

Why Previous Year Question Answers are Important

Detailed Solutions for UGC NET June 2024 Exam

Tips for Excelling in the UGC NET Computer Science and Application Exam

Frequently Asked Questions

error: Content is protected !!
Open chat
1
Hi,how Can We Help You ?