更多"DBMS的含义是( )。有SQL语句:
SELECTDIST"的相关试题:
[单项选择]DBMS的含义是( )。有SQL语句:
SELECTDISTINCT系号FROM教师WHERE工资>=;
ALL(SELECT工资FROM教师WHERE系号=”02’,)
与如上语句等价的SQL语句是( )。
[单项选择]DBMS的含义是( )。有SQL语句:
SELECT DISTINCT系号FROM教师WHERE工资>= ;
ALL(SELECT 工资 FROM 教师 WHERE 系号=“02”)
该语句的执行结果是系号( )。
A. “01”和“02”
B. “01” 和“03”
C. “01”和“04”
D. “02”和“03”
[填空题]在SQL语句中,要删除仓库关系中仓库号的字段值是WH2的记录,可利用命令:
FROM 仓库 WHERE 仓库号="WH2"。
[单项选择]有SQL语句:
SELECT DISTINCT系号FROM教师WHERE工资>=;
[填空题]查询“学生”表中所有姓“张”的学生记录,完成下列SQL语句:
SELECT*FROM学生成绩WHERE姓名______"张%/
[单项选择]有SQL语句:
SELECT学院.系名,COUNT(*)AS教师人数FROM教师,学院;
WHERE教师.系号=学院.系号GROUP BY学院.系名
与如上语句等价的SQL语句是
A) SELECT学院.系名,COUNT(*)AS教师人数;
FROM教师INNER JOIN学院;
教师.系号=学院.系号GROUP BY学院.系名
B) SELECT学院.系名,COUNT(*)AS教师人数;
FROM教师INNER JOIN学院;
ON教师.系号GROUP BY学院.系名
C) SELECT学院.系名,COUNT(*)AS教师人数;
FROM教师INNER JOIN学院;
ON教师.系号=学院.系号GROUP BY学院.系名
D) SELECT学院.系名,COUNT(*)AS教师人数;
FROM教师INNER JOIN学院;
ON教师.系号=学院.系号
[单项选择] Communications technologies are far from equal when it comes to conveying the truth. The first study to compare honesty across a range of communications media has found that emails are automatically recorded — and can come back to haunt (困扰) you — appears to be the key to the finding.
Jeff Hancock of Cornell University in Ithaca. New York, asked 30 students to keep a communications diary for a week. In it they noted the number of conversations or email exchanges they had lasting more than 10 minutes, and confessed to how many lies they told. Hancock then worked out the number of lies per conversation for each medium. He found that lies made up 14 per cent of emails, 21 per cent of instant messages, 27 per cent of face-to-face interactions and an astonishing 37 per cent of phone calls.
His results, to be presented at the conference on human-computer interaction in Vienna, Austria, in April, have surprised psychologists. Some expected entailers to be the biggest liars, reasoni
A. people are less likely to lie in instant messages
B. people are unlikely to lie in face-to-face interactions
C. people are most likely to lie in email communication
D. people are twice as likely to lie in phone conversations