GATE Question (GATE CSE 1992 | Question: 13b) Suppose we have a database consisting of the following three relations: FREQUENTS(Customer, Hotel): Indicates the hotels each customer visits. SERVES(Hotel, Snack): Tells which snacks each hotel serves. LIKES(Customer, Snack): Indicates which …
This post explores the concepts of Third Normal Form (3NF) in relational databases and the types of functional dependencies that may still exist in a 3NF database. We provide a detailed discussion to help you master these crucial concepts for …
GATE CSE 1990: Analyzing Finite Automata and Regular Languages Original Question GATE CSE 1990 Question 3(ii): Consider the following finite automaton: a ↗ ↘ →(q0) (q1) ↖ ↙ ↘ b a (q2) ↺ a What is the language accepted …
Original Question GATE CSE 1990 Question 2(iv): Consider the following relational algebra expression: πA(R ⋈ (S ⋈ T)) where R, S, and T are relations, and A is a set of attributes. Suggest how this expression can be optimized. Detailed …
A comprehensive guide to understanding key database concepts for GATE aspirants Original GATE Question Year: 1990 Question Number: 2-iv Instructions: Match the following database concepts with their corresponding terms: Secondary index – (q) B-tree Non-procedural query language – …
GATE CSE 1987 Question 2n: Mastering Functional Dependencies in Databases Are you preparing for GATE CSE and struggling with database concepts? Let’s dive deep into a classic question from GATE CSE 1987 that tests your understanding of functional dependencies. This …
A CPU has a 32KB direct-mapped cache with 128 byte-block size. Suppose A is a two-dimensional array of size 512×512 with elements that occupy 8-bytes each. Consider the following two C code segments, P1 and P2. P1: for (i=0; i<512; i++) { for (j=0; j<512; j++) { x …
In this video, question which was asked in the exam of GATE 2016 Computer Science. Question :- In a process, the number of cycles to failure decreases exponentially with an increase in load. At a load of the 80 units, …
In this video, question which was asked in the exam of GATE 2016 Computer Science. Question :- If f(x) = 2x^7+3x-5, which of the following is a factor of f(x) ? A. (x^3+8) B. (x-1) C. (2x-5) D. (x+1) Solution …
In this video, question which was asked in the exam of GATE 2016 Computer Science. Question :- Consider the following statements relating to the level of poker play of four players P, Q, R and S. 1. P always beats …
In this video, question which was asked in the exam of GATE 2016 Computer Science. Question :- Indian currency notes show the denomination indicated in at least seventeen languages. If this is not an indication of the nation’s diversity, nothing …
In this video, question which was asked in the exam of GATE 2016 Computer Science. Question :- A shaving set company sells 4 different types of razors, Elegance, Smooth, Soft and Executive. Elegance sells at Rs. 48, Smooth at Rs. …
