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

相似题目

• Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）  

  A .  when ASM disk goes offline B .  when one or more ASM files are dropped C .  when some disks in a disk group are offline D .  when some disks in a failure group for a disk group are rebalancing

  查看最佳答案

• 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 following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）

  A . The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role. B . All the user-defined tablespaces must be in read-only mode on the source database. C . The export dump file must be created before starting the import on the target database. D . The source and target database must be running on the same platform with the same endianness. E . The path of data files on the target database must be the same as that on the source database. F . The impdp operation must be performed by the same user that performed the expdp operation.

  查看最佳答案

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

  查看最佳答案

• View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command（） https://assets.asklib.com/images/image2/2018080117575419854.jpg

  A . The backup piece is expired as the new backup is available. B . The backup piece is expired because the operating-system file was not found. C . The backup piece is expired because the retention period for the backup has expired. D . The backup piece is expired because the backup set to which it belongs is not complete

  查看最佳答案

• Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）

  A . when ASM disk goes offline B . when one or more ASM files are dropped C . when some disks in a disk group are offline D . when some disks in a failure group for a disk group are rebalancing

  查看最佳答案

• 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 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 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 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 following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）

  A . Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file. B . All DDL commands are logged in the alert log file. C . All DDL commands are logged in a different log file that contains DDL statements and their execution dates. D . Only DDL commands that resulted in the creation of new segments are logged. E . All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

  查看最佳答案

• Examine the following RMAN command: https://assets.asklib.com/images/image2/201808021135212163.jpg Which two statements are true regarding the backup taken by using the above RMAN command?（）

  A . Only data files and the control file are backed up. B . Archived redo logs are backed up only I f the database is open during the backup. C . The backup is deleted after one day, regardless of the default retention policy settings. D . The backup becomes obsolete after one day, regardless of the default retention policy settings.

  查看最佳答案

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

  查看最佳答案

• Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）

  A . RESTORE DATAFILE ’/DISK2/user_data01.dbf’ B . RESTORE DATAFILE ’/DISK3/user_data01.dbf’ C . SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’ D . SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf&rsquo

  查看最佳答案

• 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

  查看最佳答案

• View the Exhibit to examine the output for the CROSSCHECK BACKUP command. https://assets.asklib.com/images/image2/2018080115551810468.jpg Which statement is true about the output of the command（）

  A . The backup piece is expired as the new backup is available. B . The backup piece is expired because the operating-system file was not found. C . The backup piece is expired because the retention period for the backup has expired. D . The backup piece is expired because the backup set to which it belongs is not complete.

  查看最佳答案

• Examine the command：   ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS；   What does the command accomplish？（）

  A . Creates an additional copy of the database online redo log files.  B . Stores the primary key column values of each row involved in a DML operation in the online redo log files.  C . Stores the primary key column values of each row involved in a DML operation in the supplemental log files.  D . Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.

  查看最佳答案

• 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 following command that is used to duplicate a database on the same host: https://assets.asklib.com/images/image2/2018080214260721422.jpg Which two statements describe the effect after the database is duplicated successfully? （）

  A . The data files of the read-only tablespaces in the target database are not duplicated B . The read-only tablespaces in the target database are still defined in new the database C . The read-only tablespaces in the target database are changed to online after duplication D . The data files of the read-only tablespaces in the target database get duplicated E . The read-only tablespaces in the target database are not defined in the new database

  查看最佳答案

• 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

  查看最佳答案