In context of Relational Algebra of Database Management System, SELECT operation is used to select a subset of the tuples from a relation that satisfy a __________.
Show answerHide answer
Correct answer: (B) Selection Criteria
BEL PE · Computer Science
DBMS & SQL Previous Year Questions
11 DBMS & SQL (Computer Science) questions asked in BEL PE previous year papers, each with the correct answer and explanation. Read them free on UTpaper, or attempt the full papers as timed online tests.
- 11 questions
- Official answer key
- Free
Other Computer Science topics
In context of Database, which of the following is the CORRECT order for creating a database?
A → Defining its structure (scheme)
B → Entering data into the database
C → Designing forms (custom screens) for displaying and entering data
Show answerHide answer
Correct answer: (B) A → C → B
Consider a hash table with 10 slots. What is the sequence of the following elements in a hash table if hash function is k mod 10 and the collision is resolved using linear probing?
44, 26, 12, 93, 80, 57, 56, 23, 46, 36
Show answerHide answer
Correct answer: (D) 80, 36, 12, 93, 44, 23, 26, 57, 56, 46
A ______ defines an action the database should take when some database-related event occurs that causes a change in the content of a table in a database.
Show answerHide answer
Correct answer: (C) Trigger
Which of the following statement is CORRECT regarding Referential Integrity Constraints in Relational Database Management System?
I. Referential Integrity Constraint is a rule that maintains consistency among the rows of two tables (relations).
II. Referential Integrity rule states that if there is a foreign key in one relation, either each foreign key value must match a primary key value in the other table or else the foreign key value must be null.
Show answerHide answer
Correct answer: (D) Both I and II
In the context of Relational Algebra of Database Management System, which of the following is the symbol of the JOIN operation?
Show answerHide answer
Correct answer: (A) ⋈ (bow-tie)
In context of data normalization in database management system, relation is in Boyce-Codd Normal Form if and only if every determinant is a ______.
Show answerHide answer
Correct answer: (D) Candidate key
Database designers use _________ to define the structure of a database (database scheme) which typically includes definition of all data elements of the database and organization of data elements into records, tables etc.
Show answerHide answer
Correct answer: (B) Data Definition Language
In context of computer Database, _________ language includes command to enable users to enter and manipulate data in a database.
Show answerHide answer
Correct answer: (D) Data Manipulation
Match the phases of compiler with its function.
Phases: I. Intermediate code generator; II. Code generation; III. Table management
Function: 1. Keeps track of the names used by the program; 2. Create a stream of simple instructions; 3. Produces the object code
Show answerHide answer
Correct answer: (A) I – 2; II – 3; III – 1
In context to Database management system which of the following is CORRECT regarding query by example?
I. A Query by example form collects all information from a user for composing query language statements for search criterion.
II. Query by example relieves users from remembering query language keywords and using them with correct syntax to form queries.
Show answerHide answer
Correct answer: (A) Both I and II
How to use these BEL PE Computer Science questions
Every question here was asked in a real BEL PE paper; the paper and shift are shown on the card, and the number opens the question on its own page. Try each one before tapping Show answer, then attempt the full BEL PE papers as timed tests to check your speed under exam conditions.