An administrator account is granted the CREATE SESSION and SET CONTAINER system
privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB
that has been opened in read only mode?
A.
You can conned as a common user by using the connect statement.
B.
You can connect as a local user by using the connect statement.
C.
You can connect by using easy connect.
D.
You can connect by using OS authentication.
E.
You can connect by using a Net Service name.
F.
You can connect as a local user by using the SET CONTAINER statement.
Explanation:
* The choice of threading model is dictated by the THREADED_EXECUTION initialization
parameter.
THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the
multiprocess model.
THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model.
* OS Authentication is not supported with the multithreaded model.
* THREADED_EXECUTION
When this initialization parameter is set toTRUE, which enables the multithreaded Oracle model,operating system authentication is not supported. Attempts to connect to the database using
operating system authentication (for example,CONNECT / AS SYSDBAorCONNECT /) when this
initialization parameter is set toTRUEreceive anORA-01031″insufficient privileges”error.
F: The new SET CONTAINER statement within a call back function:
The advantage of SET CONTAINER is that the pool does not have to create a new connection to
a PDB, if there is an exisitng connection to a different PDB. The pool can use the existing
connection, and through SET CONTAINER, can connect to the desired PDB. This can be done
using:
ALTER SESSION SET CONTAINER=<PDB Name>
This avoids the need to create a new connection from scratch.
C,D,E,F
D is wrong. A user needs to have sysdba privilege to use OS authentication.
D may be correct if it is assumed that the administrator has sysdba privs.
Why ‘A’ is wrong ?
ADEF
A – common user – connect c##admin
password:
D – OS authentication – sqlplus “/as sysdba” or connect / as sysdba
E – net_service_name – $ sqlplus sys/password@net_service_name
F – SET CONTAINER – alter session set container=CDB$ROOT;
From http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm
You can connect to the root in the same way that you connect to a non-CDB. Specifically, you can use the following techniques to connect to the root with the SQL*Plus CONNECT command:
•Local connection
•Local connection with operating system authentication
•Database connection using easy connect
•Database connection using a net service name
•Remote database connection using external authentication
The following prerequisites must be met for the user connecting to the root:
•The user must be a common user.
•The user must be granted CREATE SESSION privilege in the root.
F is incorrect as local user can’t connect to root.
So, the correct answer should be ACDE.
ACDE
A C D and E looks more logical.
https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#ADMIN13608
The following prerequisites must be met for the user connecting to the root:
The user must be a common user.
So, B,F are incorrect.
A. You can conned as a common user by using the connect statement.
The user must be a common user.
C. You can connect by using easy connect.
Database connection using easy connect
D. You can connect by using OS authentication.
Local connection with operating system authentication
E. You can connect by using a Net Service name.
Database connection using a net service name
http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#ADMIN13608
B,F False: Cannot connect as local user
SQL> conn system/oracle
Connected.
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL> conn system/oracle@pdb01
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
SQL> conn system/oracle
Connected.
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL> alter session set container=pdb01;
ERROR:
ORA-65024: Pluggable database PDB01 is not open.
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL>
ACDE
ACDE
ACDE
ACDE
ACDE
F – is incorrect because SET CONTAINER is used when you are already connected to root as common user and then want to switch to one of the PDBs
If you pay attention to the question is asking establishing a connection to root CDB. you can’t directly connect to root CDB using “SET CONTAINER” option.
I have a question.How to distinguish the common user and the local user?
when we startup database with read only mode,the pdbs can not open or open read only.
SQL> startup mount
ORACLE instance started.
Total System Global Area 587202560 bytes
Fixed Size 2927048 bytes
Variable Size 452986424 bytes
Database Buffers 125829120 bytes
Redo Buffers 5459968 bytes
Database mounted.
SQL> alter database open read only;
Database altered.
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 PDB2 MOUNTED
SQL> alter pluggable database pdb1 open;
alter pluggable database pdb1 open
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database or pluggable database open for read-only access
SQL> alter pluggable database pdb1 open read only;
alter pluggable database pdb1 open read only
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database or pluggable database open for read-only access
So,B and F are incorrect.
only common user may have that privilege;
==========
The following prerequisites must be met to use the ALTER SESSION SET CONTAINER statement:
The current user must be a common user. The initial connection must be made using the SQL*Plus CONNECT command.
When altering a session to switch to a PDB as a common user that was not supplied with Oracle Database, the current user must be granted the SET CONTAINER privilege commonly or must be granted this privilege locally in the PDB.
The choice of threading model is dictated by the THREADED_EXECUTION initialization parameter. THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the multiproces model. THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model. OS Authentication is not supported with the multithreaded model. THREADED_EXECUTION When this initialization parameter is set to TRUE, which enables the multithreaded Oracle mode operating system authentication is not supported. Attempts to connect to the database usin operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) whe his initialization parameter is set to TRUE receive an ORA-01031″insufficient privileges” error.
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 4 11:28:16 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
So the D answer is incorrect.
F is wrong – you cannot connect by set container, the connection must already exist. So, ACDE.
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs
Great information. Lucky me I discovered your site by chance (stumbleupon). I’ve book marked it for later!|