CompTIA ITF 9,10

How does Microsoft SQL Server differ from Microsoft Excel when used to store a dataset?

• Excel is an example of relational database software that is better suited for larger volumes of information and more users, whereas SQL Server is a flat file system.

• Excel is an example of relational database software, whereas SQL Server is a flat file system that is better suited for larger volumes of information and more users.

• Excel is an example of a flat file system that is better suited for larger volumes of information and more users, whereas SQL Server is relational database software.

• Excel is an example of a flat file system, whereas SQL Server is relational database software that is better suited for larger volumes of information and more users.

What are the structural elements of a database?

• Each table stores information about queries and reports.

• Each query stores information about tables in reports.

• Each report stores information about tables in fields.

• Each table stores information about records in fields.

An INSERT statement is an example of what data language type?

• Data Definition language

• Data Manipulation Language

• Both Data Manipulation Language and Data Definition Language

• Neither Data Manipulation Language nor Data Definition Language

You need a development environment with a library of database functions. What type of interface are you using?

• Direct/Manual Access

• Programmatic access

• Query/Report Builder

• Utility Access

What term is used to describe selecting and viewing information in a database?

• Report

• Query

• Storage

• Create

What language is usually used to request data from an RDBMS such as Oracle?

• eXtensible Markup Language (XML) is used to query RDMBS-based database platforms.

• Structured Query Language (SQL) is used to query RDBMS-based database platforms.

• Hypertext Markup Language (HTML) is used to query RDBMS-based database platforms.

• Java is used to query RDBMS-based database platforms.

Which of the following is NOT an example of unstructured data?

• PowerPoint presentation

• Image files

• Text files

• Relational databases

What provides sound functionality in a personal computer?

• Sound functions in modern PCs will send your audio directly to an external radio for processing.

• Sound functions must be provided by a plug-in sound card.

• Sound functions are provided by a plug-in card with external speakers.

• Sound functions are often provided by the motherboard chipset.

What is the main advantage of using a CPU in 64-bit mode?

• It's new and technically more scalable than the 32-bit CPU.

• CPUs don't use 64-bit mode; they are limited to 16 bits. This means that each instruction is 16-bits "wide".

• There are no advantages of a 64-bit CPU over a 32-bit CPU. They cost more money and are not worth the cost.

• 64-bit software is more reliable and a bit faster than 32-bit software. It also supports more system memory.

  ANot Selected

  BNot Selected

  CSelected

  DNot Selected

How would you access the system setup program on a PC?

• Historically, by pressing and holding the Windows key (4 little white boxes) on your keyboard. Modern PCs use the function key "F5"

• Historically, by pressing the appropriate key during startup (ESC, DEL, F1, F2, or F10). Modern PCs often use fast boot modes that require some other means of booting to the firmware setup program.

• Logically, by pressing CTL+ALT+DEL twice during startup. Just like when you want to exit a program on your PC.

• Logically, by pressing ALT+F4 during startup will access the startup menu through windows.