Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）

相似题目

• Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）

  A . The shrink operation touches every block in the BOOKING table B . The high-water mark (HWM) for the BOOKING table is shifted from its original position C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio

  查看最佳答案

• Examine this statement：  RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2；  What state must the target database be in for you to use this RMAN command？（）

  A . The target database must be open. B . The target database must be closed. C . The target database must be mounted. D . The target database must be mounted or open.

  查看最佳答案

• Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

  A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL *Loader. D . New data conforms to the constraint， but existing data is not checked. E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

  查看最佳答案

• You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

  A . Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT. B . Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

  查看最佳答案

• Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）

  A . Oracle Managed Files are used for this instance. B . The USER_DATA tablespace is managed using FET$/UET$ tables. C . The COMPATIBLE initialization parameter must be 9.0.0 or higher. D . Space within segments in the USER_DATA tablespace is managed with freelists.

  查看最佳答案

• Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）

  A .  The shrink operation touches every block in the BOOKING table B .  The high-water mark （HWM） for the BOOKING table is shifted from its original position C .  The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D .  The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio

  查看最佳答案

• Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

  A . The SKD user cannot log in to the database instance. B . The objects owned by the SKD user are not accessible to any user. C . The other users can access the objects owned by the SKD user， on which they have access. D . The password for the SKD user expires and the user is forced to change the password at the next log in.

  查看最佳答案

• Examine the command that is used to create a table：  SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；  Which two statements are true about the effect of the above command） （）

  A . A CHECK constraint is created on the OID column. B . A NOT NULL constraint is created on the OID column. C . The ORDERS table is the only object created in the USERS tablespace. D . The ORDERS table and a unique index are created in the USERS tablespace. E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

  查看最佳答案

• The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）

  A . No privileges. B . Only the SELECT privilege. C . Only the CONNECT privilege. D . All the privileges of a default user.

  查看最佳答案

• 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（）

  A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL*Loader. D . New data conforms to the constraint， but existing data is not checked E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

  查看最佳答案

• Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）

  A . It cancels all pending disk drops within the disk group. B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E . It adds previously dropped disks back into the disk grou

  查看最佳答案

• Examine the CREATE DISKGROUP command used to create a disk group：   SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY  DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2；   In which situation would you use this method of disk group creation？（）

  A .  When two-way disk mirroring is required for the allocation units B .  When three-way disk mirroring is required for the allocation units C .  When using hardware mirroring or RAID D .  When disk mirroring is required for the Automatic Storage Management （ASM） disk

  查看最佳答案

• Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）

  A . Automatic statistics collection is stopped for the CUSTOMERS table. B . Statistics for the CUSTOMERS table are locked and cannot be overwritten. C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D . Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

  查看最佳答案

• Examine the CREATE DISKGROUP command used to create a disk group: https://assets.asklib.com/images/image2/2018080215151252767.jpg In which situation would you use this method of disk group creation?（）

  A . When two-way disk mirroring is required for the allocation units B . When three-way disk mirroring is required for the allocation units C . When using hardware mirroring or RAID D . When disk mirroring is required for the Automatic Storage Management (ASM) disk

  查看最佳答案

• Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

  A . The SKD user cannot log in to the database instance. B . The objects owned by the SKD user are not accessible to any user. C . The other users can access the objects owned by the SKD user， on which they have access. D . The password for the SKD user expires and the user is forced to change the password at the next log i

  查看最佳答案

• Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）

  A . A CHECK constraint is created on the OID column. B . A NOT NULL constraint is created on the OID column. C . The ORDERS table is the only object created in the USERS tablespace. D . The ORDERS table and a unique index are created in the USERS tablespace. E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

  查看最佳答案

• To examine the Exhibit, press the Exhibit button. Which option would produce this output from the errpt command? （）https://assets.asklib.com/images/image2/20180802115800592.jpg

  A .  errpt -t  B .  errpt -a  C .  errpt -D  D .  errpt

  查看最佳答案

• 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 remai

  查看最佳答案

• Examine the following ALTER command：   SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS；   What is the purpose of the command？（）  

  A .  It cancels all pending disk drops within the disk group. B .  It restores disks that are being dropped as the result of a DROP DISKGROUP operation C .  It mounts disks in the disk group for which the drop-disk operation has already been co pleted D .  It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E .  It adds previously dropped disks back into the disk grou

  查看最佳答案

• Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）

  A . Automatic statistics collection is stopped for the CUSTOMERS table. B . Statistics for the CUSTOMERS table are locked and cannot be overwritten. C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D . Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistic

  查看最佳答案

• Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）

  A . Database operations will be monitored only when they consume a significant amount of resource. B . Database operations for all sessions will be monitored. C . Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning. D . Only DML and DDL statements will be monitored for the session. E . All subsequent statements in the session will be treated as one database operation and will be monitored.

  查看最佳答案

• Examine the following commands and their output:SQL＞ SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL＞ UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL＞ SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row？（）

  <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a303b81782e5cc63228b13b8df2b43c9.jpg' /> A. Flashback logging is not enabled for the database. B. The changes made to the table are not committed. C. Supplemental logging is not enabled for the database. D. The database is not configured in ARCHIVELOG mode.

  查看最佳答案

• Examine the following ALTER command:SQL＞ ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command？（）

  A. It cancels all pending disk drops within the disk group B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation C. It mounts disks in the disk group for which the drop-disk operation has already been completed D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E. It adds previously dropped disks back into the disk group

  查看最佳答案