List of top Computer Science Questions on Database Concepts

An alternate key is ________.

The primary key is chosen from ________.

A relation in a relational database is also known as:

A domain in a relational database refers to:

What is the primary difference between a database and a file system?

Which of the statement(s) is/are True for the given question.
Data elements are: 7, 5, 17, 13, 9, 27, 31, 25, 35.
Hash Table Size: 7
Hash Function: H(I) = (Data element) mod (Hash Table Size)
Options:
(A) Element 27 will create collision.
(B) Element 25 will create collision.
(C) Element 35 will create collision.
(D) Element 31 will create collision.
Choose the correct answer from the options given below:

Which of the following is called a database instance?

Match List-I with List-II:

List-I	List-II
(A) Controlled Data Sharing	(I) Same data maintained in different places does not match
(B) Data Isolation	(II) Limited Access given to users
(C) Data Dependence	(III) There is no mapping between two files
(D) Data Inconsistency	(IV) If the structure of a file is changed, all the existing programs accessing that file also need to be changed

How many candidate keys are possible with the table?

RollNo	Name	Mobile	City
1	Arun	91	Delhi
2	Sanjay	92	Mumbai
3	Arun	93	Noida
4	Varun	94	Guwahati
5	Arti	95	Kolkata

Which of the following statement is not true ?

Consider the following table -

SID	SName	Contact No	Age	Course	Year
2301	Rajat	8167782923	0	CS	2022
2302	Kamal	8168842399	21	HIS	2023
2303	Amit	8167832455	20	ECO	2022
2304	Sujata	7987235422	20	MATH	2022
2305	Amita	6276542311	21	ENG	2023

Identify the correct pair of values :

A row in a table is called _____

Match LIST I with LIST II

LIST I Mineral		LIST II  States
A	UNIQUE	I	The column which refers to value of an attributes defined primary key in another table
B	Primary key	II	A value specified for the column if no value is specified
C	Default	III	The column which can uniquely identify each row/record in a table
D	Foreign key	IV	Ensures that all the values in a column are distinct

Choose the Correct answer from the options given below

In relational database management system RDBMS, a tuple is defined as :

A key is used to represent the relationship between two relations.

Consider the tables A and B given below. How many tuples will be in the output after apply A B operation.
A

SNO	Name	Class
1	Meena	8
2	Meena	6
3	Leena	7
4	Vijaya	7
5	Sujata	8

B

SNO	Name	Class
1	Asha	7
2	Meena	6
3	Mohit	7
4	Vijaya	7

Which is not correct about string function?

Consider the algorithm:
NameSearch (numList, key,n)
Step1: SET index = 0
Step2: WHILE index < n, REPEAT step3
Step3: IF numlist [index]-key THEN
                        PRINT "Element found at position", index + 1
                           STOP
             ELSE
                             index = index+1
Step4: PRINT "Search unsuccessfull"
The algorithm performs

Match LIST I with LIST II

LIST I		LIST II
A	Relation	I	Number of rows
B	Tuple	II	Logically related data organised in a table
C	Degree	III	Number of columns
D	Cardinality	IV	Row in a table

Choose the Correct answer from the options given below

Match LIST I with LIST II

LIST I Mineral		LIST II  States
A	Round()	I	Date function
B	Rtrim()	II	Aggregrate function
C	Count()	III	Math function
D	Monthname()	IV	String function

Choose the correct answer from the options given below:

Which key is used to link two tables together?

The criteria for selecting a primary key for a table: A. It must uniquely identify the row.
B. It cannot have NULL value.
C. It can have NULL value.
D. It can have duplicate values.
E. It never uniquely identifies the row.
%Option

Match List I with List II

LIST I	LIST II
A. RDBMS	III. Store data in related table
B. Primary Key	I. Unique identification of tuples
C. Tuple is collection of	II. Attribute Value
D. Database Schema and Constraints	IV. Database catalog