You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A. ll data along with the table structure is deleted
B. The pending transaction in the session is committed
C. ll indexes on the table will remain but they are invalidated
D. ll views and synonyms will remain but they are invalidated
E. ll data in the table are deleted but the table structure will remain
查看答案
相关试题
换一换
The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit,respectively. How do you accomplish this?（）
A.Add the appropriate PL/SQL code for each key. B.Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key. C.Create an object library to define the key triggers, then reference the object library in the form. D.This cannot be accomplished because other function keys provide this functionality by default.
答案
The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit,respectively. How do you accomplish this?（）
A.dd the appropriate PL/SQL code for each key. B.Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key. C.reate an object library to define the key triggers, then reference the object library in the form. D.This cannot be accomplished because other function keys provide this functionality by default.
答案
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A.All data along with the table structure is deleted B.The pending transaction in the session is committed C.All indexes on the table will remain but they are invalidated D.All views and synonyms will remain but they are invalidated E.All data in the table are deleted but the table structure will remain
答案
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）
A. The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file. B. The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file. C. The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file. D. The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
答案
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A.ll data along with the table structure is deleted B.The pending transaction in the session is committed C.ll indexes on the table will remain but they are invalidated D.ll views and synonyms will remain but they are invalidated E.ll data in the table are deleted but the table structure will remain
答案
You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）
A. The control file will be multiplexed. B. The control file will be recreated. C.The script containing the CREATE CONTROLFILE statement will be created. D. The binary backup of the control file will be created.
答案
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A.FORMS_DDL B.DO_SQL C.FORM_SUCCESS D.FORM_NOT_SUCCESS E.DBMS.ERROR_CODE
答案
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A.ORMS_DDL B.O_SQL C.ORM_SUCCESS D.ORM_NOT_SUCCESS E.BMS.ERROR_CODE
答案
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）
A.Immediately following statement execution B.fter the ALTER TABLE DROP UNUSED COLUMNS command is issued C.fter the ALTER TABLE SET UNUSED COLUMN command is issued D.fter the ALTER TABLE MODIFY command is issued
答案
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）
A.reating the parse tree of the statement B.Writing the modified data blocks to the data files C.Writing the modified data to the archived redo log files D.Updating the control file to indicate the most recent checkpoint E.Updating the data file header to indicate the most recent checkpoint F.Reading the blocks to database buffer cache if they are not already there
答案
热门试题
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）
Which of the following commands must be issued to remove a stored script from the recovery catalog？（）
Which of the following commands must be issued to remove a stored script from the recovery catalog？（）
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
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？（）
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？（）
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
使用微信扫一扫登录
