-
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group?()
A . when ASM disk goes offline
B . when one or more ASM files are dropped
C . when some disks in a disk group are offline
D . when some disks in a failure group for a disk group are rebalancing
-
Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
A . The shrink operation touches every block in the BOOKING table
B . The high-water mark (HWM) for the BOOKING table is shifted from its original position
C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio
-
View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?()https://assets.asklib.com/images/image2/2018080213555554170.png
A . The COMMIT order in the captured workload is preserved during replay.
B . The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
C . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
D . The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
E . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
-
View the Exhibit to examine the parameter values.
You are planning to set the value for the MEMORY_TARGET parameter of your database instance.
What value would you recommend?()
https://assets.asklib.com/images/image2/2018080117085922509.png
A . 90 MB
B . 272 MB
C . 362 MB
D . 1,440 MB
-
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?()
A . An error is returned.
B . You are prompted to enter a new value.
C . A report is produced that matches the first report produced.
D . You are asked whether you want a new value or if you want to run the report based on the previous value.
-
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? ()
A . when ASM disk goes offline
B . when one or more ASM files are dropped
C . when some disks in a disk group are offline
D . when some disks in a failure group for a disk group are rebalancing
-
Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
A . The shrink operation touches every block in the BOOKING table
B . The high-water mark (HWM) for the BOOKING table is shifted from its original position
C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio
-
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
A . It cancels all pending disk drops within the disk group.
B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E . It adds previously dropped disks back into the disk grou
-
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?()
A . An error is returned.
B . You are prompted to enter a new value.
C . A report is produced that matches the first report produced.
D . You are asked whether you want a new value or if you want to run the report based on the previous value.
-
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?()
A . Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B . All DDL commands are logged in the alert log file.
C . All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D . Only DDL commands that resulted in the creation of new segments are logged.
E . All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
-
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
A . The SGA advisor will be disabled.
B . The MTTR advisor will be disabled.
C . Automatic checkpoint tuning will be disabled.
D . Checkpoint information will not be written to the alert log file.
-
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?()
A . Table_open_cache
B . Table_open_cache_instancs
C . Table_definition_cache
D . Tmp_table_size
E . Max_heap_table_size
F . Max_tmp_table
-
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
A . It cancels all pending disk drops within the disk group.
B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E . It adds previously dropped disks back into the disk grou
-
Examine the following RMAN script:
https://assets.asklib.com/images/image2/2018080215330499234.jpg
Which statement describes the purpose of the script?()
A . The data file is checked for physical corruption and backed up if found clean.
B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
-
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?()
A . 120M
B . 320M
C . 480M
D . 600M
-
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()
A . None of the data definition language (DDL) statements are logged in the trace file.
B . Only DDL commands that resulted in errors are logged in the alert log file.
C . A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D . Only DDL commands that resulted in the creation of new database files are logged.
-
Paraphrase the underlined word in the following sentence. It’s a good idea to examine a textbook before the course begins.
-
What would be the output of the following statement?char* value = ‘hello’;printf(‘%s’, value);
-
The following are the benefits of to examine industries and companies EXCEPT __________________
-
Which of the following values represents the strongest correlation?
-
Given the following estimated financial results, value the stock of FishnChips, In
A., using the infinite period dividend discount model (DDM).
· Sales of $1,000,000.
· Earnings of $150,000.
· Total assets of $800,000.
· Equity of $400,000.
· Dividend payout ratio of 60.0%.
· Average shares outstanding of 75,000.
· Real risk free interest rate of 4.0%.
· Expected inflation rate of 3.0%.
· Expected market return of 13.0%.
· Stock Beta at 2.1.
The per share value of FishnChips stock is approximately: (Note: Carry calculations out to at least 3 decimal places.)
B.Unable to calculate stock value because ke
D.$17.91.
E.$26.86.
-
The values of literature include the following EXCEPT______()
A.Literature feeds our dreams and aspirations
B.It discourages us from knowing and improving ourselves and our world
C.We read for the adventure of finding out about life in other times and places
D.We read poems, plays, stories, and essays to learn what it is to be human
-
Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?()
A. It cancels all pending disk drops within the disk group
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been completed
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group