You intend to use only password authentication and have used the passw

Login | Register

(31)

(1)

(0)

(9)

(7)

(1)

(11)

(2)

Oracle Database Skills Practice Test

You intend to use only password authentication and have used the password file utility to create
a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE. You created a user and
granted only the SYSDBA privilege to that user as follows:
CREATE USER dba_user
IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;
The user attempts to connect to the database as follows:
connect dba_user/dba_pass as sysdba;
Why does the connection fail?

The DBA privilege was not granted to dba_user

REMOTE_LOGIN_PASSWORDFILE is not set to EXCLUSIVE

The password file has been created in the wrong directory

The user did not specify the password orapass to connect as SYSDBA

Question 1 of 69

First | Previous | Next | Last

Sponsored Links

Related Questions
#	Question Details
1	Does garbage collection guarantee that a program will not run out of memory
2	What restrictions are placed on the location of a package statement within a source code file
3	What value does readLine() return when it has reached the end of a file
4	What is a task's priority and how is it used in scheduling
5	When a thread is created and started, what is its initial state
6	How are commas used in the intialization and iteration parts of a for statement
7	How are Java source code files named
8	What value does read() return when it has reached the end of a file
9	What happens when a thread cannot acquire a lock on an object
10	What is the purpose of the File class

You intend to use only password authentication and have used the password file utility to create
a password file as follows:

$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5

The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE. You created a user and
granted only the SYSDBA privilege to that user as follows:

CREATE USER dba_user
IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;

The user attempts to connect to the database as follows:

connect dba_user/dba_pass as sysdba;

Why does the connection fail?

Related Articles

Business Intelligence Key Performance Indicators

Business Intelligence Key Performance Indicators What are Key Performance Indicators Key Performance Indicators are also known as Key Success Indicators they help an organization to better define and measure their progress toward professional goals Once an organization has clearly identified its nee

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat

Taking Advantage of Standard Internet Protocols

Taking Advantage of Standard Internet Protocols As mentioned Oracle XML DB provides native support for standard internet protocols such as S WebDAV and Continuing with the preceding sample you might for example upload another employee XML document into the XML repository with one of the above prot

Accessing Repository Resources with SQL

Accessing Repository Resources with SQL In fact Oracle XML DB repository resources are stored in a set of database tables and indexes which can be accessed via SQL You are not supposed to access those tables directly Instead Oracle XML DB provides two public views RESOURCE VIEW and PATH VIEW through

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ

Using XML Schemas

Using XML Schemas The simplest way to create an XMLType storage structure in Oracle XML DB is by registering an appropriate XML schema against the database As a part of the registration process Oracle automatically creates the storage for a particular set of XML documents based on the information pr

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per

Performing XSLT Transformations inside the Database

Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr employees table you can create a script that will instruct the database to build an HTML page based on the data stored in hr e

Moving All the XML Processing into the Database

Moving All the XML Processing into the Database In the preceding example the database server performs only a part of the XML processing while the rest is still performed by the PHP engine Specifically the database server generates an employees XML document based on the records from the hr employees