刷题
导入试题
【单选题】
下列不属于Oracle所支持的触发器为___?
A. 语句级触发器
B. 替换触发器
C. RS触发器
D. 系统触发器
查看试卷,进入试卷练习
微信扫一扫,开始刷题
答案
C
解析
暂无解析
相关试题
【单选题】
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
【单选题】
下列哪个不是合法字符?___
A. a.9
B. 9
C. ?
D. *
【单选题】
假设用户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的逻辑结构的是___。
A. 区
B. 段
C. 数据文件
D. 表空间
【单选题】
在Oracle中,当控制一个显式游标时,下面哪种命令包含INTO子句___。
A. OPEN
B. CLOSE
C. FETCH
D. CUPSOR
【单选题】
下列哪个数据对象不属于段?___
A. 数据表
B. 视图
C. 索引
D. 回滚
【单选题】
下列哪个后台进程不是必须启动的?___
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. 位图索引
【单选题】
数据字典名称前缀有:___
A. USER.DBA.ALL
B. USER.SYS.ALL
C. USER.DBA.SYS
D. USER.SYS.SCOTT
【单选题】
显示表student的结构可以用___
A. LIST TABLE student
B. LIST student
C. DESC TABLE student
D. DESC student
【单选题】
"Sql>"为哪个运行环境下的结构组成部分___
A. sql sever
B. Sql developer
C. Sql plus
D. 以上都不是
【单选题】
___是为了加速对特定表数据的访问而创造的数据段。
A. 视图
B. 索引
C. 存储过程
D. 触发器
【单选题】
当需要描述一个表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)
【单选题】
利用游标来修改数据时,所用的..FOR UPDATE充分利用了事务的哪个特性?___
A. 原子性
B. 一致性
C. 永久性
D. 隔离性
【单选题】
当Oracle服务器启动时,下列哪种文件不是必须的___。
A. 数据文件
B. 控制文件
C. 日志文件
D. 归档日志文件
【单选题】
在Oracle中,当用户要执行SELECT语句时,下列___进程从磁盘获得用户需要的数据。
A. 用户进程
B. 服务器进程
C. 日志写入进程(LGWR)
D. 检查点进程(CKPT)
【单选题】
在Oracle中,一个用户拥有的所有数据库对象统称为___。
A. 数据库
B. 模式
C. 表空间
D. 实例
【单选题】
在Oracle数据库的逻辑结构中有以下组件:A表空间,B数据块,C区,D段。这些组件从大到小依次是___。
A. A→B→C→D
B. A→D→C→B
C. A→C→B→D
D. D→A→C→B
【单选题】
在Windows操作系统中,Oracle的___服务监听并接受来自客户端应用程序的连接请求。
A. OracleHOME_NAMETNSListener
B. OracleServiceSID
C. OracleHOME_NAMEAgent
D. OracleHOME_NAMEHTTPServer
【单选题】
在Oracle数据库中,___用户模式存储数据字典表和视图对象。
A. SYSTEM
B. SYS
C. SCOTT
D. YSDBA
【单选题】
在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
【单选题】
在Oracle中,游标都具有下列属性,除了___。
A. %NOTFOUND
B. %FOUND
C. %ROWTYPE
D. %ISOPEN
推荐试题
【单选题】
Q1: What are the man and woman talking about?___
A. Whether nature is magical and kind .
B. Whether nature is powerful and full of risks .
C. Whether Christopher was well prepared for the trip .
D. Whether Christopher's trip to Alaska was  worthwhile .
【单选题】
Q2: What can we learn about Christopher?___
A. He made a film about his trip to Alaska .
B. He wrote a story about his trip to Alaska .
C. He died while having an adventure in Alaska .
D. He learned how powerful and risky Alaska was .
【单选题】
Q3: What does the woman think about Christopher taking the trip to Alaska?___
A. He was too foolish .
B. He was really romantic .
C. He had a very kind heart .
D. He had a spirit for trying things .
【单选题】
Q4: Which of the following is NOT mentioned as something that would have saved Christopher’s life?___
A. A gun to hunt .
B. The map of the area .
C. Emergency food supplies .
D.
E. mergency communication equipment .
【单选题】
Q1: What speed can an avalanche reach within five seconds of taking off?___
A. At 8 miles an hour .
B. At 18 miles an hour .
C. At 80 miles an hour .
D. At 88 miles an hour .
【单选题】
Q2: According to the passage, under what circumstances may an avalanche occur?___
A. There are too many layers of snow on the  .
B. There is a layer of snow covering an entire  area .
C. The top layer of snow slides off the layer  below it .
D. The layer of snow below the surface  becomes unstable .
【单选题】
Q3: What are skiers advised to do to avoid being caught in an avalanche?___
A. Ski only in the official ski areas .
B. Look for solid snow to walk on .
C. Look out for each other while skiing .
D. Learn to control themselves in an  avalanche .
【单选题】
Q4: Why does the ski patrol use explosives?___
A. To dig holes in the snow .
B. To close the area for skiing .
C. To make an avalanche move on purpose .
D. To' check how different layers are holding  up .
【单选题】
Q1:What is conversation mainly about?___
A. The woman's happy college life the  man's doubt .
B. The woman's spending habits and the  man's concerns .
C. The man's reminding the woman of the  exam this Thursday .
D. The man's support for the woman over the  past 15 years .
【单选题】
Q2:What did the woman do last night?___
A. She bought a new leather coat .
B. She studied very hard for an exam .
C. She treated all her friends to dinner .
D. She went to a concert with her friends .
【单选题】
Q3:Where did the woman get the money?___
A. She just received her student loan .
B. She saved some money for herself .
C. She borrowed the money from her friends .
D. She asked her mom to send her the money .
【单选题】
Q4:What is the man?___
A. A teacher of biology .
B. An undergraduate student .
C. A freshman in biology class .
D. A graduate teaching assistant .
【单选题】
Q1: What is this passage mainly about?___
A. How businesses can compete with each  other .
B. How small businesses operate during  holidays .
C. How small businesses manage holiday  workers .
D. How can earn more money  during holidays .
【单选题】
Q2: According to Rubin, what can small companies do to thank holiday workers?___
A. Have talks with their families .
B. Give them good extra benefits .
C. Offer them expensive holiday tokens .
D. Show appreciation to them face to face .
【单选题】
Q3: What can small business owners do to help holiday workers get into the holiday spirit?___
A. Entertain them with big meals .
B. Let them enjoy some holiday games .
C. Give them handmade thank-you cards .
D. Send their families some holiday gift cards .
【单选题】
Q4: Who are supposed to benefit most from this passage?___
A. Workers who have to work during  holidays .
B. Employees who intend to earn extra  money .
C. Big companies that usually close on  holidays .
D. Small businesses that try to be more  competitive .
【单选题】
In the first two paragraphs of the passage the writer tries to tell us that___
A. he had lived in Washington D.C. for twenty years
B. he was very imaginative when he was a child
C. he had fond memories of his old neighborhood
D. )he had come from a very poor neighborhood
【单选题】
The writer ,as a child ,was very fond of playing in the basement because ___
A. it was bright and alive
B. it contained a movie house and a space station
C. it was ideal for playing hide-and-seek
D. it was surrounded by trees and flowers
【单选题】
How did the writer feel when he visited his old neighborhood in Washington D.C. ?___
A. Greatly surprised .
B. Very regretful .
C. Quite excited .
D. Very sad .
【单选题】
On his visit to his hometown ,the writer found the old apartment building___
A. see medunfit to live in
B. had been repaired
C. could hardly be recognized
D. looked dirty and smelt horrible
【单选题】
" Youcan never go home again "inthe last sentence of this passage means that___
A. one should never revisit his hometown after many years of absence
B. one will never find his hometown the same as it was in his childhood memory
C. avisit to one's hometown will bring back one's fond memories of home
D. avisit to one's hometown will bring back many sad memorie
【单选题】
We learn from the passage that Tracy died___
A. on December 8,1992
B. of brain damage
C. 24 hours after he fell off the roof of a car
D. in a car crash
【单选题】
Tracy's parents decided to donate Tracy's organs because___
A. Tracy told them to do so just before he died
B. they wanted to save others the pain of seeing a dear one die
C. David's life could continue in a meaningful way
D. they knew David was suffering from a hopeless liver disease
【单选题】
The meeting between the writer's family and Tracy's parents was arranged because___
A. the writer and her husband wished to express their thanks to Tracy's parents 
B. the local organ bank wanted to see how both families felt about the donation 
C. Tracy's parents wanted to see someone whose life had been saved by the donation
D. the two families were linked by the most bittersweet ties imaginable
【单选题】
The writer and her husband learned how Tracy died___
A. from his parents
B. from the organ bank
C. from the hospital
D. from the doctor who performed the operation
【单选题】
The meeting between the two families helped to ease the Marshes'suffering because___
A. they saw that David looked very much like their son
B. they saw that David had regained health with Tracy's liver
C. they now had someone to share their memories of Tracy
D. they now knew for sure they had done the right thing
【单选题】
The writer's first marriage was unsuccessful because___
A. her husband often woke her up at midnight
B. her husband kept criticizing her
C. she was so unattractive
D. she had a self-esteem problem
【单选题】
When the writer asked for a divorce ,her husband___
A. told her that she would never find one who loved her as he did
B. delayed two years before giving her a reply
C. accused her of having an affair
D. said that she was unattractive and not worth loving
【单选题】
When the writer first met Clint ,she felt that___
A. she should have listened to her friend and met Clint earlier
B. Clint was a nice ,dazzling young man
C. Clint could not be really interested in her
D. she would find true love in Clint
【单选题】
The writer was particularly touched by Clint because___
A. he loved her children and asked for their approval of the marriage
B. he said that he could not imagine a life without her and the children 
C. he believed that at 2 and 4 ,the two children were the "menof the house "
D. hekept her company and talked with her until the next morning
【单选题】
The writer's marriage to Clint is important to her mainly because___
A. it gave her and her sons a second chance to live a happy life 
B. every day Clint would tell the writer that he loved her
C. it helped her to regain her self respect
D. it made her children happy ,which is all she cared about in life
【单选题】
What was Goodall's childhood dream ?___
A. She dreamed of going to college .
B. She dreamed of studying animals in Africa .
C. She dreamed of becoming a scientist .
D. She dreamed of traveling all around the world .
【单选题】
What did Goodall's mother think of her dream ?___
A. As a girl she should not go to the African jungle .
B. Her dream would remain a dream unless she got the right training .
C. As a girl she should stay away from violent animals .
D. She could make her dream come true if she was determined .
【单选题】
Goodall's most important discovery was that___
A. some animals use tools
B. like humans animals have emotions
C. chimpanzees could attack each other violently
D. termites are chimpanzees'favorite food
【单选题】
Goodall's success is chiefly due to her___
A. exceptional talents
B. scientific training
C. determination and patience
D. enthusiasm and good luck
【单选题】
What is Goodall doing now ?___
A. Studying animal behavior at Cambridge University .
B. Raising funds for the preservation of wildlife .
C. Observing chimpanzees in African jungles .
D. Working hard supervising postgraduate students.
【单选题】
___是我们理解当前所处历史方位的关键词。
A. 新时期
B. 新时代
C. 重要战略机遇期
D. 关键期
【单选题】
中国特色社会主义进入新时代,意味着科学社会主义在21世纪的中国焕发出强大生机活力,在世界上高高举起了___伟大旗帜。
A. 小康社会
B. 社会主义现代化强国
C. 和谐社会
D. 中国特色社会主义
【单选题】
“思想道德修养与法律基础”,是一门融思想性、政治性、科学性、理论性、实践性于一体的___课。
A. 专业基础
B. 通识教育
C. 思想政治理论
D. 专业选修
【单选题】
党的十九大提出到本世纪中叶,要把我国建设成富强、民主、文明、和谐、___的社会主义现代化强国。
A. 复兴
B. 和谐
C. 幸福
D. 美丽
欢迎使用我爱刷题
×
微信搜索我爱刷题小程序
温馨提示
×
请在电脑上登陆“www.woaishuati.com”使用