单项选择题
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 -
单项选择题
A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）
A.Alias
B.View
C.Schema
D.Trigger
