单项选择题

Which of the following database objects is considered executable using SQL?（）

A.View
B.Table
C.Routine
D.Package

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

Which of the following describes the objects of a DB2 database and their relationships?（）

A.Instance
B.Table space
C.System catalog
D.Schema repository

单项选择题

Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）

A.View
B.Alias
C.Table
D.Package

单项选择题

Given the following statements:
CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);
What is the result of the following query? SELECT count(*) FROM tab2;（）

A.3
B.2
C.1
D.0