-
如果对关系emp(eno,ename,salary)成功执行下面的SQL语句: CREATE CLUSTER INDEX name_index ON emp(salary) 对此结果的正确描述是()。
A . 在emp表上按salary升序创建了一个唯一索引
B . 在emp表上按salary降序创建了一个唯一索引
C . 在emp表上按salary升序创建了一个聚簇索引
D . 在emp表上按salary降序创建了一个聚簇索引
-
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them? ()
A . The two statements produce identical results.
B . The second statement returns a syntax error.
C . There is no need to specify DESC because the results are sorted in descending order by default.
D . The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
-
如果对关系emp(eno,ename,salary)成功执行下面的SQL语句:CREATECLUSTERINDEXname_indexONemp(salary),其结果是()
A . 在emp表上按salary升序创建了一个聚簇索引
B . 在emp表上按salary降序创建了一个聚簇索引
C . 在emp表上按salary升序创建了一个唯一索引
D . 在emp表上按salary降序创建了一个唯一索引
-
类Teacher: class Teacher{ String name; float salary; Teacher(String name){ this.name = name; } Teacher(String name,float salary){ this.name = name; this.salary = salary; } } 执行语句Teacher t = new Teacher(“Tom”,2000.0f);后,字段salary的值是哪一项?()
A . 2000.0f
B . 0.0f
C . null;
D . 2000
-
EMPLOYEES中职员编号为90的职员的commission_pct为空值,salary为1000,语句select12*salary*(commission_pct+0.2)comm from EMPLOYEES;comm显示的结果是()。
A . 12000
B . 0
C . 2400
D . NULL
-
The question of salary increases is high on the()
A . agenda
B . procedure
C . schedule
D . budget
-
执行如下两个查询,结果为() Select ename name,sal salary from emp order by salary Select ename name,sal“salary”from emp order by sal asc
A . 两个查询结果完全相同
B . 第一个查询正确,第二个查询错误
C . 两个查询结构不同
D . 第二个查询正确,第一个查询错误
-
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()
A . SELECT ename, salary*12 ‘Annual Salary’ FROM employees;
B . SELECT ename, salary*12 “Annual Salary” FROM employees;
C . SELECT ename, salary*12 AS Annual Salary FROM employees;
D . SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employee
-
Salaries for temporary positions seem to be higher than ().
A . that of permanent
B . permanent
C . that permanent
D . those for permanent
-
Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?()
A . 17000.00
B . 17000*****
C . ****170.00
D . **17000.00
E . an error statement
-
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? ()
A . SELECT ename, salary*12 'Annual Salary' FROM employees;
B . SELECT ename, salary*12 "Annual Salary" FROM employees;
C . SELECT ename, salary*12 AS Annual Salary FROM employees;
D . SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employee
-
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?()
A . SELECT * FROM t1 UNION SELECT * FROM t2
B . SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C . SELECT * FROM t1 INTERSECT SELECT * FROM t2
D . SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
-
What are your salary expectations?
-
They want at least _______ salaries.
-
Indirect payments of compensation refers to wages, salaries and financial incentives.
-
What’s the salary?
-
The salary of an engineer is much higher_____.
A.than a teacher
B.than that of a teacher
C.in comparison with a teacher's
D.than of a teacher's
-
语句ofstream f("SALARY.DAT",ios_base::app)的功能是建立流对象f,并试图打开文件SALARY.DAT与f
语句ofstream f("SALARY.DAT",ios_base::app)的功能是建立流对象f,并试图打开文件SALARY.DAT与f关联,而且
A.若文件存在,则将其置为空文件;若文件不存在,则打开失败
B.若文件存在,则将文件指针定位于文件尾;若文件不存在,则建立一个新文件
C.若文件存在,则将文件指针定位于文件首;若文件不存在,则打开失败
D.若文件存在,则打开失败;若文件不存在,则建立一个新文件
-
He has a handsome salary can afford many luxuries.
-
Research indicates that over 81% of teachers are dissatisfied with their salary.
A.shows
B.dictates
C.proves
D.discovers
-
语句ofstream f("SALARY.DAT",ios∷app|ios∷binary);的功能是建立流对象f,试图打开文件SALARY.DAT
语句ofstream f("SALARY.DAT",ios∷app|ios∷binary);的功能是建立流对象f,试图打开文件SALARY.DAT并与之连接,并且
A.若文件存在,将文件写指针定位于文件尾;若文件不存在,建立一个新文件
B.若文件存在,将其置为空文件;若文件不存在,打开失败
C.若文件存在,将文件写指针定位于文件首;若文件不存在,建立一个新文件
D.若文件存在,打开失败;若文件不存在,建立一个新文件
-
语句ofstream f(“SALARY.DAT”,ios::noreplace | ios::binary); 的功能是建立流对象f,并试图打开文件SALARY.DAT并与之连接,而且()
A.若文件存在,将文件指针定位于文件尾;若文件不存在,建立一个新文件
B.若文件存在,将其截为空文件;若文件不存在,打开失败
C.若文件存在,将文件指针定位于文件首;若文件不存在,建立一个新文件
D.若文件存在,打开失败;若文件不存在,建立一个新文件
-
将各个系教师的平均工资定义为视图average_salary. create view average_salary as select dept_name,max(salary) from instructor; group by dept_name;
-
_____ a doctor, his salary was 1,000 yuan per month.
A.For
B.As
C.Like
D.To