ITPub博客

34、Which is true about invalid PL/SQL objects?A) They are automatically recompiled against the new definition of a referenced object at the same time as the referenced object is modified.B) They can

33、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.Your plan is to install both Oracle database and Grid Infrastructure.Which two are true

32、Which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database can contain only a single temporary tablespace.C) A database instance stores undo d

31、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is re

30、Which four are true about the tools used to administer Oracle databases?A) SQL*Plus can be used to create databases.B) RMAN can be used to start up Oracle Instances.C) DBCA can be used to upgrade

29、Which two are true about undo tablespaces?A) They always retain undo for the time period defined by UNDO_RETENTION.B) They must have only one data file.C) They can be recovered only when an Instanc

28、USER1. EMP has a referential Integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.  user1 executes these commands:  SQL> UPDATE dept SET 1oc=’UK’ where dno=1; 

27、Which two are true about data dictionary views?A) ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views.B) DBA prefixed views are accessible wh

26、Your database Is open in ARCHIVELOG mode.• LOG_ARCHIVE_DEST Is set to Fast Recovery Area (FRA) and it Is 100% full when a log switch takes place.• No alternative or optional archive destinations

25、Examine this LISTENER. ORA file:LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = srvl.example.com)(PORT = 1522))) ) )SID LIST LISTENER =(SID LIST =(SID_

24、Examine these components:• 1. Execution plan for a non-embedded SQL statement• 2. Local, global, and package variables for a session• 3. Execution plan for a SQL statement contained In a PL/SQL pro

23、Which three are true about the Automatic Database Diagnostic Monitor (ADDM)?A) Its findings are accessible only by using Oracle Enterprise Manager.B) It improves database performance by automatic

22、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2.SYS executes this command:SQL> REVOKE UPDATE ON user1.emp FROM user1;What will be the outcome?A) It will succeed and o

21、Which two are true about roles?A) A role can be granted a combination of system and object privileges and other roles.B) The CONNECT role Is granted automatically to a user when It Is created.C

20、Your database is using Automatic Memory Management.Which two SGA components must be managed manually?A) default buffer cacheB) redo log bufferC) large poolD) shared poolE) keep buffer poolAnswer:BE

19、Which two can be backed up by using RMAN when a database Is open in ARCHIVELOG mode, so that media recovery can be performed If required?A) control filesB) password fileC) pfileD) online redo log

18、Where Is backup metadata stored for use by Recovery Manager (RMAN)?A) In the control fileB) In the SYSAUX tablespaceC) in the SPFILED) in the SYSTEM tablespaceE) In the diagnostic destination flies

17、 Examine these commands and their output:SQL> SELECT * FROM emp;ENO ENAME---- -----100 Adam101 AlanSQL> INSERT INTO emp VALUES(102,'Ben");1 row created.SQL> COMMIT;Commit complete

16、Which two events always request the LGWR to write?A) when LGWR is notified by a server process that performs a Commit or ROLLBACKB) When PMON restarts a server processC) when DBWn writes dirty bu

15、Which two are true about space management in tablespaces?A) Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are m