CIS 207T Week 4 Quiz

CIS 207T Week 4 Quiz | University of Phoenix | Assignment Help

1.

Michael, an administrator, needs to add a column to an existing table. Which command should he use?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A ALTER 

B INSERT

C UPDATE

D CREATE

2.

Your friend Maria asks you which router feature provides for guaranteed bandwidth. What do you tell her?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Firewall

B QoS

C DNS

D DHCP

3.

Which of the following connectivity options gives you the best mobility?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Cellular

B Wireless

C Wired

D Broadband

4.

Of your internal network connection options, which one can provide the fastest speeds?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A UTP

B 802.11n

C Infrared

D Fiber

5.

Kate, a database administrator, needs to add records into a database. Which command should she use?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A ALTER

B UPDATE

C CREATE

D INSERT 

6.

A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A CPU

B SSD 

C Cache

D RAM

 7.

Rachel, a database administrator, has created a database for her website. It contains pictures of vacations that people have uploaded. In the database, pictures have associated information about who uploaded them and the date. What is this an example of?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Schema definition

B Structured data

C Non-structured data

D Semi-structured data 

8.

Joe creates a database. What does he need to do next to make it usable?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Import data (Correct)

B Enable permissions

C Create forms

D Run queries

9.

When configuring a wireless router, which of the following should you always do?

Each correct answer represents a complete solution. Choose two.

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Change the SSID. 

B Change the admin password. 

C Configure the firewall.

D Enable DHCP.

 10.

George needs to remove a customer’s information completely from a table. Which command should he use?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A ALTER

B UPDATE

C DELETE  

D DROP

11.

Which one of the following types of network connections can give you the highest data transfer rates?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A DSL 

B T1

C Cellular

D ISDN

12.

Oscar’s user account has been granted permissions to view a database. Nathan then uses the deny command in an attempt to deny Oscar the ability to view the database and applies it to a group to which Oscar belongs. Which of the following statements is true?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Oscar will still be able to view the database because granted permissions must be removed with the revoke command.

B Oscar will no longer be able to view the database, because the deny cancels the grant, giving Oscar no specific permissions.

C Oscar will no longer be able to view the database because a deny overrides a grant.(Correct)

D Oscar will still be able to view the database because a grant overrides a deny.

13.

ize that you forgot your password. What can you do?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Hold the reset button down for 30 seconds to reset the router. (Correct)

B Use the password reset option in your router configuration utility.

C Unplug the router and plug it back in.

D Use the default password of admin.

14.

What command would you use on a Mac to determine your TCP/IP configuration information?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A tcpipconfig

B Ifconfig

C ipconfig

D Ipinfo

15.

You are helping a friend who is opening a small tax preparation firm. She needs to set up an office network for five users. Her office will need Internet access, and because she is dealing with confidential financial information, security is a big concern. Your friend wants the tax prep agents to be able to let clients connect their wireless devices to the network. Which password should she tell the agents to give to clients?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A tpg$2019

B Tx$pr4y2

C No password is required.

D 7ygH$2p*

16.

Which one of the following addresses is considered a private IP address?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A 168.192.100.101

B 19.21.68.100

C 172.15.100.101

D 192.168.100.101 

17.

Which of the following descriptions best describes the type of structure that stores values as blobs?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Document database

B Non-relational database

C Relational database

D Key/value database 

18.

You are helping a friend who is opening a small tax preparation firm. She needs to set up an office network for five users. Her office will need Internet access, and because she is dealing with confidential financial information, security is a big concern. When connecting client computers to the network, what password do they need to enter?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A 7ygH$2p*

B tpg$2019

C  No password is required.

D Tx$pr4y2

19.

You have created a relational database. Which of the following elements uniquely identifies a record in the database?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Primary key 

B Foreign key

C Schema

D Field

20.

Which one of these connection types has the longest delay?

This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.

A Wired

B Infrared

C Wireless

D Cellular