当前分类： 1Z0-052
问题：单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step t...
查看答案
问题：多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which ar...
问题：单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A System monitor （SMON）B Process monitor...
问题：单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the prima...
问题：多选题You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）AYou can perform consistent backups only.BYou can per...
问题：单选题You executed the following command to perform a backup of the USERS tablespace：SQL ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be...
问题：多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is...
问题：多选题Which statements are true regarding the Oracle Data Pump export and import operations（）AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.D...
问题：多选题Which two statements correctly describe the relation between a data file and the logical databasestructures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data fi...
问题：单选题You executed this command to create a temporary table： SQL CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA...
问题：多选题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（）ANo flashback is possible to bri...
问题：单选题Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTI...
问题：单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command o...
问题：单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing...
问题：单选题You are managing an Oracle Database 11g database with this backup strategy： - Every Sunday night， level 0 backup is performed. - On Monday night and subsequent days， level 1 incremental backup is performed. The backups are not cumulative incremental...
问题：单选题You want to create a role to meet these requirements： 1：The role is to be protected from unauthorized usage. 2：The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict...
问题：多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table...
问题：多选题Which two statements are true about Shared SQL Area and Private SQL Area（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DPrivat...
问题：多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index...
问题：单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5...
