单选题View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）A The row movement is not enabled on the table.B The first two updates were not explicitly committed.C The Flashback Versions Query lists only the most recent update.D The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
单选题
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）
A
The row movement is not enabled on the table.
B
The first two updates were not explicitly committed.
C
The Flashback Versions Query lists only the most recent update.
D
The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
参考解析
解析：
暂无解析
相关考题：
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? () A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A、USER_TAB_PRIVS_MADEB、USER_TAB_PRIVSC、USER_COL_PRIVS_MADED、USER_COL_PRIVS
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. A、 Flashback TableB、 Flashback DatabaseC、 Flashback Version QueryD、 The RMAN REPORT commandE、 The DBA_PENDING_TRANSACTIONS view
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.
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.
Which two operations can be performed on an external table（）A、Create a view on the table.B、Create an index on the table.C、Create a synonym on the table.D、Add a virtual column to the table.E、Update the table using the UPDATE statement.F、Delete rows in the table using the DELETE command.
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.
In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？（）A、CPU usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed
You have a computer that runs Windows 7. You need to view the processes that currently generate network activity. What should you do? （）A、Open Resource Monitor and click the Network tab.B、Open Windows Task Manager and click the Networking tab.C、Open Event Viewer and examine the NetworkProfile Operational log.D、Open Performance Monitor and add all the counters for network interface.
You need to identify all failed logon attempts on the domain controllers. What should you do（）A、Run Event Viewer.B、View the Netlogon.log file.C、Run the Security Configuration Wizard.D、View the Security tab on the domain controller computer object.
You need to identify all failed logon attempts on the domain controllers. What should you do（）A、Run Event Viewer.B、View the Netlogon.log file.C、Run the Security Configuration Wizard.D、iew the Security tab on the domain controller computer object.
单选题You have a server named Server1 that runs Windows Sever 2003 Service Pack 2 （SP2）. You create a FTP site on Server1.You need identify how many users are connected to the FTP site. What should you do？（）AFrom Task Manger， view the Networking tab.BFrom the command prompt， run Net view //server1.CFrom the properties of the FTP site， view Current Sessions.DFrom the properties of the FTP site， enable Open Database Connectivity （ODBC） logging.
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed.B The time when the first flashback operation in your database was performed.C A list of flashback operations performed in your database using SCN and time.D The approximate time and the lowest system change number （SCN） to which you can flash back your database.
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A The materialized view should have a complete refresh performed after the online table redefinition is completed.B The materialized view should have a fast refresh performed after the online table redefinition is completed.C The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
单选题Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）AUSER_TAB_PRIVS_MADEBUSER_TAB_PRIVSCUSER_COL_PRIVS_MADEDUSER_COL_PRIVS
单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A V$DATABASEB V$FLASHBACK_DATABASE_STATC V$FLASHBACK_DATABASE_LOGD V$RECOVERY_FILE_DEST
单选题By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.AFlashback TableBFlashback DatabaseCFlashback Versions QueryDthe RMAN REPORT commandEthe DBA_PENDING_TRANSACTIONS view
多选题In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command
单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）AUse the DESCRIBE command on the EMP_DEPT_VU view.BUse the DEFINE VIEW command on the EMP_DEPT_VU view.CUse the DESCRIBE VIEW command on the EMP_DEPT_VU view.DQuery the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.EQuery the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.FQuery the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
单选题You install Microsoft Windows Vista on a new computer. The computer has the following hardware configuration： 2.4-GHz processor 2 GB of RAM 512-MB video adapter 250-GB hard disk. You are unable to view the following features of Windows Vista： Thumbnails Previews on folders Transparent glass. You need to be able to view the advanced visual features of Windows Vista. What should you do？（）APress the ALT key and the TAB key simultaneously.BPress the WINDOWS key and the TAB key simultaneously.CConfigure the system properties to optimize for applications.DConfigure the system properties to optimize for best appearance.
单选题View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）A The row movement is not enabled on the table.B The first two updates were not explicitly committed.C The Flashback Versions Query lists only the most recent update.D The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
多选题You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed