Question

Which of the following is not a restriction for a table to be a relation?

(a) The cells of the table must contain a single value

(b) All of the entries in any column must be of the same kind

(c) The columns must be ordered

(d) No two rows in a table may be identical

I got this question during an interview.

The query is from Normalization topic in chapter Planning Oracle Applications of Oracle

Answer 1

Right answer is (c) The columns must be ordered

The explanation: To format the columns differently, assign a unique alias to each column within the SELECT command itself (do not use the ALIAS clause of the COLUMN command) and enter a COLUMN command for each column’s alias.