Oracle 1Z0-060 問題集

質問 1：
You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?
A. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
B. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
C. A TOP-N query is created during execution and a filter is added to the query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
D. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
正解：B

質問 2：
Which two statements are true regarding the count function?
A. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.
B. Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
C. The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
D. A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.
E. Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
正解：A,E

質問 3：
To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(`SH', `SALES',
`INT_SALES', 600);
What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?
A. It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.
B. All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.
C. All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.
D. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)
A. STREAMS_POOL_SIZE
B. SORT_AREA_SIZE
C. DB_KEEP_CACHE_SIZE
D. DB_16K_CACHE_SZIE
E. JAVA_POOL_SIZE
F. LOG_BUFFER
正解：C,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privilege used by a user for
privilege analysis.
2. Generate a report with the data captured for a specified privilege
capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.
A. 1, 3, 2, 5, 6, 4
B. 1, 3, 5, 6, 2, 4
C. 1, 3, 2, 5, 6, 4
D. 1, 3, 5, 2, 6, 4
E. 1, 3, 6, 2, 5, 4
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login
attempts by user.
2. A user should not be able to create more than four simultaneous
sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?
A. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
C. by granting a secure application role to the users
D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
E. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
A. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
B. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
C. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
D. Take the USERDATA tablespace offlineinACCOUNTS_PDB.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.
A. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
B. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
C. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
D. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
F. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
G. BACKUP SPFILE SECTION SIZE 1M;
正解：A,B,E,F