Database operations will be monitored only when they consume a significant amount of resource.
Database operations for all sessions will be monitored.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
Only DML and DDL statements will be monitored for the session.
All subsequent statements in the session will be treated as one database operation and will be monitored.
第1题:
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
第2题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()
第3题:
Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?()
第4题:
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()
第5题:
Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are trueregarding the MRKT tablespace()
第6题:
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
第7题:
The SKD user cannot log in to the database instance.
The objects owned by the SKD user are not accessible to any user.
The other users can access the objects owned by the SKD user, on which they have access.
The password for the SKD user expires and the user is forced to change the password at the next log in
第8题:
Every SQL statement in the STS is considered only once for execution
The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
The execution plan and execution statistics are computed for each SQL statement in the STS
The effects of DDL and DML are considered to produce the execution plan and execution statistics
第9题:
/SQL*Plus commands cannot be abbreviated.
/SQL*Plus commands are accessed from a browser.
/SQL*Plus commands are used to manipulate data in tables.
/SQL*Plus commands manipulate table definitions in the database.
/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
第10题:
iSQL*Plus commands cannot be abbreviated.
iSQL*Plus commands are accessed from a browser.
iSQL*Plus commands are used to manipulate data in tables.
iSQL*Plus commands manipulate table definitions in the database.
iSQL*Plus is the Oracle proprietary interface for executing SQL statements.
第11题:
Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
第12题:
EXPDP and IMPDP are the client components of Oracle Data Pump.
DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
第13题:
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?()
第14题:
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
第15题:
Which two statements are true regarding Oracle Data Pump()
第16题:
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
第17题:
Which two are attributes of iSQL*Plus? ()
第18题:
Which two are attributes of /SQL*Plus? ()
第19题:
No more data files can be added to the tablespace.
Segment space is managed by free lists in the tablespace.
A user created without being assigned a default tablespace uses this tablespace.
The tablespace can be dropped with the current setting with segments present in it
第20题:
/SQL*Plus commands cannot be abbreviated.
/SQL*Plus commands are accesses from a browser.
/SQL*Plus commands are used to manipulate data in tables.
/SQL*Plus commands manipulate table definitions in the database.
/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
第21题:
Database operations will be monitored only when they consume a significant amount of resource.
Database operations for all sessions will be monitored.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
Only DML and DDL statements will be monitored for the session.
All subsequent statements in the session will be treated as one database operation and will be monitored.
第22题:
The SKD user cannot log in to the database instance.
The objects owned by the SKD user are not accessible to any user.
The other users can access the objects owned by the SKD user, on which they have access.
The password for the SKD user expires and the user is forced to change the password at the next log in.
第23题:
Database operations will be monitored only when they consume a significant amount of resource.
Database operations for all sessions will be monitored.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
Only DML and DDL statements will be monitored for the session.
All subsequent statements in the session will be treated as one database operation and will be monitored.
第24题:
Every SQL statement in the STS is considered only once for execution.
The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
The execution plan and execution statistics are computed for each SQL statement in the STS.
The effects of DDL and DML are considered to produce the execution plan and execution statistics.