-
Which three SELECT statements displays 2000 in the format “$2,000.00”?（）
A . SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;
B . SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;
C . SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;
D . SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;
E . SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;
F . SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual
-
Evaluate this SQL statement:
https://assets.asklib.com/images/image2/2018080116554090144.jpg
In the statement, which capabilities of a SELECT statement are performed?（）
A . Selection, projection, join
B . Difference, projection, join
C . Selection, intersection, join
D . Intersection, projection, join
E . Difference, projection, product
-
A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）
A . Acquire locks on table queried
B . Generate redo for statement
C . Fetch data from disk into memory
D . Write changes to disk
-
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? （）
A . SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B . SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C . SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D . SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E . SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual
-
Select the two answers that best describe the IP Event Dampening feature（）
A . The IP Event Dampening uses exponential decay mechanism to suppress the effects of excessive interface flapping
B . BGP Operators use IP Event Dampening to suppress the effect of unstable internet Routes
C . The IP Event Dampening works with routing protocols by stopping the announcement of dampened interface subnets in their updates
D . When IP Event Dampened internet routes resch their re-use limit BGP installs them in the Routing Table and announces them to other BGP speaker
-
Choose the most accurate statement regarding the account qualification and planning service component in the prepare phase. Select exactly 1 answer（s） from the following：（）。
A . providing a partner with information regarding customer acceptance of a new Solution
B . providing information regarding current network infrastructure readiness
C . using stakeholder interviews to identify stakeholders and decision-makers， high-level solution requirements， timelines， and the scope of an opportunity
D . adjusting a solution to account for a customers physical site characteristic
-
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? （）
A . Immediately after the SELECT clause
B . Before the WHERE clause
C . Before the FROM clause
D . After the ORDER BY clause
E . After the WHERE clause
-
Which three SELECT statements displays 2000 in the format "$2,000.00"? （）
A . SELECT TO CNAR(2000, '$#,###.##') FROM dual;
B . SELECT TO CNAR(2000, '$0,000.00') FROM dual;
C . SELECT TO CNAR(2000, '$9,999.00') FROM dual;
D . SELECT TO CNAR(2000, '$9,999.99') FROM dual;
E . SELECT TO CNAR(2000, '$2,000.00') FROM dual;
F . SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual
-
You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）
A . SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B . SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
C . SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D . SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E . SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual
-
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）
A . SELECT SUBSTR( ‘Hello World’,1) FROM dual;
B . SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
C . SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
D . SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
E . SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual
-
Select the two correctstatements from the list below that describe DES and 3DES： （）
A . 3DES is muchmore secure than DES.
B . Both DES and 3DES are stream ciphers.
C . DES uses 64 bitkeys， although the effective key lengthis only 56bits.
D . The decryption operation for both DES and 3DES is the same as the encryption operation.
E . DES can only be used for encryption， whereas 3DES can also be used for authentication.
-
Which of the following statements is true about the 80/20 rule （Select all that apply）？（）
A . 20 percent of the traffic on a network segment should be local.
B . no more than 20 percent of the network traffic should be able to move across a backbone.
C . no more than 80 percent of the network traffic should be able to move across a backbone.
D . 80 percent of the traffic on a network segment should be local.
-
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）
A . CREATE SYNONYM ord FOR orders; This command is issued by OE
B . CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
C . CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
D . CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator&e
-
Which of the following are true statements regarding the characteristics of OSPF areas? Select all that apply.（）
A . All OSPF networks require the use of multiple areas
B . Multiple OSPF areas must connect to area 0
C . Single area OSPF networks must be configured in area 1
D . Areas can be assigned any number from 0 to 63535
E . Area 0 is called the backbone area
F . Each OSPF area need to be configured with a loopback interface
-
Select the three foundational hardware components that comprise the Smart Business Communication System.（）
A . IPcelerate IPsmartSuite
B . Cisco Unified Communication 500 series
C . Catalyst Express
D . Cisco UnifiedCallConnector
E . Cisco Monitor Directory
F . Cisco 500 seriesphone
-
Refer to the exhibit. Select the true statement.（）https://assets.asklib.com/images/image2/2018080115004472772.jpg
A . The interval value should be configured at 150ms since that is target latency budget.
B . This router never delayed any packets.
C . This router is provisioned for a 256K DSL link.
D . The inside LAN interface is Ethernet 0/0.
-
Which three SELECT statements display 2000 in the format "$2,000.00"? （）
A . SELECT TO_CHAR(2000, '$#,###.##') FROM dual;
B . SELECT TO_CHAR(2000, '$0,000.00') FROM dual;
C . SELECT TO_CHAR(2000, '$9,999.00') FROM dual;
D . SELECT TO_CHAR(2000, '$9,999.99') FROM dual;
E . SELECT TO_CHAR(2000, '$2,000.00') FROM dual;
F . SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual
-
Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? （）
A . 46 and 45
B . 46 and 45.93
C . 50 and 45.93
D . 50 and 45.9
E . 45 and 45.93
F . 45.95 and 45.93
-
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed? （）
A . 0
B . 1
C . 0.00
D . An error statement
-
Refer to the exhibit. Which statement is true about the router configuration that is shown ?Select the best response.（）https://assets.asklib.com/images/image2/2018073015224359390.jpg
A . Additional DHCP options will be imported from another DHCP server.
B . The DHCP server pools need to be bound to an interface to operate.
C . This configuration will provide IP configuration information to two different su bnets.
D . Additional DCHP option information needs to be imported from another DHCP server.
E . If the router hands out all the addresses in pool 1, then it will supply addresses from pool 2.
-
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）
A . SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B . SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYY') FROM dual;
C . SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D . SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E . SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual
-
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/e0e7e26248da659a6662e982bf95acc3.jpg' />
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
-
Select the definition that most nearly defines the given word. satisfy
A．someone who travels to find new things
B．something new found after searching．
C．Behave in a certain manner．
D．to give somebody what they need or want so that they are please
D．
-
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' />
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' />
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
