O Teste do Teste

You start your database instance in NOMOUNT state. Which two actions are performed?. The consistency of the database is checked. SYS can access the database. The control files are opened. Memory is allocated for the SGA. All required background processes are started.

What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;. It should be used whenever PDB1 open mode needs to be changed. It is unnecessary if the PDB is in the process of being upgraded. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.

You execute the SHUTDOWN ABORT Command. Which two statements are true?. Subsequent instance startup performs instance recovery. Data files are closed normally. Subsequent instance startup performs media recovery. A checkpoint is written. Uncommitted transactions are not rolled back by the shutdown.

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?. Online data files are opened. Online redo logs are opened. The initialization parameter file is read. Oracle background processes are started. Oracle shared memory structures are allocated. Control files are read. The alert log has instance startup details written to it.

Which two tasks can be performed in the NOMOUNT state?. Creating a database. Re-creating control files. Enabling online redo log archiving. Renaming data files. Full database recovery.

Which statement is true about database links?. 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. A public database link can be created only by SYS. A public database link can be used by any user allowing remote database instance connection for selecting schema data. A database link can be created only between two Oracle databases. Private database link creation requires the same user to exist in both the local and the remote databases.

Why would you use the TNSPING hr command?. To verify if the HR database instance is up. To verify if a requested service is available. To check and list multiple ORACLE HOME locations on the server. To determine if the listener for the HR net service name can be reached. To validate the network connectivity between a client and the database instance.

8. At which two container database levels can COMMON Unified Audit Policies be used?. At the Application Root level of an Application Container. COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level. At the PDB level if the policy is created by a COMMON user. At the CDB level. At any level by using the COMMON option in the policy.

Which three statements are true about a dedicated server configuration?. A dedicated server process can be spawned without a listener when using local clients. A dedicated server process may be reused by a new session after the session using that process terminates. A dedicated server process can be spawned by the listener when using local clients. The DBA configures the maximum number of dedicated server processes that can share the same dispatcher process. A dedicated server process communicates directly with a client or middle tier process once the session is established. Each dedicated server process has its own dispatcher process.

Examine these commands: [oracle@host01 ~]$ sqlplus ul/oracle SQL> SELECT * FROM emp; ENO ENAME DN 1 Alan 2 2 Ben 2 SQL> exit [oracle@host01 ~]$ cat emp.dat 1,Alan, 2 3, Curl,4 4, Bob,4 [oracle@host01 ~]$ sqlldr ul/oracle TABLE-emp Which two statements are true about the sqlldr execution?. It overwrites the data for Alan and adds data for Curl and Bob. It overwrites all data in EMP with data from EMP.DAT. It generates a sql script that it uses to load data from EMP.DAT to EMP. It appends data from EMP.DAT to EMP. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.

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?. It skips only tables that exist in both ORCL: SH and TESTDB:HR. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR. It skips only indexes that exist in both ORCL:SH and TESTDB:HR. It skips all indexes of ORCL:SH and ORCL:OE.

Which three tools are components of the Oracle Database Optimizer?. Statistic Advisor. The DBMS_STATS P/L SQL package. Estimator. Index Detector. Query Transformer. Plan Generator.

Which of the following statements is true about external tables?. They describe how data is stored in the external source. They describe how the external table layer presents data to the server. They are read/write tables. They describe data stored in the database.

As the DBA, you execute this command: GRANT CREATE VIEW TO Usrl WITH ADMIN OPTION; USR1 then executes this command: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes this command: GRANT CREATE VIEW TO usr3; Which statement is true?. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 and USR3. When USR1 revokes the CREATE VIEW privilege from USR2, it is revoked from USR3. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3. USR1 can revoke the CREATE VIEW privilege from USR3. The DBA can revoke only ADMIN OPTION from USR1. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.

Which three statements are true about roles?. Roles may be granted to other roles. Object privileges may not be granted to roles. All roles granted to a user are set on default when the user logs in. The SET ROLE statement can disable one or more roles for a session. The SET ROLE statement can enable one or more roles for a session. Roles must be password protected.

