Section 15 Database Design

ANATOMY OF A SQL STATEMENT
If you want to see just a subset of the columns in a table, you use what symbol?
None of the above, instead of using a symbol you name the columns you want to see the data for.
         
The SQL SELECT statement is capable of:
Selection and projection
         
What is a NULL value?
An unknown value
           
SELECT * FROM departments; is a:
Statement
         
The order of operator precedence is
* / + -
         

RELATIONAL DATABASE TECHNOLOGY
The following statements are true regarding tables in a RDBMS:
A table holds all the data necessary about something in the real world, such as employees, invoices or customers.
Tables contain fields, which can be found at the intersection of a row and a column.
         
Once data has been created in a RDBMS, the ony way of getting it out again is by writing a Java or C program. No other languages can be used to access that data. True or False?
False
        
The following table creation statement is valid. True or False?
CREATE TABLE country (ID NUMBER(6) NOT NULL, NAME VARCHAR2(30) NOT NULL, LOC VARCHAR2(40), REG_ID NUMBER, NAME VARCHAR2(25))
False
         
RDBMS stands for
Relational Database management system