【单选题】
用SQL*PLUS的___命令可以查看表的结构信息，包括列的名称和数据类型。
A. DESCRIPTION
B. DESC
C. SHOW TABLE
D. SHOW USER
查看试卷，进入试卷练习
微信扫一扫，开始刷题
答案
B
解析
暂无解析
相关试题
【单选题】
显示表student的结构可以用___
A. LIST TABLE student
B. LIST student
C. DESC TABLE student
D. DESC sudent
【单选题】
当需要描述一个表table1对象结构时，可以使用___。
A. DES table1
B. DESC table1
C. DESCR table1
D. DESCRIB table1
【单选题】
在PL/SQL中定义一个名为V_NAME长度为60个字符的变长字符串类型的变量，以下正确的是___
A. V_NAME CHAR(60)
B. V_NAME STRING(60)
C. V_NAME VARCHAR(60)
D. V_NAME VARCHAR(61)
【单选题】
在Oracle中，当用户要执行SELECT语句时，下列___进程从磁盘获得用户需要的数据。
A. 用户进程
B. 服务器进程
C. 日志写入进程（LGWR）
D. 检查点进程（CKPT）
【单选题】
在Windows操作系统中，Oracle的___服务监听并接受来自客户端应用程序的连接请求。
A. OracleHOME_NAMETNSListener
B. OracleServiceSID
C. OracleHOME_NAMEAgent
D. OracleHOME_NAMEHTTPServer
【单选题】
在Oracle中，下面哪条语句当COMM字段为空时显示0，不为空时显示COMM的值___。
A. SELECT ename, NVL(comm, 0) FROM emp
B. SELECT ename, NULL(comm, 0) FROM emp
C. SELECT ename, NULLIF(comm, 0) FROM emp
D. SELECT ename, DECODE(comm, NULL, 0) FROM emp
【单选题】
在Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是___。
A. select seq.ROWNUM from dual
B. select seq.ROWID from dual
C. select seq.CURRV AL from dual
D. select seq.NEXTV AL from dual
【单选题】
要统计某表中记录的总个数，以下哪项是正确的SQL语句___。
A. select Max(*) from 表名
B. select Sum(*) from 表名
C. select Count(*) from 表名
D. select Min(*) from 表名
【单选题】
下列正确查询姓张的学生的语句是___。
A. select * from 表名 where 姓名= '张'
B. select * from 表名 where 姓名 like '张%'
C. select * from 表名 where 姓名= '%张%'
D. select * from 表名 where 姓名 like '张'
【单选题】
在SQL*PLUS环境中可以利用DBMS_OUTPUT包中的PUT_LINE方法来回显服务器端变量的值，但在此之前要利用一个命令打开服务器的回显功能,这一命令是___。
A. set server on
B. set serverecho on
C. set servershow on
D. set serveroutput on
【单选题】
第一步用DELETE命令删除了表A中的数据(但并没有提交)，第二步成功创建了一个表B，第三步执行了一个ROLLBACK回滚操作。请问以下叙述正确的是___。
A. 表A中的数据被恢复回来，创建的表B被从数据库中被删除，恢复为未建表之前的状态
B. 表A中的数据被恢复回来，表B被创建在数据库中
C. 表A中的数据被彻底从数据库中删除，但表B被从数据库中被删除,恢复为未建表之前的状态
D. 表A中的数据被彻底从数据库中删除，表B被创建在数据库中
【单选题】
某个表的创建语句如下: CREATE TABLE USER_TAB01(COL1, COL2, COL3) TABLESPACE USER01 STORAGE(INITIAL 64K NEXT 128K PCTINCREASE 100); ORACLE为该表的数据段分配的前3个区的大小依次为多大?___
A. 64KB, 128KB, 128KB
B. 64KB, 128KB, 192KB
C. 64KB, 128KB, 64KB
D. 64KB, 128KB, 256KB
【单选题】
假定有一张表用户表users，其中一身份证字段ID_card。为了维护数据的完整性，在设计数据库时，最好对ID_card字段添加约束，请问应该添加什么约束___。
A. primary key
B. check
C. default
D. not null
【单选题】
下面哪一个like命令会返回名字象HOTKA的行？___
A. where ename like ‘_HOT%'
B. where ename like ‘H_T%'
C. where ename like ‘%TKA_'
D. where ename like ‘%TOK%'
【单选题】
命令sqlplus /nolog的作用是___
A. 仅创建一个ORACLE实例,但并不打开数据库.
B. 仅创建一个ORACLE实例,但并不登录数据库.
C. 启动sqlplus,但并不登录数据库
D. 以nolog用户身份启动sqlplus
推荐试题
【单选题】
Which STP feature can prevent an attacker from becoming the root bridge by immediately shutting down the interface when it receives a BPDU？___
A. root guard
B. Port Fast
C. BPDU guard
D. BPDU filtering
【单选题】
Which technology can best protect data at rest on a user system？___
A. full-disk encryption
B. IPsec tunnel
C. router ACL
D. network IPS
【多选题】
Which two primary security concerns can you mitigate with a BYOD solution ？___
A. schedule for patching the device
B. securing access to a trusted corporate network
C. compliance with applicable policies
D. connections to public Wi-Fi networks
E. device tagging and invento
【多选题】
choose five___
A. MD5————————inserure
B. DES————————insercure
C. SDES———————legacy
D. SHA-1———————legacy
E. HMAC-MD5—————legacy
【多选题】
Which two characteristics of symmetric encryption are true？___
A. It uses digital certificates
B. It requires more resources than asymmetric ancryption
C. It uses the same key to enctypt and decrupt traffic
D. It uses a public key and a pricate key to encrypt and decrypt traffic.
E. It is faster than asymmetric encryption
【多选题】
which two characteristics of PVLAN are true？___
A. Promiscuous porta can communicate with PVLAN ports.
B. Isolated ports cannot communicate with other ports on the same VLAN
C. Community ports have to be a part of the trunk.
D. They require VTP to be enabled in server mode
E. PVLAN ports can be configured as Ether Channel ports
【多选题】
What are two options for running Cisco SDM?___
A. Running SDM from a mobile device
B. Running SDM from within CiscoWorks
C. Running SDM from a router's flash
D. Running SDM from the Cisco web porta
E. Running SDM from a PC
【多选题】
Which two options are the primary deployment modeles for mobile device management？___
A. multisite
B. cloud-based
C. on premises
D. hybrid cloud basedo
E. single site
【多选题】
Drag the recommendation on the left to the Cryptographic algorithms on the right， Options will be used more than once.___
A. Avoid——————————————DES，MD5
B. Legacy——————————————SDES，SHA1，HMAC-MD5
【多选题】
Which two are valid types of vLans using PVLANS ?___
A. Community VLAN
B. Backup VLAN
C. Secondary VLAN
D. Isolated VLAN
E. Isolated VLAN
【多选题】
Which two commands are used to implement Resilient lOS Configuration ___
A. Secure boot-config
B. copy running-config tftp
C. copy flash:ios bin tftp
D. copy running-config startup-config
E. secure boot-image
【多选题】
Which two types of firewalls work at layer 4 and above ？___
A. Stateful inspection
B. Network Address Translation
C. Circuit-Level gateway
D. Static packet filter
E. Application Level firewall
【多选题】
Which two default settings for port security are true ？___
A. Violation is Protect
B. Violation is Restrict
C. Violation is Shutdown
D. Maximum number of MAC addresses is 2
E. Maximum number of MAC addresses is 1
【多选题】
Which two are characteristics of RADIUS？___
A. Uses UDP ports 1812 /1813
B. Uses TCP port 49
C. Uses UDP port 49
D.
E. ncrypts only the password between user and server
【多选题】
When setting up a site-to-site VPN with PSK authentication on a Cisco router， which two elements must be configured under crypto map？___
A. pfs
B. nat
C. reverse route
D. peer
E. transform-set
【多选题】
When using the Adaptive Security Device Manager（ASDM), which two options are available to add a new root certificate？___
A. Install from SFTP server
B. Usehttps
C. Install from a file
D. Use LDAP
E. Use SCEP
【多选题】
Which two SNMPv3 services support its capabilities as a secure networ k manage protocol？ ___
A. access control
B. the shared secret key
C. authentication
D. authorization
E. accounting
【多选题】
Which two statements about routed firewall mode are true ？___
A. The firewall acts as a routed hop in the network
B. This mode conceals the presence of the firewall
C. The firewall requires a unique iP address for each interface
D. This mode allows the firewall to be added to an existing networ k with minimal additional configuration By default， this mode permits most traffic to pass throug
【多选题】
Which two statements describe DHCP spoofing attacks？___
A. They are used to perform man-in- the-middle attacks
B. They can access most network devices
C. They can modify the flow of traffic in transit. LNGKAIG
D. They protect the identity of ti attacker by masking the DHCP address
E. They can physically modify the network gateway
【多选题】
Which two types of VLANs using PVLANs are valid？___
A. isolated
B. promiscuous
C. backup
D. secondary
E. community
【多选题】
What are two limitations of the self-zone policies on a zone-based firewall？___
A. They are unable to block Https traffic
B. They restrict SNMP traffic.
C. They are unable to support Https traffic
D. They are unable to implement application inspection
E. They are unable to perform rate limiting
【多选题】
Which two descriptions of TACACS+ are true？ ___
A. The TACACS+ header is unencrypted
B. It combines a uthentication and authorization
C. It uses TCP as its transport protocol
D. Only the password is encrypted.
E. It uses UDP as its transport protocol.
【多选题】
Which two actions does an IPS perform？ ___
A. it spans the traffic
B. it reflects the traffic back to the sender
C. it encrypts the traffic
D. it terminates the user session or connection of the attacker
E. it reconfigures a device to block the traffic
【多选题】
In which form of fraud does an attacker try to learn information such as login credenti account information by ma squerading as a reputable entity or person in email， IM or communication channels ?___
A. phishing
B. Smurfit
C. Hacking
D. Identity Spoofing
【多选题】
Which two ESA services are available for incoming and outgoing mails ？___
A. anti-DoS
B. reputation filter
C. antispam
D. content filter
E. DLP
【多选题】
What are two reasons to recommend SNMPv 3 over SNMPv2？___
A. SNMPv3 is secure because you can configure authe ntication and privacy
B. SNMPv3 is insecure because it send in formation in clear text
C. SNMPv2 is insecure because it send information in clear text
D. SNMPv3 is a Cisco proprietary protocol
E. SNMPv2 is secure because you can configure authentication and privacy
【多选题】
Which two actions can a zone- based firewall apply to a packet as it transits a zone pair？___
A. drop
B. inspect
C. queue
D. quarantine
【单选题】
Which security principle has been violated if data is altered in an unauthorized manner？___
A. accountability
B. confidentiality
C. availability
D. integrity
【单选题】
Which IKE Phase 1 parameter can you use to require the site-to-site VPN to use a pre-shared ？___
A. encryption
B. authentication
C. group
【单选题】
Which command successfully creates an administrative user with a password of "cisco"on a Cisco router?___
A. username Operator privilege 7 password cisco
B. username Operator privilege 1 password cisco
C. username Operator privilege 15 password cisco
D. username Operator password cisco privilege 15
【单选题】
Which EAP method authenticates a client against Active Directory without the use of client-side 802.1X certificates？___
A. EAP-TLS
B. EAP-MSCHAPv2
C. EAP-PEAP
D.
E. AP-GTC
【单选题】
What is a limitation of network-based IPS？___
A. It must be in dividually configured to support every operating system on the network.
B. It is most effective at the in dividual host level
C. It is unable to monitor attacks across the entire netw ork
D. Large installations require numerous sensors to fully protect the network
【单选题】
When would you configure the ip dhcp snooping trust command on a sw itch？___
A. when the switch is connected to a DHCP server
B. when the switch is working in an edge capacit
C. when the switch is connected to a client system
D. when the switch is serving as an aggregator
【单选题】
How does the 802. 1x supplicant communicate with the authentication server？___
A. The supplicant creates EAP packets and sends them to the authenticator, which encapsulates them into RADIUS and forwards them to the authentication server.
B. The supplicant creates RADIUS packets and sends them to the authe nticator, which encapsulates the m into EAP and forwards them to the a uthentication server.
C. The supplicant creates RADIUS packets and sends them to the authenticator, which translates them into eap and forwards them to the a ut hentication server
D. The supplicant creates
E. AP packets and sends them to the authe nticator, which translates them into radius and forwards them to the authentication server.
【单选题】
Which command do you enter to verify the phase I status of a VPN connection？___
A. sh crypto se ssion
B. debug crypto isakmp
C. sh crypto isakmp sa
D. sh crypto ipsec sa
【单选题】
Refer to the exhibit. what is the e ffect of the given configuration？___
A. It enables authentication，
B. It prevents keychain authentication.
C. The two routers receive normal updates from one another.
D. The two device s are able to pass the message digest to one another.
【单选题】
Which command can you enter to configure OSPF to use hashing to authenticate routing updates？___
A. ip ospf aut hentication message-digest
B. neighbor 192 168.0 112 cost md5
C. ip ospf priority 1
D. ip ospf aut hentication-key
【单选题】
Which command can you enter to verify the status of Cisco lOS Resilient Configuration on a Cisco router?___
A. show secure bootset
B. secure boot-image
C. show binary file
D. ure boot-config
【单选题】
A user on your network inadvertently activates a botnet program that was received as an emai attachment. Which type of mechanism does Cisco Firepower use to detect and block only the botnet attack？___
A. network-based access control rule
B. reputation-based
C. user-ba sed access control rule
D. botnet traffic filter
【单选题】
What does the policy map do in CoPP？___
A. defines service parameters
B. defines packet selection parameters
C. defines the packet filter
D. define s the action to be performed
