SQL Server2005中的Create Database语句可以创建一个()。
第1题:
根据SQL标准,创建一个表,应该使用下面哪个语句?()
A CREATE TABLE
B CREATE INDEX
C CREATE VIEW
D CREATE DATABASE
第2题:
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.
You want the package to execute automatically each evening at 8:00 P.M. What should you do?
A.Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B.Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
C.Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D.Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
第3题:
( 23 )在 Access 数据库中创建一个新表,应该使用的 SQL 语句是( ) 。
A ) Create Table
B ) Create Index
C ) Alter Table
D ) Create Database
第4题:
SQL Server2005中的Create Database语句可以创建一个()。
A.表
B.系统数据库
C.用户数据库
D.视图
第5题:
在SQL Server2005中,以下()语句可以创建存储过程。
A.create proc
B.create trigger
C.Create View
D.create database
第6题:
在Access数据库中创建一个新表,应该使用的SQL语句是______。
A.Create Table
B.Create Index
C.Alter Table
D.Create Database
第7题:
SQL Server2005中,使用()可以创建一个触发器。
A.create procedure
B.create table
C.create trigger
D.create index
第8题:
A、CREATE SCHEMA
B、CREATE TABLE
C、CREATE VIEW
D、CREATE DATABASE
第9题:
SQL Server2005触发器主要针对下列语句创建()。
A.SELECT、INSERT、DELETE
B.INSERT、UPDATE、DELETE
C.SELECT、UPDATE、INSERT
D.INSERT、UPDATE、CREATE
第10题:
在SQL中,创建数据库用的命令是()