영어문제 번역 및 해석~!^^*

소개글

영어문제 번역 및 해석~!^^*에 대한 보고서 자료입니다.

목차

Question 156.
From SQL*Plus, you issue this SELECT statement:
SELECT *
FROM orders;
You use this statement to retrieve data from a database table for____. (Choose all that apply.)

A. updating
B. viewing
C. deleting
D. inserting
E. truncating
Answer: B


Question 157.
From SQL*Plus, you issue this SELECT statement:
SELECT *
FROM orders;
The statement allows you to retrieve data from a database table for ____.

A. updating
B. viewing
C. deleting
D. inserting
E. truncating

Answer : B


Question 158.
Evaluate this SQL statement:
SELECT e.employee_id, (.15*e.salary) + (.5*e.commission_pct)
+ (s.sales_amount*(.35*e.bonus)) AS CALC_VALUE
FROM employees e, sales s
WHERE e.employee_id=s.emp_id;
what will happen if you remove all the parentheses from the calculation?

A. The value displayed in the CALC_VALUE column will be lower.
B. The value displayed int the CALC_VALUE column will be higher.
C. There will be no difference in the value displayed in the CALC_VALUE column.
D. An error will be reported.
Answer : C


Question 159.
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

A. SELECT ename, salary*12 'Annual Salary'
FROM employees;
B. SELECT ename, salary*12 "Annual Salary"
FROM employees;
C. SELECT ename, salary*12 AS Annual Salary
FROM employees;
D. SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY")
FROM employees;

Answer : B

Question 160.
Management has asked you to calculate the value
12*salary*commission_pct for all the employees in the EMP table. The EMP table contains these columns;
LAST_NAME VARCHAR2(35) NOT NULL
SALARY NUMBER(9,2) NOT NULL
COMMISSION_PCT NUMBER(4,2)
Which statement ensures that a value is displayed in the calculated column for all employees?

A. SELECT last_name, 12*salary*commission_pct
FROM emp;
B. SELECT last_name, 12*salary*(commission_pct,0)
FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0))
FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0))
FROM emp;

Answer : C


Question 161.
Evaluate this SQL statement:
SELECT ename,sal, 12*sal+100
FROM emp;
The SAL column stores the monthly salary of the employee. Which
change must be made to the above syntax to calculate the annual
compensation as "monthly salary plus a monthly bonus of $100,
multiplied by 12"?

A. No change is required to achieve the desired results.
B. SELECT ename, sal, 12*(sal+100)
FROM emp;
C. SELECT ename, sal, (12*sal)+100
FROM emp;
D. SELECT ename, sal+100,*12
FROM emp;

Answer : B


Question 162.
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address.
The CUSTOMERS table has these columns:
CUST_ID NUMBER(4) NOT NULL
CUST_NAME VARCHAR2(100)NOT NULL
CUST_ADDRESS VARCHAR2(150)
CUST_PHONE VARCHAR2(20)
Which SELECT statement accomplishes this task?

A. SELECT &
FROM customers;
B. SELECT name, address
FROM customers;
C. SELECT id, name, address, phone
FROM customers;
D. SELECT cust_name, cust_address
FROM customers;
E. SELECT cust_id, cust_name, cust_address, cust_phone
FROM customers;

Answer : D


Question 163.
The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
CUSTOMER_ADDRESS VARCHAR2(150)
CUSTOMER_PHONE VARCHAR2(20)
You need to produce output that states "Dear Customer customer_name,"
The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table. Which statement produces this output?

A. SELECT dear customer, customer_name,
FROM customers;
B SELECT "Dear Customer", customer_name||','
FROM customers;
C. SELECT 'Dear Customer' ||customer_name','
FROM customers;
D. SELECT 'Dear Customer,||customer_name||','
FROM customers;
E. SELECT "Dear Customer"|| customer_name||","
FROM customers;
F. SELECT 'Dear Customer'|| customer_name||','||
FROM customers;

Answer : D


Question 168.
The EMP table contains these columns:
LATS_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 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.

Answer : C


Question 169.
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 results
B. two of the desired results
C. one of the desired results
D. an error statement
Answer : C

본문내용

ct를 가진 2.Exclude 직원. 3.Display 무효 임무 가치를 가진 직원을 위해 0. SQL 계산서를 평가하십시오: LAST_NAME, SALARY*COMMISSION_PCT를 선정하십시오 직원에서 COMMISSION_PCT가 무효 이지 않는 곳에; 계산서는 무엇을 제공하는가? 원한 결과의
A. 전부 원한 결과의 B. 2 원한 결과의 C. 하나 D. 과실 계산서 응답: C
번역 방법:
팁 1: 정확한 번역을 위해 올바른 철자와 문법, 구두점을 사용하세요.
팁 2: 번역이 완료된 후에도 여러분이 번역한 내용을 검색어로 검색하기 위해 아래의 "본 텍스트를 웹으로 검색하기" 버튼을 눌러보세요.
팁 3: "원래 언어로 페이지 보기" 버튼을 클릭하여 원본과 번역된 웹 페이지를 비교해 보세요.

키워드

질문 159,   영어,   해석