单项选择题
A.Instance B.Table space C.System catalog D.Schema repository
Which of the following DB2 objects are publicly referen...
单项选择题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...
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 statem...
单项选择题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