The database instance is not available.
The ALTER TABLE command does not have WAIT option
The table or a row in the table is currently locked by another user session.
The database instance is busy processing other user sessions commands.
The CUSTOMERS table has no long running query active at the time when this request is made.
The server process executing the ALTER TABLE command is busy with another command execution
第1题:
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
第2题:
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
第3题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第4题:
One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem?()
第5题:
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
第6题:
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
第7题:
use the ROLLBACK command with SCN 663571
perform Flashback Transaction Query with SCN 663571
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
第8题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion
第9题:
Restore the backup control file and open the database with RESETLOGS option.
Perform point-in-time recovery because flashback cannot be performed again on this table
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
第10题:
Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
第11题:
Use ROLLBACK command with SCN 663571.
Perform Flashback Transaction Query with SCN 663571.
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
第12题:
’SQL ALTER DATABASE OPEN’;
SQL ALTER DATABASE ’OPEN’;
OPEN DATABASE;
DATABASE OPEN
第13题:
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?()
第14题:
You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table: ALTER TABLE customers MODIFY (cust_nameVARCHAR2 (40)) / When you execute the command, it displays the following error message: ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified What could be the reason for the error message?()
第15题:
You execute the following command in your Supportcenter.cn production database to change the width of the CUST_NAME column of the CUSTOMERS table: ALTER TABLE customers MODIFY (cust_nameVARCHAR2 (40)) / When you execute the command, it displays the following error message: ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified What could be the reason for the error message?()
第16题:
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?()
第17题:
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
第18题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第19题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第20题:
The database instance is not available.
The ALTER TABLE command does not have WAIT option
The table or a row in the table is currently locked by another user session.
The database instance is busy processing other user sessions commands.
The CUSTOMERS table has no long running query active at the time when this request is made.
The server process executing the ALTER TABLE command is busy with another command execution
第21题:
Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
第22题:
The database instance is not available.
The ALTER TABLE command does not have WAIT option
The table or a row in the table is currently locked by another user session.
The database instance is busy processing other user sessions commands.
The CUSTOMERS table has no long running query active at the time when this request is made.
The server process executing the ALTER TABLE command is busy with another command execution
第23题:
Immediately following statement execution
After the ALTER TABLE DROP UNUSED COLUMNS command is issued
After the ALTER TABLE SET UNUSED COLUMN command is issued
After the ALTER TABLE MODIFY command is issued
第24题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion