当前分类： 1Z0-052
问题：多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn...
查看答案
问题：单选题You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）A The XML scriptB The PL/SQL scriptC The DBMS_SCHEDULER packageD Enterprise Manager to schedule the backup...
问题：多选题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...
问题：单选题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...
问题：单选题In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）A Optimizer statistics are collected automatically.B Only timed operating system （OS） statistics and plan execution statistics...
问题：单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A You can perform online whole database backups.B You can performofflinewhole database backups.C You cannot ...
问题：单选题What could be the reason for this（）A The listener is not running on the database node.B The TNS_ADMIN environmental variable is set to a wrong value.C The orcl.oracle.com database service is not registered with the listener.D The DEFAULT_DOMAIN par...
问题：单选题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...
问题：单选题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...
问题：单选题Note the following points describing various utilities in Oracle Database 11g： 1：It enables the high-speed transfer of data from one database to another. 2：It provides a complete solution for the backup， restoration， and recovery needs of the entire ...
问题：多选题Identify two situations in which the block header grows in a data block. （）Awhen row directories need more row entriesBwhen there is row migration in the data blockCwhen there is an increase in the PCTFREE value for the data blockDwhen more transaction...
问题：多选题You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarte...
问题：单选题For which database operation would you need the database to be in the MOUNT state（）A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance ...
问题：单选题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...
问题：多选题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...
问题：单选题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...
问题：单选题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...
问题：多选题Which two statements are true about Shared SQL Area and Private SQL Areas（）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.DThe w...
问题：多选题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...
问题：单选题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...
