052(二）

6、

6.You executed the following command to create a password file in the database server: 
$ orapwd file = orapworcl entries = 5 ignorecase=N 
Which statement describes the purpose of the above password file? 
A. It records usernames and passwords of users when granted the DBA role 
B. It contains usernames and passwords of users for whom auditing is enabled 
C. It is used by Oracle to authenticate users for remote database administrator 
D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups 
Answer: C

Beginning with Oracle Database 11gRelease 1, passwords in the password file are case-sensitive unless you include the IGNORECASE = Y command-line argument.

密码文件是用来存放sysdba权限用户的密码的，其他用户存在数据库中。

7、

7.Which two statements are true regarding the MRKT tablespace? (Choose two.)
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 3 EXTENT MANAGEMENT
LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
A. No more data files can be added to the tablespace. 
B. Segment space is managed by free lists in the tablespace. 
C. A user created without being assigned a default tablespace uses this tablespace. 
D. The tablespace can be dropped with the current setting with segments present in it. 
Answer: AC 

一个大文件表空间中只包含一个文件

8、View the Exhibit and examine the privileges granted to the MGR_ROLE role. 

The user SKD has been granted the CONNECT and RESOURCE roles only. 
The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command: 
SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION; 
Which statement is true about the user SKD after he/she is granted this role? 
A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it 
B. The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor 
C. The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN 
OPTION 
D. The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke 
privileges from them 
Answer: A

 with admin option选项，可以把分配给它的角色分配给别的用户

9、

9.After performing a clean shut down of the database instance for maintenance, you mount the database 
and then execute a command to open the database: 
SQL> ALTER DATABASE OPEN; 
Which two statements are true? (Choose two.) 
A. The online redo log files and online data files are opened 
B. All the online data files headers are checked for consistency 
C. Instance recovery is performed before opening the database 
D. The path and existence of all the log file members are checked 
Answer: AB 

参考052(一）第3题

10、

10.Examine the command that is used to create a table:
SQL> CREATE TABLE orders (
oid NUMBER(6) PRIMARY KEY,
odate DATE,
ccode NUMBER (6),
oamt NUMBER(10,2)
) TABLESPACE users;
Which two statements are true about the effect of the above command? (Choose two.)
A. A CHECK constraint is created on the OID column. 
B. A NOT NULL constraint is created on the OID column. 
C. The ORDERS table is the only object created in the USERS tablespace. 
D. The ORDERS table and a unique index are created in the USERS tablespace. 
E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID 
column in the SYSTEM tablespace. 
Answer: BD 

CHECK constraint约束检查：
例如：ALTER TABLE temp ADD CONSTRAINT ck_temp_id CHECK ((id>0) AND (id <= 125)); 
主键不能为null
索引表空间不指定单独的表空间，就会和数据存储到一起