Structure of the BOOKS Table

question 136

Multiple Choice

Structure of the BOOKS table
​
-Based on the structure of the BOOKS table,which of the following is a valid SQL statement?​

• A) ​CREATE INDEX books_profit_idx ON books "retail-cost";
• B) CREATE INDEX books_title_idx ON books (INITCAP(title));​
• C) ​CREATE INDEX books_profit_idx FOR books "retail-cost";
• D) ​CREATE INDEX books_title_idx FOR books (INITCAP(title);

---

Definitions:

Protein-Coding Gene

A segment of DNA that contains the instructions for building a protein, with the sequence of the gene determining the amino acid sequence of the resulting protein.

CDNA Library

A collection of complementary DNA (cDNA) clones synthesized from the messenger RNA of an organism, representing a subset of the genes expressed in the tissue from which the RNA was extracted.

Introns

Non-coding sections of DNA within a gene that are removed during RNA processing before translation into proteins.

Transgenic Organisms

Organisms that have been genetically modified to contain DNA from an external species.