Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）

相似题目

• 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 details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）

  A . The size of the shared pool is too small. B . Cursors are not being shared. C . A large number COMMITS are being performed. D . There are frequent logons and logoffs. E . The buffers are being read into the buffer cache, but some other session is changing the buffers.

  查看最佳答案

• 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 RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?（）

  A . Provide a password for the encryption B . Set up an Oracle wallet for the encryption C . No setup is required as it is a default encryption method D . Both Oracle wallet and password must be set up for the encryptio

  查看最佳答案

• 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 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 following RMAN command：   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG；   Which prerequisite must be met before accomplishing the backup？（）

  A .  Provide a password for the encryption B .  Set up an Oracle wallet for the encryption C .  No setup is required as it is a default encryption method D .  Both Oracle wallet and password must be set up for the encryptio

  查看最佳答案

• 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 following RMAN script：   RMAN> run { debug on；  allocate channel c1 type disk； backup datafile 5； }   Which statement describes the purpose of the script？（）  

  A .  The data file is checked for physical corruption and backed up if found clean. B .  The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C .  The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D .  The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

  查看最佳答案

• Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?（）

  A . Provide a password for the encryption B . Set up an Oracle wallet for the encryption C . No setup is required as it is a default encryption method D . Both Oracle wallet and password must be set up for the encryptio

  查看最佳答案

• Examine the following set of RMAN commands: https://assets.asklib.com/images/image2/2018080210170026958.jpg Which statement is true when the RMAN RUN block Is executed?（）

  A . The execution of the script fails because multiple channels cannot coexist. B . The script is executed and both the channels are used for the script execution. C . The new channel, CHI, is Ignored because a channel has been configured already. D . ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

  查看最佳答案

• 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 following RMAN script: https://assets.asklib.com/images/image2/2018080215330499234.jpg Which statement describes the purpose of the script?（）

  A . The data file is checked for physical corruption and backed up if found clean. B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

  查看最佳答案

• Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?（）

  A . The data file is checked for physical corruption and backed up if found clean. B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

  查看最佳答案

• Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）

  A . None of the data definition language (DDL) statements are logged in the trace file. B . Only DDL commands that resulted in errors are logged in the alert log file. C . A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file. D . Only DDL commands that resulted in the creation of new database files are logged.

  查看最佳答案

• Paraphrase the underlined word in the following sentence. It’s a good idea to examine a textbook before the course begins.

  查看最佳答案

• The following are the benefits of to examine industries and companies EXCEPT __________________

  查看最佳答案

• Examine the following query output:You issue the following command to import tables into the hr schema:$ ＞ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hrTRANSFORM=DISABLE_ARCHIVE_LOGGING: YWhich statement is true？（）

  A. All database operations performed by the impdp command are logged. B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged. C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged. D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

  查看最佳答案

• Examine the following commands for redefining a table with Virtual Private Database （VPD) policies:Which two statements are true about redefining the table？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/398a37009eba261eceebfd5a001edaba.png' /> <img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/a5add098aa6143b225044036df53c199.png' /> A. All the triggers for the table are disabled without changing any of the column names or column types in the table. B. The primary key constraint on the EMPLOYEES table is disabled during redefinition. C. VPD policies are copied from the original table to the new table during online redefinition. D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

  查看最佳答案

• Examine the following RMAN command:RMAN>CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN>BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup？（）

  A. Provide a password for the encryption B. Set up an Oracle wallet for the encryption C. No setup is required as it is a default encryption method D. Both Oracle wallet and password must be set up for the encryption

  查看最佳答案

• 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

  查看最佳答案