SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
第1题:
ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?()
A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);
B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);
C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);
D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);
E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)
F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
第2题:
A. The SQL statement displays the desired results.
B. The column in the WHERE clause should be changed to display the desired results.
C. The operator in the WHERE clause should be changed to display the desired results.
D. The WHERE clause should be changed to use an outer join to display the desired results.
第3题:
你们怎样选拔参加保卫工作的人员?
A.How long will you select those employees for the security work?
B.Why do you select those employees for the security work?
C.How will you select those employees for the security work?
D.How do you select security guards for the World Expo?
第4题:
It will display a list of files that need incremental backup
It will display a list of files that need backup after five days
It will display a list of files that were backed up in the last five days
It will display a list of files that have not been backed up in the last five days
It will apply the current retention policy to determine the files that need to be backed up
第5题:
You perform a security audit on a server named Server1. You install the Microsoft Network Monitor 3.0 application on Server1.You find that only some of the captured frames display host mnemonic names in the Source column and the Destination column. All other frames display IP addresses.You need to display mnemonic host names instead of IP addresses for all the frames. What should you do? ()
第6题:
The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?()
A. All of the desired results
B. Two of the desired results
C. One of the desired results
D. An error statement
第7题:
You issue the following command on the RMAN prompt. RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE; Which statement is true about executing this command?()
第8题:
The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)COMMISSION_PCT NUMBER (6)You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value. Evaluate the SQL statement:SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide? ()
A. All of the desired results
B. Two of the desired results
C. One of the desired results
D. An error statement
第9题:
all of the desired results
two of the desired results
one of the desired results
an error statement
第10题:
Create a new display filter and apply the filter to the capture.
Create a new capture filter and apply the filter to the capture.
Populate the aliases table and apply the aliases to the capture.
Configure the network monitor application to enable the enable converstations option, recapture the data to a new file.