Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to、

试卷相关题目

• 1Given the following statement:GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;Which statement is correct、

  A.USER1 can only remove the SALES table.

  B.USER1 can only remove records from the SALES table.

  C.USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.

  D.USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.

  开始考试点击查看答案
• 2Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement、

  A.Change the data type of the sequence.

  B.Reset the sequence to its starting value.

  C.Establish new minimum or maximum values.

  D.Change the increment between future values.

  开始考试点击查看答案
• 3What is used in conjunction with a foreign key to define a relationship between two tables、

  A.Primary key

  B.Partitioning key

  C.Check constraint

  D.Unique constraint

  开始考试点击查看答案
• 4Which statement about BEFORE triggers is FALSE、

  A.A BEFORE trigger can be used to perform validation of input data.

  B.A BEFORE trigger can be used to automatically generate values for newly inserted rows.

  C.A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

  D.A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

  开始考试点击查看答案
• 5By default, where is the data stored for a column defined with an XML data type、

  A.In an XML index.

  B.In line with the rest of the data for the table.

  C.In an XML storage object that is separate from the table.

  D.In line with the rest of the data for the table, for XML columns less than 32KB.

  开始考试点击查看答案
• 6Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1、

  A.REVOKE USE OF TABLESPACE mytbsp FROM user1

  B.REVOKE ALTER ON TABLESPACE mytbsp FROM user1

  C.REVOKE UPDATE OF TABLESPACE mytbsp FROM user1

  D.REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

  开始考试点击查看答案
• 7In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in、

  A.Locked

  B.Waiting

  C.Pending

  D.Unconnected

  开始考试点击查看答案
• 8When is a mask used to limit access to data in a table、

  A.When mandatory access control (MAC) is used to protect the table.

  B.When discretionary access control (DAC) is used to protect the table.

  C.When label-based access control (LBAC) is used to protect the table.

  D.When row and column access control (RCAC) is used to protect the tabl

  开始考试点击查看答案
• 9What privilege is required to create a view on a table that you are not the owner of、

  A.INSERT

  B.SELECT

  C.CREATE

  D.TRIGGER

  开始考试点击查看答案
• 10After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create apackage that is stored in the database so it will take advantage of the new indexes. Whichauthority/privilege must user USER1 be granted in order to re-create the package、

  A.BIND

  B.REBIND

  C.BINDADD

  D.BIND_REBIND

  开始考试点击查看答案