1Z0-052章節(jié)練習(xí)(2019.04.16)

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

our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；
What would be the outcome of this command（）

You executed the following command to perform a backup of the USERS tablespace： 
SQL> ALTER TABLESPACE users BEGIN BACKUP；
ALTER TABLESPACE users BEGIN BACKUP * 
ERROR at line 1： 
ORA-01123： cannot start online backup； media recovery not enabled 
What could be the reason for this error（）

To make audit information more productive， the DBA executes the following command before startingan audit operation： 
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； 
Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

You are using Enterprise Manager to schedule backups for your database. 
Which type of script wouldbe generated by the backup scheduler（）

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