itgle.com

A user in the accounting department reports that their office is able to connect to the network, butthey are unable to connect to the Internet.Which of the following documentation would be the MOST useful to the administrator in diagnosing this issue?（） (

题目

A user in the accounting department reports that their office is able to connect to the network, butthey are unable to connect to the Internet.Which of the following documentation would be the MOST useful to the administrator in diagnosing this issue?（） (Select TWO).

A. Physical network diagram

B. Job log

C. Acceptable use policy

D. Baseline documentation

E. Wiring schematic

相似考题

1.Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error? （）A. remove the ORDER BY clauseB. remove the table alias prefix from the WHERE clauseC. remove the table alias from the SELECT clauseD. prefix the column in the USING clause with the table aliasE. prefix the column in the ORDER BY clause with the table aliasF. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

2.An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?()A.Bob has max_user_connections set to zero, which blocks all his connectionsB.Joe has exceeded the max_user_connections global limitC.All users are blocked because max_user_connections is accumulated over the host account informationD.Kay is already connected elsewhere and attempting to log in againE.Connect_timeout is too small to allow a connection to occur

3.Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERMGR_ID NUMBER References EMPLOYEE_ID COLUMNDEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS tableDEPARTMENTSColumn name Data type RemarksDEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30)MGR_ID NUMBER References MGR_ID column of the EMPLOYEES tableEvaluate this SQL statement:SELECT employee_id, e.department_id, department_name, salaryFROM employees e, departments dWHERE e. department_id = d.department_id;Which SQL statement is equivalent to the above SQL statement? （）A. SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);B. SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;C. SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;D. SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);

4.Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? （）A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);

参考答案和解析
参考答案：A, E
更多“A user in the accounting department reports that their office is able to connect to the ne ”相关问题

  • 第1题：

    ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?（）

    A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);

    B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);

    C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);

    D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);

    E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)

    F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);


    参考答案：B

  • 第2题：

    Examine the data in the EMPLOYEES and DEPARTMENTS tables.EMPLOYEESLAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000Kochhar 5000DEPARTMENTSDEPARTMENT_ID DEPARTMENT_NAME10 Sales20 Marketing30 Accounts40 AdministrationYou want to retrieve all employees, whether or not they have matching departments in the departments table.Which query would you use?（）

    A. SELECT last_name, department_name FROM employees , departments(+);

    B. SELECT last_name, department_name FROM employees JOIN departments(+);

    C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d

    D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

    E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);

    F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);


    参考答案：F

  • 第3题：

    WhichcommandwouldcreateamachineaccountinActiveDirectoryundertheComputers\BusinessUnit\Department\Serversorganizationalunit?()

    A.netrpcjoin-mlocalhost-ldap="ldap.ldapserver.comComputers\BusinessUnit\Department\Servers"

    B.rpcclient-c"joinComputers\BusinessUnit\Department\Servers"

    C.netadsjoinou="Computers\BusinessUnit\Department\Servers"

    D.netadsjoin"Computers\BusinessUnit\Department\Servers"


    参考答案：D

  • 第4题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMPLOYEE_ID NUMBERDEPARTMENT_ID NUMBERMANAGER_ID NUMBERLAST_NAME VARCHAR2(25)DEPARTMENTSDEPARTMENT_ID NUMBERMANAGER_ID NUMBERDEPARTMENT_NAME VARCHAR2(35)LOCATION_ID NUMBERYou want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?（）

    A. SELECT last_name, department_name, location_id FROM employees , department ;

    B. SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;

    C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;

    D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;


    参考答案：D

  • 第5题：

    Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their managers‘ last names and their department names. Which query would you use?（）

    A.SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN departments d ON (e.department_id = d.department_id);

    B.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

    C.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

    D.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

    E.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

    F.SELECT last_name, manager_id, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id) ;


    参考答案：B

  • 第6题：

    YouaretheExchangeadministratorfortheXxxCorporation’sExchange2010organization.JenniferBrownisauserintheAccountingdepartmentwhowillbeonleavefor30to40days.YouwouldliketoforwardallmailforJenniferBrown’smailboxtoAnnGarciaduringherabsence.WhenJenniferreturnsfromleave，sheshouldbeabletoseeallthemessagesthatwereforwardedtoAnnGarcia.Whatshouldyouconfigure？（）

    A.Set-Mailbox-Identity"JenniferBrown"-ForwardingAddress"ann@Xxx"-DeliverToMailboxAndForward$false

    B.Set-Mailbox-Identity"JenniferBrown"-ForwardingAddress"ann@Xxx"-DeliverToMailboxAndForward$true

    C.Add-ADPermission-Identity’CN=JenniferBrown，OU=Accounting，DC=Xxx，DC=com’-User’XXX\Ann’-ExtendedRights’Send-as’

    D.Add-MailboxPermission-Identity’CN=JenniferBrown，OU=Accounting，DC=Xxx，DC=com’-User’XXX\Ann’-AccessRights’FullAccess’


    参考答案：B

相关内容