-
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.
-
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）
A . A syntax error will result as you cannot specify more than one partition in the same statement
B . All data in p1 and p3 partitions are removed and the table definition is changed
C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D . Only the first partition (p1) will be dropped as only one can be dropped at any time
-
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.
-
Which two statements or sets of statements are true about the application of the qos pre-classify command？（）
A . If the classification policy is based upon the ToS byte， the qos pre-classify command is required because the ToS byte only appears in the inner IP header.
B . The ToS byte is copied to the outer header by default. Therefore， the qos pre-classify command is not necessary.
C . With GRE encapsulation， the qos pre-classify command is applied on the tunnel interface. This practice allows for different OoS configurations on each tunnel.
D . With GRE encapsulation， the qos pre-classify command is applied on the physical interface. This practice allows for different OoS configurations on each interface.
E . With IPsec encapsulation， the qos pre-classify command is applied on the physical interface. This practice allows for different OoS configurations on each interface.
-
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.
-
You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）
A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B . The command will not execute successfully because resumable space allocation is enabled at the session level.
C . The command will execute successfully and resumable space will be allocated at the session level.
D . The command will execute successfully and resumable space will be allocated at the instance level.
-
You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）
A . The control file will be multiplexed.
B . The control file will be recreated.
C . The script containing the CREATE CONTROLFILE statement will be created.
D . The binary backup of the control file will be created.
-
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
-
Examine the statement：
DROP TABLESPACE IND2
INCLUDING CONTENTS
AND DATAFILES；
What is the result of the statement？（）
https://assets.asklib.com/images/image2/2018080111115360474.jpg
A . A
B . B
C . C
D . D
-
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
-
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 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.
-
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
A . This clause is not valid for a temporary or undo tablespace.
B . If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
C . The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
D . The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
-
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）
A . An error is generated.
B . You will have two identical tables in the HR schema with different names.
C . You create a table called employees in the HR schema based on you EMP table.
D . You create an alternative name for the employees table in the HR schema in your own schema.
-
Read the following statements. Judge which statements are true and which statements are false.1 Confucius took non-action as the principal doctrine.
-
Which statement is the main idea of the second paragraph?Which statement is the main idea of paragraph 2?
-
Usually the thesis statement is the last sentence of the introduction. ( )
-
Which of the following statements is the theme?
-
Sometimes the controlling idea implied in the thesis statement.
-
Which of the items belong to the income statement?
-
Which of the following statements about the research is NOT the？（）
A．it was done within 30 hours.
B．It was headed by Professor Stickgold.
C．It focused on long-term memory formation.
D．There were altogether 24 subjects in the experiment.
-
The statement of financial position is a summary of the balances remaining after the statement of profit or loss has been prepared.（)
此题为判断题(对，错)。
-
Do the following statements reflect the opinions of the writer in Reading Passage 3？ In boxes 36-39 on your answer sheet write YES if the statement reflects the opinion of the writer NO if the statement contradicts the opinion of the writer NOT GIVEN if it is impossible to say what the writer thinks about this
Popper says that the scientific method is hypothetico-deductive.
此题为多项选择题。
-
阅读附件文章，做出判断。The 1993 Sydney survey involved 289 patients who visited alternative therapists for acupuncture treatment.YESif the statement agrees with the views of the writerNOif the statements
A．YES
B．NO
C．NOT GIVEN
-
阅读附件文章，做出判断。All the patients in the 1993 Sydney survey had long-term medical complaints.YESif the statement agrees with the views of the writerNOif the statements contradicts the views of the
A．YES
B．NO
C．NOT GIVEN
