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.
第2题:
A.mkgroup -A=john,mary delivery
B.groupadd -A=john,mary delivery
C.mkgroup adms=john,mary delivery
D.groupadd adms=john,mary delivery
第3题:
第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';
第5题:
下列值不为true的表达式有( )。
A、"john"=="john"
B、"john".equals("john")
C、"john"="john"
D、"john".equals(newString("john"))
第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'