Oracle 1z0-497 問題集

質問 1：

Which two statements about this policy are true?
A. It replaces the first digit of the value from the SALARY column with the number 4.
B. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.
C. It uses the full data redaction method.
D. It uses the random redaction method.
E. It replaces the first four digits of the value from the SALARY column with the number 9.
F. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.
正解：D,F

質問 2：
What happens when you execute these SQL statements?
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS POOL SIZE = 0;
A. You activate Automatic Shared Memory Management.
B. The database stops (shutdown abort).
C. You get an error message.
D. B) The database Stops (shutdown immediate).
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine the command:
sqlplus /nolog
In which scenario would this command execute successfully?
A. only from the server, if the database instance is not up
B. from either a client or server, only if the database instance is up, and the command connects the session to the instance
C. from either a client or server, only if the database instance is up, but the command does not connect the session to the instance
D. from either a client or server, even if the database instance is not up
正解：D

質問 4：
Which three statements about common and local roles are true?
A. Common roles can be granted to both local and common users.
B. Local roles can be granted only to local users.
C. When a role is granted to a user, the privileges in the role are limited to the context of the PDB.
D. Common roles can be created in the root and PDBs.
E. A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs
正解：A,C,E

質問 5：
You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?
A. You can drop the PDB and keep the data files to be reused by another PDB.
B. You can drop the PDB only if it is closed.
C. You can drop the seed PDB, but you cannot create any other PDB within the CD
D. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.
正解：A,B

質問 6：
Which three tasks can you perform in Database Express?
A. Start up the database.
B. View performance and status information about the database instance.
C. Shut down the database.
D. Create database structures.
E. Manage users and security.
正解：B,D,E

質問 7：
YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
A. SCHEMAS
B. FULL
C. TRANSFORM
D. REMAP_TABLESPACE
E. REMAP_SCHEMA
正解：E

質問 8：
For which database operation do you need the database to be in MOUNT state?
A. dropping a tablespace in your database
B. dropping a user in your database
C. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode
D. renaming the control files
E. re-creating the control files
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
A. Oracle recommends that you back up the root. sh script after you complete the installation.
B. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
C. You should not install the Oracle Database software into an existing Oracle home from a different release.
D. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
E. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
正解：E