Exam Number: 1Z0-514
Associated Certifications: Oracle Database 11g Certified Implementation Specialist , OPN Certified Specialist
Exam Product Version: Oracle Database 11g,
Exam Price: CNY 1078 More on exam pricing
Duration: 120 minutes
Number of Questions: 69
Passing Score: 61% View passing score policy
Validated Against: This exam is valid for Oracle Database 11gR1 and 11gR2.
format: Multiple Choice
Oracle 1Z0-514시험을 등록하였는데 시험준비를 어떻게 해애 될지 몰라 고민중이시라면 이 글을 보고Pass4Test를 찾아주세요. Pass4Test의 Oracle 1Z0-514덤프샘플을 체험해보시면 시험에 대한 두려움이 사라질것입니다. Pass4Test의 Oracle 1Z0-514덤프는 Oracle 1Z0-514실제시험문제를 마스터한 기초에서 제작한 최신시험에 대비한 공부자료로서 시험패스율이 100%입니다. 하루 빨리 덤프를 마련하여 시험을 준비하시면 자격증 취득이 빨라집니다.
NO.1 The DBA of your database informs you that the Oracle instance has started. What does this imply?
A. Users can access the data in the database.
B. Only the SGA has been allocated for the database.
C. Only the background and user processes are running.
D. Memory areas have been allocated and background processes have been started.
Answer: D
NO.2 Which two statements are true regarding the usage of tools in administering an Oracle database?
(Choose two.)
A. Oracle Net Manager: configure a new or existing listener
B. Data Pump: transfer of data from one database to another
C. SQL*Loader: load data horn an Oracle database to an external file
D. Database Upgrade Assistant: upgradeonly single-instance databases
E. Database configuration Assistant (DBCA): create new database userin an existing database
Answer: A, B
NO.3 View the exhibit.
Which actions would be performed and in what sequence by clicking the Startup button?
1) Control file is read.
2) Memory is allocated.
3) Background processes are started.
4) Initialization parameter file is read.
NO.4 Redo log files and data files are opened.
A. 2, 3, 1
B. 4, 1, 5
C. 1, 5, 4, 2
D. 4, 2, 3, 1, 5
E. 3, 2, 4, 1, 5
Answer: D
5.Which two statements are true regarding consistent backups? (Choose two)
A. Database can be opened immediately after the restore operation.
B. Database can be opened only after the restore and recovery operations.
C. Consistent backups can be taken only when the instance is running and the database is closed.
D. Consistent backups can be taken only when the instance is shut clown and the database is closed.
E. Consistent backup are taken before the changes in the online redo log files haw been applied to the
data files.
Answer: A, D
NO.5 You issue the following command as a DBA: SQL>SHUTDOWN
What would be the outcome of the above command?
A. It causes the instance to abort.
B. It waits for all sessions to disconnect.
C. It rolls back the current transactions and disconnects a/I sessions.
D. It waits for the current transaction in each session to complete before disconnecting the sessions.
Answer: B