What happens when you run the SQL Tuning Advisor with limited scope?()
A . Access path analysis is not performed for SQL statements.
B . SQL structure analysis is not performed for SQL statements.
C . SQL Profile recommendations are not generated for SQL statements.
D . Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
-
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens?()
A . log writer
B . archival
C . process monitor
D . system monitor
E . change tracking writer
F . database writer
-
When an operator is trying to log off the system displays this message: you have running jobs?? What does this mean?()
A . One or more processes are running in the background, preventing log off.
B . One or more processes are paused, requiring operator input prior to logging off.
C . At least one process is running in the background and it will keep running after the operator logs off
D . At least one process is running in the background using nohup and it will terminate when the operator logs off
-
You work as a network engineer for . You study the exhibit carefully.
What happens when the switch 2 is connected to the rest of the network in the VTP domain Lab_Network?()
Exhibit:
https://assets.asklib.com/images/image2/2018073016373365008.jpg
A . The recently introduced switch 2 removes all configured VLANs throughout the VTP domain.
B . The recently introduced switch 2 creates a STP loop in the VTP domain.
C . The recently introduced switch 2 switches over to VTP transparent mode in order to be included into the VTP domain.
D . A trunk should be configured between the two switches in order to integrate 2 into the VTP domain.
E . The recently introduced switch 2 adds one more VLAN to the VLAN database in the VTP domain.
-
You have a portable computer that runs Windows XP Professional. The computer supports Advanced Configuration and Power Interface (ACPI). You need to ensure that the computer enters Sleep Mode when you close the lid of the computer. What should you do?()
A . From Control Panel, configure the Power Options.
B . From the System properties, configure the Data Execution Prevention settings.
C . From the Services console, set the Startup type for the Human Interface Devices service to Manual.
D . From the Services console, set the Startup type for the Uninterruptable Power Supply service to Manual.&e
-
You have a computer that runs Windows 7. You need to record when an incoming connection is allowedthrough Windows firewall. What should you do?()
A . In Local Group Policy, modify the audit policy.
B . In Local Group Policy, modify the system audit policy.
C . From the Windows Firewall with Advanced Security properties, set the logging settings to Log successfulconnections.
D . From the Windows Firewall with Advanced Security properties, set the Data Protection (Quick Mode)IPSec settings to Advanced.
-
You creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? ()
A . The report will not execute.
B . The report will only accept destination type of previewer or printer.
C . Printer codes will be ignored.
D . Only the printer codes that apply will be processes.
-
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
A . archival
B . log writer
C . database writer
D . system monitor
E . process monitor
F . change tracking writer
-
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 run the following commands: RMAN> list expired backup; RMAN> delete expired backup; What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()
A . They will be renamed.
B . Nothing will happen to them. The backup set pieces do not exist.
C . They will be deleted immediately since they are not in the flash recovery area.
D . You will need to manually remove the physical files listed in the output of the commands.
E . They will become hidden files and removed 10 days later.
-
You plan to use Windows PowerShell scripts to configure system settings when you deploy Windows 7. You need to ensure that Windows PowerShell scripts will run on the client computers during initial setup. What should you do?()
A . Set the script execution policy to RemoteSigned.
B . Set the script execution policy to AllSigned.
C . Set the script execution policy to Restricted.
D . Use Group Policy preferences.
-
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 have a computer that runs Windows Vista.
You need to ensure that active content can be automatically displayed when you insert a CD.
What should you do?()
https://assets.asklib.com/images/image2/2018073115060921801.jpg
A . A
B . B
C . C
D . D
-
You have a computer that runs Windows Vista.
You need to ensure that the computer does not enter sleep mode when it is sharing media files.
What should you do?()
https://assets.asklib.com/images/image2/201807311540139510.jpg
A . A
B . B
C . C
D . D
-
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()
A . Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.
B . Oracle will automatically take the datafile out of hot backup mode and then open the database.
C . Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
D . The database will open with the file in hot backup mode. You can restart the backup at any time.
E . The datafile in hot backup mode will be corrupted and you will have to recover it.
-
You have a portable computer that runs Windows 7. Windows Backup is configured to run every day at15:00. You need to prevent backups from automatically running when the computer is running on thebattery. What should you do?()
A . From Backup and Restore, click Change settings.
B . From Task Scheduler, modify the AutomaticBackup task.
C . From Power Options, modify the settings of the current power plan.
D . From the local computer policy, modify the power management settings.
-
You have an application that is incompatible with Windows Aero.
You need to ensure that Windows Aero is automatically disabled when you run the application.
What should you do?()
https://assets.asklib.com/images/image2/2018073114473613911.jpg
A . A
B . B
C . C
D . D
-
You have a DNS server that runs Windows Server 2003 Service Pack 2 (SP2). You need to see when the server receives a dynamic update in real time. What should you do?()
A . From the System Monitor snap-in, add a new counter.
B . From Task Manager, add a column to the Networking tab.
C . From the Performance Logs and Alerts snap-in, create a new counter log.
D . From the DNS snap-in, open the DNS server properties and configure the Monitoring settings.
-
You install the FTP role service on a server that runs Windows Server 2008. Users receive an errormessage when they attempt to upload files to the FTP site. You need to allow authenticated users toupload files to the FTP site. What should you do?()
A . Run the ftp Ca 192.168.1.200 command on the server that runs Windows Server 2008.
B . Run the appcmd unlock config command on the server that runs Windows Server 2008.
C . Configure Write permissions on the FTP site. Configure the NTFS permissions on the FTP destinationfolder for the Authenticated Users group to Allow - Modify.
D . Configure Write permissions on the FTP site. Configure the NTFS permissions on the FTP destinationfolder for the Authenticated Users group to Allow C Write attributes.
-
You have a computer that runs Windows Vista.
You need to ensure that the temporary Internet files are deleted when you close Windows Internet Explorer.
What should you do?()
https://assets.asklib.com/images/image2/2018073115050493733.jpg
A . A
B . B
C . C
D . D
-
You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; ()
A . You get an error because of a primary key violation.
B . The data and structure of the EMPLOYEES table are deleted.
C . The data in the EMPLOYEES table is deleted but not the structure.
D . You get an error because the statement is not syntactically correct.
-
You have a portable computer that runs Windows XP Professional Service Pack 2 (SP2). You need to configure the computer to generate an alert when only 25 percent of the battery life is available. What should you do?()
A . From the Performance console, create a trace log.
B . From the Performance console, create a counter log.
C . From the Power Options, modify the Alarm Action.
D . From the Power Options, select the Minimal Power Management power scheme.
-
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.
-
What will happen when listeners dial 03?
A.A list of services will be made available.
B.Information on payments can be received.
C.The message will repeat.
D.Requests will be registered.
-
听力原文:W: Mr. Atkins, Would you please tell the court what you were doing when the accident happened and what you saw?
M: Yes, I was driving home from work. It was about 5:15, and there was a blue car in front of me. We were both driving along Harbor Road when a small white Ford suddenly shot out of a side road. It shot right in front of the blue car. The driver tried to stop, but it was impossible. He ran into the white Ford.
W: I see. Now, how fast was the car in front of you going when the accident happened?
M: The blue car? 30 miles an hour. Certainly no more than that.
W: And the white Ford shot out without any warning?
M: Yes, that's right.
W: Then, how can you be sure the blue car was only doing 30?
M: Because I was only doing 30, and the blue car wasn't going any faster than I was.
W: Are you sure of that?
M: Yes, I am. I'm positive.
W: How can you be so positive, Mr. Atkins? Were you looking at your speedometer when the accident happened?
M: Of course not. I was looking at the road ahead. That's how I managed to see the accident!
W: Well, if you weren't looking at your speedometer, how can you possibly be sure how fast you were going?
M: Because I never go faster than 30 on that road.
(20)
A.Defendant and lawyer.
B.Lawyer and witness.
C.Witness and judge.
D.Witness and defendant.