执行如下语句,实际插入的值为:()
A.1,2,3 B.1,2 C.1,3 D.2,3
单项选择题假设PostgreSQL数据库中没有触发器tttt,以下语句能够执行成功且不报错误的是()
A.drop trigger tttt; B.drop trigger tttt on test; C.drop trigger if exists tttt; D.drop trigger if exists tttt on test;
多项选择题下列依据模板创建表的方式中,不包含数据的有()
A.create table testd(liketest)including all; B.create table testc as select * from test with no data; C.create table testb(liketest); D.create table testd(like test including all);
单项选择题下列语句的执行效果是() revoke create on schema public from public;
A.回收public用户在public模式下的create权限 B.回收所有用户在public模式下的create权限 C.该语句执行失败 D.该语句可以执行成功但没有任何效果
单项选择题PostgreSQL中search_path的默认格式是()
A.$user",public B.postgres",public C.test",public D.schema",public
多项选择题下列语法正确的有()
A.alter database db_name rename to newname; B.alter database db_name owner to newname; C.alter database db_name set tablespace new_tbspace; D.alter database db_name reset all;