-
You issued the RMAN>SHOW ALL； command. The output of this command is as follows：
https://assets.asklib.com/images/image2/2018080116074760626.jpg
After analyzing the output， which conclusion will you draw？（）
A . The current control file is not automatically backed up every time you perform a backup.
B . The backups save space on the storage media.
C . While performing backups across a network， the network bandwidth is reduced.
D . The backups consist of backup pieces.
-
You examine the port statistics on a Cisco Catalyst switch and notice an excessive number offrames are being dropped. Which of the following are possible reasons for the drops？（）
A . Unknown destination MAC address
B . Bad cabling
C . MAC forwarding table is full
D . Port configured for half duplex
E . Port configured for full duplex
F . Network congestio
-
View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces?（）https://assets.asklib.com/images/image2/2018080213513444789.png
A . The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
B . The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
C . The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
D . The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
-
To examine the Exhibit， press the Exhibit button. Using the "ps -mo THREAD" output as shown in the exhibit， which of the following conclusions is most appropriate to draw？（）https://assets.asklib.com/images/image2/2018080211465344151.bmp
A . This is a uniprocessor system
B . The "prog" process has a nice value of 107
C . There are two active processors on this system
D . The "prog" process will only be scheduled to run on processor 0
-
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
-
You executed the following command in the Recovery Manager （RMAN）： RMAN> REPORT NEED BACKUP days 3； What is the output of this command？（）
A . A list of files that require a backup within 3 days
B . A list of files requiring more than 3 days of archivelogs to apply
C . A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D . A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
-
Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
A . All database operations performed by the impdp command are logged.
B . Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C . Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D . None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
-
View the Exhibit and examine the output of the query.
https://assets.asklib.com/images/image2/2018080116223452518.jpg
What do you infer from this（）
A . The SGA_TARGET is a static parameter.
B . The instance is started， but the database is not yet open.
C . The server parameter file （SPFILE） was used to start the instance.
D . The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.
-
You executed the following command in Recovery Manager （RMAN）： RMAN> REPORT NEED BACKUP days 3； What is the output of this command？（）
A . a list of files that require a backup within three days
B . a list of files requiring more than 3 days of archive logs to apply
C . a list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D . a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
-
Examine the structures of the EMPLOYEES and TAX tables.
https://assets.asklib.com/images/image2/2018080116321734981.jpg
You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min_salary AND t.max_salary;
B . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
C . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
D . You cannot find the information because there is no common column between the two tables.
-
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?（）
A . A list of files that require a backup within 3 days
B . A list of files requiring more than 3 days of archivelogs to apply
C . A list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D . A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
-
You issued the RMAN>SHOW ALL； command. The output of the command is as follows：
https://assets.asklib.com/images/image2/2018080116014456210.jpg
After analyzing this output， what conclusion can you draw？ （）
A . If you perform a backup across a network， then the backup will reduce the bandwidth.
B . If you perform a backup of a datafile， then the backup will be the same as the operating system copy of the datafile.
C . If you perform a backup of a single datafile， then the control file will not be backed up.
D . The maximum size of each backup set is 10MB
E . The backups will be performed on the disk.
-
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.
https://assets.asklib.com/images/image2/2018080116500849327.jpg
For which situation would you use a nonequijoin query?（）
A . To find the tax percentage for each of the employees.
B . To list the name, job id, and manager name for all the employees.
C . To find the name, salary, and department name of employees who are not working with Smith.
D . To find the number of employees working for the Administrative department and earning less then 4000.
E . To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
-
Which of the following commands will enable you to see the contents of the IP routing table andsend the output to a TFTP server at the same time？（）
A . show ip route ∣ to tftp：//192.168.1.1/route.txt
B . show ip route ∣ tee tftp：//192.168.1.1/route.txt
C . show ip route ∣ include tftp：//192.168.1.1/route.txt
D . show ip route ft include tJtp：//19Z168.1.1/route.txt
E . show ip route ∣ redirect tftp：//192.168.1.1/route.txt
-
View the Exhibit and examine the output.
You execute the following RMAN command to perform the backup operation:
https://assets.asklib.com/images/image2/2018080215274892659.jpg
What is the multiplexing level in the preceding backup process（）
A . 4
B . 8
C . 7
D . 0
-
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.
-
To examine the Exhibit， press the Exhibit button. Using the "ps -el" output as shown in the exhibit， which of the following conclusions is most appropriate to draw？（）https://assets.asklib.com/images/image2/2018080211154480089.jpg
A . The snmpd process is running at a fixed priority of 60
B . If both the syncd process and the portmap process become available to be run at the same time， then the syncd process would get scheduled first
C . If both the userprog process and the qdaemon process become available to be run at the same time， then the qdaemon process would get scheduled first
D . If both the syslogd process and the llbd process become available to be run at the same time， then the llbd process would get scheduled first
-
To examine the Exhibit, press the Exhibit button. The exhibit shows the output of netstat -nr. Which of the following addresses will require an additional route entry? （）https://assets.asklib.com/images/image2/2018080211523042275.jpg
A . 129.35.54.22
B . 129.35.56.35
C . 129.35.57.22
D . 129.35.1.22
-
When examining the output from regression analysis, the goodness of fit measure is labeled ________ by most computer programs.
-
An important factor in determining how well you perform in an examination is the ________ of your mind.
-
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 query output:You issue the following command to import tables into the hr schema:$ ＞ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hrTRANSFORM=DISABLE_ARCHIVE_LOGGING: YWhich statement is true？（）
A. All database operations performed by the impdp command are logged.
B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
-
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN＞ BACKUP DATABASE FILESPERSET 2;The database has seven data files.Why is the %_COMPLETE refreshed to 13.59 in the third output afterreaching 88.77？（）
A. Because the progress is reported for each data file
B. Because the progress is reported for each backup set
C. Because other RMAN sessions have issued the same BACKUP command
D. Because new data files have been added to the database while the RMAN backup is in progress
-
Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/6bce46904716f2e8357f4849d2a3423d.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/c5c76fa6bab26c6735c868df586306cf.jpg' />
A.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/0f921b8c15106e9d6cc8e36a50134106.jpg' />
B.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/d072515564553d90b433296aa71e021a.jpg' />
C.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b4721c6b94a9b61c92cdbe82aabc3ae1.jpg' />
D.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b27c35e83798de4bbbccaef22fa31b48.jpg' />
E. The SQL statement produces an error.
