当前分类： 1Z0-052
问题：单选题Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）A An update in a leaf row takes place.B The index becomes invalid after the update.C The leaf block containing the row to be updated is ...
查看答案
问题：单选题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...
问题：单选题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...
问题：单选题In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be...
问题：单选题in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）A Optimizer statistics are collected automatically.B Only timed operating system （OS） statistics and plan execution statistics...
问题：单选题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 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...
问题：单选题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 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...
问题：单选题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 have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage，which can be inserted as...
问题：单选题Which statement is true about loading data using the conventional path of SQL*Loader（）A Redo is not generated while performing conventional path loads.B Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.C No exclusive locks are acquire...
问题：单选题Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA Large PoolB Redo Log BufferC Database Bu...
问题：多选题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...
问题：多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with...
问题：单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A when the data file of the undo tablespace is autoextensibleB when there are more than one undo tablespaces available in the databaseC when the undo tablespa...
问题：多选题Which statements are true regarding listeners（）AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can...
