-
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
-
In a Teleworker deployment with a single IP phone connected to a Cisco 831 router, select the true statement regarding Call Admission Control.()
A . RSVP is a required configuration to support conference calls without voice packet loss.
B . The QoS configuration on the 831 router must always provision sufficient bandwidth for two RTP streams.
C . Call admission control is an issue only when using hardware DSP resources.
D . When using the conference call features on a 7960 IP phone, only one RTP stream is present regardless of how many extensions are on the conference.
-
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()
A . It updates the existing SQL profiles with current statistics
B . It makes the statistics information available to GATHER_STATS_JOB
C . It initiates the statistics collection process by running GATHER_STATS_JOB
D . It logs a warning message in the alert log so that the DBA can perform statistics collection manually
-
Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?()
A . System privileges apply only to the PDB in which they are used.
B . Local users cannot use local system privileges on the schema of a common user.
C . The granter of system privileges must possess the set container privilege.
D . Common users connected to a PDB can exercise privileges across other PDBs.
E . System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
-
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
-
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; 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
-
You are developing a custom-collection class.You need to create a method in your class. You need to ensure that the method you create in your class returns a type that is compatible with the Foreach statement. Which criterion should the method meet?()
A . The method must return a type of either IEnumerator or IEnumerable.
B . The method must return a type of IComparable.
C . The method must explicitly contain a collection.
D . The method must be the only iterator in the class.
-
Which prepare phase service component involves testing high-level in a controlled environment to ensure that it meets business and technology requirements? Select exactly 1 answer(s) from the following:()。
A . Technology Strategy Development
B . High-Level Design Development
C . Business Case Development
D . Proof of Concept
-
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? ()
A . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
B . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;
C . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM dual;
D . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual
-
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
-
Select the statement that best describes The cure for Amplification Principle in the Internetdomain, as explained in RFC 3429 (Internet Architectural Guidelines )()?
A . Amplification is prevented if global changes have only a local effect as opposed to systems in which global changes have a local effect
B . Amplification is prevented if local changes have only a local effect as opposed to system inwhich localchange have a global effect
C . Internet domain does not suffer from“The Amplification Principle”as BGP takes care of misbehaving advertisers
D . None of the above
-
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;
A . $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B . Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C . $ mysql – u root – p – h localhost test < /tmp/t1.sql
D . Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql
-
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()
A . ORDER BY SALARY > 5000
B . GROUP BY SALARY > 5000
C . HAVING SALARY > 5000
D . WHERE SALARY > 5000
-
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; 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
-
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
-
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?()
A . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
B . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
C . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;
D . SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth "of" Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual
-
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
-
Morrison’s goal in writing The Bluest Eye is that she wants to make a statement about the damage that internalized racism can do to the most vulnerable member of a community.
-
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.
-
The financial statement that would be most useful to an analyst in understanding the changes that have occurred in a companys retained earnings over a year is the statement of:
A、Financial position.
B、Comprehensive income.
C、Changes in equity.
-
To ensure that we always achieve the ________ in quality, we obtain our cacao beans from a select number of respected farms and then handcraft our chocolate in small batches.
A.token
B. history
C. prospect
D. utmost