• 2022-06-01 问题

    以下不是合法的数据库名称的是: A: 1_Test B: _TestDB C: TestDB_1 D: TestDB

    以下不是合法的数据库名称的是: A: 1_Test B: _TestDB C: TestDB_1 D: TestDB

  • 2022-06-04 问题

    style="padding-left:0px;">下面哪条语句创建了一个连接对象() A: con = pymysql.connect(“localhost”,"root","pass","testdb") B: con = pymysql.connect(“localhost”,"root") C: con = pymysql.connect(“localhost”,"pass","testdb") D: con = pymysql.connect("testdb")

    style="padding-left:0px;">下面哪条语句创建了一个连接对象() A: con = pymysql.connect(“localhost”,"root","pass","testdb") B: con = pymysql.connect(“localhost”,"root") C: con = pymysql.connect(“localhost”,"pass","testdb") D: con = pymysql.connect("testdb")

  • 2021-04-14 问题

    创建数据库testDB,正确的语句是

    创建数据库testDB,正确的语句是

  • 2022-06-09 问题

    SQL Server 2012 提供的系统数据库包括( )。 A: master B: msdb C: tempdb D: testdb E: resource

    SQL Server 2012 提供的系统数据库包括( )。 A: master B: msdb C: tempdb D: testdb E: resource

  • 2021-04-14 问题

    每个月份的发生额都比101科目多的科目 请用SQL语句实现:从TestDB数据表中查询出所有月份的发生额都比101科目相应月份的发生额高的科目。请注意:TestDB中有很多科目,都有1-12月份的发生额。 AccID:科目代码,Occmonth:发生额月份,DebitOccur:发生额。 数据库名:JcyAudit,数据集:Select * from TestDB 准备数据的sql代码: drop table if exists TestDB; create table TestDB( id int primary key auto_increment, AccID varchar(20), Occmonth date, DebitOccur bigint); insert into TestDB values (null,'101','1988-1-1',100), (null,'101','1988-2-1',110), (null,'101','1988-3-1',120), (null,'101','1988-4-1',100), (null,'101','1988-5-1',100), (null,'101','1988-6-1',100), (null,'101','1988-7-1',100), (null,'101','1988-8-1',100); --复制上面的数据,故意把第一个月份的发生额数字改小一点 insert into TestDB values (null,'102','1988-1-1',90), (null,'102','1988-2-1',110), (null,'102','1988-3-1',120), (null,'102','1988-4-1',100), (null,'102','1988-5-1',100), (null,'102','1988-6-1',100), (null,'102','1988-7-1',100), (null,'102','1988-8-1',100); --复制最上面的数据,故意把所有发生额数字改大一点 insert into TestDB values (null,'103','1988-1-1',150), (null,'103','1988-2-1',160), (null,'103','1988-3-1',180), (null,'103','1988-4-1',120), (null,'103','1988-5-1',120), (null,'103','1988-6-1',120), (null,'103','1988-7-1',120), (null,'103','1988-8-1',120); --复制最上面的数据,故意把所有发生额数字改大一点 insert into TestDB values (null,'104','1988-1-1',130), (null,'104','1988-2-1',130), (null,'104','1988-3-1',140), (null,'104','1988-4-1',150), (null,'104','1988-5-1',160), (null,'104','1988-6-1',170), (null,'104','1988-7-1',180), (null,'104','1988-8-1',140); --复制最上面的数据,故意把第二个月份的发生额数字改小一点 insert into TestDB values (null,'105','1988-1-1',100), (null,'105','1988-2-1',80), (null,'105','1988-3-1',120), (null,'105','1988-4-1',100), (null,'105','1988-5-1',100), (null,'105','1988-6-1',100), (null,'105','1988-7-1',100), (null,'105','1988-8-1',100);

    每个月份的发生额都比101科目多的科目 请用SQL语句实现:从TestDB数据表中查询出所有月份的发生额都比101科目相应月份的发生额高的科目。请注意:TestDB中有很多科目,都有1-12月份的发生额。 AccID:科目代码,Occmonth:发生额月份,DebitOccur:发生额。 数据库名:JcyAudit,数据集:Select * from TestDB 准备数据的sql代码: drop table if exists TestDB; create table TestDB( id int primary key auto_increment, AccID varchar(20), Occmonth date, DebitOccur bigint); insert into TestDB values (null,'101','1988-1-1',100), (null,'101','1988-2-1',110), (null,'101','1988-3-1',120), (null,'101','1988-4-1',100), (null,'101','1988-5-1',100), (null,'101','1988-6-1',100), (null,'101','1988-7-1',100), (null,'101','1988-8-1',100); --复制上面的数据,故意把第一个月份的发生额数字改小一点 insert into TestDB values (null,'102','1988-1-1',90), (null,'102','1988-2-1',110), (null,'102','1988-3-1',120), (null,'102','1988-4-1',100), (null,'102','1988-5-1',100), (null,'102','1988-6-1',100), (null,'102','1988-7-1',100), (null,'102','1988-8-1',100); --复制最上面的数据,故意把所有发生额数字改大一点 insert into TestDB values (null,'103','1988-1-1',150), (null,'103','1988-2-1',160), (null,'103','1988-3-1',180), (null,'103','1988-4-1',120), (null,'103','1988-5-1',120), (null,'103','1988-6-1',120), (null,'103','1988-7-1',120), (null,'103','1988-8-1',120); --复制最上面的数据,故意把所有发生额数字改大一点 insert into TestDB values (null,'104','1988-1-1',130), (null,'104','1988-2-1',130), (null,'104','1988-3-1',140), (null,'104','1988-4-1',150), (null,'104','1988-5-1',160), (null,'104','1988-6-1',170), (null,'104','1988-7-1',180), (null,'104','1988-8-1',140); --复制最上面的数据,故意把第二个月份的发生额数字改小一点 insert into TestDB values (null,'105','1988-1-1',100), (null,'105','1988-2-1',80), (null,'105','1988-3-1',120), (null,'105','1988-4-1',100), (null,'105','1988-5-1',100), (null,'105','1988-6-1',100), (null,'105','1988-7-1',100), (null,'105','1988-8-1',100);

  • 2022-06-07 问题

    SQL Server安装程序创建4个系统数据库,下列属于系统数据库的是( ) A: master、model、msdb、tempdb B: master、pub、msdb、tempdb C: testdb、model、msdb、tempdb D: master、model、msdb、bookdb

    SQL Server安装程序创建4个系统数据库,下列属于系统数据库的是( ) A: master、model、msdb、tempdb B: master、pub、msdb、tempdb C: testdb、model、msdb、tempdb D: master、model、msdb、bookdb

  • 2022-06-08 问题

    使用连接对象的Execute方法可以执行各种SQL语句,以完成创建数据库、创建表、添加新记录、修改记录及删除记录等任务。试完成填空题。创建一个名为 TestDB的数据SQL Server数据库  conn.Execute()

    使用连接对象的Execute方法可以执行各种SQL语句,以完成创建数据库、创建表、添加新记录、修改记录及删除记录等任务。试完成填空题。创建一个名为 TestDB的数据SQL Server数据库  conn.Execute()

  • 2022-06-14 问题

    案例分析题对SQL Server数据库进行操作,数据库名为:TestDB,用户名为sa,密码为xyz123,数据库服务器名为ACT或211.153.165.7,创建的数据源为TEST,下列语句已创建Connection对象 Set conn = Server.CreateObject("ADODB.Connection") 请按下列要求填空: 以数据源方式指定conn对象的连接字符串 conn.ConnectionString =()

    案例分析题对SQL Server数据库进行操作,数据库名为:TestDB,用户名为sa,密码为xyz123,数据库服务器名为ACT或211.153.165.7,创建的数据源为TEST,下列语句已创建Connection对象 Set conn = Server.CreateObject("ADODB.Connection") 请按下列要求填空: 以数据源方式指定conn对象的连接字符串 conn.ConnectionString =()

  • 2022-06-01 问题

    for i in range(b.max_row): for j in range(b.max_column): print(b.cell(row=i,column=j).value)上面语句运行的结果是:__________。 A: 1 1 1 1 1 1 1 1 1 1 B: 1111111111 C: 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 D: 出现异常

    for i in range(b.max_row): for j in range(b.max_column): print(b.cell(row=i,column=j).value)上面语句运行的结果是:__________。 A: 1 1 1 1 1 1 1 1 1 1 B: 1111111111 C: 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 D: 出现异常

  • 2021-04-14 问题

    【单选题】CDMA通信的基站,假定基站A的码片序列是+1 +1 +1 -1 -1 +1 -1 -1,基站发射bit为101时,实际发射的信号是 A. +1 +1 +1 -1 -1 +1 -1 -1 +1 +1 +1 -1 -1 +1 -1 -1 –1 –1 –1 +1 +1 –1 +1 +1 B. +1 +1 +1 -1 -1 +1 -1 -1 –1 –1 –1 +1 +1 –1 +1 +1 +1 +1 +1 -1 -1 +1 -1 -1 C. +1 +1 +1 -1 -1 +1 -1 -1 +1 +1 +1 -1 -1 +1 -1 -1 +1 +1 +1 -1 -1 +1 -1 -1 D. –1 –1 –1 +1 +1 –1 +1 +1 –1 –1 –1 +1 +1 –1 +1 +1 –1 –1 –1 +1 +1 –1 +1 +1

    【单选题】CDMA通信的基站,假定基站A的码片序列是+1 +1 +1 -1 -1 +1 -1 -1,基站发射bit为101时,实际发射的信号是 A. +1 +1 +1 -1 -1 +1 -1 -1 +1 +1 +1 -1 -1 +1 -1 -1 –1 –1 –1 +1 +1 –1 +1 +1 B. +1 +1 +1 -1 -1 +1 -1 -1 –1 –1 –1 +1 +1 –1 +1 +1 +1 +1 +1 -1 -1 +1 -1 -1 C. +1 +1 +1 -1 -1 +1 -1 -1 +1 +1 +1 -1 -1 +1 -1 -1 +1 +1 +1 -1 -1 +1 -1 -1 D. –1 –1 –1 +1 +1 –1 +1 +1 –1 –1 –1 +1 +1 –1 +1 +1 –1 –1 –1 +1 +1 –1 +1 +1

  • 1 2 3 4 5 6 7 8 9 10