1Z0-052章節(jié)練習(2019.05.09)

The user HR receives the following error while inserting data into the TTK table： ERROR at line 1： 
ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon 
investigation， you find that SMD is a small file tablespace. 
Which three action would allow the user to insert data（）

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client 
while connecting to the database instance from a remote machine（）

You want to create a role to meet these requirements：
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
method would you use to restrict enabling of such roles（）

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 SKDWITH ADMIN OPTION； 
Which statement is true about the user SKD after he/she is granted this role（）

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * 
ERROR at line 1： 
ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. 
Which method would you use to load data into the Oracle database（）

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； 
Which statement is true about this command（）

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（）