Oracle Database 12c: Installation and Administration - 1z1-062 模擬練習
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output? (Choose three.)
Which three statements are true about the users (other than sys) in the output? (Choose three.)
正解: A,B,C
解説: (PassTest メンバーにのみ表示されます)
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
正解: E
Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.
Which command must you execute before starting the recovery of this tablespace?
Which command must you execute before starting the recovery of this tablespace?
正解: C
A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)
正解: B,C
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
正解: D
解説: (PassTest メンバーにのみ表示されます)
You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?
正解: D
You install Oracle Grid Infrastructure for a standalone server.
Which two components are automatically included in the Oracle Restart configuration? (Choose two.)
Which two components are automatically included in the Oracle Restart configuration? (Choose two.)
正解: D,E
解説: (PassTest メンバーにのみ表示されます)
What is a requirement for creating a remote database scheduler job?
正解: A
Examine this command executed on a client that is remote from the database server.
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
正解: B,D
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked.
You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked.
You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
正解: B
All of your database instances use SPFILES.
You executed this command in one of them:
ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;
Which statement is true?
You executed this command in one of them:
ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;
Which statement is true?
正解: D
解説: (PassTest メンバーにのみ表示されます)
Which three statements are true about Oracle Data Pump? (Choose three.)
正解: A,D,E
You set the following parameters in the parameter file and restart the database instance:
Which two statements are true? (Choose two.)
Which two statements are true? (Choose two.)
正解: B,E
You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor? (Choose three.)
Which three statements are true about the advisor given by the segment advisor? (Choose three.)
正解: A,B,E