Last Quarter of Exam Deck Flashcards

1
Q

What are the differences between Relational databases and NoSQL databases

* NoSQl can be diffcult to …
* Relation databases have a …

A
  • NoSQL can be difficult to query due to lack of joins and expressive query language.
  • Relational databases have a schema which leads to better design and code.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How do you access data with PHP?

A

PDO (PHP Data Objects)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

List the code to “include files”?

A
  • include
  • require
  • require_once
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Explain “calling functions”

A
  • Functions are a way for us to reuse blocks of code
  • Functions have: inputs and outputs
  • Inputs: We pass information into a function
  • Outputs: The outputs are the result or return value of a function
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is SEO?

Search engine optimisation is a process…

A

Search engine optimisation is a process of tailoring the structure and content of a Web page with search engines in mind

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the SEO algorithm?

A search engine algorithm examines…

A

A search engine algorithm examines a number of factors to decide the priority of search results

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is metadata?

A

metadata is data about data. meta tag content is not displayed in the page but can be used by browsers and other services to get information about a page.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is microdata?

Microdata enables you to…

A

Microdata enables you to define keyword values for specific types of information on the page. This allows search engines to better understand the information and provide better results.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

List the video codecs

A
  • H.264 (MPEG-4)
  • Theora
  • VP8
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

List the audio codecs

A
  • AAC
  • MP3
  • Vorbis
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the source element?

Source elements allow you to…

A

Source elements allow you to provide multiple copies of the file in different formats

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the picture element?

A

An image can be added using a picture element to provide responsive specific images.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Picture v img srcset

A
  • img srcset is about resolution switching. The images are the same just at different resolutions.
  • picture allows us to define completely different images to be loaded at different responsive points.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How do you add javascript to HTML?

We can define our scripts…

A

We can define our scripts locally in the document or the script can by added from an external script file by using a “src” attribute of the script tag to define the location of the script file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is trigger events with event handlers?

An event handler is…

A

An event handler is used to indicate the code that should execute in response to a specific type of user action

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is creating a function (Javascript)?

Javascript has functions which are…

A

Javascript has functions which are bundles of individual lines of code that have been grouped together and given a name (function name)