OCA OCP Oracle Certification Exam Braindumps

Killtest offers free demo for 1z0-053 Exam. You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only onesite can offer demo for almost all products.

1.You are not sure if Flashback Database is enabled. What database column and view can you query to
see if the flashback logs are being created in the flash recovery area?
A. Query the initialization parameter FLASHBACK_DATABASE in VJINSTANCE. 
B. Query the FLASHBACK_ENABLED column in VJDATABASE.
C. Query the FLASHBACK column in VJDATABASE..
D. Query the FLASHBACK_ON column in VJDATABASE.
Answer: D  
2.What  dynamic  performance  view  can  you  query  to  list  the  supported  platforms  for  transportable
tablespaces?
A. V$TRANSPORTABLE_PLATFORM
B. V$TRANSPORTABLE_TABLESPACE 
C. V$SUPPORTED_PLATFORMS
D. V$DATABASE PLATFORM
Answer: A  
3.You issue the following command to enable block change tracking:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
However, you receive an error message, and the tracking file is not created. What is a possible reason for
the error message?
A. The parameter DB_RECOVERY_FILE_DEST is not set. 
B. You must use ALTER SYSTEM instead. )
C. Your database must be in the MOUNT state to create the block change tracking file. 
D. The parameter DB_CREATE_FILE_DEST is not set.
Answer: D