Passage 2

In 1917, Russia was in chaos. The economy was collapsing, there were food shortages and the country was suffering heavy losses in the World War Ⅰ. Inevitably, people began to lose faith in their ruler, Tsar Nicholas Ⅱ. On 15 March 1917, after much political unrest, the Tsar decided to abdicate. He was replaced by a new government led by Alexander Kerensky.
To begin with a rival political group, the Bolsheviks, led by Vladimir Lennin and Leon Trotsky, supported the new government, but their relationship soon collapsed. The Bolsheviks wanted even more change—their aim was to replace the existing political structure with groups representing each sector of society and they urged every worker to join a revolution in order to bring this about. In July 1917, the Bolsheviks tried to overthrow the government but failed. They tried again on 24 October and this time they were successful. The provisional government was arrested in St Petersburg, and Lenin took over as Head of State. Support for the Bolsheviks soon spread across Russia, and world’s first “workers’ revolutionary State” became reality.
A new government led by Alexander Kerensky ______.

A:was supported by the Bolsheviks all the time B:was overthrew by the Bolsheviks C:abdicated D:wanted more change

向学生表ST中增加一个新列;出生日期(RQ),其类型为日期型。实现该功能的正确SQL语句是 ______。

A:APPEND TABLE RQ DATE ADD ST B:APPEND TABLE RQ DATE ADD ST NOT NULL C:ALTER TABLE ST ADD RQ DATE SMALLINT D:ALTER TABLE ST ADD RQ DATE

建立一个学生表ST,它由学号XH、姓名XM、所在系SD这3个属性组成,其中学号属性不能为空。在下列语句中,能实现该功能的正确语句是______。

A:CREATE TABLE ST(XH CHAR(5) NOT NULL;XM CHAR(20);SD CHAR(15)) B:CREATE TABLE ST(XH CHAR(5),XM CHAR(20)NOT NULL,SD CHAR(15)) C:CREATE TABLE ST(XH CHAR(5) NOT NULL,XM CHAR(20),SD CHAR(15)) D:CREATE TABLE ST(XH CHAR(5) UNIQUE;XM CHAR(20);SD CHAR(15))

向学生表ST中增加一个新列:出生日期(RQ),其类型为日期型。实现该功能的正确的SQL语句是______。

A:APPEND TABLE RQ DATE ADD ST B:APPEND TABLE RQ DATE ADD ST NOT NULL C:ALTER TABLE ST ADD RQ DATE SMALLINT D:ALTER TABLE ST ADD RQ DATE

建立一个学生表ST,它由学号XH、姓名XM、所在系SD这3个属性组成,其中学号属性不能为空。在下列语句中,能实现该功能的正确语句是______。

A:CREATE TABLE ST(XH CHAR(5) NOT NULL;XM CHAR(20);SD CHAR(15)) B:CREATE TABLE ST(XH CHAR(5),XM CHAR(20)NOT NULL,SD CHAR(15)) C:CREATE TABLE ST(XH CHAR(5) NOT NULL,XM CHAR(20),SD CHAR(15)) D:CREATE TABLE ST(XH CHAR(5) UNIQUE;XM CHAR(20);SD CHAR(15))

向学生表ST中增加一个新列:出生日期(RQ),其类型为日期型。实现该功能的正确的SQL语句是______。

A:APPEND TABLE RQ DATE ADD ST B:APPEND TABLE RQ DATE ADD ST NOT NULL C:ALTER TABLE ST ADD RQ DATE SMALLINT D:ALTER TABLE ST ADD RQ DATE

下表是用list命令显示的“运动员”表的内容和结构,第(33)~(35)题使用该表。
记录号 运动员号 投中2分球 投中3分球 罚球
1 1 3 4 5
2 2 2 1 3
3 3 0 0 0
4 4 5 6 7
为“运动员”表增加一个字段“得分”的SQL语句是( )。

A:CHANGE TABLE运动员ADD得分1 B:ALTER DATA运动员ADD得分1 C:ALTER TABLE运动员ADD得分1 D:CHANGE TABLE运动员INSERT得分1

微信扫码获取答案解析
下载APP查看答案解析