网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?()
A

implementing value-based auditing by using triggers

B

implementing fine-grained auditing with audit condition and event handler

C

performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED

D

performing standard database auditing to audit SQL statements with granularity level set to ACCESS


参考答案

参考解析
解析: 暂无解析
更多 “单选题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?()A implementing value-based auditing by using triggersB implementing fine-grained auditing with audit condition and event handlerC performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDEDD performing standard database auditing to audit SQL statements with granularity level set to ACCESS” 相关考题
考题 以下语句错误的是( )A. alter table emp delete column addcolumn;B. alter table emp modify column addcolumn char(10);C.alter table emp change addcolumn addcolumn int;D. alter table emp add column addcolumn int;

考题 以下能够删除一列的是( )A.alter table emp remove addcolumnB.alter table emp drop column addcolumnC.alter table emp delete column addcolumnD.alter table emp delete addcolumn

考题 要给学生信息表(STUDENT)增加一个出生日期字段(日期型),下面正确的是____A CREATE TABLE STUDENT ADD COLUMN 出生日期 DATETIMEB ALTER TABLE STUDENT ALTER COLUMN 出生日期 DATETIMEC ALTER TABLE STUDENT ADD COLUMN 出生日期 DATETIMED ALTER TABLE STUDENT SET COLUMN 出生日期 DATETIME

考题 You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?() A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

考题 删除student表中“平均成绩”字段的正确SQL命令是( )。A. DELETE TABLE student DELETE COLUMN平均成绩B. ALTER TABLE student DELETE COLUMN平均成绩C. ALTER TABLE student DROP COLUMN平均成绩D. DELETE TABLE student DROP COLUMN平均成绩

考题 只修改列的数据类型指令是A.ALTER TABLE … … ALTER COLUMNB.ALTER TABLE … MODIFY COLUMN…C.ALTER TABLE … UPDATE …D.ALTER TABLE … UPDATE COLUMN…

考题 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?() A.Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.B.Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).C.Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.D.Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

考题 In which of the following situations should correlation names be used?() A.A table referenced in the FROM clause has no indexed column.B.The table referenced in the FROM clause has more than 200 columns.C.Two or more tables in the FROM clause have identical column names.D.The FROM clause contains two or more tables in the SELECT statement.

考题 利用SQL命令删除“学生”表中的“年龄”字段,正确的命令格式是( )。A)ALTER TABLE 学生 DELETE COLUMN 年龄B)ALTER TABLE 学生 DROP COLUMN 年龄C)ALTER TABLE 学生 CANCEL COLUMN 年龄D)ALTER TABLE 学生 CUT COLUMN 年龄

考题 SQL server中()语句能将temp表中的hostname字段扩充为varchar(100)。A、alter table temp alter column hostname varchar(1100)B、alter table temp column hostname varchar(100)C、alter table temp alter column of hostname varchar(100)D、alter table temp add column hostname varchar(100)

考题 You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?()A、ALTER TABLE commercials MODIFY (description CHAR2(1000));B、ALTER TABLE commercials CHANGE (description CHAR2(1000));C、ALTER TABLE commercials CHANGE (description VARCHAR2(1000));D、ALTER TABLE commercials MODIFY (description VARCHAR2(1000));E、You cannot increase the size of a column if the table has rows.

考题 What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?()A、A check constraint on the EMPLOYEE tableB、A unique constraint on the EMPLOYEE table WORKDEPT columnC、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

考题 Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()A、Define the column MAINID as NOT UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX

考题 You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.

考题 You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()  A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.

考题 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?()  A、On the Products table, you should create a view. B、On the RadioSize column, you should create a clustered index C、On the RadioSize column, you should create a filtered index D、On the RadioSize column, you should create a unique clustered index

考题 单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement:   SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’;   What will be the result of issuing the above statement?()A  The statement will be executed successfully, and a new time zone will be set for the database.B  The statement will be executed successfully, but a new time zone will not be set for the database.C  The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D  The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

考题 单选题You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?()A Create a trigger that rolls back changes to the Price column that violate company policy.B Create a stored procedure that disallows changes to the Price column that violate company policy.C On the Price column, create a check constraint that requires a specified minimum value.D On the Price column, create a foreign key constraint to a table that contains valid prices.

考题 单选题You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?()A ALTER TABLE commercials MODIFY (description CHAR2(2000));B ALTER TABLE commercials CHANGE (description CHAR2(2000));C ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));D ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));E You cannot increase the size of a column if the table has rows.

考题 单选题You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do?()A Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.B Define the new column as NOT NULL with a default value of ’Undefined.’C Define the new column as NULL. Use application logic to enforce the data constraint.D Define the new column as NULL with a default value of ’Undefined.’

考题 单选题You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A Drop the table.B Partition the tableC Truncate the table.D Add a column to the table.E Rename a column in the table.

考题 单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()A  Drop the table.B  Partition the table.C  Truncate the table.D  Add a column to the table.E  Rename a column in the table.

考题 单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column.  Which type of index would you suggest to improve the query performance?()A B­treeB bitmapC reverse keyD function based

考题 单选题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?()A implementing value-based auditing by using triggersB implementing fine-grained auditing with audit condition and event handlerC performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDEDD performing standard database auditing to audit SQL statements with granularity level set to ACCESS

考题 单选题In which of the following situations should correlation names be used?()A A table referenced in the FROM clause has no indexed column.B The table referenced in the FROM clause has more than 200 columns.C Two or more tables in the FROM clause have identical column names.D The FROM clause contains two or more tables in the SELECT statement.

考题 单选题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?()A Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.B Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).C Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.D Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

考题 单选题What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?()A A check constraint on the EMPLOYEE tableB A unique constraint on the EMPLOYEE table WORKDEPT columnC A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table