更多“John Smith is one of the explorers to the New World.() ”相关问题
  • 第1题:

    Examine the data in the EMPLOYEES table.EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPLOYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD.ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EK_DIR 8000120 Revi 20 110 SA_DIR 6500On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.Evaluate this DELETE statement:DELETE employee_id, salary, job_idFROM employeesWHERE dept_id = 90;Why does the DELETE statement fail when you execute it?()

    A. There is no row with dept_id 90 in the EMPLOYEES table.

    B. You cannot delete the JOB_ID column because it is a NOT NULL column.

    C. You cannot specify column names in the DELETE clause of the DELETE statement.

    D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.


    参考答案:C

  • 第2题:

    Which command will create a group called ‘delivery’and set the administrators to john’ and ‘mary’?()

    A.mkgroup -A=john,mary delivery

    B.groupadd -A=john,mary delivery

    C.mkgroup adms=john,mary delivery

    D.groupadd adms=john,mary delivery


    参考答案:C

  • 第3题:

    Last Sunday had a picnic in Beihai Park.

    A.John,Mary and me
    B.John,I and Mary
    C.John,Mary and I
    D.I,John and Mary

    答案:C
    解析:

  • 第4题:

    下列语句错误的是( )。

    A.char*p="John";p[2]='a';

    B.char name[5]="John";name[2]='a'

    C.char name[5]="John",*p=name;p[2]='a';

    D.char name[5]="John",*p=&name[2];*p='a';


    正确答案:A

  • 第5题:

    下列值不为true的表达式有( )。

    A、"john"=="john"

    B、"john".equals("john")

    C、"john"="john"

    D、"john".equals(newString("john"))


    正确答案:C

  • 第6题:

    通过 SQL,从 “actor” 表中选取 "FirstName" 列的值等于"John" 的所有记录的表述正确的是()。

    A.SELECT * FROM Actor WHERE FirstName='John'

    B.SELECT [all] FROM Actor WHERE FirstName LIKE 'John'

    C.SELECT * FROM Actor WHERE FirstName LIKE 'John'

    D.SELECT [all] FROM Actor WHERE FirstName='John'


    SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter'