1Z0-497 Online Practice Questions and Answers

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

A. Automatic Storage Management (ASM)

B. OS file system

C. logical volume (LVM)

D. clustered file system

E. RAW

A DBA informs you that an Oracle instance has started. What does this imply?

A. Users can access the data in the database.

B. Only SGA has been allocated for the database.

C. Only background and user processes are running.

D. Memory areas have been allocated and background processes have been started.

Your database is down. You log in as the SYS user and issue this command: SQL> STARTUP

What happens after the instance is started?

A. Nothing else happens.

B. The database is mounted but not opened.

C. The database is mounted and finally opened.

D. The database is opened and finally mounted.

Which two statements about multitenant architecture are true?

A. It ensures full backward compatibility with non-CDBs.

B. It fully operates with RAC.

C. It is integrated with Enterprise Manager, but not with the Resource Manager.

D. It allows central management and administration of single databases.

Which two are client-side components of Oracle Data Guard Broker?

A. Oracle Enterprise Manager Cloud Control

B. Oracle Data Guard monitor

C. Oracle Data Guard command-line interface (DGMGRL)

D. Oracle Data Guard Broker Manager

Examine the statements:

SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;

SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) ) PARTITION BY RANGE(id) (

partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than

(MAXVALUE) tablespacemytbs storage (initial 1m) );

When inserting data, you get the error:

ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS

Which three operations would allow you to insert data without getting the error message?

A. Extend the logical volume by 10 MB where the data files are stored; # lvextend -L+10M /diskl

B. Add a data file: SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

C. Move a partition to another tablespace: SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE 10M; SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

D. Resize the existing data file: SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M; E) Remove a data file: SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';

Which two statements about switchover and failover are true?

A. A snapshot standby can be the target of a switchover or fast-start failover operation.

B. Neither a switchover nor a failover is possible to a far sync instance.

C. For fast-start failover, you must preselect the target standby database that will be used.

D. You can activate a standby database to test whether it is being updated correctly.

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:

lsnrctl start listener2

What would be the outcome?

A. It starts the second listener without affecting current sessions.

B. It starts the second listener and terminates all current sessions.

C. It gives an error because multiple listeners cannot run simultaneously.

D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

A. select patch from vSoption where opatch_data=' 333333' ;

B. select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT ()) from dual

C. select opatch from vSpatchsets where opatch_number = '333333';

D. opatchlsinventory -xml

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

A. less instance overhead

B. increased storage cost

C. minor application changes

D. fast and easy provisioning

E. same time needed for patching and upgrade as in the previous release

F. isolation