网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。
- A、TAKE BACK CREATE ANY TABLE FROM test
- B、REVOKE CREATE ANY TABLE FROM test
- C、REVOKE CREATE ANY TABLE test
- D、TAKE BACK CREATE ANY TABLE test
参考答案
更多 “假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。A、TAKE BACK CREATE ANY TABLE FROM testB、REVOKE CREATE ANY TABLE FROM testC、REVOKE CREATE ANY TABLE testD、TAKE BACK CREATE ANY TABLE test” 相关考题
考题
Which is a valid CREATE TABLE statement? ()
A. CREATE TABLE EMP9$# AS (empid number(2));B. CREATE TABLE EMP*123 AS (empid number(2));C. CREATE TABLE PACKAGE AS (packid number(2));D. CREATE TABLE 1EMP_TEST AS (empid number(2));
考题
You are granted the CREATE VIEW privilege. What does this allow you to do? ()
A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.
考题
SQL语言定义完整性约束条件的功能主要体现在( )。A．CREATE TABLE 语句B．ALTER TABLE 语句C．CREATE TABLE 语句或 ALTER TABLE语句D．CREATE TABLE 语句和 ALTER TABLE语句
考题
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()
A.REVOKE DROP ON t1 FROM PUBLICB.REVOKE UPDATE ON t1 FROM PUBLICC.REVOKE DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC
考题
下列哪种方法不能用于创建索引?_______A.使用CREATE INDEX语句B.使用CREATE TABLE语句C.使用ALTER TABLE语句D.使用CREATE DATABASE语句
考题
你定义了一个对象类型myOBJ,要基于该类型来创建表tab1,语句为()。
A.CREATE TABLE tab1 OF myOBJB.CREATE TABLE myOBJ OF tab1C.CREATE TABLE tab1 AS myOBJD.CREATE TABLE tab1 TYPE OF myOBJ
考题
假设需要回收为用户test授予的CREATE ANY TABLE系统权限,可以使用如下()语句。
A.TAKE BACK CREATE ANY TABLE FROM testB.REVOKE CREATE ANY TABLE FROM testC.REVOKE CREATE ANY TABLE testD.TAKE BACK CREATE ANY TABLE test
考题
假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。
A.GRANT CREATE ANY TABLE testB.GRANT CREATE ANY TABLE TO testC.TAKE CREATE ANY TABLE TO testD.ALTER CREATE ANY TABLE TO test
考题
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
考题
要求删除表test中的所有数据，但是不删除表，而且该删除操作不允许ROLLBACK，应该使用的语句为（）。A、UPDATA testB、DROP TABLE testC、DELETE FROM testD、TRUNCATE TABLE test
考题
下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）A、GRANT INSERT ON emp TO acctsuperB、GRANT CREATE TABLE TO acctsuperC、GRANT SELECT ON emp TO acctsuperD、GRANT UPDATE ANY TABLE TO acctsuperE、GRANT CREATE SESSION TO acctsuper
考题
授予删除任何表的系统权限（DROP ANY TABLE）给user1，并使其能继续授该权限给其他用户，以下正确的SQL语句是（）A、Grant drop any table to user1B、Grant drop any table to user1 with admin optionC、Grant drop table to user1D、Grant drop any table to user1 with check potion
考题
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）A、REVOKE DROP ON t1 FROM PUBLICB、REVOKE UPDATE ON t1 FROM PUBLICC、REVOKE DELETE ON t1 FROM PUBLICD、REVOKE CONTROL ON t1 FROM PUBLIC
考题
你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。A、CREATE TABLE tab1 OF myOBJB、CREATE TABLE myOBJ OF tab1C、CREATE TABLE tab1 AS myOBJD、CREATE TABLE tab1 TYPE OF myOBJ
考题
Which is a valid CREATE TABLE statement? （）A、CREATE TABLE EMP9$# AS (empid number(2));B、CREATE TABLE EMP*123 AS (empid number(2));C、CREATE TABLE PACKAGE AS (packid number(2));D、CREATE TABLE 1EMP_TEST AS (empid number(2));
考题
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A、The table created by SKD is not accessible and SKD cannot create new tables.B、The tables created by SKD and HR remain， but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。A、GRANT CREATE ANY TABLE testB、GRANT CREATE ANY TABLE TO testC、TAKE CREATE ANY TABLE TO testD、ALTER CREATE ANY TABLE TO test
考题
Examine the following steps performed on a database instance： 1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2：The SKD usercreates a table. 3：The SKD user grants theCREATETABLE system privilege to the HR user. 4：The HR user creates a table. 5：The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 is performed（）A、The table created by SKD isnot accessibleand SKD cannot create new tables.B、The tables created by SKD and HR remain， but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
You are granted the CREATE VIEW privilege. What does this allow you to do?（）A、Create a table view.B、Create a view in any schema.C、Create a view in your schema.D、Create a sequence view in any schema.E、Create a view that is accessible by everyone.F、Create a view only of it is based on tables that you created.
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create table FROM C # # A_ADMIN;What is the result?（）A、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B、It fails and reports an error because the CONTAINER=ALL clause is not used.C、It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D、It fails and reports an error because the CONTAINER=CURRENT clause is not used.E、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）A、Grand privileges on the interim table.B、Invoke the dbms_redefinition.can_redef_table procedure.C、Invoke the dbms_redefinition.sync_interim_table procedure.D、Create any triggers， indexes， or constraints on the interim table.E、Create an empty interim table with all the desired characteristics.
考题
CREATE TABLE test（t_idINT，t_nmae CHAR（10））后，增加t_sex字段，以下语句正确的是（）。A、ALTER TABLE test ADD t_sex CHAR（2）B、ALTER TABLE test ADD t_sexC、ALTER TABLE test ALTER t_sex CHAR（2）D、ALTER TABLE test DROP（t_sex CHAR（2））
考题
单选题In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create table FROM C # # A_ADMIN;What is the result?（）A
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B
It fails and reports an error because the CONTAINER=ALL clause is not used.C
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D
It fails and reports an error because the CONTAINER=CURRENT clause is not used.E
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
单选题假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。A
GRANT CREATE ANY TABLE testB
GRANT CREATE ANY TABLE TO testC
TAKE CREATE ANY TABLE TO testD
ALTER CREATE ANY TABLE TO test
考题
单选题Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A
The table created by SKD is not accessible and SKD cannot create new tables.B
The tables created by SKD and HR remain， but both cannot create new tables.C
The table created by HR remains and HR still has the CREATE TABLE system privilege.D
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
单选题假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。A
TAKE BACK CREATE ANY TABLE FROM testB
REVOKE CREATE ANY TABLE FROM testC
REVOKE CREATE ANY TABLE testD
TAKE BACK CREATE ANY TABLE test
热门标签
最新试卷