熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

1Z0-023 考試回憶 11.20

2013-11-13 16:24:29  來源: Oracle 

  Dear all
  
  Its not my lucky day today I didnt pass only got Ill try in next month Please read following questions its really exact same with real test
  and be careful on password and profiles for exemple view password expire date
  redo log file(group members size)
  temporary and permanent segment different
  Archive Log List or select * from archive_log_list which view is right
   Add datafile solution
   Which will be use when SQL*Loaderlog file or other
  
   Which of the following is one reason for using the package DBMS_TTS?
  
  A To verify that a tablespace is selfcontained
  B To drop indexes outside a transportable tablespace
  C To create the metadata for a transportable tablespace
  D To attach transportable tablespaces datafiles to the database
  
   Which export option will generate code to create an initial extent that is equal to the sum of the sizes of all the extents currently allocated to an object?
  
  A FULL
  B DIRECT
  C COMPACT
  D COMPRESS
  
   What are two reasons for changing user quotas on a tablespace?
  
  A A datafile becomes full
  B A user encounters slow response time from the application
  C Tables owned by a user exhibit rapid and unanticipated growth
  D Database objects are reorganized and placed in different tablespace
  
   A DBA performs the query:
  
  SELECT tablespace_name max_blocks
  FROM dba_tablespace_quotas
  WHERE username= 慗ERRY?
  That returns the result:
  TABLESPACE_NAME MAX_BYTES
  DATA
  
  What does indicate?
  
  A Tablespace DATA has been dropped
  B Tablespace DATA has no free space
  C The user has no quotas on tablespace DATA
  D The user has an unlimited quota on tablespace DATA
  E The user has exceeded his or her quota on the tablespace DATA
  
   Consider the following command to create the user 憄eter?
  
  CREATE USER peter
  IDENTIFIED by pan
  TEMPORARY TABLESPACE temp
  PASSWORD EXPIRE;
  
  Since no default tablespace was specified what will happen if this command is executed?
  
  A The user will not own a home directory
  B The user peter will be created using the TEMP tablespace as the default
  C The user peter will be created using the SYSTEM tablespace as the default
  D The code will produce an error message the user peter will not be created
  
   An Oracle user receives the following error:
  
  ORA SNAPSHOP TOO OLD
  
  What are two possible solutions?
  
  A Increase the extent size of the rollback segments
  B Perform media recovery
  C Increase the number of rollback segments
  D Increase the size of the rollback segment tablespace
  E Increase the value of the OPTIMAL storage parameter
  
   When creating rollback segments what is the recommended value for the MINEXTENT minimize dynamic extension?
  
  A
  B
  C five
  D ten per transaction
  E number_of_users*
  
   MINEXTENTS must be at least _____ when a rollback segment is created
  
  A
  B
  C
  D
  
   You are creating a database with a character set other than USACII Which operating system environmental variable needs to be set to specify the director location of the NLS support files?
  
  A NLS_LANG
  B ORA_NLS
  C ORACLE_SID
  D ORACLE_BASE
  E ORACLE_HOME
  
   Given the statement:
  
  CREATE DATABASE orc
  LOGFILE GROUP /Oracle/dba/loglardo?SITE DM
  GROUP /Oracle/dba/loglardo?SITE DM
  DATAFILE 憉/Oracle/dbs/sys_dbf?REUSE;
  
  Which statement is true?
  
  A The online redo logs will be multiplexed
  B The file 憉/Oracle/dbs/sys_dbf?already exists
  C File 憉/Oracle/dbs/sys_dbf?as a parameter file
  D The control file name is 憉/Oracle/dbs/sys_dbf?
  E Oracle will determine the optimum size for 憉/Oracle/dba/sys_dbf?
  
   What is a default role?
  
  A A role that requires a password
  B A role that requires no password
  C A role automatically enabled when the user logs on
  D A role automatically assigned when the user is created
  
   Who is the owner of a role?
  
  A SYS
  B Nobody
  C SYSTEM
  D The creator
  
   Which class of segments is most likely to cause fragmentation in permanent tablespace?
  
  A Index segments
  B Rollback segments
  C User data segments
  D Temporary segments
  E Data dictionary segments
  
   Which data dictionary view shows the available free space in a certain tablespace?
  
  A DBA_EXTENTS
  B V$FREESPACE
  C DBA_FREE_SPACE
  D DBA_TABLESPACE
  E DBA_FREE_EXTENTS
  
   Which statement about using PCTFREE and PCTUSED is true?
  
  A Block space utilization can be specified only at the segment level
  B Block space utilization can be specified only in the data dictionary
  C Block space utilization parameters can only be specified at the tablespace
  D Block space utilization can be specified both at the tablespace level and segment level
  
   Which type of index should be created to spread the distribution of an index across the index tree?
  
  A Btree indexes
  B Bitmap indexes
  C Reversekey indexes
  D Functionbased indexes
  
   Which statement about rebuilding indexes is true?
  
  A The NOSORT option must be used
  B The new index is built using the table as the data source
  C A reverse btree index can be converted to a normal index
  D Query performance may be affected because the index is not
  
   When granting the system privilege which clause enables the grantee to further grant the privilege to other users or roles?
  
  A PUBLIC
  B WITH PRIVILEGE
  C WITH ADMIN OPTION
  D WITH GRANT OPTION
  
   Which view will show a list of privileges that are available for the current session to a user?
  
  A SESSION_PRIVS
  B DBA_SYS_PRIVS
  C DBA_COL_PRIVS
  D DBA_SESSION_PRIVS
  
   How does a DBA specify multiple control files?
  
  A With the ADD CONTROLFILE command
  B By using the files in the STARTUP command
  C With the MULTIPLEX control file command
  D By listing the files in the CONTROL_FILES parameter
  
   Which dynamic view should a DBA query to obtain information about the different sections of the control file?
  
  A V$CONTROLFILE
  B DBA_CONTROLFILE
  C V$CONTROLFILE_RECORD_SECTION
  D DBA_CONRTOLFILE_RECORD_SECTION
  
   What are two characteristics of the control file?
  
  A It is a text file
  B It is a fixed size
  C It should be multiplexed
  D It is required to start the instance
  E It must be updated at every log switch
  
   Which two dynamic views can be queried when a database is started up in nomount state?
  
  A V$SGA
  B V$LOGFILE
  C V$INSTANCE
  D V$CONTROLFILE
  E V$DATAFILE_HEADER
  
   Which t
From:http://tw.wingwit.com/Article/program/Oracle/201311/18281.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.