Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

301.

What is the function of the equi-width histogram?(a) Adjusts boundaries of the ranges such that each range has the same number of values(b) Divides range of values into equal sized ranges(c) Divides the range of values into ideally sized ranges(d) Does not divide the range of values.

Answer» Correct answer is (b) Divides range of values into equal sized ranges

To explain I would say: The equi width histogram divides the range of values into equal sized ranges.
Discussion
302.

The intersection of all records satisfying the individual simple conditions Oi is called as ________(a) Conjunctive selection(b) Disjunctive selection(c) Negation(d) None of the mentioned

Answer» Right choice is (a) Conjunctive selection

The explanation: The intersection of all records satisfying the individual simple conditions Oi is called as conjunctive selection. It is a form of a complex selection.
Discussion
303.

We create an index in SQL using _______ command(a) Create index(b) New index(c) Create new index(d) Develop index

Answer» Right choice is (a) Create index

For explanation: We create an index in SQL using the create index command. Eg: create index dept_index on instructor(dept_name).
Discussion
304.

What kind of a sample must be used for statistical analysis?(a) A random sample(b) A sample having excessive representation of a relation(c) A sample having suppressive representation of a relation(d) None of the mentioned

Answer» Correct option is (a) A random sample

The best I can explain: A random sample must be taken into consideration for statistical analysis because it gives a fair result on the data analysis.
Discussion
305.

The union of all records satisfying the individual simple conditions Oi is called as ________(a) Conjunctive selection(b) Disjunctive selection(c) Negation(d) None of the mentioned

Answer» Correct choice is (b) Disjunctive selection

To explain: The union of all records satisfying the individual simple conditions Oi is called as disjunctive selection. It is a form of a complex selection.
Discussion
306.

The collections on which aggregate functions can operate are called as __________(a) Multisets(b) Multivalues(c) Multicollections(d) Multivariables

Answer» The correct option is (a) Multisets

Best explanation: The collections on which aggregate functions can operate are called as multisets. Sets are a special case of multisets.
Discussion
307.

The ________ SQL command generates statistics on a particular relation(a) Statistic(b) Analyze(c) Modify(d) Runstats

Answer» Correct choice is (b) Analyze

For explanation I would say: The analyze command is used to generate statistics on a particular set of relations. The runstats command is also valid but not in SQL. It is used in IBM DB2.
Discussion