单项选择题A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?（）

A.User ID/password file
B.Communications layer
C.Client applications
D.Operating system

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

点击查看答案
2.单项选择题A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER

点击查看答案
3.单项选择题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）

A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC

点击查看答案
4.单项选择题A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

A.Table
B.Columns
C.Table and Alias
D.Columns and Alias

点击查看答案
5.单项选择题

Given the following DDL and INSERT statements:
CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);
How many of these INSERT statements will be successful?（）

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

点击查看答案
6.单项选择题Which of the following database objects is considered executable using SQL?（）

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

点击查看答案
7.单项选择题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

点击查看答案
8.单项选择题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

点击查看答案
9.单项选择题

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

点击查看答案
10.单项选择题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

点击查看答案

最新试题

Which of the following actions may cause a trigger to be fired?（）

题型：单项选择题

The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?（）

题型：单项选择题

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

题型：单项选择题

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

题型：单项选择题

Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）

题型：单项选择题

When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）

题型：单项选择题

Given the following table definition:STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2)If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）

题型：单项选择题

Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）

题型：单项选择题

Which kind of non-sourced UDF can be created so that it only returns a single value?（）

题型：单项选择题

A UDT is a data type which:（）

题型：单项选择题