多选题

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

查看答案
该试题由用户695****39提供 查看答案人数:15977 如遇到问题请联系客服
正确答案
该试题由用户695****39提供 查看答案人数:15978 如遇到问题请联系客服
热门试题
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?() 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?() 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 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 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 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?()
购买搜题卡会员须知|联系客服
会员须知|联系客服
关注公众号,回复验证码
享30次免费查看答案
微信扫码关注 立即领取
恭喜获得奖励,快去免费查看答案吧~
去查看答案
全站题库适用,可用于聚题库网站及系列App

    只用于搜题看答案,不支持试卷、题库练习 ,下载APP还可体验拍照搜题和语音搜索

    支付方式

     

     

     
    首次登录享
    免费查看答案20
    登录成功
    首次登录已为您完成账号注册,
    可在【个人中心】修改密码或在登录时选择忘记密码
    账号登录默认密码:手机号后六位