网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Translation table的更新方式有哪些?()
- A、通过命令方式
- B、CP重启后
- C、每间隔一小时
- D、通过参数文件的配置指定在每天的固定时间
参考答案
更多 “Translation table的更新方式有哪些?()A、通过命令方式B、CP重启后C、每间隔一小时D、通过参数文件的配置指定在每天的固定时间” 相关考题
考题
( 35 ) “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是A ) GRANT SELECT , UPDATE ( grade ) ON TABLE sc TO user1B ) GRANT SELECT sc , UPDATE sc . grade TO user1C ) GRANT SELECT , UPDATE ON TABLE sc . grade TO user1D ) GRANT SELECT ON TABLE sc , UPDATE ON TABLE sc(grade) TO user1
考题
“把查询SC表和更新SC表的9rade列的权限受予用户userl”的正确SQL语句是( )。A) GRANT SELECT, UPDATE (grade) ON TABLE sc TO userlB) GRANT SELECT so,UPDATE sc,grade TO userlC) GRANT SELECT, UPDATE ON TABLE sc.grade TO userlD) GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc (grade)TO userl
考题
“把查询SC表和更新SC表的9rade列的权限授予用户user”的正确SQL语句是( )。A)GRANT.SELECT sc, UPDATE sc.grade TO userB)GRANT SELECT, UPDATE (grade) ON TABLE sc TO userC)GRANT SELECT, UPDATE ON TABLE sc.grade TO userD)GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user
考题
SQLSERVER服务器中,给定表 table1 中有两个字段 ID、LastUpdateDate,ID表示更新的事务号, LastUpdateDate表示更新时的服务器时间,请使用一句SQL语句获得最后更新的事务号。
考题
假设需要删除Customer表中的LogoutTime列,可以使用如下()方式。
A.ALTER TABLE CUSTOMER DROP column LOGOUTTIMEB.UPDATE TABLE DROP column LOGOUTTIMEC.ALTER TABLE CUSTOMER DROP LOGOUTTIMED.UPDATE TABLE DROP LOGOUTTIME
考题
WhichrouterisdoingLSAtype7totype5translation,andwhy?()
A.BothRTAandRTBwilldoLSA7/5translation,sincetheyarebothNSSAABRsB.RTAwilldoLSA7/5translation,sinceithasthelowerrouterIDC.RTBwilldoLSA7/5translation,sinceithasthehigherrouterIDD.TheredistributingrouterwilldoLSA7/5translation,sinceitiswithintheNSSA
考题
“把查询sc表和更新sc表的grade列的权限受予用户userl”的正确SQL语句是( )。A)GRANT SELECT,UP DATE(grade)ON TABLE sc TO userlB)GRANT SELECT sc,UP DATE sc,grade TO userlC)GRANT SELECT,UP DATE ON TABLE sc,grade TO userlD)GRANT SELECT ON ABLE sc,UP DATE ON TABLE sc(grade) TO userl
考题
数据库应用系统在运行过程中,发现随着数据量的不断增加,有部分查询业务和数据更新业务执行耗时越来越长。经分析,这些业务都与表Table1有关。假设Table1有30多个字段,分别为(Key,A1,A2,...Am,B1,B2,...Bn)。执行频度较高的查询业务都只用到A1,A2,...Am中的大部分属性,因此,DBA决定将表Table1分解为Table2(Key,A1,A2,...Am)和Table3(Key,B1,B2,...Bn)。为了使所有对Table1的查询程序不必修改,应该( );为了使对Table1的更新业务能正确执行,应该(请作答此空);这样实现了( )。A.修改所有对Table1更新的事务程序
B.创建视图Table1,为Table2和Table3的自然连接
C.只修改对A1,A2,...Am中属性更新的事务程序
D.只修改对B1,B2,...Bn中属性更新的事务程序
考题
What is true about this statement used during import?() imp hr/hr tables= (employee, departments) file=hr.dmp ignore=yA、It ignores duplicates.B、It prevents character set translation on import.C、It allows rows to be inserted into a table that already exists.D、It ignores storage parameters in the DML executed during import.
考题
单选题Which router is doing LSA type 7 to type 5 translation,and why?()A
Both RTA and RTB will do LSA7/5 translation,since they are both NSSA ABRsB
RTA will do LSA7/5 translation,since it has the lower router IDC
RTB will do LSA7/5 translation,since it has the higher router IDD
The redistributing router will do LSA7/5 translation,since it is within the NSSA
考题
单选题假设需要删除Customer表中的LogoutTime列,可以使用如下()方式。A
ALTER TABLE CUSTOMER DROP column LOGOUTTIMEB
UPDATE TABLE DROP column LOGOUTTIMEC
ALTER TABLE CUSTOMER DROP LOGOUTTIMED
UPDATE TABLE DROP LOGOUTTIME
考题
单选题如果希望更新表authors中的first_name列为非空,那么可以使用哪个语句?()A
alter table authors add first_name not nullB
alter table authors modify first_name not nullC
alter table authors alter first_name not nullD
alter table authors drop first_name not null
考题
单选题What is true about this statement used during import?() imp hr/hr tables= (employee, departments) file=hr.dmp ignore=yA
It ignores duplicates.B
It prevents character set translation on import.C
It allows rows to be inserted into a table that already exists.D
It ignores storage parameters in the DML executed during import.
考题
问答题切口平移(nick translation)标记探针的主要步骤有哪些?
热门标签
最新试卷