-
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
-
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
-
Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）
A . Materialized views
B . Indexes
C . Index-organized tables
D . Hash cluster
-
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
-
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
A . MANAGER must be a role.
B . It allows the MANAGER to pass the specified privileges on to other users.
C . It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D . It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E . It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F . It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
-
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）
A . NLS_LANG
B . NLS_COMP
C . NLS_SORT
D . None of the above
-
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
-
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）
A . DISPATCHER
B . USER
C . SERVER
D . LGWR
E . DBW0
-
Which is the most accurate statement regarding the business requirements development service component in the prepare phase. Select exactly 1 answer（s） from the following：（）。
A . Determine the appropriate cooling temperature for a customers server room
B . Analyze the customers business requirements for a proposed solution
C . Analyze a customers ongoing operational requirements
D . Identify a customers technology requirement
-
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 NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）
A . NLS_LANG
B . NLS_COMP
C . NLS_SORT
D . None of the above
-
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.
-
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
-
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query; Which statement is correct regarding the query output？（）
A . It would return information regarding only the last committed transaction.
B . It would return only the active transactions in all the undo segments in the database.
C . It would return only the committed transactions in all the undo segments in the database.
D . It would return both active and committed transactions in all the undo segments in the database.
E . It would return information regarding the transactions that began and were committed in the last 30 minutes.
-
Which is an example of a dynamic SELECT statement? （）
A . A query whose object names change during its execution.
B . A query whose object names are not known until run time.
C . A query whose bind variables values change during execution.
D . A query whose bind variable values are not known until run time.
-
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A . It would return information regarding only the last committed transaction.
B . It would return only the active transactions in all the undo segments in the database.
C . It would return only the committed transactions in all the undo segments in the database.
D . It would return both active and committed transactions in all the undo segments in the database.
E . It would return information regarding the transactions that began and were committed in the last 30 minutes.
-
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A . It would return information regarding only the last committed transaction.
B . It would return only the active transactions in all the undo segments in the database.
C . It would return only the committed transactions in all the undo segments in the database.
D . It would return both active and committed transactions in all the undo segments in the database.
E . It would return information regarding the transactions that began and were committed in the last 30 minutes.
-
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
-
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.
