-
You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）
A . INDEX_STATS
B . DBA_INDEXES
C . DBA_IND_COLUMNS
D . V$OBJECT_USAGE
-
You are designing the Windows Server 2003 Active Directory forest structure to meet the business and technical requirements. Which forest structure should you use？（）
A . One Active Directory forest with one domain.
B . One Active Directory forest with three domains.
C . One Active Directory forest with four domains.
D . Two Active Directory forests with one domain in each forest.
E . Three Active Directory forests with one domain in each forest.
-
Which four actions can you perform using the WebLogic Admin Console?（）
A . Stop and start Managed Servers using the Node Manager.
B . Stop and start Coherence Servers using the Node Manager.
C . Create a WebLogic Domain Template.
D . Create and target JDBC connection pools.
E . Create and target WebLogic Diagnostic Framework Diagnostic Modules.
F . Change Java command-line parameters at run time.
-
For which two actions can you use the TO_DATE function? （）
A . convert any date literal to a date
B . convert any numeric literal to a date
C . convert any date to a character literal
D . format 'January 10 1999' for input
E . format '10-JAN-99' to 'January 10 1999'
-
You are designing the forest and domain structure to meet the business and technical requirements. Which structure should you use？（）
A . A single forest with one tree， and one domain
B . A single forest with one tree two domain
C . A single forest with two trees， each with a single domain
D . Two forests， each with a single tree and a single domain
E . Two forests， each with two trees， with a single domain in each tree.
-
You are designing the DNS topology to meet the business and technical requirements. Which DNS structure should you use？（）
A . one primary zone
B . two primary zones
C . one Active Directory-integrated zone that has the replication scope set to all DNS servers in the forest.
D . two Active Directory-integrated zones that have the replication scopes set to all DNS servers in the forest.
E . one Active Directory-integrated zone that has the replication scope set to all domain controllers in the domain.
F . two Active Directory-integrated zones that have the replication scopes set to all domain controllers in the domain.
-
You are designing a top-level OU structure to meet the business and technical requirements. Which top-evel OU or OUs should you use？ （）
A . ATC
B . Paris
C . Berlin
D . Sydney
E . Manifast
F . Human Resource
-
You are designing the top-level organizational unit (OU) structure to meet the business and technical requirements. Your design must accommodate the anticipated growth of the company. Which top-level OU structure should you use?（）
A . Paris OU, Sydney OU, Los Angeles OU, Lisbon-Barcelona OU
B . IT Administration OU, All CohoVineyard Departments OU, All CohoVineyard Offices OU
C . Sales OU, Purchasing OU, Marketing OU, Accounting OU, Distribution OU, Human Resources OU
D . CohoVineyard Users OU, CohoVineyard Computers OU, CohoVineyard Servers OU, CohoVineyard Applications OU
-
You are designing a strategy to upgrade the DHCP servers after the new Active Directory structure is in place. Who can authorize the DHCP servers？（）
A . Chief information officer
B . IT support staff in Boston
C . IT support staff in New York
D . Network administrator in Chicago
E . Network administrator in New York
-
Which two chart base types can you select using the Chart Wizard?（）
A . Line
B . Column
C . Bubble
D . Flowchart
E . OHLC candle stock
-
Examine the structures of the EMPLOYEES and TAX tables.
https://assets.asklib.com/images/image2/2018080116321734981.jpg
You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min_salary AND t.max_salary;
B . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
C . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
D . You cannot find the information because there is no common column between the two tables.
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.
You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
https://assets.asklib.com/images/image2/2018080114273930960.jpg
A . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D . You cannot find the information because there is no common column between the two tables.
-
What RMAN command must you use before you can back up a database using the recovery catalog？（）
A . create catalog
B . install database
C . catalog database
D . merge Catalog with database
E . register database
-
Which two tasks can you perform using only the TO_CHAR function? （）
A . convert 10 to 'TEN'
B . convert '10' to 10
C . convert 10 to '10'
D . convert 'TEN' to 10
E . convert a date to a character expression
F . convert a character expression to a date
-
Which of the commands below can you use to configure a default route?（）
A . TK1(config)# ip route 0.0.0.0 0.0.0.0 E0
B . TK1(config)# ip route 0.0.0.0 255.255.255.255 S0
C . TK1(config-interface)# ip route 255.255.255.255 0.0.0.0 192.168.1.21
D . TK1(config)# ip route 0.0.0.0 0.0.0.0 192.168.1.21
E . TK1(config)# ip route 0.0.0.0 192.168.1.21 255.255.255.255
F . TK1# ip default-network 0.0.0.0 192.168.1.21 255.255.255.255
-
You are designing a strategy to upgrade the DHCP servers after the new Active Directory structure is in place. Who can authorize the DHCP servers?（）
A . Chief information officer
B . IT support staff in Boston
C . IT support staff in New York
D . Network administrator in Chicago
E . Network administrator in New York &e
-
For which of the following can you use Segment Shrink？（）
A . Heap tables
B . Tables with function-based indexes
C . Indexes
D . Partitions and subpartitions
E . None of the above
-
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.
https://assets.asklib.com/images/image2/2018080116500849327.jpg
For which situation would you use a nonequijoin query?（）
A . To find the tax percentage for each of the employees.
B . To list the name, job id, and manager name for all the employees.
C . To find the name, salary, and department name of employees who are not working with Smith.
D . To find the number of employees working for the Administrative department and earning less then 4000.
E . To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
-
You are designing the DNS topology to meet the business and technical requirements. Which DNS structure should you use?（）
A . one primary zone
B . two primary zones
C . one Active Directory-integrated zone that has the replication scope set to all DNS servers in the forest.
D . two Active Directory-integrated zones that have the replication scopes set to all DNS servers in the forest.
E . one Active Directory-integrated zone that has the replication scope set to all domain controllers in the domain.
F . two Active Directory-integrated zones that have the replication scopes set to all domain controllers in the domain.
-
Which expressions can you use to give the directions in a building?
-
You can use which of the following tips to understand idiomatic expressions?
A、Search for contextual clues
B、Look at examples
C、Find explanations
D、Locate opposite or similar phrases
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicable for each employee. Which SQL statement would you use？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135988/ea49d0916fc0345195a85a9b2816cb50.jpg' />
A.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary ＞ t.min_salary AND ＜ t.max_salary;
C.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D.You cannot find the information because there is nocommon column between the two tables.
-
Can you name some of the most commonly used packing materials?
-
To persuade people, we can use the following phrases: ‘You can…’, ‘You can afford to…’, “You don’t have to…’, ‘It’s easy to…’.
