网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Whom should the application form be sent to if you want to apply for SAL FFP Membership?
A
SAL FFP Club.
B
The SAL ticket office.
C
The SAL headquarters.
D
SAL Customer Service Center.
参考答案
参考解析
解析：
由关键词the application form定位到第三段，从文中第三段第一句“mail it to the Customer Service Center of SAL”，如果想申请会员资格，需要将申请表邮寄到上海航空公司旅客服务中心。D为正确选项。
由关键词the application form定位到第三段，从文中第三段第一句“mail it to the Customer Service Center of SAL”，如果想申请会员资格，需要将申请表邮寄到上海航空公司旅客服务中心。D为正确选项。
更多 “单选题Whom should the application form be sent to if you want to apply for SAL FFP Membership?A SAL FFP Club.B The SAL ticket office.C The SAL headquarters.D SAL Customer Service Center.” 相关考题
考题
以下语句错误的是( )A.select sal+1 from emp;B.select sal*10,sal*deptno from emp;C.不能使用运算符号D.select sal*10,deptno*10 from emp;
考题
以下说法错误的是( )A.SELECT max(sal),deptno,job FROM EMP group by sal;B.SELECT max(sal),deptno,job FROM EMP group by deptno;C.SELECT max(sal),deptno,job FROM EMP;D.SELECT max(sal),deptno,job FROM EMP group by job;
考题
Examine the following commands and their output:SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.
考题
emp表是雇员信息表,sal字段存放是的雇员的月薪,以下哪个变量可以存放sal类型的值()
A.v_sal emp%rowtype;B.v_sal emp.sal%type;C.v_sal emp.sal.%type;D.v_sal %type(emp.sal);E.v_sal (emp.sal)%type;
考题
取出工资在2000到3000元(包括上下限)之间的员工()
A.select * from emp wher sal in (2000,3000);B.select * from emp wher sal like (2000,3000);C.select * from emp wher sal = (2000,3000);D.select * from emp wher sal between 2000 and 3000;
考题
授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。
A.GRANT CHANGE ON SCOTT.EMP TO SAB.GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC.GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
考题
对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）A、select sal,decode(sal3000,'A',sal2000,'B','C') grade from emp;B、select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;C、select sal,(case when sal3000 then 'A' when sal2000 then 'B' else 'C' end) grade from emp;D、select sal,(if sal3000 then 'A' elsif sal2000 then 'B' else 'C' end if) grade from emp;
考题
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;
考题
授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。A、GRANT CHANGE ON SCOTT.EMP TO SAB、GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC、GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD、GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
考题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = did WHERE employee_id IN (103,115);B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';C、UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115);D、UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = did WHERE employee_id IN (103,115);
考题
You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.C、Data is never redacted for the EMP_V.SAL column.D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
考题
取出工资在2000到3000元（包括上下限）之间的员工（）A、select * from emp wher sal in (2000,3000);B、select * from emp wher sal like (2000,3000);C、select * from emp wher sal = (2000,3000);D、select * from emp wher sal between 2000 and 3000;
考题
You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）A、SALARY form at runtime. B、SALARY form at design time. C、COMMISSION form at runtime. D、COMMISSION form at design time.
考题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = did WHERE employee _id IN (103,115);B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';C、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115);D、UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = did WHERE employee_id IN (103,115);
考题
单选题取出工资在2000到3000元（包括上下限）之间的员工（）A
select * from emp wher sal in (2000,3000);B
select * from emp wher sal like (2000,3000);C
select * from emp wher sal = (2000,3000);D
select * from emp wher sal between 2000 and 3000;
考题
单选题对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）A
select sal,decode(sal3000,'A',sal2000,'B','C') grade from emp;B
select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;C
select sal,(case when sal3000 then 'A' when sal2000 then 'B' else 'C' end) grade from emp;D
select sal,(if sal3000 then 'A' elsif sal2000 then 'B' else 'C' end if) grade from emp;
考题
单选题Who can apply for a premium ticket from SAL according to the passage?A
A passenger who has traveled several times by plane.B
A passenger who wants to travel on any airlines flights.C
A passenger who has traveled on Shanghai Airlines flights.D
A passenger who has accumulated enough air miles on SAL flights.
考题
单选题You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）A
SALARY form at runtime. B
SALARY form at design time. C
COMMISSION form at runtime. D
COMMISSION form at design time.
考题
多选题You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.BData is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.CData is never redacted for the EMP_V.SAL column.DData is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.EData is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
考题
单选题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;
考题
单选题What’s the legal age to join SAL FFP Club according to the passage?A
11 and underB
12 and underC
12 and overD
18 and over
考题
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）A
UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = did WHERE employee_id IN (103,115);B
UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';C
UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115);D
UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';E
UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = did WHERE employee_id IN (103,115);
考题
单选题授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。A
GRANT CHANGE ON SCOTT.EMP TO SAB
GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC
GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD
GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
考题
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）A
UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = did WHERE employee _id IN (103,115);B
UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';C
UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115);D
UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';E
UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = did WHERE employee_id IN (103,115);
考题
多选题Pathos研究结果显示（）ABUD/FORM都保相比FLU/SAL准纳器，更多减少COPD患者中-重度急性加重的发生BFLU/SAL准纳器相比BUD/FORM都保，更多减少COPD患者中-重度急性加重的发生CFLU/SAL准纳器相比BUD/FORM都保，显著增加COPD患者肺炎发生率及肺炎相关住院率DBUD/FORM都保相比FLU/SAL准纳器，显著增加COPD患者肺炎发生率及肺炎相关住院率
考题
单选题emp表是雇员信息表，sal字段存放是的雇员的月薪，以下哪个变量可以存放sal类型的值（）A
v_sal emp%rowtype;B
v_sal emp.sal%type;C
v_sal emp.sal.%type;D
v_sal %type(emp.sal);E
v_sal (emp.sal)%type;
热门标签
最新试卷
