Two database users， Jack and Bill， are accessing the Certkiller STAFF table of the Certkiller DB database. When Jack modifies a value in the table， the new value is invisible to Bill. Which is the modified value invisible to Bill？（）

A . The modified data are not available on disk. B . The modified data have been flushed out from memory. C . The modified rows of the Certkiller STAFF table have been locked. D . Jack has not committed the changes after modifying the value. E . Both users are accessing the database from two different machines.

时间：2022-10-26 08:59:29 所属题库：1Z0-042题库

相似题目

You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）

A . Event Viewer gives more details on the failure. B . The alert log file gives detailed information about the failure. C . PMON rolls back the transaction and releases the locks. D . SMON rolls back the transaction and releases the locks. E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

查看最佳答案
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）

A . Do nothing. B . Restart the database. C . Perform recovery on the database. D . Restore the alert log from the last backup.

查看最佳答案
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）

A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

查看最佳答案
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

A . open the database with the RESTRICTED option B . open the database with the RESETLOGS option C . recover to the required SCN only that data file in which the error occurred D . recover all the data files to the same system change number （SCN）

查看最佳答案
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

A . backup of offline tablespaces B . backup of readonly tablespaces C . backup of systemcritical tablespaces D . backup of online， locally managed tablespaces E . backup of read/write dictionarymanaged tablespace

查看最佳答案
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

A . The database must be opened in restricted mode. B . The database must be configured to run in ARCHIVELOG mode. C . The tablespaces are required to be in backup mode before taking the backup. D . The tablespaces are required to be in read-only mode before taking the backu

查看最佳答案
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

A . user managed complete recovery B . user managed incomplete recovery C . RMAN-based complete recovery D . RMAN-based incomplete recovery

查看最佳答案
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

A . The database must be opened in restricted mode. B . The database must be configured to run in ARCHIVELOG mode. C . The tablespaces are required to be in backup mode before taking the backup. D . The tablespaces are required to be in read-only mode before taking the backu

查看最佳答案
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

A . The online redo log files and online data files are opened. B . All the online data file headers are checked for consistency. C . Instance recovery is performed before opening the database. D . The path and existence of all the log file members are checked

查看最佳答案
Which two are true concerning a multitenant container database with three pluggable database?（）

A . All administration tasks must be done to a specific pluggable database. B . The pluggable databases increase patching time. C . The pluggable databases reduce administration effort. D . The pluggable databases are patched together. E . Pluggable databases are only used for database consolidation.

查看最佳答案
Which of the following roles must be granted to a user to perform a full database import？（）

A . CONNECT B . IMP_FULL_DATABASE C . FULL_EXPORT_PRIVS D . RESOURCE E . FULL_IMPORT_PRIVS

查看最佳答案
Which two items does a user object in the UCS system contain?（）

A . Authentication and Authorization credentials B . Microsoft Active Directory credentials C . LDAP assignment D . Role assignment

查看最佳答案
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

A . The database must be opened in restricted mode. B . The database must be configured to run in ARCHIVELOG mode. C . The tablespaces are required to be in backup mode before taking the backup. D . The tablespaces are required to be in read-only mode before taking the backu

查看最佳答案
Which two steps check out a database connection from the connection pool?（）

A . DB Get B . DB Read C . DB Write D . DB Release

查看最佳答案
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

A . Backup of offline tablespaces. B . Backup of read-only tablespaces. C . Backup of system-critical tablespaces. D . Backup of online， locally managed tablespaces. E . Backup of read/write dictionary-managed tablespaces.

查看最佳答案
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）

A . You can perform consistent backups only. B . You can perform a complete database backup without shutting down the database instance. C . You can back up data files only when all data files have the same SCN recorded in the control file. D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command

查看最佳答案
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）https://assets.asklib.com/images/image2/2018080110052310043.jpg

A . A B . B C . C D . D

查看最佳答案
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

A . open the database with the RESETLOGS option B . open the database with the RESTRICTED option C . recover all the data files to the same system change number （SCN） D . recover to the required SCN only that data file in which the error occurred

查看最佳答案
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

A . Data Pump B . Oracle Net Manager C . Oracle Enterprise Manager D . Oracle Universal Installer （OUI） E . Database Configuration Assistant （DBCA）

查看最佳答案
In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

A . the alert log file B . the core dump files C . the change tracking file D . the user session trace files E . the database audit trail files F . the background process trace file

查看最佳答案
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）

A . You can perform consistent backups only. B . You can perform a complete database backup without shutting down the database instance. C . You can back up data files only when all data files have the same SCN recorded in the control file. D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

查看最佳答案
You are connected to a pluggable database （PDB) as a common user with DBA privileges.The S

You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL ＞ ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command？（） A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened. C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted. D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

查看最佳答案
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands？（）

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/fe48cb3c0725d56bce44108ab4437e61.jpg' /> A. They import all metadata from the RCAT10 catalog. B. They unregister the database from the RCAT10 catalog. C. They do not register the databases registered in the RCAT10 catalog. D. They register all databases registered in the RCAT10 catalog.

查看最佳答案
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query？（）

<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' /> A. You obtain the results retrieved from the public synonym HR created by the database administrator. B. You obtain the results retrieved from the HR table that belongs to your schema. C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym. D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product. E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

查看最佳答案

推荐题目