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

One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?

• A.Online redo logs are opened.
• B.The initialization parameter file is read.
• C.The alert log has instance startup details written to it.
• D.Control files are read.
• E.Oracle shared memory structures are allocated.
• F.Online data files are opened.

Which two AWR-based tools listed below are part of Oracle Database self-tuning components?

• A.Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• B.Automatic Diagnostic Collector used to capture and store database errors and hung analysis.
• C.Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• D.ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.
• E.Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.
• F.Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

Which three statements are true about Deferred Segment Creation in Oracle databases?

• A.Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.
• B.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
• C.It is the default behavior for tables and indexes.
• D.It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• E.It is supported for SYS-owned tables contained in locally managed tablespaces.

Which statement is true about database links?

• A.A database link can be created only between two Oracle databases.
• B.Private database link creation requires the same user to exist in both the local and the remote databases.
• C.A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
• D.A public database link can be created only by SYS.
• E.A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.

orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?

• A.It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.
• B.It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.
• C.It skips only tables that exist in ORCL:SH and ORCL:OE.
• D.It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
• E.It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.