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.
时间:2024-01-18 11:15:11
-
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.
-
You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct?()
A . Undo data becomes obsolete after 1,000 seconds.
B . Undo data gets refreshed after 1,000 seconds.
C . Undo data will be stored permanently after 1,000 seconds.
D . Committed undo data would be retained for 1,000 seconds if free undo space is available.
E . Undo data will be retained in the UNDOtablespacefor 1,000 seconds, then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.
-
A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters. How should the administrator configure the disks?()
A . Run 'mkdev' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.
B . Run 'mkpath' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.
C . Run 'chpath' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.
D . Run 'cfgmgr' to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run 'cfgmgr' to discover and configure the disks.
-
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?()
A . control file
B . password file
C . listener controller file
D . control file and password file
-
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.
-
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
A . Set the UNDO_RETENTION parameter to AUTO.
B . Create an initial undo segment in undotablespace.
C . Set the UNDO_RETENTION parameter to 900 or more
D . Set the initialization parameter UNDO_MANAGEMENT to AUTO
E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
-
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
A . All control files are opened
B . All redo files are opened
C . The password file is opened
D . The parameter file is opened
E . All online data files are opened
-
You work as a database administrator for Certkiller .com. While granting a role,SELECT_CATALOG_ROLE, to a user, Certkiller, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?()
A . The user cannot use the role at all.
B . The role would not be granted to the user.
C . The user needs to enable the role explicitly.
D . The user can start using the role immediately.
E . The user would have the admin option for the role.
-
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: $ rman target / What would be the effect of this command?()
A . RMAN would use the current operating system location to place the backup.
B . RMAN would use the control file of the target database to maintain the backup.
C . RMAN would use the recovery catalog of the target database to maintain the backup.
D . RMAN would use the control file of the target database to maintain the backup metadata.
E . RMAN would use the recovery catalog of the target database to maintain the backup metadata.
-
You need to ensure that the network administrators are able to administer the NewApp database servers. Which two actions should you perform?()
A . Create an organizational unit (OU) for all users who log on to any of the NewApp servers.
B . Create an organizational unit (OU) named NewApp Users for the NewApp users.
C . Create an organizational unit (OU) named NewApp Servers for the NewApp servers.
D . Create a Group Policy object (GPO) for the NewApp Users OU to enforce the use of IPSec.
E . Create a global group for all NewApp servers. Add this group to the NewApp Servers OU.
F . Create a Group Policy object (GPO) for the NewApp Servers OU to enforce the use of smart cards.
-
You work as a database administrator for Supportcenter.cn. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
A . PMON coordinates media recovery.
B . SMON coordinates instance recovery.
C . PMON coordinates instance recovery.
D . Undo Advisor would roll back all uncommitted transactions.
E . SQL*PLUS reports an error with the message asking you to perform instance recovery.
-
An administrator wants to delete an account object using the Database Cleanup utility. Which of the following is the correct syntax to perform this task?()
A . dbclean -object account -type obsolete -db dbname -days daysold
B . dbclean -table account -type obsolete -db dbname -days daysold
C . dbclean -object organization -type account -db dbname -days daysold
D . dbclean -object user -type account -db dbname -days daysold
-
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
A . The DBWn process writes to the datafile.
B . Changes in the background process are recorded.
C . The log file is updated with the current SCN number.
D . The System Change Number (SCN) is recorded in the control file.
E . The changes to the listener configuration in the listener.ora file are recorded.
-
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()
A . Password file
B . Initialization file
C . Datafile
D . Control file
E . Nothing - SYSDBA privileges are not required for these actio
-
You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()
A . It degrades the run time and compiler performance.
B . It provides better run time and compiler performance.
C . It provides better optimization of the statement during parse time.
D . It forces the rule based optimizer to be used for statement optimization.
E . It provides better run time performance but slightly degraded compiler performance.
F . It provides better run time performance but slightly degraded run time performance.
-
You work as a database administrator for Supportcenter.cn. While granting a role, SELECT_CATALOG_ROLE, to a user, SupportCenter, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?()
A . The user cannot use the role at all.
B . The role would not be granted to the user.
C . The user needs to enable the role explicitly.
D . The user can start using the role immediately.
E . The user would have the admin option for the role.
-
A system administrator needs to upgrade the Oracle database from Version 7 to Version 8. Which of the following scheduling concerns should be considered?()
A . Schedule enough down time to backup, upgrade and reboot.
B . Backup, upgrade, then schedule enough down time to reboot the system.
C . Backup, then schedule enough down time to upgrade and reboot the system.
D . There are no scheduling concerns because no down time is required.
-
A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters. How should the administrator configure the disks?()
A . Run ’mkdev’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
B . Run ’mkpath’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
C . Run ’chpath’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
D . Run ’cfgmgr’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
-
When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?()
A . the query transaction rate
B . numeric data versus character data
C . extent size
D . the cardinality of the candidate columns
E . prefetch size&e
-
You work as a database administrator for Certkiller .com. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
A . PMON coordinates media recovery.
B . SMON coordinates instance recovery.
C . PMON coordinates instance recovery.
D . Undo Advisor would roll back all uncommitted transactions.
E . SQL*PLUS reports an error with the message asking you to perform instance recovery.&e
-
You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old In which situation would you receive such an error?()
A . You performed rollback after commit.
B . If a log switch occurs in your database.
C . Thearchiverfails to generate an archived log file.
D . Instance recovery fails to find one of the redo log files.
E . A long-running query is unable to get read-consistent image.
F . If you perform manual undo management operations in auto mode.
-
An administrator determines that performance has degraded for a WebSphere Commerce database. Which of the following steps should be performed to correct this problem?()
A . Cleanup obsolete data
B . Clear the WebSphere Commerce cache
C . Enable WebSphere Commerce Accelerator
D . Reindex the database tables
E . Run Performance Monitor to monitor SQL statement
-
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
A . Execute the ALTER DATABASE ARCHIVELOG statement
B . Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C . Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D . Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
-
A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters.How should the administrator configure the disks?()
A.Run ‘mkdev‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks.
B.Run ‘mkpath‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks.
C.Run ‘chpath‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks.
D.Run ‘cfgmgr‘ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ‘cfgmgr‘ to discover and configure the disks.