-
Evaluate the following statement：
https://assets.asklib.com/images/image2/2018080114444988840.jpg
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A . They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B . They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C . They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D . The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
-
Evaluate the SQL statement:
https://assets.asklib.com/images/image2/2018080115100724106.jpg
What is the result of the statement?（）
A . The statement produces an error at line 1.
B . The statement produces an error at line 3.
C . The statement produces an error at line 6.
D . The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E . The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
-
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
A . You cannot roll back this statement.
B . All pending transactions are committed.
C . All views based on the DEPT table are deleted.
D . All indexes based on the DEPT table are dropped.
E . All data in the table is deleted, and the table structure is also deleted.
F . All data in the table is deleted, but the structure of the table is retained.
G . All synonyms based on the DEPT table are deleted.
-
Evaluate the following SQL statements that are issued in the given order：
https://assets.asklib.com/images/image2/2018080114465944231.jpg
What would be the status of the foreign key EMP_MGR_FK？（）
A . It would be automatically enabled and deferred.
B . It would be automatically enabled and immediate.
C . It would remain disabled and has to be enabled manually using the ALTER TABLE command.
D . It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
-
Evaluate the following SQL statements that are issued in the given order：
https://assets.asklib.com/images/image2/2018080114351530846.jpg
What would be the status of the foreign key EMP_MGR_FK？（）
A . It would be automatically enabled and deferred.
B . It would be automatically enabled and immediate.
C . It would remain disabled and has to be enabled manually using the ALTER TABLE command.
D . It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
-
Which of the following calendaring syntax expressions would evaluate to the last day of every month？（）
A . FREQ = MONTHLY； BYMONTHDAY = 31
B . FREQ = MONTHLY； BYMONTHDAY = -1
C . FREQ = DAILY； BYDAY = -1
D . FREQ = MONTHLY； BYDAY = 31
E . FREQ = DAILY； BYMONTHDAY = LAST_DAY
-
Evaluate the following command and its output： SQL>SELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）
A . FREE_SPACE indicates only the space that is currently unallocated.
B . ALLOCATED_SPACE indicates only the space currently allocated and in use.
C . FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D . ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
E . FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
-
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? （）
A . It releases the storage space used by the table.
B . It does not release the storage space used by the table.
C . You can roll back the deletion of rows after the statement executes.
D . You can NOT roll back the deletion of rows after the statement executes.
E . An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F . You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
-
Which expressions will evaluate to true if preceded by the following code？（） String a = "hello"； String b = new String（a）； String c = a； char[] d = { ’h’， ’e’， ’l’， ’l’， ’o’ }；
A . （a == "Hello"）
B . （a == b）
C . （a == c）
D . a.equals（b）
E . a.equals（d）
-
Evaluate the following statements:
https://assets.asklib.com/images/image2/201808020932369103.jpg
What are the two consequences of the above statements?（）
A . Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B . Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
C . Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
D . The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
E . Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
-
Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?（）
A . It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B . It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C . It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D . It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
-
Evaluate the following statement：
https://assets.asklib.com/images/image2/2018080114301711053.jpg
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A . They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B . They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C . They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D . The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
-
Evaluate the following block of code:
https://assets.asklib.com/images/image2/2018080208432879092.jpg
What is the outcome of the above code?（）
A . It produces an error because a fully qualified host name needs to be specified.
B . It produces an error because the range of ports associated with the hosts has not been specified.
C . It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D . It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
-
Evaluate the following command： SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’； What is the impact of this setting on the usage of SecureFiles？（）
A . It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B . It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C . It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D . It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
-
Evaluate the following command： SQL> CREATE TABLE design_data （id NUMBER， doc CLOB） LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）； Which statement is true regarding the above command？（）
A . The LOB values are automatically compressed.
B . The LOB values are cached by default in the buffer cache.
C . The LOB values are automatically stored in encrypted mode.
D . All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
-
Evaluate the following command:
https://assets.asklib.com/images/image2/2018080210413383362.jpg
Which statement is true regarding the above command?（）
A . The LOB matically compressed.
B . The LOB values are cached bvalues are autoy default in the buffer cache.
C . The LOB values are automatically stored in encrypted mode.
D . All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
-
Evaluate the following command and its output:
https://assets.asklib.com/images/image2/2018080214105523041.jpg
Which two statements correctly interpret the output?（）
A . FREE_SPACE indicates only the space that is currently unallocated.
B . ALLOCATED_SPACE indicates only the space currently allocated and in use.
C . FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D . ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E . FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
-
Evaluate the following SQL statement used to create the PRODUCTS table:
https://assets.asklib.com/images/image2/2018080210365762118.jpg
Which statement is true regarding this command?（）
A . It executes successfully but partition pruning cannot happen for this partition key.
B . It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C . It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D . It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
-
3.The right order of the stages of listening is receive, comprehend, evaluate, respond, interpret and remember.
-
Which of the following would be classed as physical evidence in terms of the tangible cues that customers may use to evaluate a service?
-
Evaluate this SQL statement:What will happen if you remove all the parentheses from the calculation？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/b0aed9f70f3cf7c71c4d975acbe48082.jpg' />
A. The value displayed in the CALC_VALUE column will be lower.
B. The value displayed in the CALC_VALUE column will be higher.
C. There will be no difference in the value displayed in the CALC_VALUE column.
D. An error will be reported.
-
GSM2000 can evaluate（)of the radio network along the road where the test is conducted.
A．A. Coverage
B．B. Interference
C．C. Handover parameter
D．D. Configuration of adjacent cell
-
Passage Three:Questions 31 to 35 are based on the following passage.The way people hold to the belief that a fun-filled, pain free life equals happiness actually reduces their chances of ever attaining real happiness, if fun and pleasure are equal to happiness then pain must be equal to unhappiness. But in fact, the opposite is true: more often than not things that lead to happiness involve some pain.
As a result, many people avoid the very attempts that are the source of true happiness. They fear the pain inevitably brought by such things as marriage, raising children, professional achievement, religious commitment (承担的义务), self-improvement.
Ask a bachelor (单身汉) why he resists marriage even though he finds dating to be less and less satisfying. If he is honest he will tell you that he is afraid of making a commitment. For commitment is in fact quite painful. The single life is filled with fun, adventure, excitement. Marriage has such moments, but they are not its most distinguishing features.
Couples with infant children are lucky to get a whole night’s sleep or a three-day vacation. I don’t know any parent who would choose the word fun to describe raising children. But couples who decide not to have children never know the joys of watching a child grow up or of playing with a grandchild.
Understanding and accepting that true happiness has nothing to do with fun is one of the most liberating realizations. It liberates time: now we can devote more hours to activities that can genuinely increase our happiness. It liberates money: buying that new car or those fancy clothes that will do nothing to increase our happiness now seems pointless. And it liberates us from envy: we now understand that all those who are always having so much fun actually may not be happy at all.
第31题：According to the author, a bachelor resists marriage chiefly because ________.
A) he is reluctant to take on family responsibilities
B) he believes that life will be more cheerful if he remains single
C) he finds more fun in dating than in marriage
D) he fears it will put an end to all his fun adventure and excitement
-
For the following function definition:def Fun（args）:s = 0for i in args:s += ireturn sWhen calling the function “Fun（m）”, the m may be defined as ______（）
A．m=（10,15,20）
B．m=[10,15,20]
C．m=set（[’10’,’15’,’20’]）
D．m=dict（a=10,b=15,c=20）
