单选题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.

题目
单选题
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.

相似考题

1.以下语句错误的是( )A.select sal+1 from emp;B.select sal*10,sal*deptno from emp;C.不能使用运算符号D.select sal*10,deptno*10 from emp;

2.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.

3.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;

4.以下说法错误的是( )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;

更多“单选题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.”相关问题

  • 第1题：

    取出工资在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;


    参考答案：D

  • 第2题：

    SAL


    答案：
    解析：
    SAL又称无菌保证水平，是评价灭菌效果的质控指标之-指最终无菌产 品的微生物存活概率。100 万个制品中只允许有一个制品染菌,才达到可靠的灭菌效果。

  • 第3题：

    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;

    正确答案:B

  • 第4题：

    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);

    正确答案:C

  • 第5题：

    取出工资在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;

    正确答案:D

  • 第6题：

    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);

    正确答案:C

  • 第7题：

    单选题
    对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）
    A

    select sal,decode(sal>3000,'A',sal>2000,'B','C') grade from emp;

    B

    select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;

    C

    select sal,(case when sal>3000 then 'A' when sal>2000 then 'B' else 'C' end) grade from emp;

    D

    select sal,(if sal>3000 then 'A' elsif sal>2000 then 'B' else 'C' end if) grade from emp;


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    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. 


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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;


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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);


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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);


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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;


    正确答案： D
    解析： 暂无解析

  • 第13题：

    授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。

    A.GRANT CHANGE ON SCOTT.EMP TO SA

    B.GRANT UPDATE ON SCOTT.EMP（SAL） TO SA

    C.GRANT UPDATE （SAL） ON SCOTT.EMP TO SA

    D.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA


    参考答案：B

  • 第14题：

    对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）

    • A、select sal,decode(sal>3000,'A',sal>2000,'B','C') grade from emp;
    • B、select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;
    • C、select sal,(case when sal>3000 then 'A' when sal>2000 then 'B' else 'C' end) grade from emp;
    • D、select sal,(if sal>3000 then 'A' elsif sal>2000 then 'B' else 'C' end if) grade from emp;

    正确答案:C

  • 第15题：

    授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。

    • A、GRANT CHANGE ON SCOTT.EMP TO SA
    • B、GRANT UPDATE ON SCOTT.EMP（SAL） TO SA
    • C、GRANT UPDATE （SAL） ON SCOTT.EMP TO SA
    • D、GRANT MODIFY ON SCOTT.EMP（SAL） TO SA

    正确答案:B

  • 第16题：

    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.

    正确答案:A,C

  • 第17题：

    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. 

    正确答案:D

  • 第18题：

    单选题
    取出工资在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;


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： D
    解析：
    文章第一段最后一句When you have accumulates enough air miles，you can apply for a premium ticket or other premium items“当你积累了足够的飞行里程时，您就可以申请额外奖励的飞行票或是其他奖励方法。”D项是对该句的同义转述，为正确选项。

  • 第20题：

    多选题
    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.


    正确答案： E,A
    解析： 暂无解析

  • 第21题：

    单选题
    What’s the legal age to join SAL FFP Club according to the passage?
    A

    11 and under

    B

    12 and under

    C

    12 and over

    D

    18 and over


    正确答案： D
    解析：
    考点:细节题。文中第二段第一句Passengers（12 years old over）are eligible to join SAL FFP Clup“12岁以及12岁以上的乘客都有资格申请加入ASL FFP俱乐部”，所以可知答案为C。A、B、D选项均不正确。

  • 第22题：

    单选题
    授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。
    A

    GRANT CHANGE ON SCOTT.EMP TO SA

    B

    GRANT UPDATE ON SCOTT.EMP（SAL） TO SA

    C

    GRANT UPDATE （SAL） ON SCOTT.EMP TO SA

    D

    GRANT MODIFY ON SCOTT.EMP（SAL） TO SA


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    Pathos研究结果显示（）
    A

    BUD/FORM都保相比FLU/SAL准纳器，更多减少COPD患者中-重度急性加重的发生

    B

    FLU/SAL准纳器相比BUD/FORM都保，更多减少COPD患者中-重度急性加重的发生

    C

    FLU/SAL准纳器相比BUD/FORM都保，显著增加COPD患者肺炎发生率及肺炎相关住院率

    D

    BUD/FORM都保相比FLU/SAL准纳器，显著增加COPD患者肺炎发生率及肺炎相关住院率


    正确答案： B,D
    解析： 暂无解析

相关内容