Software Security 101A

1- Which type of programming language has the following advantage and disadvantage:

• Advantage: The program runs quickly once the entire code has been translated.

• Disadvantage: It is more difficult to find fix errors.

• Compiled

• Markup

• 
  

  Query

• Interpreted

• Scripted

2- What type of language is primarily used to make searches in a database?

• Compiled

• 
  

  Markup

• Query

• Interpreted

• Scripted

Question: 3

Which of the following is an example of the string data type?

• 4

• true

• 
  

  “Karel”

• 
  

  3.5

• false

Question: 4

Which of the following is an example of the boolean data type?

• “Computer science”

• 
  

  false

• 4.6

• 
  

  -10

• Var

Question: 5

Why do programmers use variables?

• To confuse other programmers
• To make the code longer
• To add unnecessary complexity
• To store and manage data in programs.
• To repeat lines of code and make their programs more efficient.

Question: 6

You want to create a program that stores a user’s name and their email address as a key, value pair. What type of programming construct should you use?

• Set
• Tuple
• List
• Array
• Dictionary or Object

Question: 7

What type of language is HTML?

• Scripting language
• Database language
• Programming language
• Query language
• Markup language

Question: 8

You want to pull a list of users whose last name is not Smith. What SQL clause should you add to the following query to return the correct dataset?

SELECT name FROM User

• SELECT name FROM User WHERE last_name = 'Smith'
• SELECT name FROM User WHERE last_name <> 'Smith'
• SELECT name FROM User WHERE last_name != 'Smith'
• SELECT name FROM User WHERE last_name NOT IN ('Smith')
• SELECT name FROM User WHERE last_name NOT LIKE 'Smith'

9- What is the CIA Triad?

• Confidentiality, Availability, and Authorization
• Confidentiality, Integrity, and Authentication
• Confidentiality, Integrity, and Availability
• Confidentiality, Integrity, and Reliability
• Confidentiality, Integrity, and Non-repudiation

10- What is SQL?

• SQL is a software used for graphic design.
• SQL is a type of computer hardware.
• SQL is a social media platform.
• SQL is a programming language used for creating websites.
• SQL is a domain-specific language used for managing data in relational database management systems.