You updated your primary server with new hosts.However, you notice that the secondary

\\contoso.com\management namespace hierachy is updated frequently. You need to configure the \\contoso.com\management namespace to reduce the workload of the PDC emulator. What should you do？（）

A.Enable the optimize for scalibity option.

B.Enable the optimize for consistency option.

C.Set the ordering method option to lowest cost.

D.Set the ordering method option to random order.

d \\contoso.com\Management.The \\contoso.com\Management namespace hierarchy is updated frequently.You need to configure the \\contoso.com\Management namespace to reduce the workload of the PDC emulator.What should you do？（）

A. Enable the Optimize for scalability option.

B. Enable the Optimize for consistency option.

C. Set the Ordering method option to Lowest cost.

D. Set the Ordering method option to Random order.

EATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;SQL＞ CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);Which two statement are correct？（）

A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.

B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

C. Only the ORD_CUSTOMER_IX1 index is created.

D. Only the ORD_CUSTOMER_IX2 index is created.

E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

servers have the DNS server role installed. Server3 is configured to forward all DNS requests to server2. You update a DNS record on server2, you need to ensure that server3 is able to immediately resolve the updated DNS record. What should you do？（）

A.Run the dnscmd /clearcache on server3.

B.Run the ipconfig /flushdns command on server3.

C.Decrease the time-to-live (TTL) on the start of authority (SOA) record of na.contoso.com to 15minutes.

D.Increase the retry interval value on the start of authority (SOA) record of na.contoso.com to 15 minutes.

tore service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do？

A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

E INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;SQL＞ CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);Which two statements are true？（）

A. Only the ORD_CUSTOMER_IX1 index created.

B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.

D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.

F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

A. Column definitions cannot be altered to add DEFAULT values.

B. A change to the DEFAULT value affects only subsequent insertions to the table.

C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

th servers have the DNS Server server role installed. Server3 is configured to forward all DNS requests to Server2.You update a DNS record on Server2. You need to ensure that Server3 is able to immediately resolve the updated DNS record.What should you do？（）

A. Run the dnscmd . /clearcache command on Server3.

B. Run the ipconfig /flushdns command on Server3.

C. Decrease the Time-to-Live (TTL) on the Start of Authority (SOA) record of na.contoso.com to 15 minutes.

D. Increase the Retry Interval value on the Start of Authority (SOA) record of na.contoso.com to 15 minutes.

The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARYNUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement？（）

A.Column definitions cannot be altered to add DEFAULT values.

B.A change to the DEFAULT value affects only subsequent insertions to the table.

C.Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

D.All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

The EMPLOYEES table has these columns:LAST NAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEESMODIFY (SALARY DEFAULT 5000);What is true about your ALTER statement？（）

A. Column definitions cannot be altered to add DEFAULT values.

B. A change to the DEFAULT value affects only subsequent insertions to the table.

C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.