[solved] – Question 76262

In regards to the previous technical issue, a couple employees are calling to the help desk to complain that they can’t connect to the network, as they are not getting an IP Address from the DHCP Server. After analyzing the issue, you realized that these users are located in a different network. Which DHCP configuration will allow these users to get an IP Address?

Expert Answer


[solved] – Question 76263

You are building a windows environment for a new company with 400 users across 2 cities. You want to keep the level of complexity to the minimum. But you want to make sure that the proposed infrastructure will support any future growth.

a)Define the types and number of containers that you are planning to deploy in the new solution. Provide a justification for your recommendation(s)

b)Since the company has offices in 2 cities, do you recommend the implementation of Sites? Provide a justification for your recommendation

c)Assuming you are implementing Sites, how can you control the data replication between multiple Active directories on both sites?

d)Using Microsoft Visio, develop a logical design diagram (FYI, Microsoft Visio is available in all computers @ Seneca)

Expert Answer


[solved] – Question 76265

A medium size organization is running a relatively old windows infrastructure. Unfortunately, the organization has small IT budget to do any upgrades. The IT manager has identified some critical areas in the currently infrastructure that needs to improved asap, or the organization may be faced with services outages. One of these areas includes the DNS infrastructure. Currently, the organization has a single DNS server for the entire company. Provide a group of options to improve the DNS infrastructure. Describe the main advantages and disadvantages of each of your options.

Expert Answer


[solved] – Question 76266

A junior system administrator needs to build a script to list all properties from all users in active directory. Create a userID and name it “patrick101”. Research the windows command(s) that will provide to the junior system administrator with all properties from this new user. Execute the command and provide the output.

Expert Answer


[solved] – Question 76322

I need to program an tic tac toe game on MSP432 with the booster board programming in c.

Expert Answer


[solved] – Question 76329

Difference between natural join and inner join

Expert Answer


[solved] – Question 76373

When adding a column to a table, what is the keyword used to make values for the column required? Think how you would avoid that column being empty (no value).

NULL

NOT NULL

PRIMARY KEY

UNIQUE

Expert Answer


[solved] – Question 76374

Referential Integrity is enforced via…

foreign keys

NOT NULL values

NULL values

primary keys

Expert Answer


[solved] – Question 76375

Table A has one column, COL1, an INTEGER. Select the command below that would add a row with value 10 to the table.

A (COL1) VALUES (10)

ADD ROW TO A (COL1) VALUES (10)

SELECT A (COL1) VALUES (10)

INSERT INTO A (COL1) VALUES (10)

Expert Answer


[solved] – Question 76376

What is CUST in the statement below?

SELECT CUST.CUSTOMERNAME

FROM CUSTOMER_T CUST

WHERE CUSTOMER_STATE = ‘TX’

a column alias

a synonym

a table alias

an aggregate function

Expert Answer