Summary Flashcards

1
Q

What is called the the path that goes from the start point of the program to the end point?

A

The path of execution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Abstract data?

A

Data where we are only concerned about what it is supposed to do, not about how it does it.
Ex: the brakes of a car.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is Machine instruction?

A

Bult-in actions that the CPU can perform.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is Opcode?

A
  1. Short for Operation code.
  2. Is a part of machine isntruction.
  3. A set of binary numbers that specifies the exact operation to be performed.

Ex: In a machin instruction like: 0111011010, the first three digits “011” would be the opcode. This could mean “Add a number to an earlier number”. The other part could be the number to be add to the earlier number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Bit pattern?

A

A particular layout of bits used to represent numbers, character, etc.

Ex: 100 0001 represent the letter “A”.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ASCII?

A

American Standard Code for Information Interchange.

A standard chart that represent characters using binay codes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How many digits ASCII uses to represent each character?

A

7.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

RDBMS?

A

Relational Database Management System.

A type of computer program used to manage relational database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Query?

A

A specific instruction to a computer to search through a database and collect all data that matches a certain criteria.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

SQL?

A

Structured Query Language.

A language to monitor and handle databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

T-SQL?

A

Transact-structured query language.

A language Microsoft made to add additional functionality to SQL.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

SQL server?

A

Short for Microsoft Structured Query Language Server.

Is a RDBMS developed by Microsoft.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is Unit Test?

A
  • unit, individually, independently, checked.

A teste where a unit is individually and independently checked for proper operation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a unit in a unit test?

A

The smallest testable parts of an application.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is UAT?

A

User Acceptance Testing.

A phase in software development where the software is given to the intended audience to be tested for functionality.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the first meaning o mapping?

A

Establishing a connection from one computer to another computer or device in a network.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the second meaning o mapping?

A

The correspondence from elements of a set of data to the elements of another set of data in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a Field?

A
  1. Space in a data structure that is reserved for a particular information.
  2. The smallest unit of information a user can access.
  3. Have certain attributes associated with them (numbers, text, etc.)

Ex: cells in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is CLI?

A

Command-line Interface.

A interface based on text.

20
Q

What is ALM?

A

Application Lifecycle Management.

21
Q

Give an example of an ALM.

A
  1. Requirements gathering.
  2. Architecture planning.
  3. Development.
  4. Test.
  5. Deploy.
22
Q

What is Active Diretory?

A

A software from Microsoft that provides central authentication and authorization services for computers.

23
Q

What is a Batch File?

A

A file containing a list of instructions to be carried out in order. Most often used in the Windows.

24
Q

What is Data Redudancy?

A

Data stored in more than one table in the database.

25
Q

What is Data Normalization?

A

The process of organizing the tables in order to eliminate data redundancy.

26
Q

What is 1NF?

A

First Normal.

Maximum possible level of normalization of a data base.

27
Q

What is a Primary Key in a database?

A

A piece of data used to uniquely identify a specific row in a database table.

28
Q

What is a Foreign Key?

A

A column in one table that holds the data from a primary key in another, related table.

29
Q

What is O/RM?

A

Object Relational Mapping.

A program that maps between objects in a program and tables in a database. When you modify an object in the program, you can use the O/RM to modify the data in the database that correspond to that object.

30
Q

What is Entity Framework?

A

An O/RM program. Used with C# language.

31
Q

What is LBA?

A

Line of Business Application.

Purpose-built piece of software that helps a company in whatever their line of business is.

32
Q

What is a Registry?

A

A place where records are kept.

33
Q

What is a Registry in Windows?

A

A database that stores settings of the operating system, drivers and applications.

Ex: when a new program is installed, instructions (such as how to start it and how the program should work) are stored in the registry.

34
Q

What is KVP?

A

Key-value pair.

Two linked data:

  1. Key -> a unique identifier for some data.
  2. Value -> the data identified by the key.
35
Q

What is a subkey pair in the windows registry?

A

Its a node in the tree data structure of the windows registry. It’s the key + value.

36
Q

What tool can be used to launch the windows registry?

A

Windows Registry Editor or Regedit.exe.

37
Q

Describe the Terminator flowchart symbol.

A

A rectangle with rounded cornes.

Indicates the beginning and the end of the program.

38
Q

Describe the Decision flowchart symbol.

A

A diamond shape.

Indicates a decision point between two or more paths in a flowchart.

39
Q

Describe the Process flowchart symbol.

A

A rectangle.

Indicates any processing function.

40
Q

Describe the Dataflowchart symbol.

A

A parallelogram.

Can represent any type of data in a flowchart.

41
Q

What is the Peek behaviour?

A

To get the next item to be poped in a stack or queue.

42
Q

What is PHP?

A

Short for Hypertext Preprocessor.

Scripting language designed for web development.

43
Q

How an Insertion Sort algorithm works?

A

In an insertion sort, the list of items is gone through, one item at a time, starting at the beginning.

As each item is reached, the correct location earlier in the list is found for it, based on the desired outcome.

44
Q

How a Selection Sort works?

A

In a selection sort, the list of items is divided into two lists: a list of sorted items (initially empty), and a list of unsorted items (initially this has all the items in the list). The unsorted list is then gone through, one item at a time. Each item is placed in the sorted list at the correct point, according to the desired outcome. Once all items in the unsorted list have been handled, the sorted list is the final product.

45
Q

How a Bubble Sort algorithm works?

A

In a bubble sort, the list of items is gone through, one item at a time, starting at the beginning.

As each item is reached, it is compared to the item previous to in the list. It is swapped if the desired outcome requires it