최신 OCP 1Z0-045 무료샘플문제:
1. What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?
A) V$TRANSACTION
B) DBA_UNDO_EXTENTS
C) V$UNDOSTAT
D) DBA_ROLLBACK_SEGS
E) V$ROLLSTAT
2. Which data dictionary view would you query to find the name of the default permanent tablespace of the database?
A) DBA_STORED_SETTINGS
B) DBA_TABLESPACE_GROUPS
C) DICTIONARY
D) DBA_TABLESPACES
E) DBA_DIRECTORIES
F) DATABASE_PROPERTIES
3. In Oracle 10g, the LogMiner allows storage of a copy of the data dictionary in _____ and _____. (Choose two.)
A) an operating system flat file
B) the control file
C) the supplemental log file
D) the online redo log files
E) a database file
F) a nested table in the database
4. On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
A) fixed tables
B) Index-Organized Tables (IOTs)
C) temporary tables
D) views
E) heap tables
F) external tables
5. Which three files can be managed using an ASM Instance? (Choose three.)
A) Alert log files
B) Export files
C) Audit files
D) Archived log files
E) Change tracking files
F) Data files
G) Trace files
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: F | 질문 # 3 정답: A,D | 질문 # 4 정답: B,E | 질문 # 5 정답: D,E,F |