[单项选择]The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）
A. no privileges
B. only the SELECT privilege
C. only the CONNECT privilege
D. all the privileges of a default user

[单项选择] The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）
A. No privileges.
B. Only the SELECT privilege.
C. Only the CONNECT privilege.
D. All the privileges of a default user.

[单项选择] Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）
A. SELECT*FROMDEPT；
B. SELECT*FROMSCOTT.DEPT；
C. SELECT*FROMDBASCOTTDEPT；
D. SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；

[单项选择]User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）
A. UPDATE pets…
B. SELECT….FROM pets
C. INSERT INTO pets…
D. ALTER TABLE pets…

[名词解释]DBA

[单项选择]An administrator issues the command ping 127.0.0.1 from the command line prompt on a PC. If a reply is received, what does this confirm（）。
A. The PC has connectivity with a local host.
B. The PC has connectivity with a Layer 3 device.
C. The PC has a default gateway correctly configured.
D. The PC has connectivity up to Layer 5 of the OSI model.
E. The PC has the TCP/IP protocol stack correctly installed.

[单项选择]SQL SERVER的默认DBA账号是什么？（）
A. administrator
B. sa
C. root
D. SYSTEM

[单项选择]A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）
A. Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
B. Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
C. Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
D. Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

[单项选择]作为一个ORACLE DBA，你运行以下的SQL命令查询ASM实例，查询结果的含义是什么？（）SQL>select group_number，name，state fromv$ASM_DISKGROUP；GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED
A. DGROUP1磁盘组被其他的DBA卸载了
B. 一个多余的磁盘（DGROUP1）将在磁盘组中丢失
C. 一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态
D. 这个查询在ASM实例中没有意义

[多项选择]User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

[单项选择] Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)

[单项选择] Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupied by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.