CompTIA FC0-U61 Online Practice Questions and Exam Preparation

CompTIA FC0-U61 Online Questions & Answers

• Question 201:

  A database administrator finds that a table is not needed in a relational database. Which of the following commands is used to completely remove the table and its data?

  A. UPDATE
  B. DELETE
  C. ALTER
  D. DROP
  D. DROP

  ---

  Explanation/Reference:

  CREATE—this command can be used to add a new database on the RDBMS server (CREATE DATABASE) or to add a new table within an existing database (CREATE TABLE). The primary key and foreign key can be specified as part of

  the table definition.

  ALTER TABLE—this allows you to add, remove (drop), and modify table columns (fields), change a primary key and/or foreign key, and configure other constraints. There is also an ALTER DATABASE command, used for modifying

  properties of the whole database, such as its character set.

  DROP—this is the command used to delete a table (DROP TABLE) or database (DROP DATABASE). Obviously, this also deletes any records and data stored in the object.

  CREATE INDEX-specifying that a column (or combination of columns) is indexed speeds up queries on that column. The tradeoff is that updates are slowed down slightly (if the column is not suitable for indexing, updates may be slowed

  down quite a lot.) The DROP INDEX command can be used to remove an index.

  There are also SQL commands allowing permissions (access controls) to be configured. These are discussed in the upcoming pages.

• Question 202:

  A developer is in the process of creating a program and has started to draft the logic of the code. This process is an example of:

  A. drawing a value stream map.
  B. developing pseudocode.
  C. identifying functions.
  D. compiling the language.
  B. developing pseudocode.

• Question 203:

  Which of the following describes the concept of a database record?

  A. A collection of rows, columns, and constraints
  B. A collection of fields about the same object
  C. A collection of schemas within the same database
  D. A collection of tables within different schemas
  B. A collection of fields about the same object

• Question 204:

  Which of the following computing devices is MOST likely to have an internal wireless antenna?

  A. Mobile phone
  B. Workstation
  C. Server
  D. NAS
  A. Mobile phone

• Question 205:

  A large percentage of computers within an organization are suddenly reporting that their operating systems may be illegally obtained. Which of the following is the MOST likely cause?

  A. The key management server is offline
  B. Internet access is unavailable
  C. Hackers have stolen the organization's license
  D. The company did not pay for the license
  D. The company did not pay for the license

• Question 206:

  A user's personal wireless network name includes the user's last name. To make the wireless network less identifiable, which of the following would the user access to change the wireless network name to exclude?

  A. WEP
  B. SSID
  C. WAP
  D. WPA2
  B. SSID

• Question 207:

  A company has a reoccurring issue that involves users having antivirus browser extensions installed after updating to the latest version of the company's antivirus software. Which of the following would prevent this issue?

  A. Clearing browser history
  B. Changing proxy settings
  C. Disabling certificate verification
  D. Disabling browser extensions
  D. Disabling browser extensions

• Question 208:

  Which of the following is the MOST likely benefit of a structured database?

  A. Higher security
  B. Faster accumulation
  C. Easily searchable
  D. Fewer storage requirements
  C. Easily searchable

  ---

  Explanation/Reference:

  One of the most significant benefits of a structured database is that it allows for easy and efficient searching and retrieval of data. With a structured database, you can use query languages (e.g., SQL) to quickly find and retrieve specific information, which is essential for data management and analysis.

• Question 209:

  An employee uses a password to log in to a company computer. Which of the following authentication methods did the employee use to gain access to the network?

  A. Single-factor
  B. Single sign-on
  C. Permissions
  D. Multifactor
  A. Single-factor

• Question 210:

  Which of the following internet service types is most susceptible to weather disruptions?

  A. Cable
  B. Satellite
  C. DSL
  D. Fiber
  B. Satellite