You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
时间:2022-11-10
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects of this command()
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario()
Note the following structures in your database server: 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
时间:2022-11-09
Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statementdescribes the effect of the above command()
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()https://assets.asklib.com/images/image2/201808020910242598.jpg
Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine()
时间:2022-11-08
View the Exhibit and identify the component marked with a question mark. ()https://assets.asklib.com/images/image2/2018080115025841442.jpg
时间:2022-11-07
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. https://assets.asklib.com/images/image2/2018080115551810468.jpg Which statement is true about the output of the command()
Which two statements are true about Shared SQL Area and Private SQL Area()
The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery()
时间:2022-11-06
Which two statements about the background process of the database writer are true()
Identify the two situations in which the alert log file is updated with details. ()
View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings,respectively. https://assets.asklib.com/images/image2/201808011533265792.jpg Why are advisors not available for the shared pool and the buffer cache()