CompTIA FC0-U61 Online Practice Questions and Exam Preparation

CompTIA FC0-U61 Online Questions & Answers

• Question 141:

  A technician is selecting a processor for a custom PC. Which of the following units would be used to compare the speed of the various processors?

  A. GHz
  B. MHz
  C. GBps
  D. MBps
  A. GHz

• Question 142:

  Which of the following features will render a file unreadable without the proper cipher?

  A. Compression
  B. Encryption
  C. Permissions
  D. Password
  B. Encryption

• Question 143:

  A programmer needs to specify how to store a test score entered using a web form. Which of the following would be best to use?

  A. Variable
  B. Vector
  C. Constant
  D. Array
  A. Variable

• Question 144:

  Which of the following database design requirements is MOST likely a reason to implement a flat file?

  A. Data type flexibility
  B. Scalability
  C. Simplicity
  D. Search speed
  C. Simplicity

• Question 145:

  A developer needs to add a table to a database. Which of the following database activities should the user perform?

  A. UPDATE
  B. ALTER
  C. CREATE
  D. REPORT
  C. CREATE

  ---

  Explanation/Reference:

  Data Definition Language (DDL) commands refer to SQL commands that add to or modify the structure of the database. Some examples of data definition commands are:

  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.

• Question 146:

  Which of the following language types would MOST likely be used to display information in a web browser?

  A. Assembly
  B. Scripting
  C. Markup
  D. Compiled
  C. Markup

• Question 147:

  Which of the following internet service types would MOST likely be utilized by a large data center?

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

• Question 148:

  Which of the following interfaces is best for viewing database performance information?

  A. Direct
  B. Programmatic
  C. Query
  D. Utility
  D. Utility

• Question 149:

  A game developer is purchasing a computing device to develop a game and recognizes the game engine software will require a device with high-end specifications that can be upgraded. Which of the following devices would be BEST for the developer to buy?

  A. Laptop
  B. Server
  C. Game console
  D. Workstation
  B. Server

• Question 150:

  A database administrator has placed data from another source into a database. Which of the following did the database administrator perform?

  A. Import
  B. Export
  C. Create
  D. Query
  A. Import