WGU - D192 questions with verified answers
A company plans to use Data Guard SQL Apply to migrate a database to Oracle
12c. Which type of upgrade does this tool perform? Ans✓✓✓-Rolling
A database administrator needs to recover unused space from a tablespace while
preventing data loss. What should the administrator use? Ans✓✓✓-The SHRINK
option
A database link named wgu2021 has been created to link to a remote object in
the test database. The object is named employee and is owned by Scott. Which
reference resolves to the remote object? Ans✓✓✓-scott.employee@wgu2021
A database will be migrated to a platform that has a different endianness. Which
action must be performed on the data files before the migration? Ans✓✓✓-
Convert by using Recovery Manager
A user creates a role granting select and update access to table1, and assigns the
role to a coworker. The next day the user revokes select access from the role.
Which actions will the coworker still be able to perform on table1? Ans✓✓✓-
Modify
A user needs to view the table privileges of other users. Which role should be
granted to the user? Ans✓✓✓-SELECT_CATALOG_ROLE
After an administrator granted some privileges to a user, all database users
automatically had those same privileges. Which user was assigned the privileges?
Ans✓✓✓-PUBLIC
, An administrator attempts to roll back a transaction from the previous day. The
rollback attempt fails. Which action will prevent the failure from recurring?
Ans✓✓✓-Enabling the retention guarantee
An administrator creates a user profile that forces a change to the user's
password at the first login. Which clause did the administrator include in the
create user statement? Ans✓✓✓-PASSWORD EXPIRE
An administrator plans to use SQL*Loader to import a data file using a fixed-width
format. Which file must be configured before importing the file? Ans✓✓✓-
Control
An administrator runs the following SQL statements: CREATE USER HR_User
IDENTIFIED BY 'Password' DEFAULT TABLESPACE DATA; GRANT CREATE SESSION,
CREATE TABLE to HR_User; HR_User creates a new table in their own schema.
What happens when HR_User inserts a row into the new table? Ans✓✓✓-The
insert fails with an error for missing privileges on the DATA tablespace.
An administrator starts a database and initiates instance recovery. Which type of
files can be recovered? Ans✓✓✓-Data
An administrator wants to limit CPU time for accounts. Which object should the
administrator alter? Ans✓✓✓-Profile
Given the following SQL statement: DROP USER User1 CASCADE; What happens
to tables that User1 owns when an administrator runs the SQL statement?
Ans✓✓✓-Tables and the data are deleted from the database.
A company plans to use Data Guard SQL Apply to migrate a database to Oracle
12c. Which type of upgrade does this tool perform? Ans✓✓✓-Rolling
A database administrator needs to recover unused space from a tablespace while
preventing data loss. What should the administrator use? Ans✓✓✓-The SHRINK
option
A database link named wgu2021 has been created to link to a remote object in
the test database. The object is named employee and is owned by Scott. Which
reference resolves to the remote object? Ans✓✓✓-scott.employee@wgu2021
A database will be migrated to a platform that has a different endianness. Which
action must be performed on the data files before the migration? Ans✓✓✓-
Convert by using Recovery Manager
A user creates a role granting select and update access to table1, and assigns the
role to a coworker. The next day the user revokes select access from the role.
Which actions will the coworker still be able to perform on table1? Ans✓✓✓-
Modify
A user needs to view the table privileges of other users. Which role should be
granted to the user? Ans✓✓✓-SELECT_CATALOG_ROLE
After an administrator granted some privileges to a user, all database users
automatically had those same privileges. Which user was assigned the privileges?
Ans✓✓✓-PUBLIC
, An administrator attempts to roll back a transaction from the previous day. The
rollback attempt fails. Which action will prevent the failure from recurring?
Ans✓✓✓-Enabling the retention guarantee
An administrator creates a user profile that forces a change to the user's
password at the first login. Which clause did the administrator include in the
create user statement? Ans✓✓✓-PASSWORD EXPIRE
An administrator plans to use SQL*Loader to import a data file using a fixed-width
format. Which file must be configured before importing the file? Ans✓✓✓-
Control
An administrator runs the following SQL statements: CREATE USER HR_User
IDENTIFIED BY 'Password' DEFAULT TABLESPACE DATA; GRANT CREATE SESSION,
CREATE TABLE to HR_User; HR_User creates a new table in their own schema.
What happens when HR_User inserts a row into the new table? Ans✓✓✓-The
insert fails with an error for missing privileges on the DATA tablespace.
An administrator starts a database and initiates instance recovery. Which type of
files can be recovered? Ans✓✓✓-Data
An administrator wants to limit CPU time for accounts. Which object should the
administrator alter? Ans✓✓✓-Profile
Given the following SQL statement: DROP USER User1 CASCADE; What happens
to tables that User1 owns when an administrator runs the SQL statement?
Ans✓✓✓-Tables and the data are deleted from the database.
