Oracle 1z0-062 問題集

質問 1：
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.)
A. by using appropriate PASSWORD parameters set in the profile assigned to the user
B. by implementing Database Resource Manager and assign it a profile for the user
C. by implementing Database Resource Manager and assign it a role for the user
D. by alerting the appropriate user attributes with an ALTER USER command
E. by using appropriate KERNEL parameters set in the profile assigned to the user
正解：A,E

質問 2：
In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)
A. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
B. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
C. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
D. The MYTAB table is owned by the SYS user.
E. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
正解：A,D

質問 3：
Which files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)
A. the initialization parameter file
B. the password file
C. the tnsnames.ora file
D. the listener.ora file
E. the sqlnet.ora file
正解：C,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)
A. server parameter le (SPFILE)
B. active online redo log le group
C. a data file belonging to the SYSAUX tablespace
D. a data file belonging to the default temporary tablespace
E. all the control flies
F. inactive online redo log file group
正解：B,E,F

質問 5：
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table? (Choose two.)
A. You must copy the VPD policies manually from the original table to the new table during online redefinition.
B. VPD policies are copied from the original table to the new table during online redefinition.
C. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
D. All the triggers for the table are disabled without changing any of the column names or column types in the table.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)