1Z0-052章节练习(2019.01.19)

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

You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order： 
1：Shut down the instance. 
2：Execute the ALTER DATABASE ARCHIVELOG command. 
3：Start up the instance and mount the database. 
4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database. 
Which is the correct sequence of steps for accomplishing the task（）

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. 
Which data type would you use for the new column（）

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. 
Whichschema object enables the user to access the information from the remote database（）

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

You are managing an Oracle Database 11g database. The database is open， and you plan to perform
Recovery Manager （RMAN） backups. 
Which three statements are true about these backups（）

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

Examine the following steps performed on a database instance：
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2. The SKD user creates a table.
3. The SKD user grants the CREATE TABLE system privilege to the HR user.
4. The HR user creates a table.
5. The DBA revokes the CREATE TABLE system privilege from SKD. 
Which statement is true after step 5 isperformed（）

The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： 
ERROR at line 1： 
ORA-00060： deadlock detected while waiting for resource 
On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. 
two statements are true regarding the session of SCOTT in this scenario（）