Answer:
SELECT inventory_id, film_id, title, store_id, address_id
FROM Inventory.Inventory
JOIN Business.store ON Inventory.store_id = store.store_id
JOIN Business.rental ON rental.film_id = Inventory.film_id
JOIN film_text ON Inventory.film_id = film_text.film_id
WHERE COUNT(rental_id) = 0;
Explanation:
The JOIN clause is also used to query tables from two databases. The Inventory and the Business database are joined in the inventory and store table respectively. The Query also joins the inventory table and the film_text table to get the title or name of the film rented where the rental_id count is equal to zero.
Answer:
public Clock(int hours) {
this.hours = hours;
}
Explanation:
In Java programming language, Constructors are special methods that are called to initialize the variables of a class when a new object of the class is created with the new keyword. Consider the complete code for the class below;
<em>public class Clock {</em>
<em> private int hours;</em>
<em> public Clock(int hours) {</em>
<em> this.hours = hours;</em>
<em> }</em>
<em>}</em>
In this example above, an object of this class can created with this statement Clock myclock = new Clock(6); This is a call to the constructor and passes a parameter (6) for hours
<u>Answer</u>:
To quickly modify fonts, colours, and effects on a slide, a user can modify the Theme.
<u>Explanation</u>:
In Microsoft power point a theme is a group or collection of fonts , colours and effects that are pre-formatted to improve or enhance the presentation. We can start changing the font , colours or effects or any pre-existing themes by selecting them.
To Change colour:
- In Design tab, under the Variants group, click on the downward and choose one colour from the colour variant gallery.
- Now click on the customise colours which opens the "Create New Theme Colours" dialog box. In this dialog box , in the theme colours we can make the necessary changes and save them as a new theme.
To change fonts:
- In the View tab, choose Slide Master.In this tab, select "Fonts" and then select Customise Fonts.
- Now "Create New Theme Fonts" dialog box opens where use can choose the required font size under the Heading font and Body font boxes. Again this can be saved as a new theme. Changing the font of theme changes all the bullet texts and title.
Answer:
Hippocampus.
Explanation:
There are two parts of the limbic system. They are the frontal part which is the amygdala and the posterior part which is the hippocampus.
The hippocampus is an extension of the temporal part of the cerebral cortex which is a plastic-like structure that can be easily damaged by stimuli. It is packed with densed neurons and forms an S-shape at the extension of the temporal part.
It is responsible for learning and memory and damage to it can result to memory loss of recently learnt information.
