Which two options can be the next step?

A role, CON_RES, having all the privileges of the CONNECT and the RESOURCE database roles has to be created. As the first step, the CON_RES role is created like the CONNECT role.Which two options can be the next step? (Choose two.) A.Grant the role CON_RES to CONNECT. B.Grant the role CON_RES to RESOURCE. C.Modify the […]

Read More

Which five options correctly map an Oracle command with its category?

Which five options correctly map an Oracle command with its category? (Choose five.) A.ALTER: data control language B.GRANT: data control language C.ROLLBACK: transaction control D.CREATE: data definition language E.DROP: data manipulation language F.SAVEPOINT: data control language G.INSERT: data manipulation language H.UPDATE: data manipulation language I.TRUNCATE: data manipulation language Show Answer

Read More

Which four methods are used to increase the storage capacity of a database?

Which four methods are used to increase the storage capacity of a database? (Choose four.) A.Create a new tablespace. B.Increase the size of the extents. C.Increase the size of the segments. D.Increase the size of a datafile manually. E.Add a datafile to an existing tablespace. F.Provide for dynamic growth of a datafile. G.Increase the space […]

Read More

Which two environment variables have their correct functionality listed next to them?

Which two environment variables have their correct functionality listed next to them? (Choose two.) A.ORACLE_SID: specifies the instance name B.ORACLE_SID: specifies the global database name C.ORACLE_BASE: specifies the Oracle home directory D.ORACLE_HOME: specifies the home directory of user oracle E.ORACLE_HOME: specifies the location of oraInventory directory F.ORACLE_BASE: specifies the Oracle directory structure for Optimal Flexible […]

Read More

Which three statements regarding the listener are correct?

Which three statements regarding the listener are correct? (Choose three.) A.It resides on the client machine. B.It stores the client configuration files. C.It maps the net service name to connect descriptor. D.Its configuration details are stored in the listener.ora file. E.It can be configured with one or more listening protocol addresses. F.It is a process […]

Read More

What type of backup is created when this backup strategy is implemented?

Examine the following features of a backup strategy:The backup operation is performed when the instance is shut down. All the changes in the redo logs have been applied to the datafiles. The database can be opened immediately after the restore operation. What type of backup is created when this backup strategy is implemented? A.whole backup […]

Read More

Which three Oracle tools have their correct uses listed next to them?

Which three Oracle tools have their correct uses listed next to them? (Choose three.) A.Oracle Net Manager: to configure a listener B.SQL*Loader: to load data into database tables C.Database Configuration Assistant (DBCA): to create new database users D.Database Upgrade Assistant: to provide a complete solution for the restoration and recovery of the database E.Oracle Universal […]

Read More

Which three statements are correct regarding roles?

Which three statements are correct regarding roles? (Choose three.) A.You can grant a role to another role. B.You can authenticate a role with a password. C.You cannot grant a role to more than five users. D.You can grant system privileges as well as object privileges to a role. E.Only the database users with the DBA […]

Read More