ITPub博客

55、Which is true when a database instance is shut down?A. IMMEIATE, TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions either to commit or rollback and then close the databaseB. I

54、Your database instance is in NOMOUNT state.Your select the delete option in the database configuration assistant (DBCA) for your database.What is the outcome?A. DBCA is able to delete the data fi

53、Which two are true about server-generated alerts?A. Stateful alerts must always be cleared manually.B. They are visible in Oracle Enterprise Manager by default.C. All stateful alerts can be found i

52、In one of your databases:1. USER1 and USER2 have no system privileges.2. ROLE1 only has these privileges:* create session* create table* create viewExamine these commands:SQL> conn / as sysdbaCo

51、Examine this query and its output:SQL> select sid,event,blocking_sessionfrom v$sessionwhere blocking_session is not null;SID EVENT BLOCKING_SESSION---- --------------------------- --------------

50、When does an incremental checkpoint occur?• A. when DBWn writes dirty buffers as part of its normal process• B. when the alter system checkpoint statement is executed.• C. when a user tablespace is

49、For your ORCL database.1. The instance is started using an spfile.2. The database is opened.3. It is in ARCHIVELOG mode.4. CONTROL FILE AUTOBACKUP IS ON.Examine this command:RMAN> backup as copy

48、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?A. If the directory used in the export operation has existing dump files, it overwrites them.B. It allows encryption t

47、Which two are true about the Data Recovery Advisor?A. It can be used only for databases that are running in ARCHIVELOG mode.B. It can be used when the database is closed.C. It can be used to valida

46、Which three are true about undo segments and undo tablespaces in the same database and instance?A. Multiple transactions run by the same Oracle user can share a single undo segment.B. Multiple

45、Which is true when a database instance is shut down?A. Only transactional and normal modes wait for all uncommitted transactions to commit or rollback and then close the database.B. Immediate, tr

44、In one of your databases:* The database default tablespace is EXAMPLE.* Deferred_segment_creation is false.Examine these commands:SQL> create user user1 identified by oracle_4u password expire;U

43、Which two are true about external tables?A. They support the ORACLE_DATAPUMP access driver.B. They have extents.C. They support all DML operations.D. They can always be updated using SQL.E. They ca

42、Examine these facts about a database:1. USERS is the database default tablespace.2. USER1, USER2, AND USER3 have the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the default tables

41、In which state can you back up a database in ARCHIVELOGMODE using RMAN?A. NOMOUNT, MOUNT, AND OPENB. NOMOUNT AND MOUNT ONLYC. OPEN ONLYD. MOUNT AND OPEN ONLYE. OPEN RESTRICTED ONLYCorrect Answer:

40、 Which is true about logical and physical database structures?(Choose the best answer)A. An undo tablespace has a temp file instead of a data file.B. A segment can consist of extents of different s

39、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G.Currently, 5G of the space Is used of which 4G consists of obsolete backups.You execute this command:SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;

38、Which two are true about data dictionary and dynamic performance views (v$ views)?A) All database users have access to ALL_* views.B) Data dictionary view output is subject to read consistency.C)

37、You are planning a software installation for both Oracle Database 11g Release 1 and Release 2.You plan to have at lease one database for each release managed by Grid Infrastructure for a Standa

36、Which two are true about roles?A) A role can be password-protected.B) A role can be granted to another role.C) Only one default role can be granted to a user.D) A role can be granted only multiple