Domain 8: Software Development Security Deck 2

Question 1

Polyinstantiation

Answer 1

With DBs:

When two or more rows (tuples) in the same DB appear to have the identical primary key elements but contain different data for use at different classification levels.

Question 2

SQL - Stored Procedures

Answer 2

A stored procedure is a pre-programmed set of Structured Query Language (SQL) commands that are stored on the SQL server, not the client application.

Used to limit what commands can be used.

(if commands are stored in the application rather than the DB, then this is called “Parameterized Queries.”)

Question 3

Parameterized Queries

Answer 3

SQL statement/command is pre-prepped in the application code and user input is then fed into this command/commands. Command is NOT stored on the SQL server (if it was, then this would be an example of “Stored Procedures.”)

Question 4

Expert System

Answer 4

Type of artificial intelligence: A system that seeks to embody the accumulated knowledge of humankind on a particular subject and apply it in a consistent fashion to future decisions. The application of computerbased artificial intelligence in areas of specialized knowledge.

Uses a series of if/then statements to come to a decision