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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-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 Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |