IS 301 Chapter 7 Introduction to Structured Query Language
(Cengage)
Which of the following is a valid SQL statement?
a. SELECT column1, column2 FROM table_name;
b. SELECT FROM table_name column1, column2
c. SELECT column1, column2 FROM table_name
d. SELECT FROM table_name column1, column2; ✔️✔️a. SELECT column1, column2 FROM
table_name;
Which of the following arithmetic operators is not valid?
a. @ : Raise to power of
b. * : Multiply
c. - : Subtract
d. + : Add ✔️✔️a. @ : Raise to power of
Which of the following is not performed as a task of natural join?
a. If there are common attributes, returns the relational product of the two tables
b. Determines the common attribute(s) by looking for attributes with identical names and compatible
data types
c. Selects only the rows with common values in the common attribute(s)
d. If there are no common attributes, returns the relational product of the two tables ✔️✔️a. If there
are common attributes, returns the relational product of the two tables
Which of the following statements best defines outer join?
(Cengage)
Which of the following is a valid SQL statement?
a. SELECT column1, column2 FROM table_name;
b. SELECT FROM table_name column1, column2
c. SELECT column1, column2 FROM table_name
d. SELECT FROM table_name column1, column2; ✔️✔️a. SELECT column1, column2 FROM
table_name;
Which of the following arithmetic operators is not valid?
a. @ : Raise to power of
b. * : Multiply
c. - : Subtract
d. + : Add ✔️✔️a. @ : Raise to power of
Which of the following is not performed as a task of natural join?
a. If there are common attributes, returns the relational product of the two tables
b. Determines the common attribute(s) by looking for attributes with identical names and compatible
data types
c. Selects only the rows with common values in the common attribute(s)
d. If there are no common attributes, returns the relational product of the two tables ✔️✔️a. If there
are common attributes, returns the relational product of the two tables
Which of the following statements best defines outer join?
