1Z1-182 무료 덤프문제 온라인 액세스

Which four statements are true about the Oracle Server architecture?

• A.Each server process or background process has their own Program Global Area (PGA).
• B.A person or program can have more than one session with an instance by logging in with different users.
• C.A session represents the state of a user's login to an instance.
• D.A connection represents the state of a user's login to an instance.
• E.A person or program can have more than one session with an instance by logging in with the same user.
• F.The buffer cache and the redo log buffer are held in the large pool.

Which two statements are true concerning logical and physical database structures?

• A.All tablespaces may have one or more data files.
• B.Segments can span multiple tablespaces.
• C.A segment's blocks can be of different sizes.
• D.A segment can span multiple data files in some tablespaces.
• E.A segment's blocks can be of different sizes.
• F.A segment might have only one extent.

Which three statements are true about Oracle Managed Files (OMF)?

• A.If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.
• B.If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
• C.If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• D.If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.
• E.If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.
• F.If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

Which data dictionary view describes the data sources of external tables?

• A.DBA_ALL_USER_EXTERNAL_TABLES
• B.DBA_ALL_USER_TABLES
• C.DBA_ALL_USER_EXTERNAL_LOCATIONS
• D.DBA_ALL_USER_TAB_COLUMNS

Which three statements are true about Automatic Diagnostic Repository (ADR)?

• A.It is only used for Oracle database diagnostic information.
• B.It is a file-based repository held outside any database.
• C.It is held inside an Oracle database schema.
• D.It can be used for the problem diagnosis of a database when that database's instance is down.
• E.The ADR base is specified in the DIAGNOSTIC_DEST database parameter.