默认题库 - 1Z0-052

单选题

In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）

A. By assigning profiles for the users
By implementing Fine-Grained Auditing （FGA）
C. By granting a secure application role to the users
D. By implementing the Database Resource Manager pla

查看答案

单选题

Note the following points describing various utilities in Oracle Database 1g：1. It enables the high-speed transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）

A. 1
B. 2
C. 3
D. 4
E. 1， 2， and 4
F. 1， 2， 3， and 4

查看答案

多选题

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

A. The SKD user cannot log in to the database instance.
B. The objects owned by the SKD user are not accessible to any user.
C. The other users can access the objects owned by the SKD user， on which they have access.
D. The password for the SKD user expires and the user is forced to change the password at the next log i

查看答案

多选题

Which two statements about the background process of the database writer are true（）

A. It is possible to have multiple database writers in an Oracle instance.
B. It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C. It writes dirty buffers， if any， to data files whenever a transaction commits.
D. It writes dirty buffers， if any， to data files before the log writer （LGWR） write

查看答案

单选题

Which is the correct description of a pinned buffer in the database buffer cache（）

A. The buffer is currently being accessed.
B. The buffer is empty and has not been used.
C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process.
D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.

查看答案

单选题

View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）

A. The database instance is running with manual PGA management.
B. The database instance is running with manual shared memory management.
C. The database instance has the MEMORY_TARGET value set to a nonzero value.
D. All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed

查看答案

多选题

Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）

Avoid coding unnecessary long-running transactions.
B. Allow the database to handle locks in default locking mode.
C. Always explicitly code the locks as per the requirement of the application.
D. Allow escalation of row locks to block locks if too many row locks cause problem.

查看答案

单选题

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user； Which statement describes the result（）

A. The command produces an error.
B. The profile is dropped and current user sessions use the DEFAULT profile immediately.
C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D. The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

查看答案

多选题

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

查看答案

多选题

Identify three situations in which you would NOT be able to drop a tablespace. （）

A. when the tablespace is online
B. when the tablespace has segments with data in it
C. when the tablespace is a default permanent tablespace for the database
D. when the tablespace contains a table that is currently being used by transactions
E. when the tablespace contains undo data that is needed to rollback an uncommitted transactio

查看答案