单选题
View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table： SQL> CREATE TABLE orders（oid number（6）， odate date， ccode number（4）， oamt number（10，2）） TABLESPACE purchase_space； The PURCHASE_SPACE tablespace already exists in the database. Which statement describes theeffect of the command（）
The command executes successfully and creates the table in the USERS tablespace.
The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
The command produces an error because the user does not have the privilege to create the table.
The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
多选题
Which statements are true regarding a tablespace（）
It can span multiple databases.
It can consist of multiple data files.
It can contain blocks of different sizes.
It can contain segments of different sizes.
It can contain a part of a nonpartitioned segment
多选题
Which three descriptions are correct about the effects of the TRUNCATE command on a table（）
The corresponding indexes for the table are also truncated.
Delete triggers on the table are fired during the execution of the TRUNCATE command.
The child table is truncated when the TRUNCATE command is applied on the parent table.
The high-water mark （HWM） is set to point to the first usable data block in the table segment.
No undo or very little undo data is generated during the execution of the TRUNCATE command
单选题
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）
Use the database link.
Use the SQL*Loader utility.
Use the Oracle Data Pump utility.
Create an external table and leave the data in the flat file
单选题
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）
the XML script
the PL/SQL script
the DBMS_SCHEDULER package
Enterprise Manager to schedule the backup
单选题
You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis. How would you achieve this（）
by using triggers
by using Data Pump
by using external tables
by using anonymous PL/SQL blocks
多选题
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）
Data files
Control files
Parameter file
Online redo log files
Server parameter file
单选题
View the Exhibit to observe the roles assigned to the SLP_REP user.
Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）
The user must enable the role explicitly.
The user can grant the role to other users.
The user cannot use the role until the DBA enables it explicitly.
The user can start using the role immediately without any changes.
多选题
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects of this command（）
It fails if any existing row violates the constraint.
It does not validate the existing data in the table.
It enables the constraint to be enforced at the end of each transaction.
It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）