Software
Adobe | AnyDesk | ASANA
Canva | Clear Scope | CMS | CRM
Dropbox
Google Analytics | Business | Console | Ads Google Drive
Hunter
iMovie | IBM SPSS
Microsoft Office & Publisher | MOZ | Mailchimp Outlook
Oracle
Photoshop
Programming
Quickbooks
Social Media | SEO Yoast | Shareasale Skype TestFlight Mobile
Vectonator
WebCEO | Wave
WeTransfer
Zoom
*ARCGIS
ArcGIS Online is a cloud-based mapping, analysis, and data storage system hosted by Esri that can be used to create, share, and manage maps, scenes, layers, apps, and other geographic content
Address Points:
1. How Can you Check that address points in a point feature class have the proper zip code value in the ZIPCODE field, given an address point feature class named ADDRESSES and a separate polygon feature class of zip codes, named ZIP_ZONES with a ZIP field.
... Run the Summarize tool on the ZIPCODE field in each feature class and compare the output tables.
... Do a table join from the address points to the zip code polygons and sort on zip code
... Run statistics on both of the zip code columns and check that the min and max zip code values are the same in both. Next, run a query that selects all fo the records where ZIPCODE <> ZIP
... Use Spatial Join Tool to overlay the ADDRESS point feature class with ZIP Polygon feature class, which will add the ZIPCODE field from the polygons onto the points. Next, run a query that selects all of the records where ZIPCODE <> ZIP
Database:
1. Geodatabase // shape file
... shape-file called a0000000a: Homogenous
... personal GeoDataBase called Cupetino_GIS
... ArcSDE GeoDataBase called a000000a
... File GeoDataBase called Cuepertino_GIS
2. Normalized dataset
... # of voters in a district divided by population of the district
... # of single family houses in a state divided by the number of apartments in the state
... # of cows in a country times the number of counties in a state
... # of students in a city plus # of retirees in the city
Data Frame:
... Layers
Digital Elevation Model (DEM):
Given elevation Dataset and it is 30-meter Digital Elevation Model DEM: What does that mean?
1. Z-value of each pixel in the raster dataset has been rounded to the nearest 30 meters of elevation
2. Each pixel in the raster dataset covers an area on the ground that is 30 square meters in size
3. Each pixel in the raster dataset covers an area on the ground that is 30 by 30 meters
4. Raster dataset covers an area that is 30 square meters in size
Geographic Coordinate System (GCS): WGS 1984
... Winkel Tripel
... Natural Earth
... Universal Transverse Mercator
Geo-processing Tool:
1. Applied to Point Data Layer, data in result layer: Buffer
... Merge, Dissolve, Intersect
Grids:
Measure:
Graticule:
MGRS:
Reference: A1, B4, C7
Labels
Labels for different street types shown at different scale ranges: Create label classes for each type of street
Overlay Analysis: Erase, Intersect, and Union tools
... conflation
... generalization
... proximity
Paper maps: added to GIS: Scan the paper map and save it as a raster file (.tiff, .jpg, or other supported format), add the raster to ArcMap or ArcGIS and georeference it
Polygon:
Point at the geographic Center: Centroid
... datum
... centrum
... polyzoid
Storage:
1. Data stores information in a grid (each cell has numerical value): Raster
Shape file // Feature class:
the shape field of the data table is always what data type: Geometry
New feature class: polygon
Web App:
1. Configuration category allows user combination of maps, images, videos, and text to create a presentation: story map
...Summarize Data, Interpret Imagery, Collect and Edit data
*Adobe Acrobat
With Acrobat Reader DC you can open, read and print PDFs, and fill out PDF forms. If you want to edit a PDF, convert a document to a PDF, or perform any other more complex tasks, consider purchasing or subscribing to Adobe Document Cloud PDF services (formerly Acrobat.com) or Acrobat DC
3D comments
Collaboration with product designer on a PDF brochure that contains several interactive 3D models. Using General Comment tools, but the designer is using 3D commenting tools available in the 3D toolbar. One advantage of 3D comments, as opposed to general non-3d comments:
3d comments hidden, autosave, and separate layer
Drop down lists
In a complex forms document, one field is currently a drop-down list field. However, the client specifies that it should instead be a multi-line text field: select the drop-down field and then click Prepare form in the right pane
Docs // Shared view
Collaborating with three authors on book design. As the book layout approaches completions, you would like to post a pdf for comments. You would like for each author to be able to see comments from the other authors, to reduce redundancy: Create a shared view using docs cloud
Export ..
Export all graphics in a PDF to separate files, using File>Export to> Image option. However, some of the graphics are not exported. The reason:
... The graphics are RGB, while the other graphics are CMYK
... The graphics are raster images
... The graphics are Vector objects
... The graphics are CMYK, while the other graphics are RGB
Edits
Complete form fields for complicated form, client submits new PDF, with color changes, new logo, and text edits: include new work with Either PDF
Email distribution // HTML
Create ED form, with data submitted back via email. Create submit button, email specified address: Submit form selections>HTML
Home view:
Customize the # of files listed in the home view: Preferences > Page display
Printer
1. Prepare PDF for commercial printer, install custom color profile supplier by the printer. The custom color profile allows you to more realistically view the PDF on your calibrated monitor before submitting the print job. Before color profile takes affect: Quit and Restart all Adobe Programs
2. Failure to print complicated engineering file, printer is old, small ram, setting: print as image and grayscale
3. Commercial printer receives 4 pdf digital printing. prepress operator can open files, but cannot submit one of the files to the company's printing workflow; reason: 1 file has RGB content
4. Submit clients PDF to commercial printer, but notice blemish on image, no access to original file: Select tools > Edit PDF > Right click image > Select Edit using
Resolution
1. An image in a PDF appears pixelated, and you suspect its resolution is too little. Fastest way to learn its current resolution: Click on the image with the object inspector from tools > Print Production > Output Preview
2. Reduce resolution of image content in an existing PDF, while controlling the look of the images. Option allows change the resolution of image content with options: Optimized PDF
Search
Perform advanced search on multi-layered document for language versions of the content. If search for something that happens to be on a hidden layer: An alert will display asking to make layer visible Simplified field notation
In an order form, you must subtract a discount value from a subtotal, yielding the final total. What feature will allow you to perform subtraction in an acrobat form?
After you finish creating form fields for a complicated form, the client submits a new PDF, with color changes, a new logo, and minor text edits. What is the most efficient way to incorporate the new artwork.
*Adobe Illustrator
Adobe Illustrator is a premium application used for creating vector graphics for print or the web. Developed alongside with Adobe Photoshop as a companion product, Illustrator is the standard for making logos, graphics, comics, fonts, and much more.
Color Picker:
Select new color in color picker and see several variations ranging from muted vivid: Color Guide
Deselect:
Multiple objects are selected, deselect one: Press command + shift + A Mac // cntrl + Shift + A Windows and click object want deselect
Essentials Workspace:
Changed arrangement panels, closing some that were open by default and opening others from the Window menu. Get back to default arrangement of panels: Quit illustrator, press and hold command+shift+option, an relaunch illustrator.
Fill Color:
1.
... Converted to CMYK values
... Color unchanged
... Remain RGB but it appearance would change
... Illustrator would display an error because you can't paste RGB colors into CMYK
2. Change fill color of all info circles in map. Circles not created with symbol. Can use Global Edit, accomplish this task:
... live paint, edit colors, recolor artwork, select>same>appearance
3. Have 1 object on art-board, change fill color from black to yellow, open color picker and select yellow, click ok,,object changes to gray not yellow: color mode of fill is set to grayscale
Grammer
Proper nouns are not hyphenated: turn-off all hyphenated capitalized words in the paragraph panel
Full color RGB doc. and create grayscale version that prints only on back plate: apply the convert to grayscale command & change the Doc color mode to CYMK
Logo: Likes the new logo, but see new different color schemes, variations: Recolor Artwork
Outline:
1. 3d Extrude and Bevel
... revolve // rotate // offset path
2. Outline mode: Fill color in black
... compound path // live text // converted to outlines
Object spacing:
Make all objects side by side: Specify a key object then use horizontal distribute space command and align panel with spacing value of 0
Parameters // Boundaries
Add stars to background object in image, using scatter brush, appear inside circle: select Circle and click "Draw inside"
... Screen blending (Transparency)
1. Full color RGB doc. and create grayscale version that prints only on back plate: apply the convert to grayscale command & change the Doc color mode to CYMK
Save
Save selection: preserve selections objects
Symmetry
Left anchor point for object symmetry: convert it to corner // smooth point
*Adobe InDesign
InDesign is a desktop publishing software application for creating flyers, brochures, magazines, newspapers, and books. Projects created using InDesign can be shared in both digital and print formats. InDesign is used by graphic designers, artists, publishers, and marketing professionals
Content Grabber:
Move image within selection tool
Document Display:
1. In Picas change to centimeters: units & increments pane in the preferences
2. Apply Master Page B to page 3: Drag B to 3
3. Update text flow after master page: Primary text frame
Group:
1. 2 objects grouped together: All objects moved to same layer
Keys:
1. R key: Rotate
2. W Key: normal to preview mode
Panels:
1. Open close panels: Window > Workspace
Scale:
1. Horizontal Scale 150%: Frame the same, image expands
Smart Guides:
1. Green arrows: guide of edges to other objects
2. Color Frame: Layers indication
3. Blue Square: Anchor the frame into another text frame
Stoke:
1. apply arrowhead to the end of a line
Symbols:
1. Multiplication: type>Glyphs
*Adobe Lightroom
Lightroom is based on a catalog system and can automatically create and manage folders across multiple locations, even on different hard drives, without losing track of your images. Essentially, you import your photos and Lightroom makes it easy to find them again
Adjust: Straighten photo: Angle
Control:
Enable profile corrections:
Color Noise reduction:
Remove Chromatic Abbreviation: color fringe around the edges
Split Toning:
Develop Module:
Split Toning
Calibration
Basic
HSL/Color: color range
Correct and Retouch
Editing:
1. Apply same editing from one image to another: Develop Settings
Export:
Reuse Recent custom export setting: "Export with Previous"
Exposure:
Adjust exposure by -1: close aperture by 1 f-stop
Format:
Using an external image editor to work with raw life: TIFF
Lens Profile: make, model, profile
Library Module: Import
Mode:
Screen mode:
Patch Mode
Healing Mode: Spot healing brush
Clone Mode:
Review: images: number keys select images
Thumbnail:
1. ! ... Original photo missing
View: compare, loupe, gird, survey
Watermark: PNG or JPEG
*Adobe Premiere Pro
Premiere Pro is used for editing videos, commercials and other film, television, and online video. It is a comprehensive video editing software application and is also available as part of the Adobe Creative Cloud set of applications
Alpha Channel
When part of your footage is transparent, where transparency information stored in the file: Alpha Channel
- Alpha effect / Opacity Effect / Source Monitor
Codec
Which term describes the algorithm that is used to encode and decode a video file:
compressor / format / container
Effects Panel
Which panel allows you to modify video effects after the have been applied to a clip?
Source monitor panel / effect controls panel / timeline
Exporting Media
... When you click Export, adobe premiere pro will encode the file in the background and let you continue editing
... While using adobe media encoder, you can keep working on the same sequence in Adobe premier pro
... You can encode sequences into one or more formats with Adobe media Encoder
... Adobe Premiere can directly export files
Format
Suppose your clips link to media files stored in multiple location. You want to have the media files in a single location in their current format. Which option should you choose in the Project Manager
... Collect Files and Copy to new location
.. Create new trimmed project
... Consolidate and transcode
... Exclude Unused Clips
HSL
HSL Secondary Color Correction allows you to adjust
Clarity, Contrast, Saturation, temperature, Blur
Icon
If an effect has a star next to its icon, what type of effect is it? Prset
Audo / Preset / Transition / Template
Input LUT
Which adjustment can you use to quickly convert log footage using recommenced settings by a camera manufacturer:
Media Browser
Which panel would you use to browse and import assets for maximum compatibility with Premiere Pro: media browser
Library / Project / effects
Source Monitor
You want to save short portion of a longer clip for easy access.
Click on the 'Clip' menu and choose the second option 'Make Subclip…'.Right click the Source Monitor and choose 'Make Subclip…' from about a third of the way down. Hold the Control key on a PC or the Command key on a Mac and drag the clip to the Project Panel.
1. Mark in and out points... on the clip Source Monitor and Select Clip > Make Sub clip
2. ... on the clip in the program monitor and select choose clip > 3. Make sub clip
... on a clip in the Timeline panel and then drag it back into a bin
4. ...In the Media browser, mark in and out points, and the import
Timeline panel
In which panel do you assemble media in order to create sequences:
Media Browser panel
Source monitor panel
Capture panel
What is the only panel in which the rate stretch tool can modify a clip:
Program Monitor panel / Source monitor panel media browser panel
Undock Panel You want to float the history panel independently to position it on another monitor as a floating window. Which option in the panels submenu should you select: Undock Panel
Maximize frame / maximize panel / Unlock Frame
Video Footage
What adjustment can help return edge detail to video footage:
Contrast
Sharpen / Clarity / Intensity
*Adobe Photoshoot
Creative cloud application
How do you browse images on your hard drive using the companion application thats included with the adobe creative cloud plans? use the creative cloud application
Elliptical Marquee Tool
Shift and drag to reposition selection
Export layers
Click file > Export > Layers to files
Fill choices:
solid color, gradient, pattern
Filter
Create photorealistic blurs: Lens blur
Quick Mask Feature
1. Quick mask tool....
.... allows convert a vector mask to a layer mask
....allows duplicate mask quickly
.... allows use of brush tool to create or refine section
... allows use pen tool to edit a selection
Layers Panel
When the content of certain layer is very small relative to the overall image dimensions, what can you do to make it easier to see in the layers panel?
... From layers panel menu, select marge visible
... From the top menu bar, select Window - select workspace, then select graphic and web workspace
... Convert the layer to a smart object. then, from the layers panel menu, select merge visible
... In the layer palette, select panel options from the layer pane menu. then select the thumbnail contents: layer bound
Printers
Minimum dpi for photographic quality inkjet printer: 300
To reduce the file size of PDF:
apply compression, convert 8 bit images to 16 bit, upsample large images, all of these
Save
Common crop size: crop tools
Panel layout arrangement, what you should create: save the current shortcut
Selection tool:
Sharpen edges grayed out in image: Selection tool made first
Select and Mask workspace gives the best result on organic edges for complex selections
Smart objects
Command in smart objects submenu would you use to save the original file for the selected layer: edit contents / export contents
Smart filter
Blending tool: Gaussian blur
*AdobeXD
Alignment
- rollover developers share screen
Artboard Preview on Mobile - Long press image/press Artboard
Artboards from Photoshop
- Import .psd into Doc
Component Text Change
- Only Instance / All copies
IOS Animation
Slide from the right - Slide-in / Slide Right
Export Setting, low res asset at 50% of the asset in the screen
- 1x
Home Screen Add-ons / App Extensions
Interactions - copy interaction to clipboard, apply interactions to multiple objects - Shift/click each interaction
Interactions - button to components for interaction, Component Master, property Inspector, the state already applied : hover
Overlays - Separate Artboard
Preview switches to the ArtBoard View
- Circle Icon Design Preview
RGB/Hex color palette - XD Doc
Swap components in Project
- Copy components in the Assets panel, a select component in the project, paste
Vertical Guide <>
Wire Arrow (Destination)
*After Effects
After Effects brings “life” and motion to graphics, whether it's as simple as animating a title across the screen or as complex as building a 3D world. Animate text and shapes to design title sequences and motion graphics that amaze your clients.
3d Layer
Which change occurs when you enable the 3d layer switch in the timeline panel:
the layer is extruded with depth, the layer can cast a 3d shadow, z axis is enabled for the layer
Adobe Media Encoder Queue
Render a file in the background and keep working:
Blur
blur effect depth matte to define focal range:
bilateral blur
Smart blur
cc radial blur
cameral lines blur
Constraints
Holding the shift key when rotating a 3d layer constraints the rotation of how many degrees: 30
Direct Relationships
Create a direct relationship between two layer properties:
Use Pick whip to enable connecting
Use pick whip to enable parenting
use value linking
use grouping
Export Queue panel
Control the settings for footage created from an After Effects composition:
Effects:
Apply an effect to multiple layers and adjust al layers at once: Cop and past effect to another layer
Format:
Project format exposes much of the information as human-readable text in string elements. Open in text editor and edit some details of the project without opening the projects:
MOGRT
AET
XML
AEP
Importing
Option importing the PSD file: import as > composition
Layers
Changed several sliders for multiple effects, but the composition window isn't updating:Layer lock
Lumetri color
effect can restore edge detail to footage:
Contrast
Clarity
Sharpen
Intensity
Null Object:
Invisible layer with all properties for parenting other layers for composition
Retiming
Slow, fast motion, freeze frame: time remapping
Transparency
Information stored: Alpha Channels
Views
Graph editor
Composition flowchart
Composition mini-flowchart
Guided view
Amazon Web
Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow. Running web and application servers in the cloud to host dynamic websites
Command
AWS CLI 'create service' command for ECS do:
Creates a cluster called production and launches two containers into Fargate with the rest-api task definition
Code Build / Pipeline/ Deploy
Scales based on a schedule
When using an ECS cluster with EC2 instances, what maintenance tasks should you perform on the EC2s.
your database is an RDS instance running SQL server with Multi-AZ replication and you have several older .NET console Utilities that perform database operations every 15 seconds. when the cluster has to switch the primary database server to the secondary AZ, the . NET utilities start to report connection failures to the database although other applications are able to access the database. Correct problem:
When designing a server-less web application using lambda, what key concept must you factor into your design... Lambda does not use servers so it can only return the same request
what aws service can help you automate your development pipeline for continuous integration and continuous deployment
Cloud Front Network
You want to make your public API quickly accessible from all regions: Create edge-optimized API gateway endpoints and deploy them to a cloud front network
Cloud Formation
the principle of devops is to view infrastructure as code, which aws service allows you to script your AWS infrastructure
Host
you have an application using a 100 GB MYSQL database that you are migrating into AWS, what should you consider when deciding between whether to host the database on RDS for MYSQL or Aurora:
The current storage engine used by the application, such as InnoDB or MYISAM
Cost
Ease of maintenance vs. granularity of control
DynamoDB
Data store provides a simple quick way to of storing basic user attributes in an object-based format: DynamoDB
Hundreds of thousands of AWS customers havechosen DynamoDB as their key-value and document database for mobile, web, gaming, ad tech, IoT, and other applications that need low-latency data access at any scale. Create a new table for your application and let DynamoDB handle the rest.
Lake Formation
What type of data solution should you use for data coming from non relational and relational data from IoT devices websites mobile
NoSQL database: RDS MySQL
PCI
which aws service complies with the standards outlined in Payment Card Industry Data Security Standard (PCI DSS) Level 1 for the handling and transmission of credit card sales:
Simple Queue service
API Gateway
Kinesis Data streams
RDS for SQL Server
Data Store will let you store large streams of user activity data coming from both web and mobile applications:
What option is best for auto scaling your EC2 instances for predictable traffic patterns...
... Maintain current levels at all times
... scales based on a schedule
... manual scaling
... scale based demand
... you should not directly manipulate the EC2 instances created by ECS. AWS will automatically update these instances.
... ECS clusters do not use EC2 instances
... Refresh the cluster with instances built from the latest ECS AMI
... The instances created by ECS do not have patches that need to be applied; however, you should make containers contain any important security updates
... use the RDS console to force a reboot of the database instance so that the primary server becomes the master server again.
... A .NET application will remain the IP address of a connection string until the hist machine is rebooted
... The .NET utilities need to change the SQL Server endpoint in the connection strings to read from the secondary database serving using a try/catch
... the server running the .NET utilities is caching the DNS lookup on the database cluster address. Flush the DNS cache of the server and force the C# utilities to open new connections to the database.
... Lambda only allows you to write functions in Java Script (wrong I think)
... Server-less web applications run within the web browser of the user, so you will need to store any data the user changes directly in a dataset
... Lambda is stateless, so it won't remember who a users is in between requests
AutoCad
AutoCAD is a commercial computer-aided design and drafting software application. Developed and marketed by Autodesk, AutoCAD was first released in December 1982 as a desktop app running on microcomputers with internal graphics controllers.
Annotation
What specific annotation setting must be in place a text annotation in a drawing? Text style
Blocks
When creating block with attributes, why must you use underscores between words in the attribute tag: Attribute tags not do allow spaces
DonutThe donut command creates donut shaped drawing objects. Which two values are needed to place a donut on a drawing: Internal / External diameters
Dimensions tab / Annotate You can dimension objects in Autocad from the annotation pane on the home tab of the ribbon. Where else can you dimension on the ribbon?
Elliptical
Auto-cad allows you to create elliptical arc drawings. When creating one of these arcs, which default drafting rule do you need to follow: Arcs follow a clock wise positive angle value path
EATEDIT
By default of the array commands make their respective arrays associative and group the selected objects in the array. What command would you use to convert the selected array into individual AUTOCAD objects:
Insertion points
When an inserted block is selected, a single grip is displayed on the block. what is the point known as when the block is created with Create Block (block) Command:
Line type Scales
Line type Scales (LTScale) is apple to what sort of line types in Autocad drawings: any objects that utilize a dash / dotted Line type / combination
Line Objectswhen drawing line objects in a drawing, you may use coordinates to define distances and directions. one type of coordinate is a relative coordinate, which is relevant to the last point specified- often the second point when drawing a line using the LINE command. What prefix symbol you type in front of 2D X Y coordinates to ensure that AutoCad knows it as a relative input.
#X,Y
MatchPropSometimes you will need to match properties of one object to another using the match properties (MatchProp)command when matching the properties of an existing view port to a new one, which setting do you turn off on match properties to ensure the viewport scale is NOT match across a new Viewport. ... basic properties > Line-type scale
... Basic properties > Layer
... Special properties / Center objects
... Special properties viewport
QAT
The Quick access toolbar (QAT) is located in the top left of the AUTOCAD application window. Which two commands in the QAT allows you to go backward and forward in your Autocad workflow: undo / Redo
Relevant Type
External Reference Files (XREFs) link external drawings to the host drawing. You can set the XFER path type to no path, the relative path, or full path. What value should be used for relevant path type.
Scaling When scaling a drawing from imperial feet and inches to metric milligrams, what scale factor do you use in the Scale command, before adjusting your units settings:
... 0.08333
... 12.0
... 0.03937
... 25.4
Scaled model space
One of the benefits of lock viewpoint in a layout is that you can activate it and work through the viewport on objects and annotation in the model space, without worrying about affecting the viewport scale. What is the space in the activated viewport commonly known as when you do this?
ViewPort
When working in a layout, if a viewport is activated and unlocked and you accidentally zoom in or out, what happens to your viewport scale: Nothing, viewport scale remain the same
Autodesk Investor
Autodesk Inventor is a computer-aided design application for 3D mechanical design, simulation, visualization, and documentation developed by Autodesk.
Assembly constants
what is the purpose of assembly constraints: limit how an assembly can be shared with collaborators
Base View When creating a drawing view, which view type is most commonly created first:
Calculated Properties How can you view the mass properties for a given design:
File Type
What type of file is open:
assembly file
simulation file
part file
History Based Modeling System
What makes inventor a history-based modeling system: It contains a historical versioning system to ensure designs and changes are tracked properly throughout a project
Jagged lines What do the jagged lines cutting through the view tell you about the drawing view: incomplete
Models How can you get a model to appear: Navigate to the view tab and, from the visual styles menu, select wireframe with hidden edges
Models
What is this model:
Multi body part
Weldment
rigid assembly
sheet metal part
Models
Given the geometry shown. what is most likely the next modeling feature to be created:
loft
revole
sweep
extrude
Models
What modeling feature do you use hollow out a part? hollow
Origin
What is the purpose of the origin geometry:
To provide a fixed reference for any part or assembly in 3d
Share
How can you share a 3d design with someone who doesn't have inventor:
Click File > share and then select DWF or 3d PDF
Subassembly When an assembly is place inside another assembly, wha does it become: subassembly
Sketch Constraint What is the purpose of a sketch constraint? to control where dimensions can be applied to a sketch
Bash
GNU Bash or simply Bash is a Unix shell and command language written by Brian Fox for the GNU Project as a free software replacement for the Bourne shell. First released in 1989, it has been used widely as the default login shell for most Linux distributions and Apple's macOS Mojave and earlier versions.
Match Code: Ls Hello[[.Vertical-line.]]World ::
... Hello[[.vertical-line.]]World
... Noting, This is an invalid File Glob
... Hello.vertical-line.World
... HellolWorld
Which Variable contains the process ID (PID) of the Script while its running:
... $ID
... $$
... $@
... $#
What is the Output of this command Sequence:
... Cat <<E0F
... E0F
...
This is line 1
This is line 2
This is line 3
... This is line 1. This is line 2. This is line 3.
What is the Output of this command:
$ ls -1
file10.txt
file1.txt
fileabc.txt
filea.txt
fileb.txt
filec.txt
$ ls -1 file(^abc]*.txt
... File.txt
file10.txt
... file10.txt
file1.txt
fileabc.txt
filea.txt
fileb.txt
filec.txt
...fileabc.txt filea.txt fileb.txt filec.txt
...filea.txt
fileb.txt
filec.txt
What is the output of this code:
VAR="This old man came rolling"
Echo "$${VAR/man/rolling}"
... This old rolling came rolling
... This old man came man
... This old came
... This old man came rolling
What does the Script Accomplish
#!/Bin/Bash
Declare -A Array=([user1]=Bob [user2]=ted [user3]=Sally)
Keys=(${!Array[@]})
for ((i=0;$i < $(#Array[@]}; i+=1));do
Echo $(Keys[$i]} - $(ARRAY[$(KEYS[$i]}]}
done
... It creates an indexed of array of the associative array named ARRAY. It then uses a C-style for loop and the indexed array to loop through all items in the associative array, outputting the key and value of each array item use the index number
...Using a C-Style for Loop, it loops through the associative array named ARRAY using the associative arrays keys and outputs both the key and values for each item
... It sorts the associative array named Array and stores the results in an indexed array name KEYS. It then uses this sorted array to loop through the associative array ARRAY
... It created an associative array named Array, why it loops through using a C-style for loop and the index numbers of each item in the associative arrays keys, outputting the value of each item.
Which operator sends the output of ls to a file for later use:
... ls - Fielist.txt
... ls l fileliest.txt
... ls > filelist.txt
... ls < filelist.txt
The Shell looks at the contents of a particular variable to identity which programs it can run. What is the name of this variable:
... $include
... $Paths
... $Path
... $Program
The data.txt is owned by the root:root with rw--------permissions. The script will be excused by user1. Are the two conditionals in this script the same:
#!/bin/bash
[[-e data.txt]] && cat data.txt ll echo "data.txt doesn't exist"
If [[-e data.txt]]; then
cat data.txt
else
echo "data.txt doesn't exist"
fi
...The "&&" and "ll" syntax executes faster than old style if-then-else condition block; otherwise they're the same.
... No the first conditional using "&&" and "ll" is correct. The if-then-else condition will print "data.txt doesn't exist"
...These are the same. The First conditional using "&&" and "ll" is a shorter way of writing an if-then-else conditional
...The First conditional checks for the file's existence and then attempts to read it. this fails resulting in a nonzero return code so "data.txt.doesn't exist" is printed. The second conditional checks for existence and only if it doesn't exist will it print "data.txt doesn't exist."
If file.sql holds SQL statements to be executed, what will be in file.txt:
... copy of the contents of file.sql
... non-error output of the MYSQL command
... The error output of the MYSQL command
... an error indicating that this is invalid syntax
If a user wants to execute script.sh without a shebang line or executing permissions, what should the user type:
... A shebang line is required to execute a shell script
... "Bash script.sh"
... Execute permissions are required to execute a shell script
... "exec Script.sh"
How does the SUID or Setuid but affect Executable commands?
...when the command is executed, its running privileges elevate to the user owner of the command
... When the command is executed, its running privileges elevate to the group owner of the command
... The SUID bi allows anyone to execute the command no matter what other permissions are set
... When the command create files, they will be owned by the group owner of the command
In order to extract text from the first column of file called textile, which command would you use:
... awk textfile {print $1}
... cat texfile l awk [print $1]
... cat {$1, texfile}
... cat texfile l awk '{print $1}'
The keyword pauses the script to get input from the standard input
... read
... get
... argument
... input
What is the keyboard shortcut to call up the BASH history search as shown below: (reverse -i-search)'':
... Alt + R (WINDOWS) ___ Option + R (MAC)
... CNTRL + R (Windows ___ Command + R (MAC)
... ESC + R
... CNTRL + H (Windows) ___ Command + H Mac
*** Bash
https://www.youtube.com/watch?v=NGpqpxv1j4U
bach
3 methods copy directory name phot from uder home directory to backups
- use $Home/photo du"
script.sh run directory , fail :
- curly brackets
- ls command builds and loops
copy command subshell command
- ((
awk command
- 123
search root file systems for files "finance.db" info sent:
- name of files do not match finance db
Remove Empty lines from file called textile: command:
… sed -i ‘/^$/d’ textfile
User 1 exists, result of command string:
awk -F /user 1/{print $ 1 “-“ $3 “-“ $6} ‘ etc/passwd
… it would print the UID. comment, and home directory of user 1 serrated by hyphens
Set -e in bash script:
… Cause bash to exit if a conditional returns a non-zero status code
If file .SQL holds SQL statements to be executed what will be in file.txt:
… mysql < file.sql > file.txt
The error output of MySQL command
How does the SUID or setUID bit affect executable commands:
… When command is executed its running privilege elevate to the group owner of command
In oder extract text form Forst column form .txt.file command:
… awk textile {print$1}
Keyboard shortcut call bash history
reverse -i search
… control R
alogrithimic expression:
Var=$echo ’scale=2; 10 /0 ‘ l bc)
Script:
txt = penguins
[[ $txt = ~ [a-z]{8}]] echo $
1 representing false b/c variable “txt” does not contain 8 lowercase letters between a-z
ClearScope
SEO rankings
C Programming Language
C is a general-purpose, procedural computer programming language supporting structured programming, lexical variable scope, and recursion, while a static type system prevents unintended operations.
C
C is a strongly typed programmed language: What does this mean:
C uses more data types than the programming languages
LoopThe main loop structures in C Programming are for the loop, the while loop, and which other loop:
... repeat... until
do...while
Memory leaks
What is the main cause of memory leaks in application:
... memory being allocated never being deallocated
... more memory being allocated than used
... not enough memory being allocated for the program to work properly
... incorrect type memory being allocated
Recursion
What is the name for calling a function inside the same function:
Value
Describe the relationship between lvalue and rvalue:
L value left side R value either
What is the value of variable c at the end of this program:
1. main () {
2. int alb,c,;
3. a=10; b=50;
4. c = a * b % a
5. }
...500
...5
...0
...50
0x
An integral literal can be a decimal, octal, or hexadecimal constant. Which prefix specifies the base for hexadecimal:
*Which operator is used to access the address of a variable:
*
What does the program below return:
1. int main () {
2. int a=0, b-2, c=4, d=8
3. int x=a;
4. if (d / c <= b ll b / a == a) x=b;
5. else x=c;
6. return (x);
7. }
... 2
... 0
... core dump
... 4
In the code sample, what is NOT a problem for the C compiler:
1. Main () {
2. constant into PI = 3.14;
3. printf("%f/n",pi);
4. }
... the printf statement needs to use PI, not pi
... the value of PI needs to be set to 3.141593, not 3.14
... the data type of PI needs to say const, not constant
What does this code sample demonstrate:
1. main () {
2. int x;
3. if (x==1) { // some code here;
4. } else if (x == 3) { // some code here);
5. } else { // some code here;
6. }
7. }
... if statement
... if/else ladder statement
... nested if/else statement
... if/else statement
This line is included in a program unsigned x; how is that handled:
... Without the explicit data type, long is assumed, with the variable x as a positive value
... this line will cause an error because unsigned is a type modifier and requires the data type such as int or long to be present
... Without the explicit data type, int is assumed, with the variable x as a non-negative value
... this line will cause an error because unsigned requires the variable definition to be dine at the time of declaration
In C, how are constants different from regular variables:
... Constants must be declared at the top and not inside the main function
... Constants cannot be modified after the definition
... Constants are limited to integer and character data types
... Constants must be defined using only capital letters
What needs to be corrected so that this program displays the number 10 when its run:
1. main () {
2. Print("%f,f1() ):
3. }
4. f1 () {
5. int i=10;
6. return i;
7. }
... Function f1 needs to be declared as type "int"
... Function f1 needs to be declared prior to being called
... the printf statement needs to use %d not %f
... the main function needs to be declared as "void"
Which code snippet can be rewritten as a switch statement?
1. if (a == 1 ) x=a;
2. else if (b==2) x=b;
3. else if (c ==3) x=c;
4. else x=d;
_
1. if (a==1) x=b;
2. else if (a==2) x=c;
3. else if (a==3) x=d;
4. else x=a'
_
1. if (a) x=a;
2. else if (b) x=b;
3. else if (c) x=c;
4. else x=d;
_
1. if (a==b) x=a;
2. else if (b==c) x=b;
3. else if (c==d)x=c;
4. else x=d;
C#
C# is a general-purpose, multi-paradigm programming language encompassing strong typing, lexically scoped, imperative, declarative, functional, generic, object-oriented, and component-oriented programming disciplines
C# asynchronous programming model:
... task based
... reactive
... inherited callbacks
... *callback based
How do you make a method in an abstract class overridable:
... Make it Static
... Make it Private
... Make it virtual
... Make it public
Async keyword work:
... it allows thread pooling and synchronous processes in static classes
... it allows access to asynchronous methods in the C# API
... It allows the await keyword to be used in a method
... It allows access to synchronous methods in the C# API
Correct formatting for single line and multiline comments:
... //*Multiline
/ Single line
...//Single line
/* Multiline */
.../*/ - Single line
/* - Multiline
... // Multiline
/* Single Line */
Delegates
... they can be chained together
... they cannot be used a callbacks
... only variables can be passes to delegates as parameters
... delegates are not supported in the current version of C#
What are C# events:
... User - only methods that send data to the applications back end
... system actions that communicate directly with the compiler at runtime
... actions that execute when the code complies, generating logs and test output
... actions that generate notifications, which are sent to the registered listeners
For-Loop print out to the console
for (int i=2; i<10; i++)
{
Console.WriteLine(i);
}
... numbers 2-10
... a compiler error since i cannot be greater than 0
... numbers 2-9
... numbers 2-11
How could you write code for an integer proper called Age with a getter and setter?
... public int Age {get - set}
... public int Age: get set;
... public int Age (get, set);
... public int Age {get; set;}
A class that inherits behavior from a base class:
... *derive class
... parent class
... revised class
... second based class
Main purpose of LINQ
... to query and transform data
... connect assemblies
... bind namespace and assemblies
... delet duplicate data
How would you create a new instance of a class named User:
... New user1 = user();
... User user 1 = User();
... Var user1 = new User();
... User user1 = new User();
Operator Overloading allow:
... add methods to be implanted by the complier at runtime
... hide built in operators when necessary
... define custom functionality for common operators like adoption an equality
... define how enums and other primitive value types work within the rest of the application
Object in C#
... value type that can be used only with abstract class
... a class or struct, including is variables and functions
... a primitive data type that can be created only at compile time
... an instance of class or struct that includes fields, properties, and/or methods
When using a thread pool, what happened to given thread after it finishes its task:
... the thread goes inactive in the background and waits for garbage collection
... the thread runs in a loop until next assignment
... the thread is destroyed and memory is freed up
... the thread returns to the the pool for users
Valid constructor for a class named User:
... public init User {}
... public construct User () {}
... public instance User () {}
... public User () {}
C#
Dictionary rather than array type:
store key value pairs rather than single values
Delegates:
chained together
retrieve information in class and create instance at runtime:
reflection
values arrays store:
multiple values, or collection, of same types
character start regular expression patter with word boundary:
/b
asynschronous method is executed the code runs but nothing happens than a compiler warning:
the return yield on statement is missing at the end of the method
how determine if class has particular attribute:
var type = type of
why use class field:
throw clauses overwrite the stack trace while throw exceptions retain stack information.
difference between ref and out keywords:
variables passed to ref specify the parameters is an output parameter while out specifies that a variable may be passed to a function without being initialized
Code example:
Private static object (obj A)
piv static
Private void
… private class multithreading
C# events:
… actions that generate notifications which are sent to registered listeners
How delegate result call back with int parameter named response code
.. public delegate void result call back (int reponseCode)
interfaced better than abstract classes:
need to define object types characteristics, use an interface need to define objects types capabilities use an abstract class.
C++
C++ is a high-level, general-purpose programming language created by Bjarne Stroustrup as an extension of the C programming language, or "C with Classes
Correct way to call count member function for the object pointer called grades:
class my-array{
public:
int count();
}; // ... more members above
int main (){
my_array *grades = new my_array();
} // ... more code above
... grades.count()
... my_array->count()
... grades->count()
... my_array.count()
Valid definition for the get_length_function, which returns the length of a null-terminated string:
int get_length(char *str);
...int get_length (char*str){
int count = 0;
while (str!=Null){
count++;
str++;
}
return count;
}
...int get_length (char*str){
int count=0;
while ((*str)++)
count++;
return count;
}
...int get_length (char*str){
int count=0;
while (str++)
count++;
return count;
}
...Int get_length (char *str) {
int count = 0;
while (str[count++]);
Removing my_object
My_class *my_object = new my_class();
... delete (my_object);
... free (my_object);
... the garbage collector will destroy the object eventually
... existing the scope will destroy the object
Output of code:
int i=0;
loop:
std:: count<<++i<<" ";
if(i<10)
goto loop;
... 0123456789
... no output because complier error the "goto" keyword does not exist in C++
... 123456789
... this code will run into an exception the second time std::out is used
Output of code:
int i0=4, il=6, i2=8;
int&nums[3]={i2,i0,i1};
std:: count<<nums[0]<<nums[1]<<nums[2];
... There is no output. the code causes a compiler error because nums is an array of references, which is illegal
... 846
... the output is the addresses of i2, i0, and i1, in that order, with no spaces
... 468
Benefits of declaring the parameter as a const reference instead of declaring it as a regular object:
int median(const my_array& a);
... the argument is passes as a reference, so if the passed my_array object is larger, he program will require less time and memory
... actually, objects can't be passed as regular variables, because they require a construct call. therefore, a const reference is the only way to pass class instances to functions
... there are no benefits because a reference and an object are treated as the same thing
... the argument is passed as a reference, so the function receives a copy that can be modified without affecting the original variable
Sort my_array, declared below, correct call to std::sort, using a lambda expression as the comparison function:
std:: array<uint32_t, 50> my array;
... std:: sort(my_array.begin(), my_array.end(),
lambda (unit32_t a, uint32_t b) {
return a < b;
});
...std:: sort(my_array.begin(), my_array.end(),
[](unit 32_t a, unit32_t b) {
return a < b;
});
... lambda (unit32_t a, unit32_t b){
return a < b;
});
sstd:: sort (my_array.begin(), my_array.end(), &lambda);
... Lambda(unit32_t a, unit32_t b){
return a<b;
});
std::sort(my_array.beg(), my_array.end(),&lambda);
Storage occupied by u1:
union{
unit16_t a;
unit32_t b;
int8_t c;
}u1;
bytes
... 2
... 8
... 4
... 7
C++ code call a c function:
... no way
... using extern "c"
... simply calling the c code
... importing the source C code
Operators is Overloadable
... ::
... .
... ?:
... new
Difference between pointers and iterators:
... While pointers are variables that hold memory addresses, iterators are generic functions used to traverse containers. These functions allow the programmer to implement read and write code as the container is traversed
... all iterators are implemented with pointers, so all iterators are pointers, but not all pointers are iterators
... Pointers are variables hat hold memory addresses, whereas iterators are unsigned integers that refer to offsets in arrays
... incrementing an iterator always mean accessing the next element in the container (if any) no matter the container, incrementing a pointer means pointing to the next element in memory, not always the next element
Contents of vectors pointed by v1 and v2 after running this code:
std:: vector <int> *v1 = new std:: vector <int> ({1,2,3});
std:: vector <int> *2;
v2=v1;
v1-> push_back(4);
v2-> push_back(5);
... the assignment line v2 = v1; causes a compile error
... *v1: {1,2,3,4,5} *v2: {1,2,3,4,5}
... *v1: {1,2,3,4} *v2: {1,2,3,5}
... *v1: ({1,2,3,4} *v2: {5}
Not different between class and a struct:
... classes may have member functions; struct can't
... template type parameters can be declared with the class keyword, but not with the struct keyword
... the default access specifier for members of structs is public, where's for members of classes, it is private
... because structs are party of the C programming language, there's some compatibility between C and C++ using structs. this is not the case with cases
The & character has many uses in the C++ programming language. Not uses:
... get address of variable or object
... declare a pointer to a function
... declare a reference
... perform a bitwise AND operation
Whats wrong with overloading a binary operator as a member of a class shown below:
complex complex :: operator + (const complex$ c){
return complex (c.real + this->real, c.img + this -> omg);
}
complex complex :: operator + const int& my int) {
return complex (myint + this -> real, this -> img);
}
... There is nothing wrong with it. this is the standard approach
... The operator is defined twice, this is illegal
... the operator is stuck with a complex operand. trying to add two integers would cause an error
... it lacks symmetry. the example works for adding a complex with an integer, but not for adding and integer with a complex
Cascading Style Sheets
Cascading Style Sheets is a style sheet language used for describing the presentation of a document written in a markup language like HTML. CSS is a cornerstone technology of the World Wide Web, alongside HTML and JavaScript.
Not a choice for font style property
... none
... italic
... oblique
... normal
Shorthand example, which individual background properties are represented:
background: blue url(image.jpg) no-repeat scroll 0px 0px;
... background-color: blue;
background-image: url (image.jpg);
background-repeat: no-repeat;
background-attatchment: scroll;
background=position: 0px 0px;
... background-color; blue;
background-src: url(image.jpg);
background-repeat: no-repeat;
background-wrap: scroll;
background-position: 0px 0px;
... background-color blue;
background-image url(image.jpg):
background-repeat: no-repeat;
background-scroll: scroll;
background-position: 0px 0px;
... background-color: blue;
background-img: url(image.jpg);
background-position: no-repeat;
background-scroll: scroll;
background-size: 0px 0px;
When adding transparency styles, what is the difference between using the opacity properly versus the background properly with an reba() value:
... Opacity applies transparency to the parent and child elements. Background with an rgbal() value specifies the level of transparency of an element, as a whole, including its content
... Opacity applies transparency to the background color only. background with an reba() value specifies the level of transparency of an element, as a whole, including its content
... Opacity specifies the level of transparency of an element, including its content. Background with an rgba() value applies transparency to the background color only
... Opacity specifies the level of transparency of the child elements. background with an rgba() value applies transparency to the background color only
To change the color of an SVG using CSS, which property is used:
... Use background-fill to set the color inside the object and stroke or border to set the color of the border
... The color cannot be changed with CSS
... Use fill to set the color inside the object and stroke to set the color of the border
... Use fill or background to set the color inside the object and stroke to set the color of the border
Type of declaration will take precedence:
... important decelerations in user stylesheets
... any declaration in user-agent stylesheets
... normal declarations in author stylesheets
... important decelerations in author stylesheets
When using position: fixed, what will the element always be positioned relative to:
... wrapper element
... closest element with position: relative
... the parent element
... the viewport
How would you make the first letter of every paragraph on the page red:
... p:: first-letter (color: red;}
... first-letter :: p {color: red;}
... p: first-letter {color: red;)
... first-letter:p {color:red;)
By default, a background image will repeat:
... indefinitely, vertically, and horizontally
... indefinitely on the horizontal axis only
... only if the background- repeat property is set to repeat
... once, on the x and y axis
When using media queriers, media types are used to target a device category. choice lists current valid media types?
... print, screen, aural
... print, screen, speech
... print, screen, television
... print, speech, device
When using fleebox, the "justify-content" property can be used to distribute the space between the flex items along the main axis, which value should be used to evenly distribute the flex items within the container shown below:
1 2 3 4
... justify-content: center;
... justify-content: auto;
... justify-content: space-between;
... justify-content: space-around;
CSS transform properties are used to change the shape and position of the selected objects. The transform-orgin property specifies the location of the elements transformation origin. By default, what is the location of the origin:
... the top right corner of the element
... the bottom left of the element
... the top left corner of the element
... the center of the element
The Flex-direction property is used to specify the direction that flex items are displayed. what are the flex values used to specify the direction of the items in the following examples:
1 _ 2 _ 1 3 2
4 1
...
Example 1: flex-direction: row-reverse;
Example 2: flex-direction: row;
Example 3: flex-direction: column-reverse;
Example 4: flex-direction: Column
...
Example 1: flex-direction: row
Example 2: flex-direction: row-reverse
Example 3: flex-direction: column
Example 4: flex-direction: column-reverse;
...
Example 1: flex-direction: column;
Example 2: flex-direction: column-reverse;
Example 3: flex-direction: row
Example 4: flex-direction: row-reverse
...
Example 1: flex-direction: row
Example 2: flex-direction: reverse - row
Example 3: flex-direction: column;
Example 4: flex-direction: reverse - column
The flex-direction properties is used to specify the direction that flex items are displayed. What are flex values used to specify the direction of the items:
Example 1
1 2 3 4
Example 2
4 3 2 1
Example 3
1 2 3 4 going down
Example 4
4 3 2 1 going down
...
Example 1: flex-direction: row;
Example 2: flex-direction: row reverse;
Example 3: flex-direction: column;
Example 4: flex direction: column reverse;
The following media query example, what conditions are being targeted:
@media (min-width: 1024px), screen and (orientation: landscape) {...}
... the rule will apply to a device that has a
_either a width of 1024px or wider or is a screen device in landscape mode
_width of 1024x or narrower, or is a screen device in landscape mode
_ width of 1024px or wider and is a screen device in landscape mode
_ width of 1024px or narrower and is a screen device in landscape mode
Rem unit based on ... relative to the font-size of the containing (parent) element
... relative to the font-size of the p element
... **relative to the font-size of the root element of the page
... relative to the font-size of the root element of the page
There are currently four viewport-percentage lengths used to define relative to the viewport size: vw,vh,vmin, vmax. If current viewport size has a width of 800px and a height of 600px, the follow values be equivalent to pixels:
10vw = 7px
10vh = 7px
10vmin = 7px
10vmax = 7px
...
10vw = 80px
10vh = 60px
10vmin = 60px
10vmax = 80px
...
= 8
= 6
= 6
= 8
...
= 6
= 8
= 8
= 6
...
= 60
= 80
= 80
= 60
*CSS
Declaration of precedent:
Important decelerations in author stylesheets
Guidelines type class id selectors:
use type selectors for generic or default styles : use classes to select elements more specific and reusable . use ids for unique styles global elements that are not repeated for in- page links
Media quieries media types target device category, valid media types:
… print screen speech
When adding transparency styles opacity value versus background property with rgba () value:
… opacity specifies level of transparency of an element indulging its content, background with rgba() value applies transparency to background color only
Choices are true, about class selectors, not true:
… classes used multiple times per page but not within the same element
Line-height property used for:
height space between two lines of content
properties align elements layouts like float, align global navigation bar stays fixed on top of page:
… postion
Css grid introduce new length of unit, fr, to create flexible grid tracks, Code below , what widths of three columns be equivalent pixels:
-grid {
display : grid
width 500 px
grid-template -columns equivalent pixels:
Not valid:
color: 000000
Cascading and specificity rules what color will the link be:
-example color: yellow
ul li a color blue
ul a color green
a color red
<ul>
<li > < a href “a” class “Example” “> links </a></li >
…
… yellow
values from font weight property keywords or numbers. numbers 400 regular 700 bolder:
… bold
:nth child pseudo class: style every third item: strating with item 2:
… li :nth Child (2)
li :nth Child (5)
li :nth Child ( 8 ){
Margin : 0 , 5px
Elements
- .nav (…)
- nav (…)
- #nav(…)
an element with class nav 2 a nav element 3) an element with id NaV
individual background properties represented:
background blue url (image jpg no repeat 0 0px
… background blue url image . jpg no repeat scroll opt o
… background color blue
background image.jpg
background repeat
background attachment
background position
attribute selector <A> element with <title> attribute:
a[title] (…)
Elementor
Wordpress drag and drop
Exel
*** Excel
Autosum formulas range C9:F9 below return unexpected values:
… Autosum formulas refer to the column to left of their cells
… Autosum formulas exclude the bottom row the data
… Autosum formulas include the year at the top of each column in the calculation
… Autosum formulas included own cells creating a circular reference
Columns width / font size no change columns to narrow to display all text in each cell
… wrap text
Cell contains value 7.877 and want to display 7.9:
… decrease decimal x2
Restrict values in a cell create drop down list values from which feature:
… Data Validation
Display 27,500,000 as 27.5
…
###,###,0
999.9
##,###,,
###.0,,
Formula equivalence:
… Sum(a3:a6) _ Sum (a3,….a6) _ =A3+A4…
<Hr> Tag:
… designated topic shift with paragraph level
Help system
F1
Appropriate cell headers appear A4 and B3 instead of the terms Row Labels and column labels:
… show compact form
… Compact form or Show outline form
… Tabular form or outline form
… tabular form
line chart sales trend over 12 months have little space and single cell:
… add hyperlink to another worksheet that displays a chart when clicked
Organizational chart hierarchy of a company is available as:
Smart Art
Roundup value to nearest increment, next five scents, function:
… Roundup
Returns reference to a cell (cell range) that is specified distance from a base cell:
… Offset
Table:
Col 1 Col2 Col3
first second third
… <table>
<colorgroup span=“2” style = “background -color:yellow:”>
<tr>
<th> Col 1</th>
…
…
</tr>
<tr>
<td>first</td>
…
…
</tr>
</table>
<textarea> element
… form
… readonly
… spellcheck
… max
Time based data:
… line graph
Text filter in a column A designed to display only those rows where column A entry has a particular attribute:
Product ID
… the second character in the cell is 9
Ensure shapes and objects / objects left-right equal distance, select shapes, click Page layout > Align and then click ____.
… Align middle / center
GIT
Git (/ɡɪt/) is a distributed version-control system for tracking changes in source code during software development. It is designed for coordinating work among programmers, but it can be used to track changes in any set of files.
(Adding Aliases, Bisect, Branching, Cherry Picking)
Amend: command modify previous commit --amend
Beta Notes:
Status notes beta-notes .js file
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout - - <file>..." to discard changes working directory)
Modified: Beta-notes .js
::Beta Notes Untracked Modified
Bisect: Find Git bug - no history: use git bisect to compare the buggy commit to an early commit that works as expected
Custom Shorthand
Envelope: Use Git custom-key command
Clone:
1. clone existing git repository: copy repository local machine
2. Command near-exact copy: Git Clone <url>
Commits: Assign several commits to single task, restructure commit history: squash related commits together into single coherent commit
Command structure: Snapshot
Commands:
1. finds HEAD of the current branch: Git show-ref -- HEAD
2. Changes Master Branch on remote repository origin & merges them to the local checked-out branch: Git Pull Origin Master
Configuration: file store: local/global repository options
Files:
1.list modified/added to specific commit over project course: run GIT commit
Full tree: full tree option added to Git ls-tree object listing isn't limited to files in the working directory
Gitignore: Execute untracked files w/in working directory from Git repository: add a pattern matching the files to the: gitignore.file
HEAD: pointer most recent commit currently checked out branch
Hook: validate commit message contains ticket message: prepare commit-msg
Merging: merge 2 branches commit changes next step : Run git branch -d<branch new>: to delete merge branch
Push Command:
1. tags are pushed to remote repository w/ respective commits
2. after push commits to remote repository for 1st time using command git -u organ master
_shirthand command: "Master"
Rebase:
Git Rebase -i Head =-10
delete last 10 commits & reset HEAD
Reset:
1. Git reset - - hard HEAD 5
Git Merge - - Squash HEAD @ 1
Resets HEAD for 5th commit in repository then merges to master
2. Alter current checked out branch - git reset - soft HEAD: soft remove last commit: it sets HEAD to the previous commit & leaves changes from the undone commit in stage/index
Reflog:
1. default setting: show
2. reflog site: updates to branch tips & references local repository
References: refs
Remove: after staging changes to several files, changing configuration properties = incorrect & need removal from stage & working directory: command remove staged changes to file: GIT RM configuration properties
Save Files: modifying file but assigned bug fix at another branch, save w/o commit: use git stash to save work for later & reapply stashed commit
Staging Area:
1. files stored before they are committed to local repository
2. Command changes staging area file: get
*** Git
bug in commit history:
… use git bisect compare buggy commit to early commit that works as expected:
feature branch Get revere , recurring image merge conflict:
… “revere.enabled” not enabled in config file
… git search -diff to compare all commits in your repository history
Git Repository History command:
git reset - -soft HEAD^
Undoes last commit in working branch and sets the HEAD back one commit
Changes to tracked file: command
Git commit -a -m “refactor code base”
adds all modified files to staging area then commits with message
Command print to terminal:
git remote -v
list remote repositories connected to
Command
Git checkout feature - user - location
git cherry - pick {af5597c296…}
commit being copied from the feature user location branch to the master branch
Files .getignore programmed to leave out:
# .swift
build/
.txt
.metadata
all files in build directory as well as files ending with .txt or .metadata
Command creates connection between local and remote repository:
git remote add origin
PreRecieve hook on remote repository
… invoke a hook script when commits are pushed out before any references are updated
Command
Git Add -A
Add new files are staged
How squash multiple commits together without using git merge - - squash
Rebasing
Apply git configuration across your entire git environment:
- - global
Git Commands below and determine what the operation doing:
$ git bisect start
$ git bisect bad knekwnweioqin
$ git bisect good ossjsbjsjnss
Making commit bad for later decision
Create new Git Depository
… Git Init
Output
$Git Pull
Get reset hard
Git pull topic branch
$git reset
A revision and reset
Google Cloud Platform
Google Cloud Platform, offered by Google, is a suite of cloud computing services that runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail and YouTube.
Command adds a column family named cf1 to bigtable table named my-table:
... gcloud createfamily cf1 my-table cf1
... cbt create family cf1 my-table
... cbt createfamily my-table cf1
... gcloud createfamily my-table cf1
Object used to hold payment information for a GCP project:
... organization
... **billing account
... folder
... payment account
Set a Wordpress site with high availability on GCP using the fewest steps:
... create, configure, and launch a Wordpress HA deployment template on Compute Engine
... ....on google kubernetes engine
... configure and launch the Wordpress HA deployment template from the GCP marketplace
... from the Wordpress Market place
Quickly evaluate Cloud Filestore. Steps, in order to set up a test environment:
...
1. Create a compute engine VM to be the client
2. Create a Cloud filesstore instance
3. Mount the fileshare from that instance on a client VM instance
4. Create a file on the mounted fleshare
...
1.
3.
4.
...
2.
3.
1.
4.
...
2.
3.
4.
1.
Configure services to be able to perform a regular interactive query of Google Adwords data:
... Plan use cloud SQL. create cloud SQL database to hold the data
... Plan use cloud SQL. Enable cloud SQL transfer data API
... Plan use BigQuery. Create a bigQuery data set to hold the data
... Plan use BigQuery. Enable BigQuery Transfer Data API
Object is a container for GCP services instances:
... Folder
... Project
... Organization
... **Group
Needed to access GCP APIs in your project:
... GCP VMs
... **GCP credentials
... GCP users
... GCP buckets
Set up a managed Apache Spark cluster, service configure:
... cloud dataprep
... cloud composer
... cloud dataproc
... cloud dataflow
Designing security for an IOT device application, best practices should you include in design:
... use a public private key pair for each device. keep the private key secret
... use a public private key pair to each device. keep the public key secret
... use a private key for each device. keep the private key secret
... use a public key for each divorce. keep the public key secret
Schedule a corn job to send a message to a cloud pub/sub topic hourly:
... create a cloud scheduler job with a target of cloud pub/sub
... create a cloud function with a target of cloud pub/sub
... create a cloud function with a target of http
... create a cloud scheduler job with a target of http
Automatically perform security scans on user-developer containers. Where advise users to host their containers:
... Google Container Registry
... Artifactory
... Docker Hub
... GitLab
Need to create instances with identical configurations that cannot be changed, which computer engine features use:
... Snapshots
... instances
... instance templates
... instance groups
GCP organization are not available in your GCP project. What type of account using:
... Free tier
... Temporary
... Local
... organizational
What set up in order to query data stored in Cloud SQL using BigQuery:
... connection to BigQuery in Cloud SQL and a custom role with permission on cloud SQL and BigQuery
... connection to BigQuery in cloud SQL and a custom role with permission on cloud SQL
... connection to Cloud SQL in BigQuery and a service account with permission on Cloud SQL
... connection to Cloud SQL in BigQuery and a service account with permission on cloud SQL and BigQuery
Which Command copies a file named test.txt to a cloud storage bucket named my bucket:
... gcloud cp test.txt gs://myBucket
... gsutil cp gs://myBucket test.txt
... gustily cp test.txt gs://myBucket
... gcloud cp gs://myBucket test.txt
Hadoop
Apache Hadoop is a collection of open-source software utilities that facilitate using a network of many computers to solve problems involving massive amounts of data and computation. It provides a software framework for distributed storage and processing of big data using the MapReduce programming model.
Signed HTTP
Hadoop Auth enforces authentication on protected resources. Once Authentication has been established, it sets what type of authenticating cookie:
In a MapReduce job, the map () function run:
... on the data nodes of the cluster
... on every node of the cluster
... ** on the reducer nodes of the cluster
... on the master node of the cluster
Hadoop Core Supports CAP Capabilities:
Consistency , Availability, Partition Tolerance
HQL queries produce job types:
... Spark
... Impala
... Pig
... MapReduce
HBase works with type of schema enforcement:
... schema on write
... external schema
... ** schema on read
... no schema
Kind of Storage and processing does Hadoop support:
... ** Distributed
... verified
... encrypted
... remote
Configure the size of a block in a Hadoop environment:
... ** hfs.block.size in hdfs - site. xml
File system does Hadoop use for storage:
Hadoop Distributed File System (HDFS)
Type of Software is Hadoop Common:
... ** distributed computing framework
Hive Query returns the first 1,000 values:
... Select Top 1000...
... Select ... Where value = 1000
... Select ... Limit 1000
... ** Select MAX 1000...
If no reduction is desired, set the number of __ tasks to zero:
... Reduce
The Mapper map input key/value pairs:
... set of intermediate key/value pairs
Library should be used to unit test MapReduce code:
JUnit
If start the NameNode, then user must:
... **Hadoop-User
... Super-user
... admin-user
... node-user
___ Is the query language, and ___ storage for noSQL on Hadoop.
... ***SQL HBASE
... HQL, HBASE
... HDFS, SQL
... HDFS, HQL
HTML
HTML (HyperText Markup Language) is the most basic building block of the Web. It defines the meaning and structure of web content. Other technologies besides HTMLare generally used to describe a web page's appearance/presentation (CSS) or functionality/behavior (JavaScript)
Best semantic markup for the sentence:
On July 21, 1969, Neil Armstrong said, "One small step for man, one goat leap for mankind."
... <p> On July 21, 1969, neil armstrong said, <q cite="https:..www.hq.nasa.gov.alsj/all/all.st ...
... <p> On july 21, 1969, Neil Armstrong said, <q> " one small step for man, one giant leap for man...
... <p> On <time datetime = "1969-07-21">July21, 1969</time>, Neil Armstrong said, <q cite="http...
... <p> On <time datetime="07-21-1969"> July 21, 1969</time>, Neil Armstrong said, <q cite="http
Code: target:
<a href= "http://www.linkedin.com" target="_blank">Visit Site</a>
... an attribute
... content
... an element
... a tag
In HTML5, which tag or tags embed a webpage inside of a webpage:
... <frame>
... <frame> and <frameset>
... <iframe>, <frame>, and <frameset>
... <iframe>
Code below, purpose of the lang attribute
<p lang="en-GB">Welcome to our wonderful website.</p>
... it establishes the language for the website - in this case, english
... it establishes the language for the paragraph- in this case, British English
... it establishes the language for the website - in this case, British english
... It establishes the language for the paragraph - in this case, English
Code a comment in HTML:
... <!-- this is a comment -->
Code: purpose of defer:
<script defer src="my script.js"></script>
... it downloads the script from the server when resources allow
... it runs the script after HTML parsing is complete
... It pauses the parsing of HTML code while the script runs
... It runs the script when it is ready
Tag was not deprecated in HTML5:
... <acronym>
... <bgsound>
... <frameset>
... <bdi>
Purpose of <caption>
... <caption> provides captions for <img>, <audio>, and <video>
... <caption> provides captions to <table>
... <caption> provides captions for <audio>, <video>, <img>, and <table>
... <caption> provides captions for <audio>, <video>, and <table>
<Audio autoplay loop src="sound.mp3" type="audio/mpeg"></audio>
... The browser plays the sound once automatically in the background. The user has not control over the sound
... the browser plays the sound automatically and continuously in the background. The user may stop the sound at any time
... the browser plays the sound automatically and continuously in the background. the user has no control over the sound
... *** when the play button is pressed, the browser will plays the sound over and over agin until the user stops it
Confirm that document is written in HTML5:
... the server wraps the webpage in an HTML5 wrapper
... *** use the <!DOCTYPE html> declaration that strats the document
... the browser receives encoding from the server to display the document with HTML5
... it is enclosed in a <html> tag
Which snippet of HTML, when clicked, makes a phone call on a mobile device:
... <a href = "tel :802-555-1212"> Call me</a>
... <a href = "phone">802-555-1212</a>
... <a href = "tel">802-555-1212</a>
... <a href = "phone: 802-555-1212"> Call me</a>
Review the code below, what's the best was to a nest a two-call table inside of Cell 2
<table>
<tr>
<td>Cell 1</td>
<td>Cell 2</td>
</tr>
</table>
...
<td>Cell 2</td></tr></table>
<table>
<tr>
<td>Cell A</td>
<td>Cell B</td>
</tr>
</table>
...
<td> Cell 2
<table>
<tr>
<td>Cell A</td>
<td>Cell B</td>
</tr>
</table>
</td?
...
<td> Cell 1</td>
<table>
<tr>
<td>Cell A</td>
For the HTML code below, when will "sample text" display to the browser
<noscript> sample Text </noscript>
... when Javascript is not supported by the browser of if javascript is disabled in the browser
... when there is no javascript used on this webpage
... when javascript is not supported by the web browser
To get a link to open in new window or tab, use the ___ attribute.
... *** _blank
Review the code below: best way to include sub navigation for link 2 tat includes a link:
<nav><ul>
<li><a href = "#" > Link 1 </a></li>
<li><a href = "#" > Link 2 </a></li>
<li><a href = "#" > Link 3 </a></li>
</ul></nav>
***HTML
<aside> element:
… when content removed without detracting from pages message
DOC HTML5 written:
… Use <!DocType html> declaration starts doc
<Header> <footer> tag
… Body article section tags
Result:
<picture>
<source srcset= :image1.jpeg
media=“(min-width: 1000px)”>
<Source SRCset =image 2.jpeg
… it displays image 1.jpg at 1000px higher and image2.jpg at 750px and higher. image3.jpg at default <picture> is not supported
Result
<p itemscop ___ ____>
… itemprop=“aggregaterating” itemtype=http://schema.org//aggregaterating”
Result
<address _____ ______>
<span itemprop = “street address”
… itemscope item ref = “http://schema.org/postaladdress
Result
<a href =“https://es.yahoo.com/“ hreflang= “ ______ “ target = “ blank” Visita Yahoo <a/>
… es - es
Snippet
Links back to top of webpage:
… <a id=“top”></a> <!—placed at the top of the page - - > <a href=“#top” >back to top </a>
Tag embed a webpage inside a webpage:
<Iframe>
tag <kdb> tag making up short code snippet, while the <mark> tag marking up longer block of code
Depreciated tags HTML4 and returned HTML 5
… rb , rt, rp
Value attribute associated with tags:
input option textarea
...
Hunter
Hunter for Chrome. Hunter's Chrome extension lets you immediately find the email addresses behind the websites you're browsing.
iMovies
iMovie is a video editing software application developed by Apple Inc. for macOS and iOS devices. It was originally released in 1999 as a Mac OS 8 application bundled with the first FireWire-enabled consumer Mac model
Which color in the audio waveform indicates clipped audio:
yellow
Which button do you use to create picture-in-picture side effects:
Video Overlay settings
Which Filtering method is applied to the browser:
... rejected
... favorites
... all clips *
... Hid Rejected
Which color balance option relies upon using two clips:
... Auto*
... White Balance
... Match Color
... Skin tone balance
Which item cannot be selected in the browser and marked as a favorite:
... multiple ranges
... multiple clips
... range
... clip
Which movie format has the highest resolution and image quality:
H264
Which type is most commonly used to identify the speaker in the video clip:
... lower third *
... four corners
... standard
.... scrolling credits
Which button lets you access the Choose Clip Filter browser:
Cropping
Which button can help easy check full name of selected video clip:
... iMovie
... Information
... Media
... Cropping
Which option lets you make a voice sound sped up, but still keeps audio and video in sync:
... Cosmic
... Pitch Up
... Auto Tune *
... Pitch Down
When adjusting a contrast clip, what is mainly affected:
light and dark clips
Sharing a video on YouTube, perform the video from appearing in search, but want anyone with the URL to be able to watch the video, which privacy method should you choose:
Public
To adjust the intensity of color in a clip, what slider use?
... Saturation
... Color Temperature
... Multi slider Controls
... Vibrancy
No Templates in the titles browser, fix:
... change your theme
... resize the application window
... click the x in the search box to reset the filter controls *
... close and reopen the tab
What is the default duration for a title placed between two clips:
... 2*
... 4
... 8
... 10
Java
Java is a general-purpose programming language that is class-based, object-oriented, and designed to have as few implementation dependencies as possible
ArrayList of names sort alphabetically, Not work:
... names. sort (comparator.comaring(string::toString))
... names.stream().sorted((s1,s2)((s1,s2)->s1. compareTo(s2)).collect(Collectors.ToList())
... Collections.sort(names)
... names.sort(list.Descending)
Code use to tell if 'schwifty" is of type string:
... "schwifty" .getClass () .getSimpleName () == "String"
... "Schwifty" .getType () .equals ("string")
... "Schwifty" instanced String
... "Schwifty" .getTytpe () == String
Achieve runtime polymorphism in Java:
Method Overriding
Output of code:
class Main {
public static void main (string [] args) {
int a = 12345 12345 12345;
System.out.println (a);
}
}
... "1234510000"
... negative integer value
... Nothing - this will not compile
... "123451234512345"
Result of code:
1: Class Main {
2: Public Static void main ( string [] args) {
3: System.out.println(print(1));
4: }
5: static Exception print (int i) {
6: if (i>0) {
7: return new Exception ();
8: }else {
9: Throw new RuntimeException ();
10: }
11: }
12: }
... not compile
... it will show a stack trace with a runtime exception
... "java.lang.exception"
... It will run and throw exception
The runtime system starts your program by calling which function first:
... main *
... iterative
... hello
Letters will print when this code runs:
public static void main (String[] args) {
try {
system.out.println("A");
bad method ();
System.out.println("B");
} catch (Exception ex) {
system.out.print.ln ("C");
} finally {
system.out.println ("D");
}
}
public static void bad Method() {
throw new Error ();
}
... A D
... C D
... A B D **
... A C D
Which is the most up-to-date way to instantiate the current date:
... new SimpleDateFormat ("yyyy--MM--dd"). format (new Date())
... new Date (system.currentTimeMillis())
... LocalDate.now()
... Calendar.getInstance().getTime()
Program print out to the console when executed:
import java.util.LinkedList;
Public class Main {
Public static void main (string [] args) {
LinkedList <Integer> List = new LinkedList <> ();
list.add (5);
list.add (1);
list.add (10);
System.out.println (list);
}
}
... [5,1,10]
... [10,1,5]
... [10,5,1]
... [1,5,10]
By implementing encapsulation, cannot directly access the class's ___ properties unless writing code inside the class itself:
Private
Code tell int0 is divisible by 5
boolean isDivisbleBy5 =
... int0 % 5 ! = 5
... int0 / 5 ? true; false
... into0 % 5 == 0
... Math .isDivisible(int0, 5)
Output of code:
1: class Main
2: public static void main (string [] args) {
3: string message = "hello";
4: for (int i=0; i<message.lenght(); i++) {
5: system.out.print (message.charAt (i+1));
6: }
7: }
8: }
... Runtime exception is thrown
... Code does not compile
... "hello"
... "ello"
Normally access a static member of a class such as Math.Pl, need specify class "math." What would be best was to allow simply "PL" in code:
... Declare local copies of the constants in your code *
... put the static members in an interface and inherit from that interface
... add a static import
... cannot be done, always qualify references to a static members with the class form which they came
Displayed code complied and executed:
import java.util.HashMap;
public class Main {
public static void main(string[] args {
HashMap<string, Integer>pantry = new HashMap <> ();
pantry. put ("apples", 3);
pantry.put (oranges", 2);
int currentApples = pantry .get("apples");
pantry .put("apples", currentApples + 4);
System.out.println (pantry.get("apples"));
}
}
... 4 *
... 7
... 6
... 3
What Method signature will work with this code:
boolean healthyornot = is healthy ("avocado");
... private string is healthy (string food)
... public void is Healthy(string avocado)
... boolean is healthy (string String)
... public is Healthy ('Avocado")
Java Script
JavaScript, often abbreviated as JS, is a programming language that conforms to the ECMAScript specification. JavaScript is high-level, often just-in-time compiled, and multi-paradigm. It has curly-bracket syntax, dynamic typing, prototype-based object-orientation, and first-class functions.
Result of statement:
console.log(typeof (42));
... 'integer'
... 'float'
... 'value'
... 'number'
Variable is an implicit for every function in Javascript:
... args
... argumentsList
... arguments *
... argsArray
Match time value such as 12:00:32, regular expression works for code
... /[^0-9]+[^0-9]+:[^8-9]+/
... /:/:/
... /\d/d:\d\d:\d\d/
... /[0,9]{2,}:[0,9]{2,}:[0,9]{2,}/
Incorrect way define an arrow function that returns an empty object:
... () => {}
... () => { return {}; }
... () => (({}))
... () => ({}) **
Operators can be used to do a short-circuit evaluation:
... l l **
... \--
... \++
... \==
Keyword used to create an error:
... throw
Method converts JSON data to a Javascript object:
... JSON.toObject()
Attempt to call value as a function but the value is not a function, what error:
... TypeError
Method cancels an events default browser:
... preventDefault()
Valid example for arrow function:
... a, b => {return C;}
... a, b =>c
... (alb) =>c
... {A,b} =>c
Wrong line of Code:
... let result = if javascript, the if keyword starts a statement, not an expression
... You can't use the let keyword in a top-level scope
... the == operator is not a valid one in JavaScript
... Javascript requires new lines after curly braces and semicolons
Objects and functions in Javascript:
... Every function is an object
... Only pure functions are objects
... Every object is a function
.. A function always returns an object *
Difference between async and defer attributes of the HTML script tag:
... Defer attribute can work synchronously
... Defer attribute works only with generators
... Defer attribute will asynchronously load scripts in order
... Defer attribute works only with promises
Methods is special in Javascript class definition:
... Render
... Constructor
... Create
... New
Event is fired on a text field within a form when a user tabs to it, or clicks or touches it:
... blur
... focus
... hover
... enter
*** Javascript
AddTax: function and passes 50
… addtax(50)
Closure:
… It returns a reference to a variable in its parent scope
Consecutive values: code log set CV but instead results in value 5,5,5,5 being logged to the console, which version code result values 1,2,3,4 being logged:
… While (var i = ..
Conditional Statement:
When want code to choose between multiple options
Written event listener for form button but each time click button page reloads, statement stop happening:
button.addEventListener(‘click’, function(e) {
button .classname = ‘clicked’;
}. false );
… button OR e.preventDefault();
DOM node created by code:
<p class =“pull”>lorem ipsum </p>
… Document.querySelector(‘.pull’);
Final statement of code be logged in console:
Let modal = document .Query Selector (‘#results’);
setTimeout (function() {
modal.classlist.remove(‘hidden’);
} 10000);
console.log(‘results shown’);
… immediately
Foreach different from for:
… A statement is generic, but each forEach statement used only with array
Person Constructor: create new object
… Var student = new person();
Person constructor as the parent of the student constructor prototype chain:
… Student.prototype = new Person();
Result console running code shown:
var.storm = function () {};
storm.prototype.percip = ‘rain’;
var WinterStorm. Prototype = new storm ();
Winterstorm.prototype.percip. = ‘snow’
var bob = new Winterstorm ()
console . log(bob.percip);
… storm()
… undefined
… rain
… snow
Result console running code:
“use strict”;
function logthis() {
this.desc = “logger”
console.log(this)
}
new logthis();
…. undefined
Result:
console.log(typeof (42));
… integer
Regular Expression match time value 12:00:32
… /\d/d/d/d/d/d/
Variable called rate assign value 100:
… let rate = 100;
JQuery
jQuery is a JavaScript library designed to simplify HTML DOM tree traversal and manipulation, as well as event handling, CSS animation, and Ajax. It is free, open-source software using the permissive MIT License. As of May 2019, jQuery is used by 73% of the 10 million most popular websites.
Given this checkbox, how can you determine whether a user has selected or cleared the checkbox:
<input type="checkbox" id="same-address" checked>
... by checking the value of $('#same-address') .Prop('checked')
... _______ .checked
... _______ .val()
... _______ .attr('checked')
Line of code: jQuery('p');
... aliases jQuery variable p
Given this HTML code, how an you use one line to show the button if it is hidden, and hide it if it is visible:
<Button class="btn-primary" type="submit">Continue to checkout</button>
... $('.btn-primary') .not(':visible').show(); **
... $('bin-primary') .showhide();
... $('btn-primary') .toggle();
... $('btn-primary') .css({display: 'block' });
Page with one link: change the anchor tag so it links to example.com:
... ... $('a')
... .attr('href', 'http://www.example.com')
... .attribute ('href', 'http://www.example.com')
... .data('href', 'http://www.example.com')
... .href ('http://www.example.com')
Given this HTML code, make the button diessaper from the page:
<button class="btn-primary" type="submit">Continue to checkout </button>
... $('.btn-primary') . hide(); or .visibility(false); or .show(false);
... $('.btn-primary:visiblility') .not();
How select the following blockquote and the list in a single call to jQuery()
<div class = "quotes">
<blockquote data - favorite =
____repeat 4X__________ "false" >A quote/blockquote>
______________________ "true">A Favorite quote</blockquote>
______________________ "false" >A quote </blockquote>
______________________ "false">A quote</blockquote>
</div>
<ul class="menu-first">
<li> item 1</li>
<li> item 2</li>
<li> item 3</li>
<li> item 4</li>
</ul>
... $('.quotes' + '.menu-first')
... $('quotes, .menu-first')
... $('quotes + menu-first')
... $(quotes .menu-first')
Difference between the two lines the follow the html snippet:
<ul>
<li>item 1<li>
... 2
... 3
... 3 </li>
</ul>
$('ul') .find('li').get(2);
$('ul') .find('li) .eq(2);
... .get() retrieves a
__ DOM element and is 0-indexed .eq() retrieves a jQuery object and is 1-indexed
__ DOM element can cannot be chained .eq() retrieves a jQuery object and can be chained
__ jQuery object and can be chained .eq() retrieves a DOM element cannot be chained
__ jQuery object and is 0-indexed .eq() retrieves a DOM element and is 1-indexed
What is the difference between $('header').html() and $('header').text()
... $('header').html() returns the inner HTML of the header. $('header') .text() returns only the text
... $('header') .html() returns only the HTML tags used, without the text .$('header') .text() returns the text with all whitespace removed
... $('header') .html() strips all HTML from the header. $('header'). text() always return an empty string
... $('header').html() returns all header in an HTML document .$('header') .text() returns the first line of a text file
Have a ball that is created from an HTML element (id=ball) move down and to the right from its original location when clicked, and move back into its original place when finished. What snippet, added to the code below, would do this:
... $('#ball').click(function() {
// our code goes here
});
... $(this).animate({
top '+=100',
left: '+=100',
},{
duration: 600,
complete: function () {
$(this) .animate ({
top: '-=100'.
left: '-=100',
},600)
}
});
... $(this) .animate ({
top:100,
left:100,
}, 600, function () {
$(this).animate({
top:0,
left: 0,
}, 600)
});
What does $() mean in jquery
... utility function that selects the last element from the document
... alias to the main core method of jquery itself - the same as writing jQuery () **
... utility function that selects the first element in the document
... shorter way to write the document .getElemenetbyID()
Following page snippet includes a couple messages in a list, and a code snippet that retrieves a few hundred messages from an API endpoint using AJAX. how can you add these new items to the .message-area--list the element the most performant way:
<div class="message-area">
<ul class = "message-area--list">
<li> existing message 1</li>
<li> existing message 2</li>
</ul>
</div>
... $.get('//example.com/api/v1/messages')
.done(function(data) {
var tonsOFfitems = data.messages;
// add all these messages to a large page });
... tons of items.map (function(item){
$('.message-area--list').append'<li>'+item+'</li>');
});
... $each (tons of items , function (idx , item) {
$('.message-area--list').append('<li>'+item+'<li>');
});
... css. $messagelist = $('.message-area--list');
$.each(tonsOfitems, function(idx, item) {
$('<li>' +item+'</li>') .appendTo ($messagelist);
});
Best practice for including the jquery script into a web page:
... include it in the <head> tag because you want jQuarry available as soon as possible
... include it using the highest version number possible, because only jQuery 3 and later a re compatible with internet
... include it from a CDN, because you want to be able to use jQuery online or off-line
... include it just before the closing <body> tag, because you want to avoid blocking other resources from loading, and you use the ready () method to make sure your code fires after the DOM is ready
Tricky about jQuery nth-filter (:nth-child, :nth-of-type, etc.) relative to other filters:
.... they don't return the jQuery object, and cannot be chained
... they are not part of CSS so they don't get the performance benefits of passing through to document.query selectorALL
... they can return the wrong items if the DOM was recently manipulated
... referring to lists of items, they are 1-indexed (like CSS), not 0-Indexed (like JavaScript)
Absolutely positioned element inside a relatively posited parent element, and you want to animate that element within its parent element. What jQuery function is most useful is for finding the initial coordinates of the .animate-me:
<style>
.parent {
position : relative;
top: 3em;
width:50%;
min-height:50vh;
margin: 0 auto;
}
.animate-me {
position: absolute;
top: 40px;
right: 30px;
}
</style>
<div class = "parent">
<div class = "animate-me">
This box will move!
</div>
</div>
... $('.animate-me') .offset();
... $('.animate-me') each();
...
...
Given the set of checkboxes, how can you select the ones that have the phrase "sun" as part of the value:
... input type= "checkbox" name="artists[]" value= _______
_ value = "sun-ra">
_ value = otis-redding">
_ value = "captain-beefheart">
_ value = "king-sunny-ade">
_ value = "weather-report
... $('checkbox') .val(/sun/);
... $('input[value*="sun"]');
... $('input:checkbox') .attr('value', '*sun*');
... $('input[value l = "sun"]');
JSON
JavaScript Object Notation (JSON, pronounced /ˈdÊ’eɪsÉ™n/; also /ˈdÊ’eɪˌsÉ’n/) is an open standard file format, and data interchange format, that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and array data types (or any other serializable value).
Key name used to specify data type in a JSON schema: type
Term commonly used to refer to converting data to json: serialization
Data type is part of the JSON standard: *boolean
Value is supposed in the JSON specification:
... Infinity
,,, NaN
... *Null
Undefined
Supported by YAML but not supported by JSON:
... Null values*
... Nested
... Arrays
... Comments
Assemble list of team members but JSON is not parson correctly.
{
"avengers" : [
"iron man",
"hulk",
"Thor",
"black widow,"
"ant man",
"spider man'
]
}
Code is valid JSON equivalent of the key/value pair shown that also preserves the original value:
UPC: 043875
UPC: "04"
"UPC" : 04
Technique use to safely encode very large numbers:
... convert the number into an exponent
... store the number as a string *
... split the number into smaller parts
.... round the number to the nearest 10-digit number
JSON represent truth, falsity, and nullness:
... true false null
Assign a number value in JSON:
... Escape the number with a backslash
... Enclose the number in single quotes *
... Leave the number as is
... enclose the number in double quotes
Character separates keys from values
... ->
... .
... : *
... ::
Character used to define an object:
... []
... () *
... {}
... ll
Key format is valid JSON:
... "key":'value'
... "key":"value" *
... key:"value"
... key,"value"
*** Json
code of constant 6.022 =
… “contant” “6.0233”
Valid Json = (photo w h binaries url thumbnail animated tags)
…
By convention name first key in json schema:
… Schema
Data type represented by value key value /pair
true false boolean
object {}
String “” “”
Code correct json syntax key value pair: accountnum: ‘000652’
… “accountnum”: 00036
JSON support:
Null
Element added DOM JSON p request:
script
character specify control character as literal part of string:
\
Method converts javascript value to json:
json.stringify ()
Key name specifies properties that must be included to json:
Required
Which data type not pat of JSON standard
Date
Store serval paragraphs text JSON
expect whitespace expect spaces characters
Method javascripts method converts JSON to Javascript
Json.parse
Transfer JSON info to client to server and back again often includes HTTP requests:
… Post , put, header, options, get, delete
refer to converting data to json:
… serialization
Keynote
Apple Keynote is slideshow presentation software that features an elegant and easy-to-use interface. You'll be creating great presentations in no time. It's built into Mac computers, making it a great choice for Mac users. Also, Keynote files can easily be converted to Microsoft's PowerPoint if necessary.
Smooth the appearance of animations within a presentation:
Click Keynote > Preferences, select slideshow tab, select scale slideshow to fit the display
Video format suited for use with Keynote: MP3
Modify data for a chart: edit data button
Present slideshow, process to next slide: m p >
Invite multiple users to make edits to the same document: click share > collaborate
Present Keynote slideshow: display script of similar information that only you can see: Use the presenter Notes view
Chart you manipulate during a presentation to change the information that is displayed:
... Live Data
... 2D
... 3D
... Interactive *
Animation effect controls how an element leaves the screen:
build out
Paste text into a presentation while simultaneously applying the destination themes formatting:
.... Click edit >
_ paste plain text
_ Paste and match style *
_ Paste
_ Paste Formula results
Export file, powerpoint file type is considered most modern: PPT
Clock and countdown timer to display only you, while giving presentation: Click Keynote: Remotes tab
Chart Appearance:
Lighting
Chart type shows two fields of data in a single shape:
stacked column
Files > import audio file, come to track: select track
Interface element allows for easy to access movies, audio files, photos:
document inspector
media browser window
object list window
Keynote Presentation but new look, Change theme
... Edit Master Slides
Logic Pro
Logic Pro is a digital audio workstation and MIDI sequencer software application for the macOS platform. It was originally created in the early 1990s as Notator Logic, or Logic, by German software developer C-Lab which later went by Emagic
Use plug-ins and processing power low, besides printing audio of the track, preserve processing power on tracks with plugins do not need to be automated:
... select track header components > Show freeze and freeze track which not need automate plugins
Indicator show advanced tools check box not selected, result in beginner mode:
... Project name contains the extra .beg
... Main window is a light shade of green
... Toolbar light shade of green
... Slides of the main window resemble wood panels
Smart Tools:
... MIDI Editing Tools*
... The alchemy morphing controls
... Alchemy Morphing piano
... Representation of Transform pad found in simple panel of Alchemy
The Flex Time features accessed be the track header of the main window by doing:
... Resetting the anchor point or a region
... Opening project settings
... pressing shift + Command + N
... Clicking the show/hide flex button
Output fader clipping during mix:
... turn speaker monitor level down
... change the but depth
... cumulative levels of all your tracks is to high
... turn output fader down
Editing window select group of MIDI Notes and trimming all same time:
... Piano Roll
... Smart Tempo*
... Environment
... Score
Important to save project before recording audio:
... have access advanced recording modes
... engage cycle mode easily
... make sure record button can be enabled
... the recorded files go into a project folder associated with project
Create a send an available bus:
... get automatic delay send
... get automatic reverb send
... audi leaves your interface to an outboard piece of gear
... aux track with its input set to that bus automatically created
Recorded MIDI Bassline on software instrument track containing an ES2 synth, it is not perfectly in time, alter timing part:
... the flex tool
... Quantization
... beat mapping
... Arpeggiator
When you drag an audio file from from the Finder to empty space to the empty space in the main window:
... new audio track created named after that file
... logic will not allow function
... software instrument tracks auto-mute
... warning dialog box asks where save file
Expect to hear based in the settings of the drummer editor:
... just shaker and handicaps
... four on the floor beat
... only snare drum
... electro beat
Type "r" start recording onto a retro synth software instrument track from your attached MIDI Keyboard, but nothing is coming into track:
... software instrument tracks contain only audio
... "R" does not showing the advanced tools
... Not showing advanced tools
... track was not selected and armed
Order signal flow through the plugins:
... first the reverb, then auxiliary
... depends on how set up audio settings in project settings
... first compressor, then the EQ
... First EQ , then compressor
Ready to bounce two-hour movie mix, but bounce the audio as a WAV and as a MP3 at the same time:
... No
... Yes, set up two separate output faders with the different destinations set in the output
... Yes, choose PCM and MP3 destinations in the File>blounce>project or selection
... Yes bounce a second time to make a separate file
Maven
Maven is a build automation tool used primarily for Java projects. Maven can also be used to build and manage projects written in C#, Ruby, Scala, and other languages. The Maven project is hosted by the Apache Software Foundation, where it was formerly part of the Jakarta Project.
The primary purpose of maven is to provide uniform, easy, and standardized:
Project Structure
Building a web application with a WAR type project, which project directory contains style sheet, Javascript, and other static files:
src/main/webapp
Building a maven EAR project and specifying the configuration of which projects to include, what is the element in the plugin configuration that contains Enterprise Java Bean Projects:
... modules ....
... /webmodule
... /ejModule ***
... /enterpriseModules
... /services
The MVN --version command do;
print out installed versions
The Goal that is executed to generate and deploy a documentation website is:
... deploy *
... Deliver
... Doc
... site
Several properties for use in a pom.xml file that refer to details of the project, such as a groupid and version. All Properties start with:
... Jar
... Project
... Pom
... maven
Delivery structure contains the source code if your artifact:
,,, src/code **
... src/main/resources
... src/main/java
... src/test/java
Performing a build. Maven plugin allow you to set the specific version of the artifact to be built without mannually modifying the pom.xml file:
... Versions ***
... Surefire
... Compiler
... Javadoc
Element in the pom.xml file allows you to provide values that can be reused in other elements of the pom.xml:
... Parent **
... Properties
... Plugins
... Build
Default scope for maven dependencies:
... runtime
... build
... test
.... compile **
Valid packaging type for Maven Project:
... Ear/pom/war
Build maven archetype, what is the file path and file of the archetype descriptor that specifies how to lay out the prototype files:
... src/main/
... Resources/
... archetype/
...archetype/-Meta-INF/Maven/
... Maven/ Maven-archetype.xml ***
... Maven/archetype-decriptor.xml
Two dependencies of Maven project introduce the same transitive dependency with different versions, which one will be included in the dependency list fo your project:
... transitive decency that comes from the decency listed first in the pom.xml file
... transitive dependency comes form the decency listed last in the pm.xml file
... transitive dependency version of the artifact that is closest to your project
Want to utilize a locally developed JAR file in another project and JAR file has not been deployed to either the Maven central repository or your own locally sourced mirror repository, what Maven goal to you need to execute on the locally developed JAR Project:
... compile
... install
... package
... test
Build and package artifact using the Mayen package goal but don't want to execute the unit tests which environment variable nad value would you use:
... maven.test.skip=true **
... maven test.ignore=true
... maven. verify.execute=false
... maven.test.run=false
*** MySql
MySql
Created Table add rows : syntax:
… Insert into employee (“first” , “last”
Table any record added to purchases table consists of customer id exists on customer id and car id in the car able: better method than trigger:
… Default constraint
Temporary table over heap table:
… temporary table dropped when database restarted
Remove record:
… Delete From
modify data record from table:
… Update
Export database”
Mysqldump
common table express name ____ single scope statement referred later within statement:
Temporary result set
table store passwords for user accounts:
… My sql user
Export data customers table to CSB, secure file deprive file enabled:
…
Powerful method programming stored procedure cursor , set rows returned by query and process each row when working with cursor also declare:
… Not found handler
generate list customers purchase car last year:
… between
make exact copy table cilimm index data, find info about copied table:
… Show create table
Exists current MySQL:
… Quit
Limitation MySQL Workbench:
… limits access server information
Results best performance bulk insert database:m
Load data local info
Maya
Autodesk Maya, commonly shortened to just Maya, is a 3D computer graphics application that runs on Windows, macOS and Linux, originally developed by Alias Systems Corporation and currently owned and developed by Autodesk
Physically based renderer such as Arnold, material attribute controls reflectivity according the angel of the surface to the camera: Example: if you want to make the front facing surface more reflective relative to the side facing surface, attribute increase?
... transmission weight
... index of refraction
... anisotropy
... specular roughness
Do maya modeling features assume that a scene unit is: Centimeters
The softness of a spot lights edge is controlled by penumbra angle, value gives perfect hard edge:
... Penumbra angle of zero
... penumbra angle greater than Drop-off
... penumbra positive angle
... penumbra negative angle
Key advantage of physically based rendering is ability to make extensive adjustments in post production without compressing image quality. Output file format preserves the full brightness and contrast range of a physically based rendering:
... EXR
... BMP
... JPG
... GIF
MASH especially useful in filed of 3d Graphics:
... character animation
Create a node in the Node Editor or Hypershade, press the _TAB__ and type into search bar:
Simulation of how light propagates in an environment known as:
... local illumination
... Global illumination
... sampling
... atmosphere
Polygons cab be double-sided. For a single-sided polygon, only one side is renderable, and the flip side is invisible in a rendering. What property of the polygon determines which side is renderable:
.,. love of detail
... face centers
... face normal direction
... vertex normal direction
Paint effects will render natively in maya software and maya hardware 2.0 rendered. Command will enable paint effects to render in Arnold or ay third-party render:
... Convert > paint effects to polygons
... use one brush
... draw as mesh
... make paintable
Standard method to preserve links to dependent files such as bitmap textures:
... Save dependent files to the same project as the scene file
... save scene files in a ASCII format
... Save files to a network drive
... fave all files to the system drive
Modeling a shape with tool:
... extrude
... boolean
... revolve
... Connect
Set up particular node- such as camera, light, shape, specific settings that you want to use in the future. Feature allows you to store and retrieve all parameters for a particular node type:
... content browser
... object template
... attribute editor presents
... tool settings
All new primitives assigned what type of material:
,.. blinn
,,, surface
... lambert
... Phong
The marking menu shortcuts to context-sensitive commands and tools. Marking menu accessed for objects:
... Position mouse cursor in a view port and ( ...)
... hold down right mouse button ***
... hold down middle mouse button
... hold down spacebar
... tap the spacebar
Set object scale values to 1,1,1 without changing the object size, command:
... reset transformations ***
... Freeze transfromations
... center pivot
... delete by type>history
*** Microsoft Publisher
https://www.youtube.com/watch?v=GggLhqblSOU
Microsoft Publisher is a desktop publishing application from Microsoft, differing from Microsoft Word in that the emphasis is placed on page layout and design rather than text composition and proofing
*** Microsoft Word:
Paragraph start on page 2:
Insert page break
Content existing word doc into current Word doc:
… click insert > text > text from file
Set insider inside margin binding doc pages printed on both side option page setup dialogue box:
… Book Fold
ghosted Logo or text behind regular text:
Water mark
Page size doc:
… File > page setup
Mark favorite templates for future:
… Pin to list
Caption table:
… References tab
appearance entire table single step:
… Right click new style
Find replace not support:
Whole words, replace all, match case — .., spelling
Bookmark:
… works with hyperlinks jump to parts of DOC
Not option when working with Colleague:
… including personalized message
Split docs 3 sections change margins frist section:
… new margin settings applied to all margins
Ribbon tab adds media
… insert
Page front large document doc title author
… cover page
SmartObject Delete Key:
- boxes maintain and contain height
Microsoft Office/Outlook
Microsoft Office, or simply Office, is a family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas
Attachments: calendars, pdf, word docs
Contact Folder: track 2 additional info members: Start date & Last renewal:: create custom contacts form that includes two text boxes to collect data
CC/BCC: public copy / private copy
Conversations: use show as conservations to: show view conversation threads w/o scrolling inbox
Favorites: create a rule to automatically route emails to the Project A Folder: Easy finding & inbox counting off
Inbox: organize: old messages to sub folder
Messages: category: to indicate message requires further action and a FLAG to organize the message
People Hub: 4 person annual meeting: Favorites people hub, quick steps forward messages, create group
Receipts: read reliable delivery receipts: users decline requests read receipts & user changes settings to ignore requests: Track email & hyperlinks "use Contact monkey"
Reply All: reply to all message whom sent to: sender & all recipients
Storage: Running low: sort by size, archive, save-remove attachments
Tasklist: task created and assigned: its reviewed and declared where is task/owner
View: LinkedIn profile open contact in people hub
Microsoft Project
Microsoft Project is a project management software product, developed and sold by Microsoft. It is designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads
Want to overview of project, option provides information including factors affecting and individual tasks start data and any overallocation:
... task inspector
... task sheet
... turndown report
... task usage view
Project duration can have different units, following Not a valid duration unit:
... quarters
... days
... hours
... weeks
Resource assigned to task that is schedules for 2 days, the resource is scheduled for 8 hours (8h) per day at 100% the resource platforms actual work of 10 hours on the first day, how has the peak for this resource changed:
... it has changed to 6h
... it has changed to 125%
... changed to 110%
... has changed to 10th
You want to change view of the timescale on Gantt chart to be more granular, how many tiers does the timescale support:
... three
... four
... five
... ten
Resource is over allocated in a project. This resource is responsible for two tasks that are to happen at the same time, the first of these tasks is on the critical path, solution use to remedy the overallocation:
... use the leveling gent view to adjust the edays field for the second task
... use the task usage view to change the second task contour to a bell
... use the leveling Gnatt view to adjust the edays field for the first task
... use the task usage view to change the second task contour to an early peak
Have Several Microsoft Project files open, and one contains sensitive information, so you hide the file, true regarding the hidden file:
... Switch Window Command does not list the hidden file
... View a hidden file, on the view tab, click arrange windows
... the switch window command lusts the hidden file
... to unhide the file, select switch window
Graduated scale for rates can be created for a resource by using cost rate tables. Maximum number of cost rate tables each resource in a project:
... two
... five
... six
... ten
Working with a master project that contains subjects, and want to see list of tasks on which a subproject file is dependent, do this:
... on the project tab, click subproject
... view tav, click group by
... project tab, click links between projects
... view tab, click filter
Where can set fixed duration, effort driven, manually scheduled
... resource sheet
... team planner
... task form
... project information dialog box
Modifying a project work breakdown structure (WBS) code, default length for any selected sequence type:
... any
... 1
... 3
... 5
Preparing meal compromising a main dish and multiple side dishes, finish of the main dish to drive the finish of the side dishes, the main dish will start before and take linger than the side dishes. You need to create a link from the main dish to each of the side dishes, link type is appropriate:
... finish to finish (FF)
... start to finish (SF)
... Finish to start (FS)
... Start to start (SS)
Manage multiple projects with one project designated as the master project, button on the ribbon use:
... subproject
... link between projects
... share resources
... move project
When breaking down the work that needs to be done on a project, smallest unit of work:
... work breakdown structure
... task assignment
... work package
... duration
Project contains numerous linked tasks , name for task controlled or driven by another tasks:
... predecessor
... successor
... overlapped
... callout
Have many tasks in a project file and want to convert them into milestones, Do this:
... change the tasks duration to 0
... Re-create the tasks and set them as summary tasks
... set the tasks and set them as summary tasks
... unassigns any resource form the tasks, as resources are not needed for a milestone task
Mongo DB
MongoDB is a cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and licensed under the Server Side Public License
Command returns all documents in the customers collection:
... db.customers.find();
Members of replica set send heartbeats to each other:
... 10 seconds
which shell query displays all citizens with an age greater than or equal to 21
... db.citizen.find ('where age >= 21')
... db.citizen. select ('where age >= 21')
... db. citizens. where ('age>=21')
... db.citizens. find ({age:{$gte:21}})
MongoDB instance has a least ___ three files:
... data log journal
... data, namespace, journal
... journal. data, database
... namespace, journal log
MongoDB shell, programming language is used to make queries:
... JavaScript
When no parameters are passed to explain(), mode does it run in:
... ExecutionStats mode
... wireTiger mode
... queryPlanner mode
... all PlansExecution mode
Secured previously unsecured MongoDB server, but the server is still not requiring authentication:
... issue the authentication () command
MongoDB and AdHoc queries:
... allows ad hoc queries
... ad hoc queries allowed only through the adhoc command
... does not allow ad hoc queries; all queries require an index
... allowed in the paid version
Use the replaceMany() command instead:
... use the replicateMany () command instead
... set the global multi option to True
... Use the updateMulti() command instead
... Use the updateMany() command instead
View the execution performance statistics for a query:
... db.members.aggregate([ {$match: {gender: "Female"}}. {$group: {_ID: {city: "$city"}, number...
File in MongoDB directory holds the Mongo Daemon:
... Mongo-daemon
Test indexes can there be on a mongoDB collection: 1
Projections:
... allows to select which fields should be in the return data ***
... allows run queries on server
... to format the results for display
... do calculation on the results
Option can be passes to start the mongoldb shell without connecting to a database:
... -db=null ***
... --free
... -nodb
... --shell-only
Remove database and all of its records MongoDb, what operator use:
db.collection.delete_many( { } );
db.bios.remove( { } )
... drop database ()
... clear ()
... DeleteDatabase()
... removeALL()
MOZ
Moz is a software as a service company based in Seattle that sells inbound marketing and marketing analytics software subscriptions. It was founded by Rand Fishkin and Gillian Muessig in 2004 as a consulting firm and shifted to SEO software development in 2008.
Keyword Research
SEO Audit & Crawl
Backlink Research
SEO Toolbar
Domain Analysis
Google Analytical Rankings
Net Framework
.NET Framework is a software framework developed by Microsoft that runs primarily on Microsoft Windows. It includes a large class library called Framework Class Library and provides language interoperability across several programming languages
Assuming y is the value type: example of boxing:
... int y=3
... object thisObject=y
... y=(int)thisObject=;3;
... y=(int)thisObject;
All types in .net (whether explicitly, implicit, or user-created) device from:
... all.system
... system.object
... object.system
... Parent.Object
Why use ahead-of-time (AOT) compilation:
... because deliver faster startup time, especially in big applications where much code executes on startup
Asynchronous actions:
... release request thread of I/O operation *
... capture request thread of I/O operation
... avoid blocking the request thread while it waits for an I/O operation
... block the request thread if it waits for I/O operation
Difference between stack and Queue...
... Queues process value types by top-down-hierachy-last,in, first out (LIFO). Stacks follow the principles and insert items from the lower end while deleting ones from the top-first in, first out (FIFO)
... Stacks process value types by a top-down-hierarchy-last in, first out (LIFO). Queues follow this principle and insert items from the lower end while deleting ones from the top-first in, first out FIFO
... stacks process value types by top-down hierarchy - first in, first out (FIFO). Queues follow the principle and insert items from the lower end while deleting ones from the top-last in, first out (LIFO).
... Queues process values types by a top-down hierarch first in, first out (FIFO). Stacks follow this principle and insert items from the lower end while deleting ones from the top-last in, first out (LIFO).
Happens when you concatenate two strings:
... the first string object is modified so it contains the concatenated strings
... cannot concatenate strings in .NET
... second string object is modified so it contains the concatenated strings.
... A third string object is created contacting the concatenated strings
Which method do you need to call in order to suppress finalization of an object:
... GC.Supress Finalize() *
.. Cannot suppress Finalization
... Finalizer.skip ()
... GC. DONOTFinalize()
CoreCLR
... is the .NET execution engine in .net Core that performs functions like garbage collection and compilation to machine code
CAS stand for / do:
... Code access security enables restrictions granular level, managed doc according to trust level
Difference between .Net Core and Mono:
... Mono third party implementation of .net framework for Linux, Android, and iOS .NET Core is the Microsoft implementation for the same platforms
... .Net core and Mono are identical
... .Net core is a third party implementation of MONO for (Linux, android, and IOS. Mono is Microsoft
... Mono is vastest version of the .net framework for Linux, android, and IOS .NET Core earlier version
Single responsibility principle:
... A class should have only a single responsibility , only changes to one part of software specifications affect the specification of the class
Kestrel:
... cross platform web server for ASP.NET Core that includes default in ASP.NET core project templates
Code use if want to trigger a garbage collection in .net:
... Garbage.Collect (); *
... System.GC clear ():
... System.GC.Collect ();
...Garbage.Cleanup();
Dispose method statement:
... belongs to IDdisposable interface and used to free sources, such as network connection and files
... defines execution environment for program code and manages CLR
... partially method-compiled code library for use in deployment, versioning, and security
... used to encapsulation of collections tied to function of class an object
Where store connection string information:
... configuration files
NodeJS
Node. js is a platform built on Chrome's JavaScript runtime for easily building fast and scalable network applications. Node. js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices.
Javascript was always a client side language until node.js.
Common server side languages include PHP, Python, Perl, Ruby
and several more. Node enables you to use Javascript server side.
This now means you can have a consistent language both ends
which could not be done prior to Node.
When a request event is received in the HTTP module, what is the first argument passed to that event, usually named req?
... http. ServerRequest
... ServerResponse
... http. IncomingMessage
... Http. ClientRequest
const https = require('https')
const options = {
hostname: 'whatever.com',
port: 443,
path: '/todos',
method: 'GET'
}
const req = https.request(options, res => {
console.log(`statusCode: ${res.statusCode}`)
res.on('data', d => {
process.stdout.write(d)
})
})
req.on('error', error => {
console.error(error)
})
req.end()
What does the code do:
const fs = require ('fs') ;
const os = require('os) ;
Const system = os.platform() ;
Const user = os.UserInfo() .username;
fs.appendFile('hello.txt', 'Hello ${user} on $(system}!' ,
if (err) throw err;
Console.log('the data was appended to file') ;
{) ;
... creates an image file
... creates a file named data and append numbers
... created a file.hello.txt and appends customized text *
... Console logs system information
if you run a script.js with the code, how do you access the value passed to "var" inside script.js
VAR=value node script.js
... Process.argv[VAR]
... Environment.VAR
... Process.argv[0]
... Process.env.VAR *
Make an HTTP server object active and listen ti request on the certain posts:
... server.listen*
... server.start
... server.run
... server.activate
What is the purpose of path module:
... retiring module
... utilities to add/remove files
... utilities to play with file and directories paths *
... provide utilities to test files
Purpose of file system (FS) module:
fs.readFile('/etc/passwd', (err, data) => {
if (err) throw err;
console.log(data);
});
... Methods to work with databases *
... methods to work with requests and responses
... provide methods to files
... fine new file systems
When you run JavaScript in a Node.Js application, elements in a Node.JS Stack actually executes that JavaScript:
... C-ares library
... VM (like V8 or Chakra)
... Repi Module
... Libuv library
Way to have Node always run in strict mode:
...use V8 option - use strict
Console show with code:
const http = require ('http') ;
const hostname = '127.0.0.1' ;
const port = 3000 ;
const server = http.createserver ((requires) =>{
res.statusCode = 200;
res.setHeader('content-type'. 'text/plain') ;
res.end ('hello World/n') ;
}) ;
Server.listen (port,hostname,() => {
console.log('server running at http://${hostname):$(port}/') ;
}) ;
... server running ...
... http://localhost:4000/
... http://localhost:3000/
... http://127.0.0.1:3000/
... port 3000
How do you start a Node Application, if the entry file is index.js:
... node index.js
... nodemon start
... node start
... start index.js
Process event is emitted right before Node Process crashes and exits:
... Quit
... Die
... UnCaughtException
... Crash
Object holds all arguments passed after executing a script with the node command:
... OS. arguments
... process.arguments
... cli.args
... process.argv
DNS Module Methods uses the underlying OS facilities and does not necessarily perform any network communications:
... Lookup
... reverse
... resolve 4
... resolve
Which following node.JS modules use when need to decode raw data into strings:
... buffer
... string_decoder
... string_buffer
... util
Which core module in Node provides an API to register callbacks to track asynchronous resources created a Node.Js application:
... cluster
... inspector
... async_hooks
... dgram
Object Orient Program
bject-oriented programming is a programming paradigm based on the concept of "objects", which can contain data, in the form of fields, and code, in the form of procedures. A feature of objects is an object's procedures that can access and often modify the data fields of the object with which they are associated
Statement describes Gang of four deign patterns called Memento and Observer:
,,, Memento notifies classes of changes. Observer captures and restores an objects internal state
... Memento defers the exact steps of an algorithm to a subclass. Observer defines a new operation to a class without change
... Memento alters an objects behavior when its state changes. Observer encapsulates an algorithm inside a class
... Memento captures and restores an objects internal state. Observer notifies multiple classes of changes
Method:
... exact same thing as a functional subroutine
... set of instructions designed to perform a frequently used operation within a program return no values
... procedure associated with data and behavior
... set of variables that can change over time
Why would you create an abstract class, f it can have no real instances:
... avoid redundant coding in children
... explore a hypothetical class
... reserve memory for an unspecified class type
... to prevent unwanted method implementation
Content of OOP, what is composition:
... composition is a binding where the class/name association is not made until the object designated by the name is created at execution time
... composition is a process of collecting classes that provide a set of services for a particular domain
... Composition is a part/ whole relationship where an object is composes of one or more other objects , each of which is considered a part of the whole. this relationship is strong from aggregation in that lifetimes of the whole and its parts are dependent
... Composition is the act one object passing to another object an operation to be performed on behalf of the initial object.
Method with a behavior similar to a virtual method-it is meant to be overridden+ except that it does not have a method body, it jest has a method signature. What kind of method should you use:
... abstract
... internal
... public internal
... protected internal
In general, hiding the implementation complexity can do what:
... offer more features
... provide more features
... complicate the programming experience
... facilitate the programming experience
Which type of constructor cannot have a return type:
... copy
... constructors do not have a return type
... parameterized
... default
Which code creates a new object from the employee class:
... employee currentEmployee;
... Employee currentEmployee = New Employee ();
... Employee currentEmployee = Employee.New ();
... Employee currentEmployee = Employee.Create ();
If a local class is defines in a function, what is true for an object of that class:
... object is temporarily accessible outside the function
.. object can call all other class members anywhere in the program
... object can be accesses, declared, and used locally in that function
... object must be declared inside any other function
Which two blocks are used ti handle and check errors:
... catching and trying
... do and while
... do and check
... try and catch
What is the best reason to use design pattern:
... Result in code that is more extensive and maintainable
... result in more compact product
... allow add that design pattern to your resume
... speed initial development
Why would you implement composition using an id instead of reference:
... all
... can makes entity retrieval more efficient
... makes easier to save entity
... minimizes coupling
What happens when an object is assigned to a variable or passed to a method:
... deep copy of object is used
... objects aren't used, the reference to the object is used
... temporary shallow copy of the object is destroyed
... object used efficiently
there are five classes, Classes E is serviced from class D, D from C, C form B, B from A. Which class constructors will be called first if the object of E or D is created
... b
... c
... C and B
... A
How many levels does multilevel inheritance allow in a program:
.,,, only 10 levels of inheritance
... only the amount of levels memory permits, divided by processor speed
... as many levels of inheritance as required
.. as many levels if inheritance required within 10 minutes
Objective C
Objective-C is a general-purpose, object-oriented programming language that adds Smalltalk-style messaging to the C programming language.
Code execution:
typedef enum {
thing 1,
thing 2,
thing 3,
} Thing ;
-(void) enumStuff {
NSLog (@"%d", thing 2);
}
... Code not print anything
... 0
... 1
... thing 2
Difference between array and set:
... Arrays ordered, non-unique values
... Sets contain nils
... sets are ordered , unique value
... Arrays are stored sorted
Declaration of:
int (^Foo)(int);
... abstract class
... block of code
... Extension
... Generic
Code print:
NSString + str1 = @"1";
NSString + str2 = @"2";
NSString + str3 = @"3";
int num = 2;
switch (num) {
case 1:
NSLog (@"%@", str1) ;
case 2:
NSLog (@"%@", str2) ;
case 3:
NSLog (@"%@", str3) ;
default :
break ;
}
... 2
... 2 and "3"
... 3
... Code no print
Code print:
NSArray *Vals = @[@"1" , @"2" , @"3" ];
[Vals makeObjectsPerformSelector:@selector(NSLog)];
... "1" "2" "3"
...
"1"
"2"
"3"
... 123
... Code contains error = Nothing
Value is str after this line executed:
NSString str = "test" + " " + "more";
... test more
... nil
... test
... code contains error
Dot notification used for:
... property getter/setter
... nothing, as not Objective C
... Function calls only
... Parameters Delimiters
Code print:
NSPredicate *P2 = [NSPredicate PredicateWithBlock: ^BOOL (NSString*evaluatedObject, NSDictionary<NSString *, id> * _Nullable bindings) {
Return evaluatedObject.intValue % 2 == 0;
}];
NSArray*vals = @[@"1",@"2", @"3"];
NSArray*N2 = [Vals filteredArrayUsingPredicate:p2];
NSLog(@"%@", n2.firstObject);
... 2
... 1,2
... Nothing code error
... 1,2,3
Property Defaults include:
... Atomic/Weak
... nonatomic/strong
... Atomic/Strong
.... nonatomic/Weak
Glean:
#import "NSString + NameHelper.h"
... NameHelper category of NSString
... NSString helper class
... NSString Implements the NameHelper Protocol
... NameClass is subclass of NSString
Code error:
Float x = 2.0;
int (^foo)(int) = ^(int n1) {
return (int) (n1*x);
};
foo (5) ;
... X is not in the right scope
... Parameter isn't declared correctly
... Nothing is wrong with this code
... Ints and floats can't be multiplied
Key Differences between NSMutableDictionary and NSDictionary:
... D can't be coped
... MD no initializers
... MS values change
... D values change
Code example:
[self addObserver:self forKeyPath: @"Val" options:0 context:nil];
... cassvalue observing
... keypad observing
... key-data observing
... key-value observing
Observing property, causes related method called and why:
1. _val = 1;
2. self.val=100;
... Statement 2, since it calls the auto-created setter on the property
... Statement 1, since it uses the property directly
... Statement 2, since it specific the class instance to use
... Statement 1, since it calls the auto-created setter on the property
Foo:
-(Float)foo;
... function with a return tube of float
... this code contains an error
... property of type float
... variable declaration of type float
PHP
PHP is a popular general-purpose scripting language that is especially suited to web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1994; the PHP reference implementation is now produced by The PHP Group.
Want to use two traits A, B, but they contain method called upload(). What is the correct way to resolve conflict and use version defined trait A:
... Use A, B {A::Upload suppress B};
... Use A, B {A::Upload ignore B};
... Use A, B {A::upload instead B };
... Use B, A;
Purpose of adding lowercase "u" as a modifier after the final delimiter in a perl-compatible regular expression:
... Both pattern and subject string are treated as UTF-8
... Makes pattern match uppercase letters
... Makes the dot metacharacter match anything, including newline characters
... Inverts the greediness of the question of the quantifiers in the pattern so they are not greedy by default
"Headers already sent" error when using the header () function:
... calling echo or print before the header () function
... byte order mark (BOM) at the beginning of the file
... all
... extra blank lined after the closing PHP tag on an include file
Script: lines cause errors:
1 <7php
2 $count = 0;
3 $_xval = 5;
4 $_yval = 1.0;
5 $some_string = "Hello there!";
6 $some_string = "How are you?";
7 $will i work = 6;
8 $3blindmice = 3;
9 7>
... Line 5 cause error because some_strong should be someString
... Lines 7 and 8 will cause error. Line 7 has whitespace in $will i work should be $Will_I_Work. Line8 cannot start with # b/c variable
... Line 6 will cause error b/c can't reassign new value to variable that has already been set
... Lines 3 and 4 error b/c variable cannot start with underscore (_)
Key difference Get and Post:
... GET invented for changing the server state and carries more data than POST
... GET displays submitted data as part of the URL, during POST, information not shown
... GET more secure than Post and should be used for sensitive information
... GET used with HTTP protocol. POST used with HTTPS
Valid PHP Error handling keywords:
... yield, throw, catch, finally
... try, yield, catch, finally
... try, throw, catch, finally
... try, throw, catch, callable
What does script due:
1 $Email = Filter_input {INPUT_POST, 'email', Filter_Validate_Email);
2 if ($email === false) {
3 $emailErr = "Please re-enter Valid Email";
4 }
... verifies email address is well formatted
... makes email safe to input into database
... makes sue email is good and functioning address
... assigned an email to a variable and then removes all illegal characters from the $email Variable
The ___ operator is useful for sorting operations. It compares two values and returns an integer less than, equal, greater than 0 deepening on whether the value on the ___ is less then, equal, greater than other:
... greater then ; right
... spaceship; left
... equality; right
... comparison; left
Most secure way to encrypt a password before storing it in database:
... $encrypted = md5 ($password);
... $encrypted = password_hash($password, Password_default);
... $encrypted = crypt ($password, $salt);
... $encrypted = sha1 ($password)
Value of $total in calculation
$total = 2 + 5*20 - 6 /3;
Recommended settings in php configuration file php ini for a testing environment:
... error _ reporting = E_ALL & ~E_Notice
display_errors = On
... Error_reporting = E_ALL & ~E_Notice
Display_Errors = Off
... Report_Errors = E_ALL
Display _ errors = On
... error_reporting = E_ALL
Display _ errors = On
Missing form Code, supposed to create test cookie:
1. $string_Name = "test cookie";
2 $String_Value = "this is test cookie";
3 $Expiry_info = time()+259200;
4 $String_Domain = "localhost.LocalDomain";
... Cookie session is missing
... $_Request missing
... Call to Setcookie() missing
... $_Cookie array is missing
Sort $files array so that page numbers are correct order:
$Files = ['page_10.txt' , 'page_2.txt', 'page_17.txt.txt', 'page_9.txt'];
... natcasesort($files);
... $files = natcasesort ($files);
... NatSort($files);
... $files = natsort($files);
Code snippet uses correct syntax for creating an instance of the PET class:
... $cat = new PET();
... all
... $horse = (New Pet);
... $dog = new Pet;
PHP "variable variable" takes value of a variable and treats that a the name of a variable. For example, if $var is a variable, then $$var is a variable variable whose name is the value of $Var. Which script produces the output below using variable variables:
CAT
DOG
DOG
...
1,$name="Cat";
2 $$name="dog";
3 echo $name. "<br/>';
4 echo $$name. "br/>";
echo $Dog;
...
1 $name = "cat";
2 $$name = "dog";
3 echo $name."<br/>";
4 echo $name."br/>";
5 echo $cat;
...
1 $name = Cat";
2 $name = "Dog";
3 echo $name. "br/>";
4 echo $$name. "br/>";
5 echo $Dog;
...
1 $name = "cat";
2 $$name = "dog";
3 echo $name. "br/>";
4echo $$name. "br/>";
Powerpoint
Microsoft PowerPoint is a presentation program, created by Robert Gaskins and Dennis Austin at a software company named Forethought, Inc. It was released on April 20, 1987, initially for Macintosh computers only. Microsoft acquired PowerPoint for $14 million three months after it appeared.
what do you use to Use align objects on a slide to one another:
... Arrange tools
which option must be enabled if you want to manipulate the playback of a video file using a presentation:
... show playback controls
... show media controls
... use presenter view
... record slide show
which tab best for adding various types of objects to slides:
... insert
Which Project Presentation option protects a presentation from accidental changes:
... encrypt w/ pasword
... mark as final
... add a digital signature
... always open Read - only
Create new, blank presentation, you begin with one blank slide. What is the layout name of slide:
... title slide
... Blank
... title only
... title and content
Arrow option choice hide mouse cursor when presenting, except when the cursor is moved:
... none
... automatic
... visible
... hidden
How can you change appearance of table in one click:
... right-click table and choose new style
... apply cell style
... apply table style
... apply graphic style
Feature analyzes content of your slides and offers suggested options...
... Design Ideas
... Add ins
... browser for themes
... SmartArt
Select entire line of text: triple click
Statement about Compress Picture command true:
... compress only one image at a time
... compress all images at the same time
... cannot delete cropped areas
... no options for print output
which Three shadow properties adjusted powerpoint:
A. Focal Point
B. Depth
C. Blur
D. Angle
E. Distance
Where can you Configure advanced PDF options:
... options tab
Option changes text box so that is automatically changes shape to fit longer text:
... resize shape to fit text
Manner can you filter comments:
... length
... date
... author
... urgency
SmartART category can you use make information graphics out of bullet points:
... Pyramid Matrix List
Pro Tools
Pro Tools is a digital audio workstation developed and released by Avid Technology for Microsoft Windows and macOS used for music creation and production, sound for picture and, more generally, sound recording, editing and mastering processes
Spot Edit mode:
... edit or move clap in increments defined by grid value
... trim clip make all clip adjust in the by the same amount
... edit or move a clip with unrestricted freedom in increments as a small as one sample
... click clip and enter clips start point manually
Each time makes a selection, lose the selection when playback stops. fix issue:
... use different edit tool
... turn off insertion follows playback
... use smart tool
... return instead of Spacebar to stop playback
When using Destructive record mode, what happened when you record over a selection of a clip:
... automatically erases whole clip, it is the same as clear clip
... no recording mode called Destructive
... automatically save copy
... records over and makes new seamless clip with the same name
3.5dB signify on the bass clip:
... track volume up 3.5db
... bass clip totally dynamic range of 3.5db
... bass clip 3.5db clip gain applied
... bass clip 3.5 below absolute zero on digital scale
Key command allows you to import audio:
... Command + A (MAC) Cntrl A (Windows)
... Command + I(MAC) or Control I (Windows)
... I
... Shift +Command +I (MAC) or Shift+control+I (windows)
When create MIDI track:
... enable higher sample rate audio recording
... play attached hardware sampler instrument from a MIDI sequence on your track
... initiate advanced surround sound mix
... communicate advanced surround mix
Running out of processing power and your buffer size is at the minimum. How else can free up some processing power:
... >automation
... all tracks are in read mode
... Turn on insertion follow playback
... Use track > commit on any tracks that haver plugins to which you are ready to commit
Copy and paste volume automation from one track to another:
... yes, but lose breakpoints
... No, copy and paste only in advanced editing mode
... Yes, just like audio or MIDI
... no cannot
Enabled Wait for Note in the Transport window. What has to happen before recording take place:
... Sound must come through the record enabled track
... Must wait 12 seconds before any note is played, otherwise PRO TOOLS will enter Destructive Mode
... MIDI note must be played
... Must say "record" into the Microphone
Difference between bus 1-2 and bus 3-4:
... bus 1-2 special pre-fader send
... bus 3-4 is lower in volume
... bus 1-2 via track
... bus 1-2 expanded sends view , while bus 3-4 not
Not able to edit clips together in the Improve group shown ____ , make possible:
... Clear follow Globals box
... enable VCA
... Change type to mix/edit
... Change ID to e
Look at all alternative playlists vertically under your track.
... none
... bot
.. select edit >playlists
... select playlists in the track view selector
Pressing T and R keys to zoom in and out nothing happening, because
... Zoom turned off display preferences
... Keyboard focus mode is not enabled
... Running an old version of Pro tools
... using incompatible keyboard
Keyboard Focus Mode in the edit window (the a-z button is yellow) what are the quick keys to zoom in and out of timeline horizontally.
... control + and control + (Mac) or Start + (Windows)
... The R and T keys
... Plus Sign and Minus Sign keys
Python
Python is an interpreted, high-level, general-purpose programming language. Created by Guido van Rossum and first released in 1991, Python's design philosophy emphasizes code readability with its notable use of significant whitespace
Why use mixin:
... Use mixing to force a function to accept an argument at runtime even if the argument wasn't included in the functions definition
... Use mixing to make sure that a class' attributed and methods dont interfere with global variables and functions
... Use mixing to allow a decorator to accept keyword arguments
... if you have many classes that all need to have the same functionality, use mixing to define that functionality
What is runtime complexity of searching for an item in a binary search tree:
... runtime searching in a binary search tree is O(1) b/c each node acts as a key, similar to a dictionary
... runtime searching in a binary search tree is O(n b/c every node in the tree must be visited
... runtime for searching in a binary search tree is generally O(h), where h is the height of the tree
... runtime for searching in a binary search tree is O(n!) b/c every node must be compared to every other node
What is one of the most common uses of Python sys Library:
... Scan health Python ecosystem while inside a virtual environment
.... Capture command - line arguments given at files runtime
... take snapshot of all packages and libraries in your virtual environment
... connect various systems, such as connecting a web front end, API service, a database, and mobile app
What is term used describe items that may be passed into a function:
... Arguments
... Attributes
... Paradigms
... Decorators
What does a generator return:
... all keys given dictionary
... none
... linked data structure form a non-empty list
... iterable object
When use loop?
... when need to chaco every element in an iterable known length
... only is some situations, as loops are used only for certain types of programming
... when you want to run code in one file for a function in another file
... when you want to minimize the use of strings in your code
Following modes is not a valid way to access a file form within ta python script:
... write ("w")
... scan 's'
... append ('a')
... read ('r')
Primary difference between singly linked list and a doubly linked list:
... singly list can be linked to only one other data structure, whereas a doubly- linked list can be linked to two other data structures
... Singly linked list, each node has a pointer to a next node only, doubly linked list, each node has pointers to both the next node and the previous node
... runtime of adding a node to a doubly linked list is twice as ling as adding node to a singly linked list
... traverse a singly-linked list only once and then pythons garbage collector removes it from memory, you can traverse a doubly linked list twice, then pythons garbage collector removes it from memory
Meant by phrase "space complexity."
... amount of space taken up in memory as a function of the input size
... how many microprocessors it would take to run your code in less than one second
... how many copies of the code file could fit in 1 GB memory
... how many lines of code are in your code file
Class's _init_() method do:
... The_init_method is included to preserve backwards compatibility from Python 3 to Python 2, but no longer needs to be used in Python 3
... The_init_method makes classes aware of each other if more than once class is defined in a single code file
... The_int_() method is a constructor method that is called automatically whenever a new object is created from a class. It sets the initial state of new object
... the_init_method initializes any imports you may have included at the top of your file
Most self -descriptive way to define function that calculates sales tax on purchase:
... def sales _ tax(amount):
'''Calculates the sales tax of a purchase. Takes in a float representing the subtotal pass
... def txt(Amt):
''' Gets the tax on an amount. '''
pass
...def calculate_sales_tax(subtotal):
pass
... def tax (my_float):
''' calculates the sales tax of a purchase. Takes in a float representing the subtotal
pass
Review code below. Correct Syntax for changing the price to 1.5:
... fruit _ info = {
'Fruit':'apple',
'count': 2,
'price': 3.5
}
... my_lest[3.5] = 1.5
fruit_info['price'] = 1.5
my_list['price'] ==1.5
1.5=fruit_info['price]
Would you use a while loop:
... when need run two or more chunks of code at once within the same file
... when want to minimize use of strings in our code
... when want to run code in one file while code in another file is also running
... when want some code to continue running as ling as same condition is true
Main reason to recursion:
... To break problem down into smaller and easier problems, solve these problems, and use those solutions to solve the larger problem
... mostly only used to answer questions in technical interviews, its not used widely in the real world
... Recursion only used in searching and sorting algorithms
... Recursion should only be used in non-production code, b/c it is too complex to be used in large-scale applications
What is difference between class attributes and instance attributes:
... Class attributes are shared by all instances of the class, instance attributes may be unique to just that instance
... Instance attributes can be changes, but class attributes cannot be changed
... Class attributes belong to just to the class, not to instances of that class, instance attributes are shared among all instances of a class
... there is no difference between class attributes and instance attributes
*** Python
Abstract Class:
An abstract class exists only so that other ‘concrete’ classes can inherit from the abstract class
Use ‘any()’ function on list:
Returns true is any item in the list evaluates to true. Otherwise it returns false.
Attributes:
Hold data or describe state for a class or an instance of class
Data structure binary tree degenerate if not balanced:
Set
Defaultdict: work
… auto create dictionary keys which integers 0-10
Write DocTest:
def sum(A,B);
“”””
>>> sum(4,3)
7
>>> sum (-4,5)
1
“””
return a+b
Expression return:
College_years = [‘Freshman’, ’Sophomore’, ‘Junior’, ‘Senior’]
Return list (enumerate(college_years, 2019)
… [(2019 , ‘Freshman’) (2020, ’Sophomore’), (2011, ‘Junior’) …
Built in list method remove list item:
… .pop() method
Runtime accessing a value in a dictionary by using key:
O(n) linear time
O(log n) logarithmic time
O(n^2) quadratic time
O(1) constant time
Static Method:
… Can be bound by either class or instance of a class
… Serve mostly as methods since they cant access or modify a class state
Syntax called Game:
Class Game:
pass
Def Game():
pass
Syntax defining class called “game” if inherits from a parent class “logicGame.”
… Class Game (LogicGame):
pass
Python sys library :
Scan health of Python ecosystem while inside a virtual environment
Built in Python data type represent stack:
… List
Describe code:
count, fruit, price = (2, ‘apple’ , 3.5)
… tuple assignment
Quickbooks
Administrator: add new users // accessibility
Batch: Display/print batch group of reports: click reports Process multiple reports
Chart of Accounts: add new account
Hide/Collapse: sub account reports to hide details and focus on values in parent accounts
Long-term Liability: Mortgage loan
Multiuser Networks: file > switch to multiuser mode
Profit-Loss Report: Income and expenses report
Record Sales: customer pays @ time of sale then cash sale journal entry
Sales Tax: tracking sales tax, reports needed to pay the taxing authorities
Timesheet: feature tracks time for single activity
Time Tracking: times to invoice customers, employee hours for paychecks, flag more staff for projects.
Time & Cost: billable T&Cx info when invoiced: from billable time entered on timesheets and/or billable Cx entered through checks & bills.
Terms Net 30: Customer purchases goods/services w/ tn30, record transaction: create sales order, create invoice on payment due
Undeposited Funds: accounts use temporary hold payments received from customers before creating bank deposit
Vendors: 1099 subcontractor
R
R is a programming language and free software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and data miners for developing statistical software and data analysis
Results Returned by gim function, difference between null deviance and residual deviance:
... null deviance is twice the time of raw logins. Residual deviance is twice the same of the full models logins
... residual deviance is the product of null deviance and McFadens R Sq
... residual deviance is the difference between total and null deviance
... Null deviance is when only the intercept is in the equation. Residual deviance is when all predictors are included
Result of a%%b :
... Modulus
... quotient
... dividend
... divisor
Function tell you the proportion of the normal curve that falls on or below a standard score of 1.96:
... norm(1..96)
... norm(1.96)
... dorm(1.96)
... norm(1.96)
What does E contain:
d<-c("Twas", "brillig and", "the", "slithy toves")
e<-grep("[Tt]+". d, perl=T, Value=T)
... "Twas" "brillig" "and" "the" "slithy Toves"
... "slithy toves"
... "Twas" "the" "Slithy Toves"
... "Brillig" "and"
Not property of lists and vectors:
... Length
... Scalar
... Type
... Attributes
Which option setting can cause difficulty if you eat to add to a variables possible values after designed an objects initial data structure:
... option (stringsASFactors=True)
... option (max.print=5)
... options (continue="...")
... options (colnames(x) <-NULL)
Which does R regard as acceptable name for a variable
... _VarA
... Var2_A
... .2Var_A
... Var_A!
Given DFCBound <- Cbind(DF1,DF2) and the image below, how many rows are in DCFBound:
... 0
... 3
... 6
... 9
In DFmat.P <-as.Matrix (DF.) DF.P is a data frame that includes character double integer and logical values. what is effect of matrix on Dfmat.P:
... Dfmat.P becomes
... a complex matrix
... a character matrix
... a array
... a logical matrix
Commands would download and install a package names stringr from CRAN:
... install.packages(stringr)
... install.packages("Stingr")
... library(stringr)
... library("stringr")
Review line 1 and what is returned by the statement on line 2"
1 MyData<-c(10,9,8,7)
2 MyData[c(2,4)]
... [1] 16
... [1] 9 7
... [1] 7 9
... [1] 97
The > symbol by itself on the last line shown in R console. what does symbol indicate that R is waiting for user to do:
... enter the next statement
... call for result of prior statement
... begin entering a data set
... press UP arrow key
Statement returns the value in the fourth row, fifth column of data frame named fish:
... fish [4,5]
... fish(4,5}
... fish(5,4)
... fish (4,5)
Enter statement into R console, now edit, what easiest way display statement again:
... press left arrow key
... press right arrow key
... press up arrow key
... press down arrow key
which function coerces and existing objects to a data frame:
... to.data.frame()
... as.data.frame()
... is.data.frame()
... make.frame()
React JS
React is an open-source JavaScript library for building user interfaces. It is maintained by Facebook and a community of individual developers and companies. React can be used as a base in the development of single-page or mobile applications.
inline if/else statement:
{!loggedIn ? <login /> : <UserDetails />}
... line shortener
... ternary expression
... if scheduler
...one-liner operator
Property need to add to the suspense component in order to display a spinner or loading state:
function MyComponent () {
return (
<Suspense>
<div>
<message />
</div>
</suspense>
);
}
... loading
... spinner
... lazy
... fallback
What is [e.target.id] called in code snippet:
handleChange (e) {
this.setState ({ [e.target.id]: e.target.value })
}
... commuted property name
... dynamic key
... set value
... JSX code string
The console read when code is run:
conts [, , animal ] = ["Horse", "Mouse", "Cat"];
console.log(animal);
... mouse
... horse
... cat
... undefined
Second argument that is sent to the render function describe:
ReactDOM.render(
<h1>Hi</h1>,
document.getElementByID('root')
);
... where to call the function
... where to create a new JavaScript file
... where Root component is
... where the react element should be assed to the DOM
If you wanted to display the count state value in the component, what need to add the curly braces in the h1:
class ticker extends react.component {
constructor (props) {
super(props);
this.state = { count: 0 };
}
render () {
return <h1>{}</h1>
}
}
... count
... state.count
... this.state.count
... state
Tools NOT part of Create React App:
... react
... ReactDOM
... WebPack
... jQuery
Per following code, Hello component displayed:
const greeting = isLoggedIn ? <hello /> : null;
... never
... when a user logs in
... when the Hello function is called
... when isLoggedIn is true
What is the name of this component:
class clock extends React.Component {
render () {
return <h1> look at the time: {time}</h1?;
}
}
... clock
... component
... react component
... it does not have a name prop
Suppose had class called Pet. What is correct Javascript syntax create new class Cat that inherits properties from a bas class pet:
... class Cat extends Pet {...}
... class Pet adds Cat {...}
... class Cat implements Pet {...}
... class Cat instantiates Pet {...)
Disable a button so that it does not emit any events OnClick. Which prop use:
... defaultValue
... onBlur
... disable
... onClick
Javascript syntax extension commonly used to React elements:
... HTML
... React Javascript
... JSX
... JavascriptX
Which package contains the render() function that renders a react element tree to the DOM:
... React
... ReactDOM
... Render
... DOM
Why might you use a ref:
... refer another JS file
... call function
... directly access the DOM node
.. bind the function
Name of operator represented by three dots (...) in javascript:
... spread operator
... dot operator
... push operator
... trailing operator
React. JS
webpack why use loader:
… to load excess data
Code syntax error:
cont person = ( _ ) = >
(
first
)
… Wrap object around ()
Terms described React applications:
… Declative
attributes replace inner HTML browser DOM
… Dangerously Setinner HTML
Code Splitting:
… React.lazy
Create const javascript
const
restructure properties to dish component:
Function (dish) props
… Function (dish ({name , cooking time }) {
React commoner catches javascript child component tree:
… error. boundaries
Lifestyle make requests in class components:
… Component Did Mount
React components composed create user interface, how components composed:
… Nesting components
All react components act like _ props
… High order fx
Creat component Name dish to DOM
… h1
Console read code:
Const [ animal = [horse, mouse cat]
… cat
Why use Ref
… Access Dom
Use reducer use state react component when:
… Replace Redux
Revit
Autodesk Revit is a building information modelling software for architects, landscape architects, structural engineers, mechanical, electrical, and plumbing engineers, designers and contractors.
Cad drawings use ayers to define individual elements. when importing a CAD drawing into drafting view how you remove layers that dont need:
... select the imported CAD drawing right click and select delete layers
... select imported cad drawing and press delete on each element you dont need
... select the imported cad Drawing nd use the delete layers setting in the properties palette
... select the imported cad drawing and use the delete layers command
If want refit sheets to print to PDF, with black and shades of grey, which setting in colors would you use
... black lines
... grayscale *
... color
... neutral
Link to existing drafting views to a callout view. For example, in a section view you might have a callout view that references a roof connection detail. what do you select in the options bar to allow you to select the appropriate drafting view:
... reference other view
... rotate after placement
... chain
... select drafting view
When placing a linear dimension, how do you change the dimension orientation from horizontal to vertical, and vice versa:
... press enter
... press esc
... press control
... press spacebar
Filled regions are used in Revit annotations to highlight areas in plans, sections, or elevations, and in detail views. Which typical drafting tool use to Draw panel to form a closed boundary with perpendicular corners to create a filled region:
... Rectangle
... Target End Arc
... Ellipse
... Spline
Revit adding views to sheets, what familiar methodology use to get a view onto a sheet:
... drag/ drop
... copy/paste
... import cad file
... right click menu
worksharing is the default method of collaboration on Revit models. when working with a work shared model, what term used for the main model being worked in and synchronized to:
... central file
... main file
... model file
... server file
By default, doors in Revit are tagged in a numbered sequence, with each door having its own page number (instance based). other models such as walls and windows, are tagged by type (type based). What happens if information in one-typed based tag changed:
... all instances of the Tag with the type properties of the information changed will update to reflect the change
... only select tag will change. then you have to input the new tag value in the update remaining tags filed in the properties palette
... only the selected tag will change. yo will need to update all other related tags manually
... only the selected tag will change. then you will have to select update remaining in the contextual modify tab in the ribbon
A dimensioned element may need to have that dimension maintained. how do you fix a permanent dimension in place, so that the dimension value cannot be changed:
... click the dimension, right click select the lock submenu, select YES to lock the dimension
... click the dimension, right click and select locked in the contextual menu
... click the dimension and then select the padlock symbol so that the padlock is closed
... click the dimension and select locked in the contextual modify tab on the ribbon
As you add elements such as doors, windows, and other components to the Revit model, the family information provided in the family is also added to the model. Reference this information in schedules. how is the family information inserted into schedule:
... manually
... from an Access database
... automatically
... from and excel spreadsheet
As you place linear elements into Revit, temporary dimensions appear to help you to define sizes of this elements, such as the length of a wall element. If units are set to fractional units, what would you type in a temporary dimension to get the distance of 14 feet:
... 14'
... 14FT
... 14"
... 14Feet
In architectural models, there is often a geometry clash between wall and roof. what command clean up intersections:
... Join Root/wall
... join Geometry
... Join Roof
... Join Wall
Schedules have own specific view type in Revit. However, they cannot be easily exported to spreadsheets and databases. To communicate schedule data, where you place a schedule to make it part of your project:
... Floor Plan
... Sheet View
... Sheet list
.... Ceiling plan
Where can you change your Revit username:
... File properties
... Project Browser
... The login Associated with your autodesk account in the dialog box in the upper right corner of the screen
... Project Information
When using permanent dimensions, which dimensional control do you click to add dimensional constraints:
... Equality
... Equals
... EQ
... EQUAL
Ruby On Rails
Ruby on Rails, or Rails, is a server-side web application framework written in Ruby under the MIT License. Rails is a model–view–controller framework, providing default structures for a database, a web service, and web pages.
(Model, view, controller framework: default structures for database) (MIT License)
Asset Pipeline:
view, include link to Java Script File:
<%=Javascript_include_tag'Main'%>
[Controller Specific Assets)
Caching Stores:
Memory Store, File-store, MemCacheStore, RedisCacheStore, Null Store
Controller:
Code Params.Permit (:Name,:sku): (plural Last Name
It fillers out submitted form parameters that are not named :name or sku to make forms more secure
Error Attribute
Validator: define error message for model attribute value with message "this value is invalid"
Display_error_for(model,:value,"this value is invalid")
Filters
"Around filter that replaces the response body with the text "Hello World"
def replace _response
yield
response body = 'Hello World'
end
Helpers (mobile app)
Custom view helpers stored within a standard rails app
Rails_root / app / helpers
ID
if a database table of users contains the following rows, and id is the primary key, statements would return only an objet where last name is _X_
Id first_name last_name
user.find_log(first_name."x")
Instance Variables
Set within a controller action method accessible within a view:
set in an action method on controller can be accessed and displayed in a view
Naming Conventions
Model class named Product, database table with Active Records store/retrieve: "Products"
No Method Error:
[Code]
Class_Admin
def Self - Authenticate
end
def Full_Name
end
end
[Exception: Admin.Self.Full_Name]
Put&Patch
Route Handling both Put & Patch REST HTTP verbs: put items, to: items #update
Template
Cache a partial template rendered through: Render Partial: shared/menu
Parameters
Code example Not Allow Person class to read & write the: name parameter
Class Person
attr_accessor:name
end
Regex
Regular Expression within a string: 'Hello world' =- /hello/
Validation Errors
Validation model fails: messages are stored cache
Sharepoint
SharePoint is a web-based collaborative platform that integrates with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly configurable and usage varies substantially among organizations.
Which sharepoint feature activate when sharepoint items are subject to events related to litigations, investigations, or audits.
... content organizer
... metadata navigation and filtering
... following content
... hold
When a user tries to create a new document in a sharepoint library, the default option is not MS word. What setting do you need to change in the library.
... audience targeting
... document template
... site template
... versioning
Office documents have properties. In sharepoint, the properties are columns that hold information. What is the information known as:
... Objects
... Metadata
... fields
... data types
Creating a new SharePoint subsite. From image, which template would you select to create a site features scorecards dashboards, and access to performancePoint services content:
... Enterprise Search Center
... records Center
... Basic Search Center
... Business Intelligence Center
What must do you when syncing a document library to the local computer:
... Be the site owner
... Be sharePoint admin
... Copy document manually
... Sign in to OneDrive
What happens when a file is deleted in SharePoint
... it appears in the sharepoint recycle bin
... it remains on the list, but is marked as deleted
... it appears in the user recycle bin
... it is permanently deleted
A User wants to be notified when a certain document changes, what can achieve this:
... document alert
... site alert
... library alert
... object alert
What is the easiest way to assign permissions to multiple sharepoint sites for multiple users
... by sites
... by users
... by groups
... by site levels
Enabled cloud hybrid search in your organization, what capability does this feature enable:
... the ability to search across multiple site collections
... the ability to search across any web app
... the ability to search sharepoint and oneDrive
... the ability to search both cloud and on-premises sharepoint sites
Which sharepoint component can use values such as text choice currency and lookup
... Library
... list
... Quick launch
... Navigation
Start saving work online, which application supports native file savings to sharpoint
... Word
... Outlook
... Acrobat
... Edge
User wants to know what options are available when versioning is enabled. Which not a versioning option:
... Open behavior for browser-enabled documents is default
... require content approval for submitting items
... Require documents to be checked out before they can be edited
... Indicate who should see draft items in this document library
True regarding sharepoint site collections:
... Site collection can exist in only one content database, however one content database can hold site collections
... site collection can exist in multiple databases, however one content database can hold only one site collection
... A site collection can exists in only one docntent database, and one content database can hold one site collection
... A site collection can exist on only one content database, and one content database can hold multiple site collections
New library is not appearing in the left-hand column of new sharepoint site. Which setting displays the library in the list:
... site permissions
... web part
... quick launch
... site template
User has requested that group documents be hidden from a sharepoint sites search capabilities. How do access this setting:
... library settings > audience targeting settings
... library settings > advanced settings
... site contents > edit
... Site Settings > Result types
Sketchup
SketchUp is a 3D modeling computer program for a wide range of drawing applications such as architectural, interior design, landscape architecture, civil and mechanical engineering, film and video game design
Which tool allows scale an edge to a new size that specify by typing in the desired measurement:
... scale
... protractor
... tape measure
... right-click in drawing window or on a group components, select measure from context menu, type the new value, and press enter (Return)
Which action is an arc tool:
...
Offset one face by 3'. Double click another face, what happens to second face:
... 2 face offset half distance of the first face 1t 1.5'
... nothing
... 2 face offset the first face at 6'
... 2 face offset at 3'
Extension:
... plugin developed for sketches that gives added functionality
What is the purpose of the 2D people included in some sketchup templates:
... practice using the select and eraser tools
... show scale reference
... create a point of inference
... introduce sketchup staff
Icon represents extrude surface:
...
Draw 10'6 by 5'3' rectangle, which measurement type while drawing:
... 10'6, 5'3
... 10'6 by 5'3
... 10'6 x 5'3'
... 10'6 x 5'3
Creating entity that will repeat model multiple times. Do:
... save it to own .skp file so reuse it
... make it group
... make it component
...save it to 3d warehouse for later use
Add selection:
... Hold down A key, activate the select tool, and click each entity that you would like to ass to the selection set
... activate the select tool hold down the tab key and click each entity that you would like to ass to the selection set
... Activate the select tool hold down shift key and click each entity you would like to ass to the selection set
... activate the select tool, press the _ and click entity that you would like to add o the selection set
Edges in flip mirror:
,,, 3
... 7
... 8
... 4
Which style settings icon select to change the color of the ground in your model:
While working on kitchen model, try using move tool to move a cabinet but accidentally click the stove and begin to move it: Do:
... activate the select tool let go of stove. Activate the move tool again, click cabinet
... Press esc cancel the move tool operation, click cabinet
... press D key to drip stove, click cab
... set stove down, move it back with move tool, click cab
Where purge model of needed data:
... page setup
... model info
... document setup
... sketchup preferences
Style displays only edges:
... wireframe
... sketchy edges
... shaded
... hidden line
What tools use to create accurate shadows in 3d building model
... Global Finder nd shadow Settings
... Locate and Sun Shading
... Geolocatioon and shadow settings
... Map finder and sun settings
Swift
Swift is a general-purpose, multi-paradigm, compiled programming language developed by Apple Inc. for iOS, iPadOS, macOS, watchOS, tvOS, and Linux. Swift is designed to work with Apple's Cocoa and Cocoa Touch frameworks and the large body of existing Objective-C code written for Apple products.
Code print:
enum postions : Int {
case first, second, third, other }
print (position.other.rawValue)
... 3
... nil
... 0
... Other
Modern Devices, how many bits used to store an INT?
... 100
... 80
... 64
... 10
Value of names after this code is executed:
let names = ["Bear", "Joe", "Clark"]
names.map { (s) -> String in
return s.uppercased()
}
... ["B", "3", "C"]
... ["Bear", "Joe", "Clark"]
... Code error
... ["Bear", "Joe", "Clark"]
Code example:
Class Square {
Var height : Int = 0
Var width " Int (
return Height
}
}
... Lazy Loading
... Computer property
... Closure
... Code error
What error in code:
Let x = 5
Guard x ==S {Return}
... Baird missing then
... Nothing
... Guard missing else
... Comparison wrong
Wrong with code:
var x = 5
x = 10.0
... cant assign double variable of type int.
... x constant
... x no type
... There is nothing wrong
How many parameters does the initializer for Test have:
... Struct Text {
var score : Int
Var date : Date
}
.... code error
... zero
... structs no initializers
... two
What can AnyObject represent:
... instance of function type
... Instance of any class
... instance of an optional type
... all
Wrong with Code:
self.Callback = {
self.attempts += 1
self.downloadFailed ()
}
... Need to define type of closure explicitly
... Nothing wrong with code
... cannot assign a value to closure in manner
... use of self inside the closures causes retain cycle
Data type example:
Let Vals = {"Val", 1)
... optional
... tuple
... code error
... dictionary
Unit testing
... XCTAssert
... all
... @testable
... XCText
Wrong with Code:
for [Ley,value] in [1:"one", 2"two] {
print (Key, Value)
}
... nothing
... interaction variable invalid
... comma in the print is misplaced
... interaction source is invalid
Sort the array:
Var Vals = [1,2,3]
... vals.sort(by:<)
... Vals.sort { (s1,s2) in s1<s2) }
... all
... Vals.sort { $0 <$1 }
Prints to console execute code:
let x = try? Strng.init("test")
print (x)
... nil
... Optional ("Test")
... Nothing - code error
... test
wrong with Code:
Class Person {
var name: string
var address: Sting
}
... Person has no initializers
... there nothing wrong with code
... address is keyword
... Person has no base class
Transact SQL
Transact-SQL is Microsoft's and Sybase's proprietary extension to the SQL used to interact with relational databases
Which query shows total points for each item in this database:
... select sun(points), teamFromsstudentsGroup ByTeam
... select team, sum(points) from students Group by Team;
... select team sum(points), team from students group by team
... selectteam, sum(points) FromstudentsGroup ByTeam
What result is returned after executing the following command:
Declare @myVariable int;
Set @MyVariable = 1;
Go
Select @MyVariable
... error
... 1
... null
... @myvariable
How many bytes of storage does the int data type consume:
... 8 bytes
... 4 Bytes
... 1 byte
... 2 byte
Select random student from table, which statement use:
... select top(1) first_name, last_name From Student
... select top(1) first_name, last_name From students Order by NEWID ();
... Select Top (1) First_name, Last_name From Rand(student);
... Select top(1) Rand(First_name, Last_name) From Student;
Given table: Query shows how many student are in the Students table
... Select Sum(+) From Students;
... Select Count (+) From Students;
... Count + From Students
... Select Students (Count) From students
Which following # people each team:
... Select team Count(ID) from Students Group by Team
... Select Count (id), team from students Group by id
... Select team, count (last_name) From students Group by team
... Select team, count(first_name) From Students Group By team
New employee has been fired. Given the information shown below, which SQL statement inserts the new employee into the employee table:
... Create Employee (FirstName, LastName, Department, Phone, Email(Address) Values ('abhiram', ......
... Insert Into Employee (FirstName, LastName, Department, Phone, emailadress) Values ('abhir...
... Insert FirstName = abhiram, LastName = Ravikumar, department=information systems , Phone=777-
... Insert into employee (Firstname, 'abhiram'), (LastName, 'Ravikumar'), (Department. 'Information......
See a list of different values in the color field in the garments table, which statement:
... Select Count(color) From Garments
... Select + From Garments Unique by Color
... Select Unique (color) From Garments
... Select Distinct (color) From Garments
Query returns all employees in information systems department
... Select * From Department Where 'Information Systems':
... Select * From Employee Where Department = 'Information Systems'
... Select * From Department Where 'Information Systems'
... Select * Where 'Information Systems' = Department
Given table below, which Query shows how many students are in each department:
... Select Department, Count(*) From Students Group by Department
... Select Students By Department
... Select Count (*) From Students Order by Department
... Select Count (*) From students
Given table, which query returns just names of four-player card games:
... Select GameName
From Games
Where Gameplay = 'Card' And
Where Maxplayers = 4;
... Select GameName
From Games
where Gametype = 'card' , maxplayers = 4
... Select GameName
From Games
Where Gametype = 'Card'
Or MaxPlayers = 4
Given table, query returns a list card games in alphabetical order:
... Select GameName
From Games
Where Gametype = 'card'
order by Gamename
... SelectGamename
From Games
Order By GameType, GameName;
... Select Gamename
from Games
Order by Gamename
Where Gametype = 'Card'
Diagram represents Join condition:
Table 1 Blue Circle Table 2 White
... table Left Join Table2
... table2 fullOuter Join Table2
... table1 Right Join Table2
... table1 inner Join table2
Given games table, Select query: Select * From Games Where GameID between 101 and 103:
A
What Result is returned after executing following commands:
Declare @testvalue int
Set @Test Value = 1
Select @testValue
Go
... Null
... error
... 1
... @testValue
Unity
Unity is a cross-platform game engine developed by Unity Technologies, first announced and released in June 2005 at Apple Inc.'s Worldwide Developers Conference as a Mac OS X-exclusive game engine. As of 2018, the engine had been extended to support more than 25 platforms
Humanoid character assets like NPC and the player character feature an Avatar object.
... Avatars define
... IK data for animated characters
... describe how textures map on deforming objects during animation
... facilitate animation retargeting across different humanoid characters
... parameter sets for facial muscle blend shapes
What can you use to visually distinguish between Play mode and design mode on the editor:
... gizmos
... handles
... object inspector
... play mode tint
How does the Range C# attribute control control the interaction behavior of numerical variables on the Object Inspector:
It restricts...
... the variable values using a color picker widget
... validates the variable values through a text box widget
... presents valid options in a drop-down list
... restricts variable values using a slider widget
Why should you be cautious about editing properties from the object inspector during Play mode:
... Play Mode changes ...
... are removed when reverting back to scene editing mode
... can disrupt gameplay and push your games into an uncontrollable state
... Can be misleading and are not reflective of a final build
... chaotic, intensive, and difficult to predict
Some material types may include normal map textures, what does a normal map achieve:
... creates appearance of surface detail on mesh - like bumps, dents, scratches
... programmatically reduces the polycount of meshes
... displaces mesh geometry with extrusions and bevels to generate higher poly versions
... level of detail system that proresivley reduces a mesh polygons as a scene camera moves farther away from it
Project window search box can filter display of assets with text commands, displays only texture assets:
... t:mesh
... t:texture
... t:mesh
... show textures
to build unity project successfully for an android mobile device, such as phone, tablet, for testing, what need:
... access Profiler and enable visual studio debugging
... purchase developer license
... install the JDK and android SDK tools for the relevant OS version
... Download the Unity Remote application
Dead bodies that drop and fall to the ground believably can be created using:
... Pivot objects
... Wind Zone Objects
... Ragdoll objectes
... characterController objects
.
UI elements, such as images and buttons, may be fixed at specific screen positions to build responsive interfaces. Unity features help achieve:
... opacity / transparency
... anchors / pivots
... Quaternions / euler angles
... events / raycasts
To create rain fire blood effects in Unity, type object:
... Particle system
... Primitive
... MeshFilter
... Reflection Probe
SkinnedMeshRenderer component attached automatically by Unity to some mesh objects when they are added to a scene, Reason best explain why:
... Mesh file contains humanoid character
... game object also features an animator component
... mesh file contains bones and rig data
... game objet a player controller character
Ray object mathematically define by:
... direction and width
... two end points
... an origin and direction
... direction
Two components cannot be attach etch to the same game object simultaneously:
... NavMeshAgent and CharacterController
... Transform and BoxCollider
... MeshRenderer and Animator
... Rigidbody 2D / Regidbody
Game objects marked by DonDestoryOnLoad become president, which means they will travel between scenes instead of being destroyed. however, this behavior can result in object duplication whenever the prayer revisits scenes where the objects were originally created. which design patter can prevent this from happening:
... Big O
... Binary Heap
... Singleton
... A-Star
Some Models import into unit rotated the wrong way, facing sideways or downward,
... Models always imported aligned with the main scene camera
... older versions of unity oriented models differently
... FBX mesh file was corrupted during the export process
... Some 3d Modeling applications have Z-Axis pointing upward
Visio
Visio lets you translate information into graphic diagrams so you can work visually. Create diagrams from hundreds of templates including flowcharts, timelines, floor plans, and more. Add shapes, text, and pictures and connect them to show relationships in your data.
Inserting hyperlink from one shape in a visio drawing. Which attributes of target shape must be specified as part of the hyperlink:
... Z-Order
... Master
... Name
... Type
What is a connector in visio:
... 1D shape used to connect 2 shapes
... container maintain an ordered relationship among its members
... shape that is glued to other to add comments
... visual boundary around sets of objects that also builds logical relationships
When shape is rotated in Visio, what does it rotate around:
... shapes center of gravity
... origin of the rulers
... center of page
... shape's pin position
A rack diagram is an example of ______ one which size on the page is dependent on size and scale of page itself
... scale drawing
... 2d drawing
... metric drawing
... units drawing
Created a timeline template in the schedule template category. Learned that project has been extended by another month. How change end date on timeline:
... x2 click timeline, change finish date, click OK
... re-create timeline using updated finish date
... select timeline shape , drag control handle right end of timeline to the right
... Right click timeline, change finish date, click OK
Which flowchart shape marks beginning of a process:
... diamond
... pill
... Rhombus
... trapezoid
Create a diagram showing many servers, switches, other devices in a large corporate environment:
... detailed network diagram
... rack
... wiring schematic
... baseline
Template categories in the Visio Standard desktop app:
... maps and floor plans
... engineering
... science
... software/database
Flowchart shape indicates a question or branch in process flow:
... trapezoid
... Square
... diamond
... Rhombus
Save a Visio drawing contains VBA macro, file format:
... .vsdx
... .vsdm
... .vstx
... .vssx
Icon lower right corner of the orginzational shape indicate:
[ Operson Manager 111 Chris Hopkins ___Red banches to 2 grey boxes]
... belt shape
... synchronized copy
... executive position
... hidden subordinates
Visio organization chart, which not standard shapes
... assistant
... executive
... manager
... associate
Defines relative front-to-back position of shape of drawing:
... x coord
... y coord
... z-order
... layer
Difference between the drawing tools in the tools group on the home tab and the drawing tools on Mini toolbar:
... tools Home tab auto revert to pointer tool after drawing 1 shape
... tools Home tab draw shapes with dashed line border
... tools Mini draw shapes red border
... tools Mini auto reverts pointer after drawing one shape
Some business process model notation (BPMN) shapes further annoyed by attaching a callout shape: option is associated with callout shape:
... Association
... text Annotation
... message flow
... data object
Windows Server
Windows Server is a brand name for a group of server operating systems released by Microsoft. It includes all Windows operating systems that are branded "Windows Server", but not any other Microsoft product. The first Windows server edition to be released under that brand was Windows Server 2003.
After running Powershell cmdlet add-windows feature adcs-cert-authority -includemanagmenttool on a windows server 2016 server, which command make root certificate authority:
... install -certificateauthority
... install -adscerticationAuthority -CAtype enterpriserootCA
... install -AdcsCertificationAuthority -CAType rootCA
... install-CertificationAuthority -CAType RootCA
Windows server technology enables replication of volumes between servers or clusters for disaster recovery:
... storage Replica
... Storage Spaces Direct
... stretch cluster
... storage spaces
Create a file share for company accessible all branch offices. share path have name Work Share. Server install:
... File Server
... BranchCache for Network Files
... Work Folders
... DFS Namespaces
Type of DNS record NOT specifically associated with AD domain controller:
... LDAP
,,, PTR
... GC
... Kerberos
Windows Server 2012 R2 VM available for use.Created XML file that includes all server roles and features required for a file server. File XML stored at root of the D: drive. What Powershell command runs configure server:
... install - windowsrole - configurationfilepath d:\fileserverconfig.xml
... install - windows feature - configurationfilepath d:\fileserverconfig.xml
... install - windowsservices - configurationfilepath d:\PowershellConfig.xml
... install - windows feature - configurationfilepath d:\root\powershellConfigFile.xml
When config CA server, role service provides web interface for users easily request / review certificates:
… network device enrollment service
… online responder
… certificate enrollment policy web service
… certification authority web enrollment
After adding a network printer to the Windows print server, try to add printer to windows 8 desktop client. While typing the network path to the new printer, unable find it, why new network printer unavailable for selection:
…. printer lost connection to the network
… need to re-add the printer to the print management console
… did not select the share the printer check box
… did not add printer drivers to the print server
Installation software:
… AD FS
… AD LDS
… AD DS
… AD CS
Where can you go to restore deleted objects in Active Directory without the use of Microsoft Powershell or Ldp.exe
… Active Directory sites and services
… Active directory domains and trusts
… active directory users and computers
… active directory admin center
The first or root server in a PKI must have active Directory Certificate services installed running which role service:
… Online responder
… Certificate Authority
… Network Device Enrollment service
… certification Authority Web Enrollment
Have a running Active Directory certificate services (AD CS) server and need to back up the certificate databases and private keys. Accomplish:
… use cretutil.exe command
… perform direct copy of database files and private keys to file share
… schedule and incremental backup of server
… schedule full backup server
Suppose file server in an on-premise server stack. Which disaster recovery tool available protect users data:
… RDC
… Azure File Sync
… DFSR
… Azure Site Recovery
Want to verify that DHCP server has been authorizes for use in Active Directory. Which cmdlet run in window powershell:
… install-windowsfeature DHCP
… Add-OhcpServerINBC
… Get-OhcpServerINBC
… Get-Windows feature a DHCP
Setting new branch 50 clients computers, all which has been joined to the existing Active Directory domain, deployed DHCP server and were able to log in with your domain admin credentials however local clients not receiving IP addresses. Cause:
… DHCP server not part of AD domain
… DHCP server not part of the DCP servers OU in AD
… DHCP server has not been authorized
… Domain Account is not part of the local computers Administrators group
Basic DHCP server provide clients with an IP address, subnet mask, default gateway, DNS IP address, and what other IP address.
… proxy server
… Wins server
… WSUS
… file server
Wordpress
Wordpress
The wordPress Rest API designed to receive and respond to particular types of requests using the basic HTML methods. Example, request upload PHP file into particular folder on a server might look likee the code Post/folder/_file.php. Based on code, what call /folder/_file.php (in rest API terms).
… response
… schema
… route
… request
Following file types Not involved in translating Wordpress
… .pot
… .mo
… .mot
… .po
Role of Wordpress Theme:
… controls colors, fonts, page layouts
… ensures site mobile responsiveness
… adds accessibility enhancements such as keyboard navigation and skip links
… All
CMS dominates marketer share and powers over a third of the web:
Wordpress
Wordpress hack:
… new logins
… password
… all software up-to-date
… all
Minutes installation:
5,10,15, 30
Plugins:
free or premium, functionality, add specific features
Improve site performance:
… load scripts and styles on pages where needed
… CDN
… CSS and Javascript fule minify
Rest API simple way get data in and out of wordpress over HTTP. Application using API written in programming language:
… any language can make HTTP requests and interpret JSON
… java
… node.js
… PHP
Wordpress file contains database connection info:
… index.php
… wp-login.php
… wp-config.php
… wp.-load.php
Color nested within div
… green blue black red
Theme developers adv from Customizer API to give users way manipulate basic themes settings. Customizer API object oriented and provides four main objects:
… panels. blocks, controls, settings
… widgets containers, sections, settings
… containers, hooks, settings, styles
… panels sections controls, settings
The Rest API data format
… json
… xml
… yaml
… txt
Block editor:
… injecting specialized scripts into content area
… cropping images in media library
… creating site layout
… creating and laying out content
Who owns trademark for Wordpress and Wordcamp names and logos:
…. automatic
… Matt Mullenwig
… Wordpress Foundation
… Wordpress.com
Wordpress
Block Editor:
… creating laying out content
Install transience and object cash:
Transicence Pesistant and write to wp_options
object cash particular page loads
Wordpress Theme:
… Colors fonts, page layouts
… accessibility keyboard navigation links
… mobile responsiveness
Editor, blocks rendered javascript, how Front end:
… Plain HTML
WP CLI manage capabilities of WP user role:
… WP admin
Not task runner:
… webpack
code
if had post
- Nested loop (if statement)
Wordpress rest API request HTML php file to Post/folder _file php: …Requests
Debug javascript display data console
… console log
custom script only on contact page:
- function lead scripts
- If
- WP
Service mare user photos:
gravatar
posts not page:
… content part of blog
javascript library: block editor interface
… React X
code for marking translation:
… translation
Wordpress block editors blocks paragraphs images quotes shortcode Not category WP:
… Widgets
XML
Working with following XML code Snippet, Path expression produces C-Class:
… /car[Price>=2000 and @year>=2009]/make/model
… /car[price>=2000]/make/model
Which Ajax method is used to change data with a server using modern browser:
… XMLHttpRequests
… responseXML
… ActiveXObject
… Requests - XML
Convert HTML file into XHTML strict. code snippet validate without errors:
_______
Type of DTD declaration code example:
<!DocType abc System “Files/file.dtd”>
… internal
… linked
… external
… structured
Working with th XML code snippet form the XML document cars.xml. need return information about cars built after year 2000. Query:
… doc{“cars.xml”)/cars/car[xs:integer(year) gt 2000)
Working with Code XML code Snippet, line XSLT code xml:value-ofselect=“//car/make”/>. does it display:
… cadillac escalade 20000
… cadillac escalde $20,000
… cadillac
… Cadillac Escalade
XML DTD Attlist decleration, default used to indicate attribute does not have to be included:
… #default
… #fixed
… #implied
… #optional
XHTML syntax rule does Not apply to XML:
… XHTML tags and attributes must be in lowercase
… XHTML tags must have an equivalent closing tag
… XHTML attribute values must be quoted
… XHTML elements must be properly nested with each other
Statement Not sure about Xml:
… flexible customizable
… replacement for HTML
… independent of any operating system
… be used store data
Last step in extending XHTML modules:
… Last step to create DTD XHTML extension, which references both XHTML modules and the new modules
… last step to verify that the XHTML well formed and valid, and compatible with most browsers
… last step is to run XHTML extension through the XSLT processor, properly format it.
… Last step to complete the extension of XHTML compound documents adhere to define namespaces
Working with XML document that uses an XML schema, how do you specify element can appear multiple times its parent element:
… set the MaxOccurs attribute to unbounded
… set Max Occurs attribute to undefined
… set MaxOccurs attribute large number such as 1,000
… set the axOccurs Attribute attributes to 0
Working with XML code snippet, correct XSD declaration for the <price> element:
______
Correct Syntax for comments in XQuery:
… //
… (: :)
… <! -- —>
… /* */
XML DTD AttList Declaration, which tokenized attribute is used to specify multiple ID values:
… IDS
… IDSETS
… ENTITIES
… IDREFS
Code example:
<X a=“x” a=“y”></x>
… self closing tag
… improperly named element
… incorrect XML syntax
… null element
XML
Last step extending HTML modules:
Create DTD for XMLHTML extension both modules
Aynschounous Javascript and XML Ajax better web application, Both back end, tech used craft AJAX experiences on Front end:
… HTML CSS DOM
Converting HTML inXML script:
… <html
color “#33333”
XML snippet: XSLT code xml:value of select = // car / make’
… Cadillac Escalade $20,000
Display list cars codes column format with counter column each row, x path :
.. count
XML snippet Document cars return info built after 2000 x query:
… <cars>
<ol>
x/year DESCENDING
Ready state status processing XMLHTTPrequest which not valid:
… Processing 1
IS: loading DONT Unsent
XML Doc schema, extends docs:
… XS extension
Convert Large XML to CSS , best syntax info:
… AJAX
SNippet Xpath expression produces C class:
Car price >2000 make model
Main ways control display CSS and extendible Styles languages advantage CSS over XML:
… CSS same element process multiple times
XHTML DTD blowed syntax grammar: not formal DTD:
… Basic
<XSL with param defines pass to template into elements:
… apply and call
XML doc schema , attribute specified to element:
Xs: required
XSLT code: Merced, cadillac, ford:
… Make
No comments:
Post a Comment