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

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 Note the following statements that use flashback technology:1. FLASHBACK TABLE table TO SCN scn;2. SELECT * FROM table AS OF SCN 123456;3. FLASHBACK TABLE table TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP timestamp;5. SELECT * FROM table VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?()A. 1, 2, and 5B. 1, 3, and 4C. 2, 3, 4, and 5D. 1, 2, 3, 4, and 5

考题 Which statement is true about a forwarding table?() A.It stores a subset of information from the routing table.B.It contains routes learned from all protocols to a destination.C.It provides a database for routes selected and placed into the routing table.D.Every routing protocol maintains its own forwarding table.

考题 _____ is a file that contains metadata-that is, data about data. A.Document B.Excel table] C.Database] D.Data dictionary

考题 Which statement is true about a forwarding table?()A、It stores a subset of information from the routing table.B、It contains routes learned from all protocols to a destination.C、It provides a database for routes selected and placed into the routing table.D、Every routing protocol maintains its own forwarding table.

考题 You plan to execute the following command to perform a Flashback Database operation in your database:   SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation

考题 You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?()A、 The index tablespace contains bitmap indexes.B、 The index tablespace contains more than one data file.C、 The index tablespace supports only complete recovery.D、 The index tablespace is not a dictionary-managed tablespace.E、 There is a dependency relationship between a table and its indexes.

考题 Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered  SQL  CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL DROP TABLE emp;Table dropped.  What happens in this scenario?()A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.

考题 You create a table in your database that contains 50,000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes?()  A、SQL Access AdvisorB、 Memory AdvisorC、SQL Tuning AdvisorD、 Segment Advisor

考题 You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.

考题 Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT

考题 You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()A、 The FLASHBACK TABLE statement will not be written to the alert log file.B、 The EMP table that was dropped by mistake from the database will be restored.C、 The changes made to the EMP table since the specified time will be undone.D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.E、 The FLASHBACK TABLE statement will be executed within a single transaction.F、 The list of transactions that have modified the EMP table since the specified time will be displayed.

考题 You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:  SQL FLASHBACK TABLE ORDERS TO SCN 771513;   What is the prerequisite to perform Flashback Table?()A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.

考题 单选题Which statement is true about a forwarding table?()A It stores a subset of information from the routing table.B It contains routes learned from all protocols to a destination.C It provides a database for routes selected and placed into the routing table.D Every routing protocol maintains its own forwarding table.

考题 单选题You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()A The backup is similar to image copy.B The backup contains all used data blocks.C The backup contains only unused data blocks.D The backup contains all data blocks changed since the last incremental level 1 backup.

考题 单选题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 plan to execute the following command to perform a Flashback Database operation in your database: SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation

考题 单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?()A  The index tablespace contains bitmap indexes.B  The index tablespace contains more than one data file.C  The index tablespace supports only complete recovery.D  The index tablespace is not a dictionary-managed tablespace.E  There is a dependency relationship between a table and its indexes.

考题 单选题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.

考题 单选题You work in a company which 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 n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below, which compression technology should you use?()A You should use row compression B You should use page compression C You should use backup compression D You should use windows NTFS file system compression

考题 多选题You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe changes made to the EMP table since the specified time will be undone.CThe EMP table that was dropped by mistake from the database will be restored.DThe FLASHBACK TABLE statement will be executed within a single transaction.EThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.FThe list of transactions that have modified the EMP table since the specified time will be displayed.

考题 单选题You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()A create baseline metrics for today’s performanceB write the current database metrics to a database table and create a trigger to compare with future database statisticsC write the current database metrics to a flat file and create an operating script to compare with future database statisticsD write the current database metrics to a database table and create a procedure to compare with future database statisticsE write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

考题 单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:  SQL FLASHBACK TABLE ORDERS TO SCN 771513;   What is the prerequisite to perform Flashback Table?()A  You must configure OMF in your database.B  You must enable block change tracking feature in your database.C  You must enable ROW MOVEMENT feature on the ORDERS table.D  You must use the Flashback Version Query before using the Flashback Table feature.

考题 单选题You create a table in your database that contains 50,000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes?()A SQL Access AdvisorB  Memory AdvisorC SQL Tuning AdvisorD  Segment Advisor

考题 单选题Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()A  The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B  The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C  The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D  The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.

考题 单选题You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do?()A Implement a stored procedure that writes data about schema changes to a log table.B Implement DDL AFTER triggers that write user and schema information to a log table.C Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D Implement a DML AFTER trigger that writes data about schema changes to a log table.

考题 单选题Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered  SQL  CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL DROP TABLE emp;Table dropped.  What happens in this scenario?()A The table is moved to the SYSAUX tablespace.B The table is moved to the SYSTEM tablespace.C The table is removed from the database permanently.D The table is renamed and remains in the TBSFD tablespace.

考题 单选题You created the ORDERS table in your database by using the following code:   SQL CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE);   Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’);   SQL INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’);   SQL COMMIT;   Next, you issued the following statement to change the time zone for the database:   SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’;   What will be the result of executing the above statement?()A  The statement will fail.B  The statement will be executed successfully, and the new time zone will be set for the database.C  The statement will be executed successfully, but the new time zone will be set for the current session.D The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.