???
?: In SQL, there is no data type for arrays.
(X) True ( ) False
?: What is used to associate one table to another?
( ) Primary Key ( ) Integer Key (X) Foreign Key ( ) ID Key
?: If you had a table for users
and a table for posts
, you would add the foreign key to the users
table.
( ) True (X) False
?: RIGHT JOIN
and FULL JOIN
are not supported by SQLite.
(X) True ( ) False
?: What type of join returns all rows from the right table, and the matched rows from the left table?
( ) Inner Join ( ) Left [Outer] Join (X) Right Join ( ) Full Join
?: What type of join returns all rows from the left table, and the matched rows from the right table?
( ) Inner Join (X) Left [Outer] Join ( ) Right Join ( ) Full Join
?: What type of join returns all rows when there is at least one match in both tables?
(X) Inner Join ( ) Left [Outer] Join ( ) Right Join ( ) Full Join
?: What type of join returns all rows when there is a match in one of the tables?
( ) Inner Join ( ) Left [Outer] Join ( ) Right Join (X) Full Join
?: A join table creates a many-to-many relationship between data.
(X) True ( ) False
?: A complex join in SQL is also referred to as an inner join.
( ) True (X) False
???