LawMint Sign in

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

Select one answer

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

Select one answer

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

Select one answer

Question 4

__________ requires every determinant of a non-trivial functional dependency to be a superkey.

Select one answer

Question 5

In __________, whenever a new update is made, multiple versions of the data items are produced.

Select one answer

Question 6

Match the following:

List-IList-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

Select one answer

Question 7

Match the following:

List-IList-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

Select one answer

Question 8

Match the following relation R and S:

List-IList-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

Select one answer

Question 9

Given the following entries of a table:

State_tb

State_idRegionPopulation
UPN28
MPN08
KARS06
TNS07

The SQL statement

SELECT Sum (Population)
FROM State_tb
GROUP By Region;
Select one answer

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.

Select one answer

Continue practising

The practice pack for Karnataka SET (KSET) is coming soon to LawMint.

Karnataka SET (KSET) practice pack

The practice pack for Karnataka SET (KSET) is coming soon to LawMint.