CSCI 3308 Final Exam Study Guide

Which of these is NOT true of Waterfall testing techniques:

- Testing occurs as a project phase towards the end of project !- Develop and test continuously, feature by feature - Cost of creating test cases is borne once - Test cases don't change often (tied to requirements)

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. - A decision to change the scope demands renegotiating the project timeline and costs. - Any changes to the scope must be strictly managed.

Which of the following are true for non-functional requirements? Select all that apply

-Documented by Use Case -User Requirements, Business Requirements -! Ties Use Cases to Technical Implementation -! Describes HOW the system should behave

What is the output of the below command?: (base) - CSCI-test cat file1.txt This is CSCI-3308 class. (base) - CSCI-test cat file2.txt Software Dev & tools. (base) - CSCI-test wc -c file1.txt| tee file2.txt

25 file1.txt

Match the HTTP code with its description.

401 : Unauthorized 403 : Forbidden 404 : Not Found 500 : Server Error

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.

A selector is a CSS macro that will apply the designated CSS to the HTML element/tag. Selection can be determined by the selector type (select by class, ID etc,.). Match the following CSS selectors to their type: A) h1 { color: #36CFFF; } B) * { color: #000000; } C) .black { color: #000000; } D) #black { color: #000000; }

A) Element type selector B) Universal selector C) Class selector D) Id selector

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 ___________ , I want __________ , so that __________.

As a USER , I want feature , so that BENEFIT

Match the following of standard database transactions:

Atomicity : The entire of the transaction must succeed else none of it should apply. Consistency : All your data will be correct according to constraints, cascades, and triggers. Isolation : No transaction will be affected by any other transaction Durability : Once a transaction has been committed, it remains in existence with resistance against crashes etc.

Unix was originally developed at ______________

Bell Labs

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

Chat Game Rest API server Website

How to kill a process in NodeJS?

Ctrl + C

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

In HTML, all commands are case sensitive.

False

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

False

Match the following normal forms:

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

What is the full form of HTML?

Hypertext Markup Language

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

INSERT INTO

Match with their correct definition.

Information design : describes what's being presented Navigation design : describes links and nav menus Interface design : drop down menus, buttons, form fields

What does wireframe include?

Interface design Information design Navigation design

For AJAX applications, ___________ is Faster than XML

JSON

What is NOT part of a SOAP message?

JSON data

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

Jest for JS PhpUnit unittest for Python PyUnit

What is key component of the Linux Operating System?

Kernel

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

Select the communication channels NOT use in a web service?

MIME

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

Massively Scalable Rapid Deployment On-Demand Provisioning

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

Massively Scalable Rapid Deplyoment On-Demand Provisioning

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

Method Action

NPM stands for ____

Node Package Manager

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.

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

Program structure Variable naming Minimized control flow Reduced data structure complexity

What sits between a web client and a web server?

Protocol

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

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

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

Reduced data structure complexity Variable naming Minimized controll flow Program structure

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

Responsive designs and templates

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

Routing

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

SELECT * FROM Persons

Select attributes of "unmanaged scope":

Shifting requirements Undefined requirements Poorly defined requirements

Select Cloud Service Models (Select all that apply):

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

What does SMART stand for?

Specific, Measurable, Achievable, Relevant, Time-Bound

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

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

Match each of the following roles on an Agile/Scrum team with the best description of that role

Sprint Team: a self-organizing group of developers that builds features Scrum Master: A "coach" who keeps the Sprint Team following proper processes. Product Owner: Prioritizes the Feature Backlog

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.

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 _____ methodology

Team A should ideally be using Agile methodology and Team B should preferably be using Waterfall methodology

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

"touch" is a command in Linux.

True

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

True

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

True

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

True

Gmail service is a SaaS. (True /False)

True

Heroku is a IaaS provider.

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

True/False: When working with Heroku, you can use any and alllanguages.

True

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

URI

Select all the commands which are classified under DML.

Update Delete Insert

In an Agile model, requirements are primarily recorded as ____________________

User stories

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

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

WHERE

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?

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.

Node.js supports which of the following platform?

Windows Ubuntu/Linux Mac

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

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

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

application programming interface

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

build, run, and scale

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

building and testing

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

Please match the following git commands with the best description of the function/purpose of that command.

git diff : compares two versions of a git-managed file git init : creates an empty local repository git add : stages a file under git tracking making it ready for a commit git commit : copies a staged file into the local git repository git log : shows a record of recent commits git checkout : moves the HEAD pointer to a different branch making that branch active

Match the following commands with its description.

grep - globally search a regular expression & print locate - searches for files in the Linux directory tree tail - copy the last lines of a file to the screen cat - copy the contents to the screen

Match attributes to its description

id="xxxx" : identifies it class="classname" : ties it into a group for style style="xxxx" : where xxxx is a list of style elements title="xxxx" : adds misc info to the tag

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

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

one or more files AND one or more files

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'

Which command is used to see current working directory?

pwd

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

pwd

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

'Node.js' runs on _________

server

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

subset

Which of the following are defined by the API of a web service? Select all that apply.

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

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

top

HAVING is to GROUP BY as WHERE is to SELECT

true

Is Node a single-threaded application?

true

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

true

How can we create an instance of the HTTP module?

var http = require("http");