更多"假如通过使用如下的DDL语句创建了一个新用户——dog: CREAT"的相关试题:
[单项选择]若允许一个用户在DOG_DATA表空间使用38MB的磁盘空间,需在CREATE USER语句中使用以下的哪一个子句
A. QUOTA
B. PROFILE
C. DEFAULT TABLESPACE
D. TEMPORARY TABLESPACE
[多项选择]使用下面的语句创建用户:
create user jon identified by oracle default tablespace example;
在EXAMPLE表空间中创建表之前,还必须做什么(选择所有正确的答案)?
A. 什么都不需要做
B. 给予其EXAMPLE上的配额
C. 授予其CREATE TABLE权限
D. 授予其CREATE SESSION权限
E. 授予其MANAGE TABLESPACE权限
[单项选择]请看这个DDL语句:ALTER USER babydog QUOTA 0 ON dog_data;
如果在dog_data表空间中已经存在着一个属于babydog用户的表,并且这个表的大小为20M,请问这个语句将产生什么结果
A. 这个表将被截断
B. babydog用户不能再访问dog_data表空间了
C. 不能再为这个表分配新的区段(extents)了
D. 在dog_data表空间中所有babydog用户使用的磁盘空间将被释放
[单项选择]DDL是
A. 操作数据语言
B. 定义数据的语言
C. 自含语言
D. 宿主语言
[单项选择]Each person’s genetic code is unique except ()identical twins.
A. in case of
B. in the case of
C. the point in case
D. a case of
[填空题]数据库管理系统(DBMS) 提供数据定义语言(DDL) 及它的翻译程序,DDL定义数据的模式、外模式和内模式,并通过翻译程序分别翻译成相应的目标模式,存放在______。
[填空题]数据库管理系统提供了数据定义语言(DDL),用于定义各种数据库对象。数据定义语句经DDL编译器编译后,各种对象的描述信息存放在数据库的______中。
[填空题]数据库管理系统(DBMS)提供数据定义语言(DDL)及它的翻译程序,DDL定义数据的模式、外模式和内模式,并通过翻译程序分别翻译成相应的目标模式,存放在 【7】 。
[填空题]数据库管理系统(DBMS)提供数据定义语言(DDL)及它的翻译程序,DDL定义数据库的模式、外模式和内模式,并通过翻译程序分别翻译成相应的目标模式,存放在 【1】 。
[单项选择]Is your family interested in buying a dog A dog can be a good friend to your family, but if you choose the wrong kind of dog, it can cause you a lot of trouble.
Family should sit down and discuss the problems before buying a dog. Even if the children in your family are the ones who want the dog, the parents are the ones who are really responsible (有责任的) for seeing that the animal is properly cared for. If you don’t know much about dogs, it’s a good idea to go to the library for books about different kinds of dogs, as well as books about how to train a young dog. Dogs of different kinds change in popularity as the years go by. One of the most popular dogs these days is the German shepherd (牧羊犬 ). This is because it provides protection. The family should be warned that these dogs grow up to be very big, and may be too powerful for children. If your house is not big, a toy dog may be a good choice(选择). These dogs are very small and easy to train. They don’t need to be walked dail
A. They are kind.
B. People may choose the wrong dog.
C. They are hard to train.
[填空题]Why does the dog’s owner mistreat the dog
[单项选择]假设使用了如下的DDL语句:
A. 之后,需要查看以下哪一个数据字典视图以追踪sales用户下的customers_id_idx索引的使用情况DBA_INDEXES
B. INDEX_STATS
C. DBA_OBJECTS
D. V$OBJECT_USAGE
[填空题]The trademark can(easy) ______make the public identify it with the product.