List of top DBMS Questions

Which one of the following regular expressions is equivalent to the language accepted by the DFA given below? \begin{center} \includegraphics[width=6cm]{22.png} \end{center}
Match List - I with List - II.

List - I

List - II

(A)Data Base Schema(I)Limitation on the type of data
(B)Data Constraint(II)Data about data
(C)Meta Data(III)State or snapshot of the database
(D)Database Instance(IV)Visual or logical architecture

Choose the correct answer from the options given below:
If on applying a hash function, every items of a list maps to unique index in the hash table it is called.
HAVING clause in SQL is used to specify conditions on the rows with
Consider the following statements:
(A) Each attribute in a relation has a unique name
(B) All data values in an attribute must be from the same domain
(C) A special value NULL is used to represent values that are unknown
(D) A database constraint allow different types of data to inserted into the table
Choose the correct answer from the options given below:
Which of the following statements are true?
(A) Where condition in SQL can include aggregate functions.
(B) Having condition in SQL can include aggregate functions.
(C) SQL set operators tend to combine columns from two or more tables.
(D) GROUP BY function is used to group rows of a table that contain the same values in a specified column.
(E) Minus operator is also known as intersect operator.
Choose the correct answer from the options given below:
____ is the logical architecture of a Database while ____ after loading data in a database.
File system becomes difficult to handle when number of files increases and volume of data also grows. Identify the limitations of file system.
Consider the table below: UNIFORM
VcodeVnameVcolor
1ShirtWhite
2PantGrey
3SkirtGrey

Which of the following tuples cannot be inserted into the UNIFORM table ?
Identify the one which is not an online database.
Which of the following is a disadvantage of using questionnaire method of data collection?