搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单项选择题】

在SQL中，create table为（）数据库中基本表结构的命令。

A、A.建立

B、B.修改

C、C.删除

D、D.查询

查看正确答案
更多“在SQL中，create table为（）数据库中基本表结构的命令。”相关的问题
第1题
[] 在SQL Server中，建表使用的命令是（）。

A、A.CREAT TABLE  B、B.CREAT SCHEMA  C、C.CREAT INDEX  D、D.CREAT VIEW  

点击查看答案
第2题
[单选题] 在SQL中，创建数据库用的命令是（）

A、CREATE SCHEMA  B、CREATE TABLE  C、CREATE VIEW  D、CREATE DATABASE  

点击查看答案
第3题
[单选题] SQL中使用（）语句创建索引。

A、CREATE PROC  B、CREATE VIEW  C、CREATE TABLE  D、CREATE INDEX  

点击查看答案
第4题
[] SQL语言中使用（）语句创建视图。

A、A.CREATE PROC  B、B.CREATE VIEW  C、C.CREATE TABLE  D、D.CREATE DATABASE  

点击查看答案
第5题
[] You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（） You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）

A、A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;  B、B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;  C、C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***  

点击查看答案
第6题
[单选题] SQL Server删除表的关键字是（）。

A、delete table  B、drop table  C、create table  D、use table  

点击查看答案
第7题
[单选题] SQL语言可以使用下列哪条语句来修改基本表（）

A、SET TABLE  B、ALTER TABLE  C、CREATE TABLE  D、ADD TABLE  

点击查看答案
第8题
[单选题] You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）

A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;  B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;  C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***  

点击查看答案
第9题
[] You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（） You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）

A、A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.  B、B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.  C、C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.  D、D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.  E、E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服