CMS专题
单选题You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because
题目
Create an INSERT trigger to assign the default value to each item in the table.
Create a CHECK constraint to validate the data and to assign the default value to each item in the table.
Create an UPDATE trigger to update the default value for each new item in the table.
Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
参考答案和解析
相似问题和答案
第1题：
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D
第2题：
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
- A、You can perform online whole database backups.
- B、You can performofflinewhole database backups.
- C、You cannot perform schema-level export/import operations.
- D、You can perform the backup of only the SYSTEM tablespace when the database is open.
正确答案:B
第3题：
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）
- A、You obtain the results retrieved from the public synonym HR created by the database administrator.
- B、You obtain the results retrieved from the HR table that belongs to your schema.
- C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
- D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
- E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
正确答案:B
第4题：
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task（）
- A、FULL
- B、SCHEMAS
- C、TRANSFORM
- D、REMAP_SCHEMA
- E、REMAP_TABLESPACE
正确答案:D
第5题：
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）
- A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
- B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
正确答案:D
第6题：
You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema. Which process writes the before images of the physical database blocks to the flashback database logs？（）
- A、 LGWR
- B、 DBWR
- C、 MMON
- D、 RVWR
正确答案:D
第7题：
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）
- A、FULL
- B、SCHEMAS
- C、REMAP_SCHEMA
- D、REMAP_DATAFILES
- E、REMAP_TABLESPACE
正确答案:C
第8题：
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
- A、 V$FLASHBACK_DATABASE_LOG
- B、 V$FLASHBACK_DATABASE_STAT
- C、 V$DATABASE
- D、 V$UNDOSTAT
正确答案:A
第9题：
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（）
- A、 owner
- B、 touser
- C、 attach
- D、 remap_schema
正确答案:D
第10题：
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
- A、You can perform open database backups.
- B、You can perform closed database backups.
- C、You cannot perform schema-level logical backups.
- D、You can perform the backup of only the SYSTEM tablespace when the database is open.
正确答案:B