WGU D330 (questions well answered to pass)
updated
1. DBA user MIKE ran the SQL
state- ment B. A private database link is created under user
MIKE.
CREATE DATABASE LINK
SCOTT.SALES_LINK .BJS.COM Private database links are created under the user
CON- NECT TO SALES_INT
IDENTI- who ex- ecutes the CREATE DATABASE LINK
FIED BY SALESPWD1 USING statement. You cannot create a database link under
'ocasvr:1522/ ocadb'. another schema. A link by the name
SCOTT.SALES_LINK.BJS.COM is created under
Choose the option that is true. schema MIKE. You can use the Easy Connect
syntax or the Oracle Net connect syntax, or you
can resolve the alias name by using tnsnames.ora
in the USING clause. During database link
creation, a connection is not made
A. to the target database to validate the connection or
cre-
Use of 'ocasvr:1522/ocadb' is in-
valid in database link definition. dentials.
B.A private database link is
creat- ed under user MIKE.
C.A private database link is
creat- ed under user SCOTT.
D. If the SALES_INT user does not
exist or its password is not
SALESP- WD1, the database link
will not be created.
2. Which of the following statements A. create user ops$admin identified by os;
create an Oracle account but let
the operating system authenticate B. create user ops$admin identified externally;
logons? (Choose two.) identi- fied by os;
A. create user ops$admin
,WGU D330 (questions well answered to pass)
updated
Authentication by the operating system is called
external authentication, and the Oracle account
name must match the operating-system account
name prefixed with the OS_AUTHENT_PREFIX
string. When a user is created with
, WGU D330 (questions well answered to pass)
updated
B. create user ops$admin the OS_AUTHENT_PREFIX string, the password
identi- fied externally;
provided in option A is ignored, and the user is
C. create user ops$admin created as exter- nally authenticated.
nopass- word;
D. create user ops$admin
authen- ticated by os;
3. If you want to capture the
SQL statement and bind
vari- C. DB,EXTENDED
ables when performing a stan-
dard statement audit, which
value should the AUDIT_TRAIL The AUDIT_TRAIL parameter with the value
parame- ter have? DB,EXTENDED enables you to capture SQL
statements and bind vari- ables in auditing.
A. NONE
OS,EXTENDED is not a valid value for
B. DB AUDIT_TRAIL.
C. DB,EXTENDED
D. OS
E. OS,EXTENDED
4. Which of the following statements A. grant alter on gl.accounts to desmond;
give user desmond the ability to
alter table gl.accounts? Altering a table in another user's schema requires
either the object privilege ALTER on that object or
A. grant alter on gl.accounts
to desmond; the system privilege ALTER ANY TABLE. Option A has
the correct syn- tax for granting the object privilege
on ALTER gl.accounts
B. grant alter to desmond on gl.ac- to user desmond. The alter table privilege in option
C is
counts; D. allow desmond to alter table
gl.accounts;
C. grant alter table to
desmond;
updated
1. DBA user MIKE ran the SQL
state- ment B. A private database link is created under user
MIKE.
CREATE DATABASE LINK
SCOTT.SALES_LINK .BJS.COM Private database links are created under the user
CON- NECT TO SALES_INT
IDENTI- who ex- ecutes the CREATE DATABASE LINK
FIED BY SALESPWD1 USING statement. You cannot create a database link under
'ocasvr:1522/ ocadb'. another schema. A link by the name
SCOTT.SALES_LINK.BJS.COM is created under
Choose the option that is true. schema MIKE. You can use the Easy Connect
syntax or the Oracle Net connect syntax, or you
can resolve the alias name by using tnsnames.ora
in the USING clause. During database link
creation, a connection is not made
A. to the target database to validate the connection or
cre-
Use of 'ocasvr:1522/ocadb' is in-
valid in database link definition. dentials.
B.A private database link is
creat- ed under user MIKE.
C.A private database link is
creat- ed under user SCOTT.
D. If the SALES_INT user does not
exist or its password is not
SALESP- WD1, the database link
will not be created.
2. Which of the following statements A. create user ops$admin identified by os;
create an Oracle account but let
the operating system authenticate B. create user ops$admin identified externally;
logons? (Choose two.) identi- fied by os;
A. create user ops$admin
,WGU D330 (questions well answered to pass)
updated
Authentication by the operating system is called
external authentication, and the Oracle account
name must match the operating-system account
name prefixed with the OS_AUTHENT_PREFIX
string. When a user is created with
, WGU D330 (questions well answered to pass)
updated
B. create user ops$admin the OS_AUTHENT_PREFIX string, the password
identi- fied externally;
provided in option A is ignored, and the user is
C. create user ops$admin created as exter- nally authenticated.
nopass- word;
D. create user ops$admin
authen- ticated by os;
3. If you want to capture the
SQL statement and bind
vari- C. DB,EXTENDED
ables when performing a stan-
dard statement audit, which
value should the AUDIT_TRAIL The AUDIT_TRAIL parameter with the value
parame- ter have? DB,EXTENDED enables you to capture SQL
statements and bind vari- ables in auditing.
A. NONE
OS,EXTENDED is not a valid value for
B. DB AUDIT_TRAIL.
C. DB,EXTENDED
D. OS
E. OS,EXTENDED
4. Which of the following statements A. grant alter on gl.accounts to desmond;
give user desmond the ability to
alter table gl.accounts? Altering a table in another user's schema requires
either the object privilege ALTER on that object or
A. grant alter on gl.accounts
to desmond; the system privilege ALTER ANY TABLE. Option A has
the correct syn- tax for granting the object privilege
on ALTER gl.accounts
B. grant alter to desmond on gl.ac- to user desmond. The alter table privilege in option
C is
counts; D. allow desmond to alter table
gl.accounts;
C. grant alter table to
desmond;