Which two account management capabilities can be configured using Oracle profiles?. The number of days for which an account may be inactive before it is locked. The maximum amount of CPU time allowed for a user's sessions before their account is locked. The ability to prevent a password from ever being reused. The maximum number of sessions permitted for a user before the password must be changed. The number of days for which an account may be logged in to one or more sessions before it is locked.

Which three actions are ways to apply the principle of least privilege?. Setting the 07_DICTIONARY_ACCESSIBILITY parameter to true. Enabling Unified Auditing. Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the PUBLIC user. Setting the REMOTE_OS_AUTHENT parameter to true. Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the SYSTEM user. Using Access Control Lists (ACLs).

You want to apply the principle of least privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?. Analysis of all privileges used by the SYS user. Analysis of privileges that a user has on their own schema objects. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role. Analysis of privileges that a user has on other schema's objects. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?. Log in to the database instance. Execute DML statements in the HR schema. Revoke the CREATE SESSION privilege from user HR. Revoke the CREATE SESSION privilege from other users. Execute DDL statements in the HR schema. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

Which two tasks can you perform using DBCA for databases?. Register a new database with an available Enterprise Manager Management server. Enable flashback database for an existing database. Configure a nonstandard block size for a new database. Configure incremental backups for a new database. Change the standard block size of an existing database.

Which three statements are true about using SQL*Plus?. It must be downloaded from the Oracle Technology Network (OTN). It can run scripts passed to it by a shell script. It can run scripts entered at the SQL prompt. It has its own commands that are separate from any SQL statements. It can run Recovery Manager (RMAN) commands. It has both command-line and graphical user interfaces (GUI).

Which three statements are true about Enterprise Manager Cloud Control?. It provides management for Oracle middleware. It uses a web-based console built into the Oracle database using XML DB. It is available to manage a database only when that database is open. It is integrated with My Oracle Support. It provides management for Oracle-engineered systems.

Which compression method is recommended for Direct-Path Insert operations?. COLUMN STORE COMPRESS ADVANCED. ROW STORE COMPRESS ADVANCED. COLUMN STORE COMPRESS BASIC. ROW STORE COMPRESS BASIC.

Which two are true about shrinking a segment online?. It always eliminates all migrated rows if any exist in the table. To shrink a table it must have a UNIQUE KEY constraint. To shrink a table it must have row movement enabled. To shrink a table it must have a PRIMARY KEY Constraint. It is not possible to shrink either indexes or Index Organized Tables (IOTs). It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

Which three statements are true about resumable space allocation in Oracle databases?. The AFTER SUSPEND event trigger can itself be suspended due to space conditions. A user's session may be suspended and resumed multiple times. Resumable space allocation is only possible with locally managed tablespaces. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege. Resumable space allocation may be enabled for some sessions and not others. All sessions must have the same timeout value when waiting for resumable space allocations.

Which two advisors are used for tuning SQL statements?. SQL Memory Advisor. SQL Statistics Advisor. SQL Access Advisor. SQL Tuning Advisor. SQL Execution Advisor.

Which two statements are true about FGA?. FGA policies by default can be created by a schema owner on an object in their schema. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package. FGA policies can only be created by a user with SYSDBA privilege. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role. FGA policies can be created by a user having the AUDIT_ADMIN privilege.

Which three statements are true about dynamic performance views?. VSFIXED TABLE can be queried to display the name of all dynamic performance views. Data displayed by querying dynamic performance views is derived from memory structures. They are owned by the SYSTEM user. Read consistency is not guaranteed. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary. They can be queried only when the database is open.

In the SALES database, DEFERRED_SEGMENT_CREATION IS TRUE. Examine this command: SQL> CREATE TABLE T1 (cl INT PRIMARY KEY, C2 CLOB); Which segment or segments, if any, are created as a result of executing the command?. 71 only. 11 and an index segment created for the primary key only. 11, an index segment for the primary key, and a LOB segment only. T1, an index segment for the primary key, a LOB segment, and a lobindex segment. no segments are created.

