【单选题】
在Oracle中，以下不属于集合操作符的是___。
A. UNION
B. SUM
C. MINUS
D. INTERSECT
查看试卷，进入试卷练习
微信扫一扫，开始刷题
相关试题
【单选题】
假设用户USER1的默认表空间为USERS，他在该表空间的配额为10MB，则USER1在USERS 表空间创建基本表时，他应具有什么权限？___
A. CREATE TABLE
B. CREATE USER
C. UNLIMITED TABLESPACE
D. TABLE
【单选题】
下列解锁scott账户的命令正确的是___。
A. update user scott account unlock
B. alter user scott account unlock
C. alter user scott unlock
D. alter user scott indentified by 123
【单选题】
下列哪一项不属于Oracle数据库的物理存储结构？___。
A. 数据文件
B. 控制文件
C. 系统文件
D. 日志文件
【单选题】
下列用于储存字符串数据的数据类型是___。
A. vchar2
B. int
C. number
D. date
【单选题】
以下___内存区不属于 SGA。
A. PGA
B. 日志缓冲区
C. 数据缓冲区
D. 共享池
【单选题】
___模式存储数据库中数据字典的表和视图。
A. DBA
B. SCOTT
C. SYSTEM
D. SYS
【单选题】
在Oracle中，一个用户拥有的所有数据库对象统称为___
A. 数据库
B. 模式
C. 表空间
D. 实例
【单选题】
以下哪个命令是SQL PLUS命令___。
A. UPDATE
B. EDIT
C. SELECT
D. ALTER TABLE
【单选题】
你要操纵Oracle数据，下列哪个不是SQL命令？___。
A. select * from dual
B. set define
C. update emp set ename=6543 where ename='SMITHERS'
D. create table employees(empid varchar2(10) primary key)
【单选题】
有一产品表(编号，名称，价格，数量，所属分类)，下列语法不正确的是___ 。
A. select * from 产品表 where 价格>1000
B. select * from 产品表 where 编号，名称
C. select 所属分类,价格*数量 from 产品表 where 价格>1000
D. select 所属分类, 价格*数量，名称 from 产品表
【单选题】
使用以下哪种数据类型，可使数据131.14159保存为131.14___。
A. Number(6,2)
B. Number(3,2)
C. Number(2.3)
D. Number(2,5)
【单选题】
下列哪种说法有错___？
A. 数据块是逻辑存储结构中的最小逻辑单位
B. 表空间是数据库的最大逻辑划分单位
C. 数据块是Oracle存储分配的最小单位
D. 一个数据库文件智能对应一个表空间
【单选题】
下列对数据库的操作语句错误的是___。
A. create tablespace users dafafile'E:\users01' size 100M
B. create database emp
C. alter database emp
D. drop database emp
【单选题】
下列哪一控制语句有错___？
A. for…in..loop…End
B. if…then…else
C. if…then…elseif
D. if…then
【单选题】
下列不属于Oracle所支持的触发器为___？
A. 语句级触发器
B. 替换触发器
C. RS触发器
D. 系统触发器
【单选题】
DML触发器可分为三种类型，以下哪个不是DML触发器的类型___？
A. INSERT
B. UPDATE
C. DROP
D. DELETE
【单选题】
以下选项中，预定义异常与产生原因对应错误的是___？
A. ACCESS_INTO_NULL--未初始化对象
B. CASE_NOT_FOUND--游标已经被OPEN
C. TOO_MANY_ROWS--执行select into时结果超过一行
D. ZERO_DIVIDE--除数为0
【单选题】
在Oracle中，下面用于限制分组函数的返回值的子句是___。
A. WHERE
B. HAVING
C. ORDER BY
D. 无法限定分组函数的返回值
【单选题】
在Oracle中，以下不属于集合操作符的是___。
A. UNION
B. SUM
C. MINUS
D. INTERSECT
【单选题】
假设用户USER1的默认表空间为USERS，他在该表空间的配额为10MB，则USER1在USERS 表空间创建基本表时，他应具有什么权限？___
A. CREATE TABLE
B. CREATE USER
C. UNLIMITED TABLESPACE
D. TABLE
【单选题】
在Oracle中，当控制一个显式游标时，下面哪种命令包含INTO子句___。
A. OPEN
B. CLOSE
C. FETCH
D. DECLARE
【单选题】
以下___什么内存区不属于SGA。
A. PGA
B. 日志缓冲区
C. 数据缓冲区
D. 共享池
【单选题】
下列表空间中，___表空间是运行一个数据库必须的一个表空间。
A. ROLLBACK
B. TEMP
C. TOOLS
D. SYSTEM
【单选题】
手工创建一个新的数据库时，首先需要___。
A. 启动一个实例
B. 启动SQL*PLUS，以SYSDBA身份连接Oracle
C. 关闭当前实例
D. 创建一个参数文件
【单选题】
关于控制文件，下列说法正确的是___。
A. 建议至少有两个位于不同磁盘上的控制文件
B. 建议至少有两个位于同一磁盘上的控制文件
C. 建议保存一个控制文件
D. 一个控制文件，数据库不能运行
【单选题】
oracle的表空间包括___。
A. SYSTEM表空间
B. SYSAUX表空间
C. UNDO表空间
D. 以上都是
【单选题】
默认的临时表空间是TEMP，那么默认的永久表空间是___。
A. SYSTEM
B. PMET
C. SYST
D. MET
【单选题】
下列不属于ORACLE的逻辑结构的是___。
【单选题】
在Oracle中，当控制一个显式游标时，下面哪种命令包含INTO子句___。
A. OPEN
B. CLOSE
C. FETCH
D. CUPSOR
【单选题】
下列哪个后台进程不是必须启动的？___
A. SMON
B. RECO
C. CKPT
D. LGWR
【单选题】
Oracle数据库被划分为___的逻辑存储单元，该逻辑存储单元本身由操作系统磁盘文件和原始分区组成。
A. 表空间
B. 联机重做日志文件
C. 归档重做日志文件
D. 回滚段
【单选题】
Oracle的逻辑存储结构中由大到小的顺序是___。
A. 表空间.区.段.块
B. 表空间.段.区.块
C. 表空间.块.段.区
D. 段.区.表空间.块
【单选题】
表空间和数据文件在物理存储上的关系是___。
A. 一对多
B. 多对一
C. 一对一
D. 多对多
【单选题】
用SQL*PLUS的___命令可以查看表的结构信息，包括列的名称和数据类型。
A. DESCRIPTION
B. DESC
C. SHOW TABLE
D. SHOW USER
【单选题】
Oracle中，INSERT语句是___。
A. DML
B. DDL
C. DCL
D. DTL
【单选题】
在SQL*Plus中以下哪项命令是查看缓冲区代码？___
A. SQL>ed
B. SQL>L
C. SQL>C
D. SQL>k
【单选题】
若表的某字段值存在大量的重复，则基于该字段适合创建哪种索引？___
A. 标准索引
B. 唯一索引
C. 分区索引
D. 位图索引
推荐试题
【单选题】
Which command should beused to ena ble AAA Authentication to determine if a user can access the privilege command level？___
A. aaa authentication enable local
B. aaa authentication enable level=
C. aaa authentication enable method de fault
D. aaa authentication enable defa ult local
【单选题】
On an ASA， the policy indicates that traffic should not be translated is often referred to as which of the following？___
A. NAT zero
B. NAT forward
C. NAT nul
D. NAT allow
【单选题】
Which protocol offers data Integrity encryption， authentication， and anti-replay functions for IPSec VPN？___
A. ESP protocol
B. IKEv3 Protocol
C. AH protoco
D. IKEv1 Protocol
【单选题】
Which component offers a variety of security Solution， including firwall， IF Antivirus and antiphishing features？___
A. Cisco loS router
B. Cisco ASA 5500 Ser ies security appliance
C. Cisco ASA 5500 X series Next Gen Security appliance
D. Cisco 4200 series IPS appliance
【单选题】
Refer to the exhibit， A Network Secur ity administrator check the ASa firewall NAT policy table rith show nat command， which statement is fails？___
A. There are only reverse translation matches for the REAL SERvER object
B. First policy in the Section 1 is a dynamic nat entry defined in the object configuration
C. NAT policy in section 2 is static entry de fined in the object configuration
D. Translation in Section 3 used when a connection does not matches any entries in first two sections
【单选题】
What is true of an aSa in transparent mode ?___
A. It supports OSPF
B. It requires an IP address for each interface
C. It requires a management IP address
D. It allows the use of dynamic NaT
【单选题】
What is the effect of the ip scp server enable command？___
A. It references an access list that allows specific SCP servers
B. It allows the router to initiate requests to an SCP server
C. It allows the router to become an SCP server
D. It adds SCP to the list of allowed copy functions
【单选题】
How can you mitigate attacks in which the attacker attaches more than one vLan tag to a packet？___
A. Assign an access VLAN to every active port on the switch
B. Disable Ether Channel on the switch
C. Explicitly identity each VLAN allowed across the trunk
D.
E. nable transparent VTP on the switch
【单选题】
Which technology can you implement to centrally mitigate potential threats when users on your network download files that might be malicious？___
A. Enable file-reputation services to inspect all files that traverse the company network and block files with low reputation scores
B. Verify that the compa ny IpS blocks all known malicious website
C. Verity that antivirus software is installed and up to date for all users on your network
D. Implement URL filtering on the perimeter firewall
【单选题】
What is the most common implementation of PaT in a standard networked environment？___
A. configuring multiple external hosts to join the self zo ne and to communicate with one another
B. configuring multiple internal hosts to communicate outside of the network using the outside interface IP address
C. configuring multiple internal hosts to communicate outside of the network by using the inside interface IP address
D. configuring an any any rule to enable external hosts to communicate inside the network
【单选题】
Which component of a bYod architecture provides aAa services for endpoint access ?___
A. Integrated Services Router
B. access point
C. ASA
D. Identity Services
E. ngine
【单选题】
You are configuring a NAT rule on a Cisco ASA ,Which description of a mapped interface is true?___
A. It is mandatory for all firewall modes
B. It is optional in routed mode
C. It is optional in transparent mode
D. It is mandatory for ide ntity NAT only
【单选题】
Which description of the use of a private key is true ？___
A. The sender signs a message using the receivers private key
B. The sender signs a message using their private key
C. The sender encrypts a message using the receivers private key
D. The receiver decrypts a n15ssage using the sender's private key
【单选题】
Which mechanism does the FireAMP Connector use to avoid conflicts with other security applications such as antivirus products ?___
A. Virtualization
B. Containers
C. Sandboxing
D.
E. xclusions
【单选题】
Which network to pology de scribes multiple LANS in a gec? ___
A. SOHO
B. MAN
C. pan
D. CAN
【单选题】
Which statement represents a difference between an access list on an aSa versus an access list on a router？___
A. The asa does not support number access lists
B. The aSa does not support standard access list
C. The asa does not ever use a wildcard mask
D. The asa does not support extended access lists
【单选题】
Which command do you enter to verify the status and settings of an iKE Phase 1 tunnel？___
A. show crypto ipsec as output
B. show crypto isakmp
C. show crypto isakmp policy
D. show crypto ipsec transform
【单选题】
Which feature can help a router or switch maintain packet forwarding and protocol states despite an attack or heavy traffic load on the router or switch？___
A. service Policy
B. Control Plane Policing
C. Policy Map
D. Cisco
E. xpress
F. orwarding
【单选题】
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.
