单项选择题

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