Which three statements are true about Deferred Segment Creation in Oracle databases?. Indexes inherit the DEFERRED OF IMMEDIATE segment creation attribute from their parent table. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation. It is the default behavior for tables and indexes. It is supported for SYS-owned tables contained in locally managed tablespaces.

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted. The first block with enough free space to accommodate a row being inserted will always be used for that row. PCTFREE defaults to 10% for all blocks in all segments for all compression methods. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted. The first block with enough free space to accommodate a row being inserted will always be used for that row. PCTFREE defaults to 10% for all blocks in all segments for all compression methods. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.

Which three statements are true about an SPFILE?. It can be created by Sys from an idle instance. It must exist for a database instance to start. It contains only static initialization parameters. It can be used to create a pfile. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

Which of the following methods can be used to provision a copy of a PDB for possible testing purposes?. Plug an unplugged PDB into the CDB. Create a PDB from the PDBSSEED. Plug a non-CDB into the CDB as a PDB. Clone a PDB from another PDB.

Which two statements are true about the PMON background process?. It frees resources held by abnormally terminated processes. It registers database services with all local and remote listeners known to the database instance. It frees unused temporary segments. It rolls back transactions when a process fails. It records checkpoint information in the control file.

What memory structure caches the data dictionary providing access to all database user processes?. The Shared Pool. The Java Pool. The Large Pool. The Streams Pool.

Which three tasks are performed by background processes in an Oracle database instance?. Writing redo to log files. Creating dedicated server connections. Registering services with Oracle Net listeners. Reading database blocks into the buffer cache. Writing dirty database block images from the buffer cache.

Which two statements describe why Database Auditing is a security requirement?. To protect against data corruption. To protect against data theft by a non-authorized user. To monitor suspicious activity. To monitor proper usage of the system and data by privileged users. To alert DBAS about system issues.

Which two statements are true about UNDO and UNDO tablespaces?. UNDO segments are owned by SYSTEM. UNDO segments are owned by SYSBACKUP. An instance will crash if the active undo tablespace is lost. There can be only one UNDO tablespace created in a database. An UNDO tablespace may be owned by only one instance.

Which two statements are true concerning logical and physical database structures?. A segment can span multiple data files in some tablespaces. A segment's blocks can be of different sizes. Segments can span multiple tablespaces. All tablespaces may have one or more data files. A segment might have only one extent.

In which two ways would you disable timing information collected for wait events and much of the performance-monitoring capability of the database?. By setting the STATISTICS_LEVEL parameter to BASIC. By executing the P/L SQL procedure DBMS_TIME_STATISTIC.LEVEL (BASIC). By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE. By setting the TIMED_STATISTICS system parameter to FALSE. By executing the P/L SQL procedure DBMS_TIME_STATISTIC.DISABLE (TRUE).

Which three relationships between instances and Oracle databases are possible without using Multi-tenant?. one instance on one server mounting and opening one database. one instance on one server that has no database mounted. one instance on one server mounting multiple databases. one instance on one server mounting and opening multiple databases. two or more instances on separate servers all mounting and opening the same database.

Which two statements are true about database instances and Real Application Clusters (RAC)?. A RAC database can have instances on separate servers. A RAC database must have two or more instances. Two RAC databases can share their instances. A RAC database must have three or more instances. A RAC database can have one instance.

Which two statements are true about views used for viewing tablespace and datafile information?. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened. Tablespace free space can be viewed in VSTABLESPACE. Tablespace free space can be viewed in DBA_TABLESPACES. VSTABLESPACE displays information about tablespaces contained in the data dictionary. VSTABLESPACE displays information that is contained in the controlfile about tablespaces.

You execute this command: sql CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?. It uses the database default blocksize. It must be smaller than the smallest BIGFILE tablespace. Free space is managed using freelists. It is a locally managed tablespace. Any data files added to the tablespace must have a size of 5 gigabytes.

