ITPub博客

78、Which four database objects never have any segments?A) A partitioned indexB) A view selecting from a populated tableC) An empty indexD) An Oracle Loader type external tableE) An empty tableF) A vie

77、Which structure can span multiple data files?A) a bigfile tablespaceB) a permanent tablespaceC) a segmentD) a temporary tablespaceE) an extentAnswer：C北京CUUG整理，转载请注明，OCP讨论群：569933648 / 836361015

76、Which three structures can span multiple data files?A) migrated rowsB) table extentsC) temporary segment extentsD) index extentsE) chained rowsF) segmentsAnswer：AEF北京CUUG整理，转载请注明，OCP讨论群：569933648 /

75、Your database is using Automatic Memory Management.Which two SGA components must be managed manually?A. redo log bufferB. keep buffer poolC. large poolD. shared poolE. default buffer CacheAnswer: A

74、Which two can be exported by a non-administrative account by using Data Pump?A. tablesB. databaseC. directory objectsD. tablespacesE. schemasAnswer: AE北京CUUG整理，转载请注明，OCP讨论群：569933648 / 836361015

73、In one of your databases:    The database default tablespace is EXAMPLE.    DEFERRED_SEGMENT_CREATION is FALSE.Examine these commands:SQL> CREATE USER user1 IDENTIF

72、Which is true about enabling AUTOEXTEND for data files?A. It can be enabled for data files only in smallfile tablespaces.B. It can be enabled for an existing data file in a tablespace by using the

71、Which command is used to display files that no longer conform to the backup retention policy?A. CROSSCHECK BACKUPB. REPORT OBSOLETEC. LIST EXPIRED BACKUPD. SHOW DATAFILE BACKUP COPIESAnswer: B北京C

70、Which two are true about space management in tablespaces?A. Free lists are used for managing free space for segments in locally managed tablespaces.B. Extent allocation must be specified as autom

69、Which is true about unusable indexes?A. Rebuilding an unusable index always requires at least twice the space of the original indexB. Rebuilding an unusable index always allows DML statements on

65、Which three structures can span multiple data files?A. chained rowsB. segmentsC. temporary segment extentsD. index extentsE. table extentsF. migrated rowsCorrect Answer: ABF北京CUUG整理，转载请注明，OCP讨论群：56

64、 Which three are true about Oracle database security?A. By default, SYSDBA connections have access to all schema objects.B. SYSDBA connections are always subject to mandatory auditing.C. By default

63、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 are

62、In which state must a database be to enable ARCHIVELOG?A. NOMOUNTB. OPEN in RESTRICTED modeC. OPEN in READ WRITE modeD. MOUNTE. OPEN in READ ONLY modeCorrect Answer: D北京CUUG整理，转载请注明，OCP讨论群：56993364

61、Which two can be configured with profiles?A. tablespace quotas for usersB. the time after which an idle session is terminatedC. default tablespace for usersD. default object privileges for usersE.

60、Which two are true about UNDO data?A. Inactive UNDO is never written to disk.B. Active UNDO is always kept in memoryC. Only DML statements generate UNDO.D. Active UNDO can never be overwritten.E. I

59、In which two cases is a consistent database backup created?A. when the RMAN BACKUP command is used while the database is OPEN READ ONLYB. when the RMAN BACKUP AS COPY command is used while the da

58、Examine this session output:SQL> connct scott/tigerConnected.SQL> select name,value from V$parameter where name='audit_trail';NAME VALUE--------------- -----------------audit_trail DB

57、Which two statements are true about dispatchers used by the Oracle shared server?A. Multiple user processes can connect to a single dispatcher.B. They return completed requests to the appropriate

56、The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled. USER1.EMP is a table in tablespace TBS1.There are no existing backups of the database.Examine these commands:$ rman