CSCI3308 Final Exam (Quiz)

HTTP error codes

- 401: unauthorized - 403: forbidden - 404: not found - 500: server error

Select Cloud Service Models (Select all that apply):

- Infrastructure-as-a-Service - Software-as-a-Service - Platform-as-a-Service

Some useful tools for testing include (select all that apply):

- Jest for JS - PyUnit - PhpUnit - unittest for Python

What are some of the advantages of Cloud Computing? (select all the apply).

- On-demand provisioning - Massively scalable - Rapid deployment

Which of the following are correct statements about REST web service architecture? Select all that apply!

- REST APIs can use HTTP POST calls - REST APIs can be cacheable

Characteristics of Private Cloud Services (Select all that apply):

- Rapid deployment - Massively Scalable - On-demand provisioning

What are some of the concrete benefits of CI? Select all that apply.

- Speeds up each feature/sprint - Guarantees that necessary tests are being run - Immediate bug detection - Records of the history/evolution of the project

What are methods for 'self-documenting' code? Select all that apply.

- Variable naming - Minimized control flow - Program structure - Reduced data structure complexity

Check all that apply to Load Testing:

- Volume testing focuses on performance in database systems - Endurance testing focuses on the ability of a system to perform under sustained loads

Which of the following are defined by the API of a web service?

- authentication of username and password - the message and response formats - the HTTP return codes - the named methods on the server

Class selector

