What would be the best data center site for the Project Falcon team?
Question 11 Select one:
a. A location that has good sightlines to satellites for high-speed internet connections
b. A remote location in a geologically stable area where the probability of a significant disruption is less
c. A location in a jurisdiction that is willing to offer tax subsidies to compensate for lack of labor and other infrastructure
d. A location in a politically stable jurisdiction with good access to skilled labor, transportation systems and a strong internet backbone
If we need to design an SQL structure to eliminate a table that has been created and is not needed anymore, which of the following clauses should we include in the command syntax?
Question 12 Select one:
a. DROP TABLE tablename
b. ERASE TABLE tablename
c. DELETE TABLE tablename
d. REMOVE TABLE tablename
To address security concerns, the Project Falcon team has decided to use Secure Socket Layer (SSL). Why is it the most appropriate tool to address these concerns?
Question 13 Select one:
a. SSL uses both public key encryption and private key encryption
b. SSL uses private key encryption alone because public key encryption is too slow
c. SSL incorporates its own encryption scheme which is outside of public key and private key
d. SSL uses public key encryption only because there is not a practical way to get a private key involved
When implementing subject-object security to mitigate against security threats, which of the following is correct?
Question 14 Select one:
a. The subject and object are interchangeable, and their roles can switch depending on the situation
b. The subject is the data/resource being accessed, and the object is the person/system accessing it
c. Subject-object security does not apply to digital systems and is only relevant in physical security scenarios
d. The subject is the person/system accessing the object, and the object is the data/resource being accessed
Which type of user authorization on a relation allows a user to modify any tuple in the relation?
Question 15 Select one:
a. Grant authorization
b. Select authorization
c. Define authorization
d. Update authorization
In developing both internet and non-internet databases, which of the following represent major differences that the Project Falcon team will need to be aware of?
Question 16 Select one:
a. Control issues, reduced data types, and connectivity issues
b. Connectivity issues, control issues, and extraction into XML
c. Extraction into SQL, expanded data types, and control issues
d. Expanded data types, extraction into HTML, and connectivity issues
Which of the following security criteria is most effectively addressed by an authentication system?
Question 17 Select one:
a. Ensuring that data are available
b. Verifying that a given modification is valid
c. Ensuring that data integrity is not compromised
d. Verifying the identity of the user requesting access
The DBA on the project described in the case will be asked to make a recommendation on selecting a DBMS vendor that is cost effective. Which of the following factors would you include when calculating the cost of owning a DBMS?
Question 18 Select one:
a. The cost of the managers supporting the decision support system
b. The license cost of any required network support software and systems
c. The cost of the network administrators to manage the communications system
d. The cost of the database professionals to program, support, and administer the DBMS
Which of the following SQL symbols should be used in a query statement when we want to represent all of the columns in a single table?
Question 19 Select one:
a. # (pound)
b. * (asterisk)
c. % (percent)
d. ? (question mark)
Sometimes staff change roles and gain new permissions without eliminating outdated and unneeded privileges. Which of the following methods addresses this?
Question 20 Select one:
a. Pass the hash
b. Permissions creep
c. Role-based access
d. Principle of least privilege
Answer (3)
The best data center site for the Project Falcon team is a location in a politically stable jurisdiction with access to skilled labor, good transportation systems, and a strong internet backbone. This ensures operational efficiency and security. Therefore, the chosen option is d.
;
Here are the correct answers for each of the questions you've listed:
Question 11:
What would be the best data center site for the Project Falcon team?
✅ Correct answer: d. A location in a politically stable jurisdiction with good access to skilled labor, transportation systems and a strong internet backbone
This ensures long-term reliability, skilled workforce availability, and infrastructure support.
Question 12:
To eliminate a table that has been created and is not needed anymore, which clause should we include?
✅ Correct answer: a. DROP TABLE tablename
The DROP command is used to remove an entire table from a database.
Question 13:
Why is SSL the most appropriate tool to address security concerns?
✅ Correct answer: a. SSL uses both public key encryption and private key encryption
SSL/TLS uses asymmetric encryption to establish a secure session and symmetric encryption to transfer data.
Question 14:
In subject-object security, which is correct?
✅ Correct answer: d. The subject is the person/system accessing the object, and the object is the data/resource being accessed
This is the standard security model in access control systems.
Question 15:
Which user authorization allows modification of any tuple in the relation?
✅ Correct answer: d. Update authorization
UPDATE allows changes to existing records (tuples) in a table.
Question 16:
Major differences between internet and non-internet databases?
✅ Correct answer: a. Control issues, reduced data types, and connectivity issues
Internet databases deal with more restrictions on data types and connectivity compared to local systems.
Question 17:
Which security criterion is addressed by an authentication system?
✅ Correct answer: d. Verifying the identity of the user requesting access
Authentication is specifically designed to confirm identity.
Question 18:
Cost factors for owning a DBMS?
✅ Correct answer: d. The cost of the database professionals to program, support, and administer the DBMS
Personnel cost is a major component of total cost of ownership.
Question 19:
SQL symbol to represent all columns in a table?
✅ Correct answer: b. * (asterisk)
Using SELECT * FROM table; fetches all columns.
Question 20:
Which method addresses outdated and unneeded privileges?
✅ Correct answer: d. Principle of least privilege
This principle ensures users only have access necessary for their current role, helping prevent privilege creep.
Let me know if you'd like a printable version or explanation for any answer! ;
Let's go through each of the multiple-choice questions one by one:
Question 11: The best data center site should ideally offer a combination of a stable environment, skilled labor, and infrastructure. Thus, the correct option is: d. A location in a politically stable jurisdiction with good access to skilled labor, transportation systems and a strong internet backbone
Question 12: To eliminate a table in SQL, you use the DROP TABLE syntax. Thus, the correct option is: a. DROP TABLE tablename
Question 13: SSL is used because it utilizes both public key and private key encryption to establish a secure connection. Therefore, the correct option is: a. SSL uses both public key encryption and private key encryption
Question 14: In subject-object security models, the subject is the entity that accesses the resource and the object is the data/resource being accessed. Thus, the correct option is: d. The subject is the person/system accessing the object, and the object is the data/resource being accessed
Question 15: Update authorization allows a user to modify any tuple in the relation. Therefore, the correct option is: d. Update authorization
Question 16: Internet and non-internet databases differ mainly in connectivity, control, and extraction concerns. Hence, the correct option is: b. Connectivity issues, control issues, and extraction into XML
Question 17: Authentication systems are primarily designed to verify the identity of users. Therefore, the correct option is: d. Verifying the identity of the user requesting access
Question 18: In calculating the cost of owning a DBMS, the cost of database professionals is critical. Thus, the correct option is: d. The cost of the database professionals to program, support, and administer the DBMS
Question 19: In SQL, the asterisk symbol (*) is used to select all columns in a table. Therefore, the correct option is: b. * (asterisk)
Question 20: To manage changing roles and permissions without accruing outdated privileges, the principle of least privilege is essential. Hence, the correct option is: d. Principle of least privilege
These answers highlight key aspects of data management, security, and SQL usage, which are important in the field of Computers and Technology.
