更多“SQL Server is a RDBMS(Relational Database Management System)made by Microsoft. This means ”相关问题
  • 第1题:

    You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()

    A. All users except SYS

    B. All users except SCOTT

    C. All users except sys and SCOTT

    D. All users except sys, system, and SCOTT


    参考答案:B

  • 第2题:

    下列连接字符实现与SQL Server数据库的连接,()是不正确的。

    A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

    B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

    C.Data Source=.SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;

    D.Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;


    Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

  • 第3题:

    19、下列连接字符实现与SQL Server数据库的连接,()是不正确的。

    A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

    B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

    C.Data Source=.\\SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;

    D.Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;


    D

  • 第4题:

    下列连接字符实现与SQL Server数据库的连接,()是不正确的

    A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

    B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

    C.Data Source=.SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;

    D.Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;


    Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

  • 第5题:

    28、按标准SQL定义,RDBMS所支持的抽象对象包括()

    A.Schema

    B.View

    C.Database

    D.Table


    Schema;View;Table

  • 第6题:

    按标准SQL定义,RDBMS所支持的抽象对象包括()

    A.Schema

    B.View

    C.Database

    D.Table


    D解析:从SQL99开始引入面向对象数据模型,之前的标准都是完全针对关系模型,故选项D正确。