Oracle-复习题1.docVIP

考试题中可能用到的数据表结构 EMPLOYEES DEPARTMENTS 一、判断题 1．下述的SELECT语句能否成功执行 (True/False) SELECT last_name, job_id, salary AS “Salary”FROM employees; 2．下述的SELECT语句能否成功执行 (True/False) SELECT * FROM employees; 3．组函数在计算的时候不可以包含空值 (True/False) 4．创建的视图可以是只读的 (True/False) 5．下列语句是否正确 (True/False) ALTER TABLE employees ADD FOREIGN KEY (department_id) REFERENCES departments(department_id); 二、选择题 1．下列哪个PL/SQL块可以成功执行 A. BEGIN END; B. DECLARE amount INTEGER(10); END; C. DECLARE BEGIN END; D. DECLARE amount INTEGER(10); BEGIN DBMS_OUTPUT.PUT_LINE(amount); END; 2．指出下列合法的标识符名称（Choose Five） A. today B. last_name C. today’s_date D. Number_of_days_in_February_this_year E. Isleap$year F. #number G. NUMBER# H. number1to7 3．指出下列合法的变量声明和初始化（Choose TWO） A. number_of_copies PLS_INTEGER; B. printer_name constant VARCHAR2(10); C. deliver_to VARCHAR2(10).=Johnson; D. by_when DATE.= SYSDATE+1; 4．由下列语句创建的ORDERS表. CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN (‘CREDIT’,’CASH’)), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); 在执行上述SQL语句后，哪些列上的索引可以自动创建（Choose TWO） A. SER_NO B. ORDER_ID C. STATUS D. PROD_ID E. ORD_TOTAL F. Composite index on ORDER_ID and ORDER_DATE 5．下列哪些约束可以隐式创建索引。（Choose TWO） A. NOT NULL B. PRIMARY KEY C. FOREIGN KEY D. CHECK E. UNIQUE 6．TRUNCATE的作用? A. Removes the table B. Removes all rows from a table C. Shortens the table to 10 rows D. Removes all columns from a table E. Removes foreign keys from a table 7．下列哪一个语句创建一个新用户 A. CREATE USER susan; B. CREATE OR REPLACE USER susan; C. CREATE NEW USER susan DEFAULT; D. CREATE USER susan IDENTIFIED BY blue; E. CREATE NEW USER susan IDENTIFIED by blue; F. CREATE OR REPLACE USER susan IDENTIFIED BY blue; 8．关于序列（sequences）下列说法正确的是 A. Once created, a sequence belongs to a specific schema. B. Once created, a sequence is linked to a speci