Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Database 12c Certified Implementation Specialist
1z0-497
Oracle Database 12c Essentials Questions and Answers

Pass the Oracle Database 12c Certified Implementation Specialist 1z0-497 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-497 Premium Access

View all detail and faqs for the 1z0-497 exam

Go to Exam

666 Students Passed

85% Average Score

98% Same Questions

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions

Questions # 21:

Question # 21

Which two statements are true about this common user?

Options:

SQL> conn c##usr/pwd@pdb1

You are connected to PDB1 successfully.

SQL> conn c##usr/pwd@pdb2

You are connected to PDB2 successfully.

SQL> conn c##usr/pwd@pdb2

You are unable to create a connection. You first need to sync PDB2 by executing:

SQL> conn / as sysdba

SQL>exec DBMS_PDB.SYNC_PDB;

SQL> conn c##usr/pwd@pdb2

You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing:

SQL>conn system/pwd@pdb2

SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT;

Now you are able to connect as common user c##usr to PDB2.

Answer

A, B

Questions # 22:

Which normalization level is adopted in real-world database systems?

Options:

1NF

2NF

3NF

BCNF

Answer

Explanation

http://docs.oracle.com/database/121/DWHSG/ch2logdes.htm#DWHSG9225

Questions # 23:

Examine the table:

Table name: PRODUCTS

Schema: SCOTT

Tablespace: USERS

Organization: Standard (Heap Organized)

This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.

Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

Options:

PROD_NAME size can be increased from five to 10 characters.

PROD_ID can be changed from CHAR to NUMBER data type.

PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

New columns can be added only if they have a NOT NULL constraint.

None of the existing columns can be dropped because they contain data.

Answer

A, C

Questions # 24:

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

Options:

db_name

maxdatafiles

control_files

instance_name

Answer

Explanation

[Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch14.htm, , ]

Questions # 25:

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

Options:

Automatic Storage Management (ASM)

OS file system

logical volume (LVM)

clustered file system

RAW

Answer

Explanation

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60120

Questions # 26:

Which three options correctly match environment variables with their specific functionality?

Options:

ORACLE_SID specifies the instance name.

ORACLE_SID specifies the global database name.

ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

Answer

A, C, E

Questions # 27:

For which database operation do you need the database to be in MOUNT state?

Options:

renaming the control files

re-creating the control files

dropping a user in your database

dropping a tablespace in your database

configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

Answer

Explanation

To enable or disable archiving, the database must be mounted but not open.

Note: See step 5 below.

Changing the Database Archiving Mode

To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges (AS SYSDBA).

The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:

1.Shut down the database instance

2.Back up the database.

3.Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files

4.Start a new instance and mount, but do not open, the database.

STARTUP MOUNT

To enable or disable archiving, the database must be mounted but not open.

5.Change the database archiving mode. Then open the database for normal operations.

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

6.Shut down the database.

SHUTDOWN IMMEDIATE

7.Back up the database.

Questions # 28:

Which two statements are true about listeners?

Options:

Listeners use only the TCP/IP protocol.

Multiple listener processes can run simultaneously on a host.

Multiple database instances can be registered with a single listener,

Listener-related errors can be traced only at the administrative level.

Only one database instance can be registered with a single listener at any time.

Answer

B, C

Explanation

http://docs.oracle.com/cd/E11882_01/network.112/e10835/protocoladd.htm#NETRF179

Questions # 29:

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

Options:

less instance overhead

increased storage cost

minor application changes

fast and easy provisioning

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

isolation

Answer

A, D, F

Questions # 30:

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

Options:

S sqlplus / as sysdba

SQL> restart;

S sqlplus / as sysdba

SQL> startup immediate;

S rman target /

RMAN> Startup

S sqlplus / as sysdba

SQL> startup open recover;

S srvctl start database -db SORACLE_SID

Answer

C, D, E

Explanation

The following command starts an instance, reads the initialization parameters from the default location, and then mounts and opens the database. (You can optionally specify a PFILE clause.)

STARTUP

If you know that media recovery is required, you can start an instance, mount a database to the instance, and have the recovery process automatically start by using the STARTUP command with the RECOVER clause:

STARTUP OPEN RECOVER

To start or stop your entire cluster database, that is, all of the instances and its enabled services, enter the following SRVCTL commands:

$ srvctl start database -db db_unique_name [-startoption start_options]

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions