Oracle 1Z0-082 問題集

質問 1：
Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?
A. It fails because the SCOPE clause is missing
B. The value is changed for the current instance and in the PFILE
C. The value is changed only in the PFILE and takes effect at the next instance startup
D. Change is applied to the current instance, but does not persist after instance restart
正解：D

質問 2：
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

A. Display the total number of products supplied by supplier 102 which have a product status of obsolete
B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
C. Display suppliers whose PROD_LIST_PRICE is less than 1000
D. Display the minimum PROD_LIST_PRICE for each product status
E. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
正解：B,E

質問 3：
While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?
A. DBA_DATA_FILES displays the original name for the data files.
B. V$DATAFILE displays the new names for the data files.
C. DBA_DATA _FILES displays both the new name and the old name for the data files.
D. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
E. DBA_DATA_FILES displays the new name for the data files.
正解：A,C

質問 4：
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
B. SELECT &col1, &col2FROM "&table"WHERE &condition;
C. SELECT &col1, &col2FROM &&tableWHERE &condition;
D. SELECT '&&col1', '&&col2'FROM &tableWHERE '&&condition' = '&cond';
E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;
正解：C

質問 5：
Which statement is true about the INTERSECT operator used in compound queries?
A. It ignores NULLs
B. It processes NULLs in the selected columns
C. INTERSECT is of lower precedence than UNION or UNION ALL
D. Multiple INTERSECT operators are not possible in the same SQL statement
正解：B

質問 6：
Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?
A. ORDER BY last_narae DESC, city ASC
B. ORDER BY 1, LNAME DESC
C. WHERE city LIKE *%AN%*
D. WHERE city = =%AN%'
E. WHERE city IN (*%AN%')
F. ORDER BY 1, 2
正解：B,C

質問 7：
Which two statements are true about the Oracle Data Dictionary?
A. It is owned by the system user.
B. It is owned by the sys user.
C. All data dictionary view joins base tables to dynamic performance views.
D. Data dictionary views are always created with queries that join two or more base tables.
E. Data dictionary base tables can be queried directly.
正解：B,E