A. SELECT name, concat (address| | ','| |city| |', ', country) AS full_address, start_date, property_price, property_price*115/100
매장에서
WHERE MONTHS_BETWEEN (start_date, '01-JAN-2000') <=36;

B. SELECT name, concat (address||','| |city| |', ', country) AS full_address, start_date, property_price, property_price*115/100
매장에서
WHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR'))
<=36;

C. 이름, 주소 선택||','||도시||','||국가 AS full_address,
시작일,
property_price, property_price*115/100
매장에서
WHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR'))
<=36;

D. SELECT name, concat (address| | ','| |city| |', ', country) AS full_address, start_date, property_price, property_price*115/100
매장에서
WHERE TO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

A. INTERVAL YEAR TO MONTH 열의 YEAR 필드는 양수 값이어야 합니다.

B. INTERVAL DAY TO SECOND 열은 초 단위를 지원합니다.

C. INTERVAL YEAR TO MONTHcolumns는 단일 연도 내에서 월간 간격만 지원합니다.

D. INTERVAL YEAR TO MONTHcolumns는 연간 간격을 지원합니다.

E. INTERVAL YEAR TO MONTH열은 연도 범위 내에서 월간 간격만 지원합니다.

F. INTERVAL DAY TO SECOND 열의 값을 INTERVAL YEAR TO MONTH 열에 복사할 수 있습니다.

A. 

B. MEMBER_ID = NULL;

C. MEMBER_ID는 NULL입니다.

D. MEMBER_ID = "";

A. e.last_name, m.manager_id 선택
FROM 직원 e LEFT OUTER JOIN 직원 m
켜기(e.employee_id = m.manager_id)
WHERE e.employee_id = 123;

B. m.last_name, e.manager_id 선택
FROM 직원 e LEFT OUTER JOIN 직원 m
켜기(e.manager_id = m.manager_id)
WHERE e.employee_id = 123;

C. e.last_name, e.manager_id 선택
FROM 직원 e RIGHT OUTER JOIN 직원 m
에 (e.employee_id = m.employee_id)
WHERE e.employee_id = 123;

D. e.last_name, m.manager_id 선택
FROM 직원 e RIGHT OUTER JOIN 직원 m
켜기(e.manager_id = m.employee_id)
AND e.employee_id = 123;

A. INSERT INTO 주문(order_id, order_date, order_mode,(SELECT customer idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total);VALUES(1,'10-mar-2007', 'direct', &customer_id , 1000);

B. INSERT INTO ordersVALUES(1,'10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

C. INSERT INTO (SELECT o.order_id, o.order_date, o.order_mode, c.customer_id, o.order_totalFROM 주문 o, 고객 cWHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' AND c. credit_limit=600)VALUES (1,'10-mar-2007', 'direct', (SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

D. INSERT INTO 주문(order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total);VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);