Category «1Z0-041»

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 …

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

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 …

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 …

How do you access the Oracle Enterprise Manager Database Control on a host, myhost…

How do you access the Oracle Enterprise Manager Database Control on a host, myhost, in the domain, oracle.com, that uses the default port, from a client browser? A. Open a browser window and type the URL: http://myhost.oracle.com/em. B. Open a browser window and type the URL: http://myhost.oracle.com:1521/em. C. Open a browser window and type the …

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 …