-
For a general cargo ship, is not the necessary certificate/document that the PSCO will examine()
A . Survey Report File
B . Minimum Safe Manning document
C . Certificates of Competency
D . International Oil Pollution Preventio
-
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 the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?()
A . The size of the shared pool is too small.
B . Cursors are not being shared.
C . A large number COMMITS are being performed.
D . There are frequent logons and logoffs.
E . The buffers are being read into the buffer cache, but some other session is changing the buffers.
-
Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?()
A . The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
B . All the user-defined tablespaces must be in read-only mode on the source database.
C . The export dump file must be created before starting the import on the target database.
D . The source and target database must be running on the same platform with the same endianness.
E . The path of data files on the target database must be the same as that on the source database.
F . The impdp operation must be performed by the same user that performed the expdp operation.
-
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is trueabout the output of the command()
https://assets.asklib.com/images/image2/2018080117575419854.jpg
A . The backup piece is expired as the new backup is available.
B . The backup piece is expired because the operating-system file was not found.
C . The backup piece is expired because the retention period for the backup has expired.
D . The backup piece is expired because the backup set to which it belongs is not complete
-
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of theincident()https://assets.asklib.com/images/image2/2018080117523734517.jpg
A . The DBA is working on the incident and prefers that the incident be kept in the ADR.
B . The incident is now in the Done state and the ADR can select the incident to be purged.
C . The incident has been newly created and is in the process of collecting diagnostic information.
D . The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport
-
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 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.
-
You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause?()
A . ALL
B . PFILE
C . BOTH
D . NONE
E . SPFILE
F . MEMORY
G . INSTANCE
H . DATABASE
-
View the Exhibit to examine the details for an incident.
https://assets.asklib.com/images/image2/2018080116061373347.jpg
Which statement is true regarding the status of the incident()
A . The DBA is working on the incident and prefers that the incident be kept in the ADR.
B . The incident is now in the Done state and the ADR can select the incident to be purged.
C . The incident has been newly created and is in the process of collecting diagnostic information.
D . The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport.
-
Examine the structure of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080116404390510.jpg
What is the correct syntax for an inline view?()
A .https://assets.asklib.com/images/image2/2018080116405368499.jpg
B .https://assets.asklib.com/images/image2/2018080116405773977.jpg
C .https://assets.asklib.com/images/image2/2018080116410160098.jpg
D .https://assets.asklib.com/images/image2/2018080116410455360.jpg
-
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 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 statement: Create synonym emp for hr. employees; What happens when you issue the statement? ()
A . An error is generated.
B . You will have two identical tables in the HR schema with different names.
C . You create a table called employees in the HR schema based on you EMP table.
D . You create an alternative name for the employees table in the HR schema in your own schema.
-
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()
A . The backup piece is expired as the new backup is available.
B . The backup piece is expired because the operating-system file was not found.
C . The backup piece is expired because the retention period for the backup has expired.
D . The backup piece is expired because the backup set to which it belongs is not complete.
-
For a given length of time, the higher the discount rate is, the higher is the present value.
-
Which one of the following is the correct formula for the future value of $500 invested today at 7 percent interest for 8 years?
-
Getting the Best Value for Time
Are you satisfied with what you achieve in the hours spent studying, or do you wonder where all the time has gone, without much to show for it? How hard are you really working? Here are some hints to help you make the most of your study time.
Ⅰ. EFFECTIVE LEARNING
1. Review lecture notes as soon after a lecture as possible. Half an hour spent while the lecture is still fresh in your mind will do more to help you to develop an understanding of what you have heard and remember it than twice the time later on. It can be helpful to go over new work with other students to check that you have grasped all the points.
2. If you have been given an essay or assignment to do, note accurately what is required and start it when your memory of it is clear.
3. Revise and review regularly. Set regular weekly times to review the work in each course. This revision should be cumulative -- adding a bit to the total at a time, covering briefly all the work done so far in the term. This way you will consolidate the groundwork and avoid panic before exams.
4. When you revise, space out the time devoted to any one topic. You will learn more in six one hour periods spread over one week than in one six hour period.
5. Limit your blocks of study to 2 hours on any one topic or type of work. After 1/2 to 2 hours of intensive study you begin to tire and concentration weakens. Take a break at some "achievement point"(end of a chapter, solving a problem, etc. )and then changing to another part of the course or another type of work(e. g. ,from reading to writing)will provide the change necessary to keep up your efficiency.
6. Find out the best times for working for yourself. Some times may be better than others for different types of work and also for your own biological clock: if you tend to feel sleepy in the afternoon, this may not be the best time to try to read history or work out math problems. You may think that working in to the early hours suits you, but does it fit in with an early class next morning? You are likely to feel tired next day and so gain nothing!
Ⅱ. PRACTICAL STEPS
1. Plan a program of balanced activities. University life has many aspects which are important for getting fie benefit from your time here. Some activities have fixed time requirements(e. g. , classes, meetings, sport), others are more flexible(e. g. , recreation, relaxation, study time, personal matters, eating, sleeping).
2. Plan how you will use your study time. Knowing what you are going to do and when saves a lot of time spent on making decisions, false starts, retracing your steps to get the books you need, etc. Commit yourself to studying a particular assignment at a particular time.
3. Study at a regular time and in a regular place. You will learn to associate that time and place with working. This is after all what the world&39; s workers have to do.
4. Trade time and don&39; t steal it. When something unexpected happens and takes up time you had planned for study, decide immediately how you can make up the study missed.
5. Give yourself rewards for work completed on time(e. g., 2 hours solid work = 1 cup of tea or coffee; essay completed = 1 hour&39; s TV ). After a strenuous evening finishing an essay or a set of problems, allow yourself "unwinding time" before bed.
Ⅲ. PLANNING TIME
Working out a time-table will not turn you into a perfectly efficient person, but having a plan and sticking to it for a few weeks can help you to form. better study habits and actually to save time, so that in the end you have more free time than before. Here is a way to plan your time which is flexible and practical.
1. Make out a master time-table for the term, marking your fixed commitments only: class
A.Y
B.N
C.NG
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicable for each employee. Which SQL statement would you use?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135988/ea49d0916fc0345195a85a9b2816cb50.jpg' />
A.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D.You cannot find the information because there is nocommon column between the two tables.
-
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/398a37009eba261eceebfd5a001edaba.png' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/a5add098aa6143b225044036df53c199.png' />
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C. VPD policies are copied from the original table to the new table during online redefinition.
D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
-
In Customizing for Logistics Invoice Verification, the following values are defined for the stochastic block:
Threshold value-10000
Percentage-50
You enter an invoice with a value of 15000
What is the probability that the invoice will be blocked stochastically? Please choose the correct answer.()
A.100%
B.5%
C.50%
D.75%
-
What is the most common value of the hysteresis used when estimating margins for log-n
A.A.3 dB
B.B.5dB
C.C.6dB
D.D.8dB
E.E.10dB
-
Examine the parameters for your database instance:Which three statements are true about the process of automatic optimization by using cardinalityfeedback?()
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.