网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）
A
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
B
SELECT last_name FROM EMP WHERE last name ='*A%'
C
SELECT last_name FROM EMP WHERE last name ='_A%';
D
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
参考答案
参考解析
解析：
暂无解析
更多 “单选题You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）A SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B SELECT last_name FROM EMP WHERE last name ='*A%'C SELECT last_name FROM EMP WHERE last name ='_A%';D SELECT last_name FROM EMP WHERE last name LIKE '*A%'” 相关考题
考题
你们怎样选拔参加保卫工作的人员?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?
考题
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 resultsB. Two of the desired resultsC. One of the desired resultsD. An error statement
考题
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);
考题
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 resultsB. Two of the desired resultsC. One of the desired resultsD. An error statement
考题
The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()
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.
考题
You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE； Which statement is true about executing this command？（）A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.
考题
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？ （）A、Create a new display filter and apply the filter to the capture.B、Create a new capture filter and apply the filter to the capture.C、Populate the Aliases table and apply the aliases to the capture.D、Configure the Network Monitor application to enable the Enable Conversations option. Recapture the data to a new file.
考题
单选题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 EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）A
all of the desired resultsB
two of the desired resultsC
one of the desired resultsD
an error statement
考题
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5； Which statement is true about executing this command？（）A
It will display a list of files that need incremental backupB
It will display a list of files that need backup after five daysC
It will display a list of files that were backed up in the last five daysD
It will display a list of files that have not been backed up in the last five daysE
It will apply the current retention policy to determine the files that need to be backed up
考题
单选题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 dsplay 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?（）A
Create a new display filter and apply the filter to the capture.B
Create a new capture filter and apply the filter to the capture.C
Populate the aliases table and apply the aliases to the capture.D
Configure the network monitor application to enable the enable converstations option, recapture the data to a new file.
考题
单选题Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）A
ORDER BY SALARY 5000B
GROUP BY SALARY 5000C
HAVING SALARY 5000D
WHERE SALARY 5000
考题
多选题You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）ASELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESCBSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitCSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTDSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
考题
单选题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 EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）A
all of the desired resultsB
two of the desired resultsC
one of the desired resultsD
an error statement
考题
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）A
It will display a list of files that need incremental backupB
It will display a list of files that need backup after five daysC
It will display a list of files that were backed up in the last five daysD
It will display a list of files that have not been backed up in the last five daysE
It will apply the current retention policy to determine the files that need to be backed up
考题
单选题The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?（）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.
考题
单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）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.
考题
单选题You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE； Which statement is true about executing this command？（）A
It will display a list of files that need incremental backup.B
It will display a list of files that need backup after five days.C
It will display a list of files that were backed up in the last five days.D
It will display a list of files that have not been backed up in the last five days.E
It will apply the current retention policy to determine the files that need to be backed up.
热门标签
最新试卷