题目详情
当前位置:首页 > 职业培训考试
题目详情:
发布时间:2023-10-23 06:16:09

[多项选择] In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;
A. $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B. Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C. $ mysql – u root – p – h localhost test < /tmp/t1.sql
D. Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E. $ mysqlinport – u root – p – h localhost test /tmp/t1.sql

更多"In a test database, you issue the S"的相关试题:

[单项选择] You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()
A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
B. RMAN reads the block change tracking file when it performs both incremental backups.
C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
D. RMAN does not read the block change tracking file when it performs either incremental backup.
[单项选择]When you issue the logging trap informational command, what happens? ()
A. An information trap is sent to the SNMP server.
B. Informational and debug messages are logged to the syslog server.
C. All messages are sent to the logging host, where selections are made.
D. All messages from emergencies to informational are sent to the logging host.
[单项选择] You are troubleshooting an issue which is causing full-sized packets entering the MPLS cloud be dropped. You have discovered that one of the switches in the MPLS core is not a Cisco switch, but otherwise the MPLS MTU size is set to 1508 bytes on the routers. Based on this information, which of these may be the reason the packets are being dropped?()
A. The switch on you MPLS core that was not produced by Cisco does not support oversized packets
B. No switches support oversized packets
C. By definition, the maximum MTU is 1500 bytes
D. As MPLS VPN labeling increases the size of the packet by 8 bytes, the IP MTU should have been changed to 1508
[单项选择]Which command do you issue to upgrade the current software on Junos devices?()
A. request system software replace
B. request system software install
C. request system software add
D. request system software upgrade
[单项选择] 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=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which 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.
[单项选择]What will happen if you issue the redundancy force-switchover command on a Catalyst 6500 SeriesSwitch with redundant supervisor modules? ()
A. reset of the primary supervisor
B. manual switchover from standby to active supervisor
C. manual switchover from active to standby supervisor
D. automatic switchover from active to standby on primary supervisor failure
[单项选择]As a network administrator, you issue the interface auto qos voip cisco-phone command on a port in an edge network. It is possible for a Cisco Catalyst switch to check if a Cisco IP Phone is directly attached to that port by:()
A. using DHCP snooping
B. snooping the incoming 802.1Q VLAN tag
C. using CDP
D. snooping the CoS marking on the incoming frames
[单项选择] 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 are troubleshooting a routing issue and need to check the hop-by-hop path to the 10.10.10.10 destination. Which three commands would display the path?()
A. user@router# traceroute 10.10.10.10
B. user@router> ping record-route 10.10.10.10
C. user@router>traceroute 10.10.10.10
D. user@router# run traceroute 10.10.10.10
E. user@router# ping record-route 10.10.10.10
[单项选择]At which command prompt would you issue the set date command?()
A. [edit chassis]   user@router#
B. [edit]   user@router#
C. [edit system]   user@router#
D. user@router>
[多项选择] On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?()
A. Only the ORD_CUSTOMER_IX1 index created.
B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
[单项选择] 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.

我来回答:

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

订单号:

请不要关闭本页面,支付完成后请点击【支付完成】按钮
恭喜您,购买搜题卡成功
重要提示:请拍照或截图保存账号密码!
我要搜题网官网:https://www.woyaosouti.com
我已记住账号密码