Answer:
Select title, description , first_name, last_name from film inner join film_actor on film.film_id = film_actor.film_id inner join actor on film_actor.actor_id = actor.actor_id where title LIKE 'zo%';
Explanation:
- The INNER JOIN keyword selects records that have matching values in both tables.
- The WHERE clause is used to filter records.
- The WHERE clause is used to extract only those records that fulfill a specified condition.
Keyboard would be the correct answer
Answer:
Wi-Fi Protected Access 2 (WPA2)
Explanation:
The Wi-Fi Protected Access 2 (WPA2) makes some alterations to the encryption algorithm that were used in WPA and WEP to what is known as the Advanced Encryption Standard (AES). This is a 128-bit block cipher considered to be much more difficult to crack than the usual 128-bit TKIP wrapper. However, although WPA2 offers a much more tougher encryption standard, it is important to note that it is not hack proof.
Answer:
b. foreign key
Explanation:
In the database world, a foreign key is a field on one table and a primary key for another table. The purpose of a foreign key is to provide linkages between two or more tables. Given two tables A and B, and making A the point of reference, a primary key is a field that is unique in A while a foreign key is unique in B.
On another hand, a composite primary key is a combination of two or more fields/columns on database table that can be used to uniquely identify each row in the table.
In the database lingua, what we have is a unique key not a distinct key, though the two words are similar in meaning.
A duplicate key is used when an information may be repeatedly entered on a table.
So the correct option is a foreign key.
