-
web.groovymark@gmail.com
- December 5, 2024
Question 21
The administrator wants to allow a user to connect via a dedicated connection into a database configured in Shared Server mode. Which of the following options accomplishes this?
A) (SERVER=DEDICATED)
B) (CONNECT=DEDICATED)
C) (INSTANCE=DEDICATED)
D) (MULTITHREADED=FALSE)
Correct Answer: A) (SERVER=DEDICATED)
Explanation: To force a dedicated server connection in a shared server environment, the connect string must include the option (SERVER=DEDICATED).
Question 22
In which of the following files would you find the Shared Server configuration parameters?
A) listener.ora
B) mts.ora
C) init.ora
D) tnsnames.ora
E) sqlnet.ora
Correct Answer: C) init.ora
Explanation: The Shared Server configuration parameters exist in the init.ora or the SPFILE on the Oracle Server machine.
Question 23
What is the first step that the dispatcher performs after it receives a request from the user?
A) Pass the request to a shared server.
B) Place the request in a request queue in the PGA.
C) Place the request in a request queue in the SGA.
D) Process the request.
Correct Answer: C) Place the request in a request queue in the SGA.
Explanation: The dispatcher places the user request in the SGA request queue to be processed by a shared server process.
Question 24
When configured in Shared Server mode, which of the following is contained in the PGA?
A) Cursor state
B) Sort information
C) User session data
D) Stack space
E) None of the above
Correct Answer: D) Stack space
Explanation: In a Shared Server environment, most user-specific information is stored in the SGA. Only a small amount of stack space remains in the PGA.
Question 25
Which of the following is false about request queues?
A) They reside in the SGA.
B) They are shared by all the dispatchers.
C) Each dispatcher has its own request queue.
D) The shared server processes remove requests from the request queue.
Correct Answer: C) Each dispatcher has its own request queue.
Explanation: All dispatchers share a single request queue in the SGA, while each dispatcher has its own response queue.
Question 26
What is the process that notifies the listener after a database connection is established?
A) SMON
B) PMON
C) LREG
D) LGWR
Correct Answer: C) LREG
Explanation: The LREG process notifies the listener when a client connection is established. In Oracle versions before 12c, this function was performed by the PMON process.
Question 27
Which network architecture connection uses session memory from the SGA?
A) Dedicated Server
B) Shared Server
C) Database Resident Connection Pooling
D) All of the above
Correct Answer: B) Shared Server
Explanation: In a Shared Server environment, session memory is allocated from the SGA, unlike Dedicated Server connections, where memory is allocated from the PGA.
Question 28
Communication between two Oracle databases is configured using:
A) Database Resident Connection Pooling
B) Database link
C) Connection Manager
D) Oracle Net Manager
Correct Answer: B) Database link
Explanation: A database link enables communication between Oracle databases, allowing access to data from remote databases using a connection string.
Question 29
DBA user MIKE ran the SQL statement CREATE DATABASE LINK SCOTT.SALES_LINK.BJS.COM CONNECT TO SALES_INT IDENTIFIED BY SALESPWD1 USING ‘ocasvr:1522/ocadb’. Choose the option that is true.
A) Use of ‘ocasvr:1522/ocadb’ is invalid in database link definition.
B) A private database link is created under user MIKE.
C) A private database link is created under user SCOTT.
D) If the SALES_INT user does not exist or its password is not SALESPWD1, the database link will not be created.
Correct Answer: B) A private database link is created under user MIKE.
Explanation: The private database link is created under the schema of the user who executes the CREATE DATABASE LINK statement, in this case, MIKE.
Question 30
Which of the following statements create an Oracle account but let the operating system authenticate logons? (Choose two.)
A) create user ops$admin identified by os;
B) create user ops$admin identified externally;
C) create user ops$admin nopassword;
D) create user ops$admin authenticated by os;
Correct Answer: A, B) create user ops$admin identified by os; create user ops$admin identified externally.
Explanation: Oracle supports external authentication through the operating system by using the ops$ prefix and specifying identified externally.
Question 31
If you want to capture the SQL statement and bind variables when performing a standard statement audit, which value should the AUDIT_TRAIL parameter have?
A) NONE
B) DB
C) DB,EXTENDED
D) OS
E) OS,EXTENDED
Correct Answer: C) DB,EXTENDED
Explanation: The DB,EXTENDED setting for AUDIT_TRAIL captures SQL statements and bind variables during audits.
Question 32
Which of the following statements give user desmond the ability to alter table gl.accounts?
A) grant alter on gl.accounts to desmond;
B) grant alter to desmond on gl.accounts;
C) grant alter table to desmond;
D) allow desmond to alter table gl.accounts;
Correct Answer: A) grant alter on gl.accounts to desmond.
Explanation: The correct syntax for granting the ALTER privilege on a specific table is grant alter on gl.accounts to desmond.
Question 33
Which of the following statements has the correct syntax and gives the ability to grant the privilege to other users?
A) grant alter any table with grant option to desmond;
B) grant alter on gl.accounts to desmond with admin option;
C) grant alter any table to desmond with grant option;
D) grant alter any table to desmond with admin option;
Correct Answer: D) grant alter any table to desmond with admin option.
Explanation: The correct syntax for granting a system privilege with the ability to grant it to others is to use with admin option.
Question 34
Examine the CREATE USER statement and choose which of the following options best applies.
A) JOHN will not be able to log in to the database using SQL Plus until the DBA changes his password.
B) JOHN is authenticated by the database.
C) When tables are being created, if JOHN did not specify the TABLESPACE clause, the table will be created on the DATA01 tablespace.
D) Specifying unlimited space quota on INDEX01 is a redundant step because INDEX01 is JOHN’s default tablespace.
Correct Answer: B) JOHN is authenticated by the database.
Explanation: The user JOHN is authenticated by the database based on the password specified in the CREATE USER statement.
Question 35
User system granted the SELECT privilege on sh.products to user ian using WITH GRANT OPTION. Ian then granted SELECT on sh.products to user stuart. Ian has left the company, and his account has been dropped. What happens to Stuart’s privileges on sh.products?
A) Stuart loses his SELECT privilege on sh.products.
B) Stuart retains his SELECT privilege on sh.products.
C) Stuart loses his SELECT privilege if Ian was dropped with the CASCADE REVOKE option.
D) Stuart retains his SELECT privilege if Ian was dropped with the NOCASCADE REVOKE option.
Correct Answer: A) Stuart loses his SELECT privilege on sh.products.
Explanation: When object privileges are granted through an intermediary, they are revoked when the intermediary is dropped.
Question 36
User system granted the SELECT ANY TABLE privilege to user ian using WITH ADMIN OPTION. Ian then granted SELECT ANY TABLE to user stuart. Ian has left the company, and his account has been dropped. What happens to Stuart’s privileges?
A) Stuart loses his privileges.
B) Stuart retains his privileges.
C) Stuart loses his privileges if Ian was dropped with the CASCADE REVOKE option.
D) Stuart retains his privileges if Ian was dropped with the NOCASCADE REVOKE option.
Correct Answer: B) Stuart retains his privileges.
Explanation: System privileges are not affected by the removal of the user who granted them.
Question 37
Which of the following system privileges should be granted judiciously because they can allow the grantee to masquerade as another user?
A) CREATE ANY JOB
B) ALTER USER
C) CREATE ANY PROCEDURE
D) All of the above
Correct Answer: D) All of the above
Explanation: These system privileges allow actions that can be exploited to execute code or impersonate other users.
Question 38
Which of the following statements enables the role user_admin in the current session?
A) alter session enable role user_admin;
B) alter session set role user_admin;
C) alter role user_admin enable;
D) set role user_admin;
Correct Answer: D) set role user_admin;
Explanation: The set role statement is used to enable roles within the current session.
Question 39
Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar that has been granted to him?
A) set role all;
B) alter user augustin default role all;
C) alter session enable role info_czar;
D) alter session enable info_czar identified by brozo;
Correct Answer: B) alter user augustin default role all.
Explanation: Specifying a role as a default role allows it to be used without explicitly setting it in the session.
Question 40
By default, how much space can any account use for a new table?
A) None
B) Up to the current free space in the tablespace
C) Unlimited space, including autoextends
D) Up to the default quota established at tablespace creation time
Correct Answer: A) None
Explanation: By default, new user accounts do not have any space quota in tablespaces until a quota is explicitly assigned.
