多项选择题
单项选择题
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()
The database instance is currently using SPFILE. View the Exhibit and examine the error that you receivedwhile running the DB Structure Integrity check. Given below are the steps to recover from the error in randomorder: 1.Shut down the instance, if not already done. 2.Copy one of the remaining control files to a new location. 3.Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of thecontrol files. 4.Start up the database instance to the NOMOUNT stage. 5.Recover the database to the point of failure of the control file. 6.Open the database. Identify the correct sequence of steps()
Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day. Choose two actions any of which can be referred to first to diagnose the problem. ()
View the Exhibit and identify the component marked with a question mark. ()
You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are opened. 4:Instance recovery is started. 5:Background processes are started. 6:Data file headers are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time, the maintenance window closes before the statisticsare gathered for all objects. Which statement is true in this scenario()
You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are: 1:Oracle Universal Installer (OUI) 2:Database Configuration Assistant (DBCA) 3:Database Upgrade Assistant (DBUA) 4:Oracle Net Configuration Assistant Which tools would you use for this installation()
赞题库-搜题找答案
(已有500万+用户使用)
无需下载 立即使用
版权所有©考试资料网(ppkao.com)All Rights Reserved