You execute this command: sql CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /U01. Which two statements are true about the BIG_TBS tablespace?. It will be a dictionary-managed tablespace by default. AUTOEXTEND is possible for the datafile. It will always have a 32K blocksize. Additional data files may not be added. It must be bigger than the largest SMALLFILE tablespace.

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: sql CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8k but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE. The /u02 file system must have at least 100g space for the datafile. The operating system must use a 32k block size. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA. DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE.

Which three statements are true about Oracle Managed Files (OMF)?. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle managed. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n. 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. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed. 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. 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.

Which three are benefits of using temp UNDO when performing DML on global temporary tables?. It reduces the amount of UNDO stored in the UNDO tablespace. It reduces I/Os to the SYSTEM tablespace. It reduces the amount of redo generated. It permits DML on global temporary tables even if the database is opened read only. It reduces I/Os to the SYSAUX tablespace.

What are the three components of Oracle Database Automatic Maintenance Tasks?. A diagnostic system that collects database errors logs and details about database failures that can be used to diagnose and correct those issues. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database. A database alert log that stores details about major database operations and errors, which is used to manage database daily operations and issues. The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals intended to occur during a period of low system loads. Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks. A packaging system that allows you to combine all error and failure logs to share with Oracle support.

Which two statements are true about trace files produced by the Oracle Database server?. They can be written by server processes to a file system. All trace files contain error information that require contacting Oracle Support. Trace file names are based on the database name concatenated with a sequential number. They can be written by background processes to a file system. They can be written by server processes to the Fast Recovery Area (FRA).

Which three statements are true about Automatic Diagnostic Repository (ADR)?. The ADR base is specified in the DIAGNOSTIC_DEST database parameter. It is only used for Oracle database diagnostic information. It can be used for the problem diagnosis of a database when that database's instance is down. It is held inside an Oracle database schema. It is a file-based repository held outside any database.

Which two statements are true about the DUAL table?. It can display multiple rows and columns. It consists of a single row and single column of VARCHAR2 data type. It can display multiple rows but only a single column. It can be accessed by any user who has the SELECT privilege in any schema. It can be accessed only by the SYS user. It can be used to display only constants or pseudo columns.

Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?. The Automatic SQL Access Advisor task, which is used to manage an application SQL load. The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for repeated SQL statements. The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations. The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL loads. The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations on how to tune those statements.

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_01 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_ql ADD DATAFILE; Which two actions independently ensure that the command executes successfully?. Add the AUTOEXTEND ON clause with NEXT set to 100M. Ensure that DB RECOVERY FILE DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space. Ensure that DB CREATE FILE DEST specifies a location with at least 100 MB of available space. Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.

Which three statements are true about UNDO and REDO?. REDO is used for instance recovery. REDO is used for read consistency. UNDO is used for some flashback operations. UNDO is used for read consistency. REDO is used for ROLLBACK. Both REDO and UNDO can be multiplexed.

You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of the following is a necessary prerequisite for the hot remote clone?. PDBI must be in read-only mode. Both CDBs need to be in local undo mode. PDB1 must be taken offline before the cloning process begins. TESTPDB must be in read-only mode after the cloning process is complete.

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdbl UNPLUG INTO '/tmp/pdbl.pdb'; Which statement is true prior to plugging the PDB into the other CDB?. The PDB archive file and only the user defined tablespaces must be copied to the target CDB. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB. The PDB archive file must be copied to the target CDB. The PDB manifest and all the datafiles must be copied to the target CDB.

You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, values FROM pdb_spfiles. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, values FROM pdb_spfiles. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;. From the PDB, execute SELECT NAME, VALUE, ISPDB MODIFIABLE FROM v$parameter;.

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB) and affect the entire container database (CDB)?. ALTER SYSTEM SWITCH LOGFILE. ALTER SYSTEM FLUSH BUFFER_CACHE. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION. ALTER SYSTEM CHECKPOINT.

Which statement regarding PDBs (Pluggable Database) is correct?. You can drop an application root along with the associated PDBs. You can drop a PDB as long as it is not the PDB seed. When the relocation of a PDB is finished, the source PDB must be dropped. You cannot drop a source PDB of a refreshable PDB.