网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
A trigger can be created on which of the following objects?（）
- A、View
- B、Catalog Table
- C、Stored Procedure
- D、Global Temporary Table
参考答案
更多 “A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table” 相关考题
考题
A trigger can be created on which of the following objects?()
A.ViewB.Catalog TableC.Stored ProcedureD.Global Temporary Table
考题
Which are valid statements about Cisco Virtual Interface Card （VIC）？ （）A、 The Cisco VIC can create an unlimited number of Virtual NICsB、 The number of vNICs on the Cisco VIC that can be created is determined by the number of chassis uplinksC、 vNICs are created using software on the host operating systemD、 The host operating system sees a vNIC as a physical PCIe deviceE、 The host operating system sees a vNIC as a sub-interface of a primary NICF、 The Cisco VIC can create 1024 vNICs
考题
Which two statements are true regarding views?（）A、A subquery that defines a view cannot include the GROUP BY clause B、A view that is created with the subquery having the DISTINCT keyword can be updated C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
考题
Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（） A、 AWR baselines are always created as repeating baselines.B、 AWR baselines can be created on the basis of two time values.C、 AWR baselines are always created with infinite expiration duration.D、 AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.
考题
What is true about sequences?（）A、Once created, a sequence belongs to a specific schema.B、Once created, a sequence is linked to a specific table.C、Once created, a sequence is automatically available to all users.D、Only the DBA can control which sequence is used by a certain table.E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.
考题
Which two statements about creating constraints are true?（）A、Constraint names must start with SYS_CB、All constraints must be defines at the column levelC、Constraints can be created after the table is createdD、Constraints can be created at the same time the table is createdE、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view
考题
单选题Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（）A
AWR baselines are always created as repeating baselines.B
AWR baselines can be created on the basis of two time values.C
AWR baselines are always created with infinite expiration duration.D
AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.
考题
多选题Which two are true regarding external tables？ （）AExternal tables can be updated.BExternal tables are read-only tables.CIndexes can be created on external tables.DIndexes cannot be created on external tables.
考题
单选题You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）A
Define a Key-Exit trigger for all the blocks in the form. B
In the Object Navigator, highlight all the items and define a Key-Exit trigger. C
Define a Key-Exit trigger on the primary key item in the master block.D
No additional key-trigger definition is necessary.
考题
单选题What can music do to an instrumentalist according to the passage?A
Music can lead to the enlargement of all the layers of gray.B
Music can cause the brain to emit magnetic field.C
Music can stimulate to some degree the change of brain structure.D
Music can trigger physical change when he / she is playing the instrument.
考题
多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using this command？（）AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.
考题
单选题A trigger can be created on which of the following objects?（）A
ViewB
Catalog TableC
Stored ProcedureD
Global Temporary Table
考题
多选题Which three scenarios are true about Domains?（）ADomains can be created using the Configuration Wizard.BDomains can be created using WLST.CDomain configuration files are located in the WebLogic home directory.DDomains can be created based on a domain template.
考题
多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
考题
单选题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）A
AWR baselines are always created as repeating baselines.B
AWR baselines can be created on the basis of two time values.C
AWR baselines are always created with infinite expiration duration.D
AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expirationduration.
考题
多选题TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）AALTER TABLE OrdersDISABLE TRIGGER trg InsertOrdersBDROP TRIGGER trg InsertOrdersCDISABLE TRIGGER trg InsertOrders ON OrdersDALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION
考题
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view
考题
单选题You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）A
Before parameter form. B
After parameter form. C
Before report. D
After report.
考题
单选题You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）A
The index can be changed from NOLOGGING to LOGGINGB
The index cannot be recovered even in the ARCHIVELOG mode.C
The index can only be created if the base table is created with the NOLOGGING option.D
The index can be recovered if you perform a backup after the CREATE INDEX statement.
考题
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
考题
单选题Which statement is true regarding synonyms?（）A
Synonyms can be created only for a table B
Synonyms are used to reference only those tables that are owned by another user C
A public synonym and a private synonym can exist with the same name for the same table D
The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
考题
单选题What is true about sequences? （）A
Once created, a sequence belongs to a specific schema.B
Once created, a sequence is linked to a specific table.C
Once created, a sequence is automatically available to all users.D
Only the DBA can control which sequence is used by a certain table.E
Once created, a sequence is automatically used in all INSERT and UPDATE statements.
考题
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）A
To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.B
To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.C
To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.D
To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
考题
多选题Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）AALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrdersBDROP TRIGGER trg_InsertOrdersCDISABLE TRIGGER trg_InsertOrders ON OrdersDALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATIONEsp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'
考题
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column level.CConstraints can be created after the table is created.DConstraints can be created at the same time the table is created.EInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view.
热门标签
最新试卷
