Oracle OCP 1z0-052 2018年9月最新考过的题库分享-3

1. Which four statements are true about truncating a table?
A) Any insert triggers for the table will be executed.
B) Any of the table’s indexes are also truncated.
C) Any delete triggers for the table will be executed.
D) All table storage can be retained.
E) Only HEAP tables may be truncated.
F) All table storage is converted to free space.
G) MINEXTENTS amount of storage for the table can be retained.
Answer： BDFG

 

2. Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?
A) If the directory used in the export operation has existing dump files, it overwrites them.
B) It allows encryption to be performed without using a password.
C) It supports the export of specific views as tables.
D) It allows compression levels to be defined for the export.
E) It supports the renaming of tables during import.
Answer： AE

 

3. which is true about external tables?
A) Segments are allocated for external tables.
B) They may have indexes.
C) They do not support partitioning.
D) The ORACLE_DATAPUMP access driver can be used to write data to external tables.
E) DML operations may be performed on external tables.
Answer： D

 

4. Your database is open in ARCHIVELOG mode.
LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and It is 100% full when a log switch takes
place.
No alternative or optional archive destinations are defined.
What is the outcome?
A) Obsolete backups are automatically deleted and new archivelogs are generated.
B) All active sessions hang until the database administrator (DBA) makes space available in the FRA.
C) The archivelog entries are made in the diagnostic destination and when space is available, new
archivelogs are generated.
D) All active sessions are disconnected and their transactions rolled back.
E) No archivelogs are generated.
Answer： B

 

 

5. Your DB_RECOVERY_FILE_DEST_SIZE IS 8G,
Currently， 5G of the space is used of which 4G consists of obsolete backups,
You execute this command;
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;
What is the outcome?
A) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups
B) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G
C) It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter
D) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups
E) It fails because the new size is less than 5G
Answer： D

 

 

6. which three statements are true about initialization parameters and files?
A) An idle instance must start with a PFILE.
B) Session modifiable initialization parameters can only be changed by a user with the DBA role.
C) The ALTER SYSTEM command can be used to change parameter values for an instance started using a PFILE.
D) An SPFILE can be created from an idle instance.
E) Session modifiable initialization parameters can only be changed once per session.
F) The ALTER SYSTEM command can be used to change parameter values for an instance started using an SPFILE
G) System modifiable initialization parameters can only be changed by the SYS user.
Answer࿱