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");
