Which of the following is used to get all the columns of a table?

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• The                          scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
• Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
• To select all columns from the table the syntax is:
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set: