Unit 4: Trivia

Rules

• Organize according to your houses
• There are 4 Categories, each with 4 Questions
• Write your answers on a whiteboard
• After each category teams can wager up to 4 points on a challenge question

The Prize

Knowledge!

SQL & Promises

Write a SQL statement that will select the id & name from a table called pets.

Imagine we have a table called students with a column called age. Write a SQL statement that will return the oldest student.

What will the following log?

Promise.resolve(false)
.then(result => {
  console.log('Success:', result)
})
.catch(error => {
  console.log('Error:', error)
})

Will the id logged be related to a cocktail or a glass?

knex('cocktails')
.join('glasses', 
  'glasses.id', 
  'cocktails.glass_id')
.then(results => {
  console.log(results[0].id)
})

CHALLENGE:

What will happen when this route is hit?

router.get('/languages/:id', (req, res) => {
  let language
  knex('languages').where({ id: req.params.id })
    .then(languages => {
      language = languages[0]
    })
  res.send(language)
})

AngularJS

Name at least two other front-end frameworks/libraries besides AngularJS.

ng-repeat, ng-class, and
ng-if are called what in AngularJS

Forms in AngularJS come with some special properties like $dirty. Name two others.

When using ui-router, what does the base element do when added to your index?

Describe two of the binding symbols and what they do.

CHALLENGE:

Computer Science

Reduce the following Big O expression:
O(n^3 + n) + O(2n)

What is the Big O notation of Insertion Sort?

What kind of objects get deallocated by the garbage collector?

You are running a program where inserting often. Should you use an Array or a Linked List?

Consider all the operations you can perform on a Tree. What is the worst time complexity out of all of them?

CHALLENGE:

Unfamiliar Code

What will be returned?

["ruby", :magic, 42].reject do |w|
  w.class != Symbol
end

What will be returned?

def keyword_args(**kwargs):
    return kwargs

keyword_args(big="foot", loch="ness")

What will be returned?

0 :: List.range 1 5

What will be returned?

CHALLENGE:

(defn someFn [x y]
    (+ (+ x x) (+ y y)))
(someFn 5 10)

Tie Breaker!

Name as many programming languages you can think of.

Go!

Name as many native node modules as possible.

Go!