Karnataka SET (KSET) Database Management Systems Previous Year Questions
Try the preview and open any solution for a worked explanation.
Karnataka SET (KSET) practice pack
The practice pack for Karnataka SET (KSET) is coming soon to LawMint.
Question 1
Identify the correctness of the following statements?
i. Logical data independence is the ability to modify the logical schema without transforming the application programs
ii. Logical data independence modifies the logical schema as well as the application programs
iii. Logical data independence is more complicated to achieve than the physical data independence
Question 2
Identify the correctness of the following statements:
i. The project operation is a unary operation which extracts attributes from a relation
ii. The project operation allows us to locate tuples that are in one relation but not in another relation
iii. The project operation connects the data across the relations
Question 3
Consider the following statements:
i. Stored procedures can be used to process multiple databases
ii. Extended stored procedures are compiled as dynamic link library files
iii. Local stored procedures are stored on user-built databases
Question 4
__________ requires every determinant of a non-trivial functional dependency to be a superkey.
Question 5
In __________, whenever a new update is made, multiple versions of the data items are produced.
Question 6
Match the following:
| List-I | List-II |
| a. BCNF iff | (i) every JD is implied by the candidate keys |
| b. 5 NF iff | (ii) every MVD is implied by the candidate keys |
| c. 1 NF iff | (iii) all underlying domains contain scalar values only |
| d. 4 NF iff | (iv) every FD is implied by the candidate keys |
Question 7
Match the following:
| List-I | List-II |
| a. Data warehouse | (i) which allows users to analyse data from multiple database systems at once |
| b. Data mining | (ii) is the summarization of fact related data |
| c. OLAP | (iii) central repository of information that can be analyzed to make more informed decisions |
| d. Aggregation | (iv) is a process used to discover patterns and relationships in datasets |
Question 8
Match the following relation R and S:
| List-I | List-II |
| a. Theta Join | (i) If no matching tuples found in S, then the attributes of S are filled with NULL |
| b. Equi Join | (ii) If no matching tuples found in R, then the attributes of R are filled with NULL |
| c. Left outer Join | (iii) Combinations of tuples of R and S that satisfies join condition |
| d. Right outer Join | (iv) Combinations of tuples of R and S that satisfies equality comparisons |
Question 9
Given the following entries of a table:
State_tb
| State_id | Region | Population |
|---|---|---|
| UP | N | 28 |
| MP | N | 08 |
| KAR | S | 06 |
| TN | S | 07 |
The SQL statement
SELECT Sum (Population)
FROM State_tb
GROUP By Region;Question 10
Which of the following can act as possible termination conditions in K-means?
(a) For a fixed number of iterations
(b) Every cluster contains the same number of observations
(c) Centroids do not change between successive iterations
(d) Terminate when reduction in the sum of square distances between points and their assigned cluster centroids falls below threshold.
Previous papers with Database Management Systems questions
Karnataka SET (KSET) practice pack
The practice pack for Karnataka SET (KSET) is coming soon to LawMint.