.black { color: #000000; }

If you want to use a web service, you must use an ______

API, application programming interface

A Continuous Integration (CI) platform primarily focuses on automating ___ and ___.

Building and testing

How to kill a process in NodeJS?

Ctrl + C

Which of these is NOT true of Waterfall testing techniques:

Develop and test continuously, feature by feature

Heroku is a IaaS provider.

False

What is grep used for?

Globally searches a regular expression and prints

For AJAX applications, ___________ is Faster than XML

JSON

What is NOT part of a SOAP message?

JSON data

Select the communication channels NOT use in a web service?

MIME

_______ provides the runtime environment for applications, development and deployment tools, etc.

Paas

Paas stands for__________

Platform as a service

What sits between a web client and a web server?

Protocol

Continuous Integration (CI) enables a development team to always know the state of their whole system.

True

Gmail service is a SaaS

True

IaaS or Infrastructure-as-a-Service is a cloud service providing infrastructure computers, networking resources, storage. Typically virtual but could be physical.

True

One web service can call another web service API.

True

The best documentation is the code itself because inline and external documentation is prone to becoming outdated. The code itself is the single source of truth with regards to program behavior.

True

Every REST resource is identified by a(n)...

URI

Heroku enables you to ___, ___, and ___ customer apps.

build, run, and scale

The keyword that you use to refer to an object through which they were invoked is _________

this

Git commit

Copies a staged file into the local git repository

What is tail used for?

Copt the lkstlines of a file to the screen

What is cat used for?

Copy the contents to the screen

Git init

Creates an empty local repository

What does document.write() do?

Display any message on the browser

Which keyword is used to remove duplicates in the column of an RDBMS table

Distinct

Normalization of the database is used to?

Eliminate redundancy

A use case depicts the interaction between the software or system and the

End user

What is a foreign key?

When a one table's primary key field is added to related tables in order to create the common field which relates the two tables, it called a foreign key in other tables. Foreign Key constraints enforce referential integrity.

What is a Durability transaction?

When a transaction has been committed, it remains in existence with resilience against crashes

Is "touch" a command in Linux?

Yes

Where is the right place to include JavaScript file?

You could include it within either, <head> or <body> tag

ID selector

#black { color: #000000; }

Universal selector

* { color: #000000; }

Consider the scenario: Team A is working with a client who has very flexible requirements and is subject to continuous evolution. Team B is working with a client who knows exactly what they want, have a detailed document for requirements and do not expect any changes along the way. Team A should ideally be using ___ methodology and Team B should preferably be using ___

- Agile - Waterfall

Which of the Applications can be build using Node.JS?

- Chat - Game - REST API server - Website

Which of the following are from the Agile Manifesto? Select all that apply.

- Individuals and interactions over processes and tools - Working software over comprehensive documentation

Which of the following two attributes are required in <form> tag?

- Method - Action

Select all which nodeJS can do

- Node.js code can generate dynamic page content - Node.js code can create, open, read, write, delete, and close files on the server - Node.js code can collect and process form data from an HTML page

tee command reads the standard input and writes it to both the _________ and __________.

- One or more files - Standard input

First, second and third normal form

- Remove any multi-valued cells and/or any rows requiring a specific sequence - For entities with composite keys, make sure that all attributes are dependent on the full key - Make sure no attributes are dependent on any other non-key attributes

Node.js supports which of the following platform?

- Windows - Ubuntu/Linux - Mac

Scrum master

A "coach" who keeps the Sprint Team following proper processes

Sprint team

A self-organizing group of developers that builds features

JavaScript is interpreted by _________

Client

Git diff

Compares two versions fo a git-managed file

What does alert() do?

Display any message on message box

What is interface design?

How to use drop down menus, buttons, scrolling

What is the full form of HTML?

Hypertext Markup Language

Which SQL statement is used to insert new data in a database?

INSERT INTO

What does wireframe include?

Interface, information, and navigation design

In SQL, how do you display all the columns from a table named "Persons"?

SELECT * FROM Persons

In an Agile model, requirements are primarily recorded as

User Stories

What is navigation design?

What links to what menus

What is information design?

What's being presented

Which of the following Linux commands is best for getting "help" on the syntax and format of a Linux command?

man

How the NodeJS modules are available externally?

module.exports

NodeJS is a ________________________ processing engine.

multi-purpose server-side

Which of the following is not a reserved word in JavaScript?

program

Which command is used to see current working directory?

pwd

Which command shows where the user currently is in the file directory?

pwd

The SQL Answer ____ clause establishes a condition that causes the query to select a subset of rows from the input table(s).

where

______________ determines the way in which the NodeJS application responds to a client request to an endpoint.

Routing

What is locate used for?

Searches for file in the Linux directory tree

'Node.js' runs on _________

Server

Git log

Shows a record of recent commits

Unix was originally developed at

Bell labs

Select any of the following that are a benefit of the Waterfall method of project management.

- The scope is generally locked down during development, and should remain unchanged until solution delivery. - Any changes to the scope must be strictly managed. - Project sponsors get a clear picture of the complete final product. - A decision to change the scope demands renegotiating the project timeline and costs.

Non-functional requirements

- Ties use cases to technical implementation. - Describes how the system should behave

Select attributes of "unmanaged scope":

- Undefined requirements - Shifting requirements - Poorly defined requirements

Select all the commands which are classified under DML.

- Update - Delete - Insert

During a daily scrum, sprint team members take turns answering which of these questions (mark all that apply.)

- What have I completed since the last scrum? - What will I complete by the next scrum? - What obstacles are blocking my progress?

HTML attributes: - id="xxx" - class="classname" - style="xxx" - title="xxx"

- identifies it - ties it into a group for style - define style for elements - adds miscinfo to the tag

function first() {// Simulate a code delay setTimeout( function() {console.log(1); }, 500 ); }function second(){ console.log(2); } first(); second();

2 1

function x() { console.log(2+5+"8"); }; x();

78

What is the correct HTML for referring to an external style sheet?

<link rel="stylesheet" type="text/css" href="mystyle.css">

What is referential integrity?

A constraint that enforces the values of the foreign key to those already existing as primary key values in the corresponding relation.

What is Work Breakdown Structure?

A deliverable-oriented grouping of project elements which organizes and defines the total scope of the project where each descending level represents an increasingly detailed definition of a project component.

What is a Consistency transaction?

All of your data will be correct according to constraint cascades and triggers

What is Structured Query Language?

An internationally recognized standard database language that is used by commercial DBMSs.

Which of the following is the correct sequence of steps for the Waterfall method of project management?

Analysis ⟶ Design ⟶ Development ⟶Testing ⟶ Deployment ⟶ Maintenance

The formula for writing user stories

As a USER, I want FEATURES, so that I BENEFIT

The linux command ">"

Redirects the output of a command into a file

What does the Linux command ">" do?

Redirects the output of a command into a file

What is the distinguishing feature that makes the Bootstrap framework desirable for web applications that target mobile web browswers?

Responsive designs and templates

What is the key component of the Linux Operating System?

Kernal

what will the following command do: ls .././

List all the files and directory in the immediate parent directory

What is the default scope of Node.JS Application?

Local

Git checkout

Moves the HEAD pointer to a different branch making the branch active

Is the "VIM" editor pre-installed with all LINUX/UNIX operating systems?

No

What is an Isolation transaction?

No transaction will be effected by any other transaction (most relaxed property)

NPM stands for ____

Node Package Manager

Assuming you've a test.txt file with some content in it. what will the following command do: cat test.txt | grep ^c

Print all the lines where the first letter is a 'c'

Product owner

Prioritizes the Feature Backlog

SMART stands for

Specific, Measurable, Relevant, Time-Boxed

Git add

States a file under got tracking making it ready for a commit

Which of the following statements correctly describes the order in which style cascades?

Style from the inline <style> attributes overrides style from the <head> section. Style from the <head> section overrides style from an external style sheet.

The WHERE clause results in a ___________ of ROWs to appear in the answer set

Subset

What does prompt do?

Take input from the user

What is a Atomicity transaction?

The entire of the interaction must succeed or none of it applies

What is a foreign key?

The primary key of one relation that is placed in another relation to form a link between the relations.

What are the three attributes of the "Triple Constraint Model" as discussed in class?

Time, Cost, Scope

Which of the following Linux commands is the best way to list the processes using the most resources in a Linux OS?

Top

Agile Scrum Masters recommend that daily scrums should not exceed 15 minutes.

True

An anonymous function can be passed as an argument to another function.

True

Can we run the nodeJS code written on a Windows-based laptop in Linux based laptop?

True

HAVING is to GROUP BY as WHERE is to SELECT

True

In HTML, all commands are case sensitive.

True

Is Node a single-threaded application?

True

Order by is to sort ResultSet either in ascending or descending order.

True

What is the correct JavaScript syntax to change the content of the HTML element below?<p id="demo">This is a demonstration.</p>

document.getElementById("demo").innerHTML = "Hello World!";

Which module allows nodeJS to access the File System?

fs module

Which method of fs module is used to read a file? ( fd = file directory+file name)

fs.readFile(fd, callback)

Consider that you are working on a project and have modified the following 3 files : index.html, form.html, index_bootstrap.html However, you would like to add only index.html to your remote repository at this time. What would be the sequence of steps you would follow?

git add index.html, git commit, git push

Element type selector

h1 { color: #36CFFF; }

How can we declare a variable in javascript?

var

How can we create an instance of the HTTP module?

var http = require("http");