题目详情
当前位置:首页 > 职业培训考试
题目详情:
发布时间:2024-02-29 20:26:04

[单项选择] You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?()
A. The tablespace must be locally managed.
B. The tablespace must have only one temp file.
C. The tablespace must be made nondefault and offline.
D. The tablespace can remain as the default but must have no active sort operations.

更多"You issued the following command on"的相关试题:

[多项选择]The following configuration command was issued on router TK1:ip route 172.16.3.0 255.255.255.0 192.168.2.1.Which of the following statements are true regarding this command?()
A. The command is used to establish a static route.
B. The default administrative distance is used.
C. The command is used to configure the default route.
D. The subnet mask for the source address is 255.255.255.0
E. The command is used to establish a stub network
[单项选择]Which of the following command allows you to view the UDI information for a Cisco device?()
A. show environment
B. show status
C. show inventory
D. show hardware
[单项选择] You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()
A. After two days, a backup will be marked obsolete
B. After two days, a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
[多项选择]The following configuration command was entered into a router:ip route 172.16.3.0 255.255.255.0 192.168.2.4 Which of the following statements are true regarding this configuration change?()
A. The default administrative distance is used.
B. The command is used to establish a static route.
C. The command is used to configure the router interfaces.
D. The command is used to establish a stub network.
E. The subnet mask for the source address is 255.255.255.0
[单项选择]With the following CLI command output performed on an LNS: show l2tp session L2TP session 1/2/3 is up .What is the meaning of the numeric values in the output?()
A. session 1, destination 2, tunnel 3
B. destination 1, session 2, tunnel 3
C. tunnel 1, session 2, destination 3
D. destination 1, tunnel 2, session 3
[单项选择] You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
A. A list of files that require a backup within 3 days
B. A list of files requiring more than 3 days of archivelogs to apply
C. A list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
[单项选择]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 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 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 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 group
[单项选择] You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?()
A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
C.   Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
[多项选择] You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?()
A. It records the usernames and passwords of users when granted the DBA role.
B. It contains the usernames and passwords of users for whom auditing is enabled.
C. Is used by Oracle to authenticate users for remote database administration.
D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
[单项选择] You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()
A. It will display a list of files that need incremental backup
B. It will display a list of files that need backup after five days
C. It will display a list of files that were backed up in the last five days
D. It will display a list of files that have not been backed up in the last five days
E. It will apply the current retention policy to determine the files that need to be backed up
[多项选择] You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation
[多项选择] You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

我来回答:

购买搜题卡查看答案
[会员特权] 开通VIP, 查看 全部题目答案
[会员特权] 享免全部广告特权
推荐91天
¥36.8
¥80元
31天
¥20.8
¥40元
365天
¥88.8
¥188元
请选择支付方式
  • 微信支付
  • 支付宝支付
点击支付即表示同意并接受了《购买须知》
立即支付 系统将自动为您注册账号
请使用微信扫码支付

订单号:

截图扫码使用小程序[完全免费查看答案]
请不要关闭本页面,支付完成后请点击【支付完成】按钮
恭喜您,购买搜题卡成功
重要提示:请拍照或截图保存账号密码!
我要搜题网官网:https://www.woyaosouti.com
我已记住账号密码