网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）
- A、Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
- B、Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
- C、The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
- D、ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
- E、Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
参考答案
更多 “ A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）A、Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B、Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.C、The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.D、ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E、Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.” 相关考题
考题
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()
A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period
考题
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:SQL @utlrp.sqlWhat is the significance of executing this script?（）A. It performs parallel recompilation of only the stored PL/SQL code.B. It performs sequential recompilation of only the stored PL/SQL code.C. It performs parallel recompilation of any stored PL/SQL as well as Java code.D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
考题
Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)
A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period
考题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC?（）A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayC. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD. Database files stored in ZFS and accessed using conventional NFS mounts.E. Database files stored in ZFS and accessed using the Oracle Direct NFS featureF. Database files stored in any file system and accessed using the Oracle Direct NFS featureG. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
Which of the following database objects can be used to raise an error if a table is updated?()
A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint
考题
The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A、OracleSIDsonlyB、Oracle homes onlyC、Oracle install timestampD、Oracle inventory pointer filesE、Oracle database creation timestampF、OracleSIDsand Oracle homes onlyG、OracleSIDs， Oracle homes and flag for auto startup
考题
Which of the following database objects can be used to raise an error if a table is updated?（）A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint
考题
You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） A、 The audit trail is stored in an operating system file.B、 Auditing is disabled for all privileges.C、 The audit trail is stored in the database.D、 Auditing is enabled for all privileges.E、 Auditing is enabled for certain privileges related to database security.
考题
The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A、OracleSIDsonlyB、Oracle homes onlyC、Oracle install timestampD、Oracle inventory pointer filesE、Oracle database creation timestampF、OracleSIDsand Oracle homes onlyG、OracleSIDs， Oracle homes and flag for auto startup
考题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）A、ASM disk groups with ASM disks consisting of Exadata Grid Disks.B、ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayC、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD、Database files stored in ZFS and accessed using conventional NFS mounts.E、Database files stored in ZFS and accessed using the Oracle Direct NFS featureF、Database files stored in any file system and accessed using the Oracle Direct NFS featureG、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
Which two statements are true about record groups?（）A、They are stored in the database. B、They are stored in local Forms memory. C、The type is specified explicitly at design time. D、The type is implied by when and how it is created.
考题
Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)A、You can use RMAN stored scriptsB、Recovery is faster if data is stored in catalog in addition to the control fileC、You can store backup information of all registered databases in one placeD、Database backups are automatically deleted when they are older than the specified time period
考题
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）A、 You can use RMAN stored scriptsB、 Recovery is faster if data is stored in catalog in addition to the control fileC、 You can store backup information of all registered databases in one placeD、 Database backups are automatically deleted when they are older than the specified time period
考题
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（） A、Execute unit test scripts for each stored procedure in each database.B、Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.C、Set the database compatibility level on the database servers to 80.D、Execute the application user interface test scripts to verify proper operation.
考题
A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A、 Ensure that all statements execute in the same database transaction.B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
考题
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A
The archived redo logs are stored in an operating system-dependent location.B
The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C
The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D
The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
考题
单选题ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created？（）A
It is a list of remote database links stored in the XML file that are available to the users of the database.B
It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.C
It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.D
It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
考题
多选题Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）AMount the container database (CDB) and restore the control file from the control file auto backup.BRecover and open the CDB in NORMAL mode.CMount the CDB and then recover and open the database, with the RESETLOGS option.DOpen all the pluggable databases.ERecover each pluggable database.FStart the database instance in the nomount stage and restore the control file from control file auto backup.
考题
多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）A
You should configure the database for Read Committed Snapshot isolation. B
You should modify the stored procedure to use the Snapshot isolation level C
You should configure the database for Auto Update Statistics asynchronously D
You should modify the stored procedure to use the Repeatable Read isolation level
考题
多选题You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）AEnsure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.BEnsure that the stored procedure and the tables are owned by the same database user.CEnsure that the stored procedure and the tables use the same database schema.DConfigure the multiuser database option on both databases.EConfigure the cross-database ownership chaining option on both databases.
考题
单选题You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）A
SPFILEB
archive logC
control fileD
system tablespace
考题
单选题Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script： SQL @utlrp.sql What is the significance of executing this script？（）A
It performs parallel recompilation of only the stored PL/SQL code.B
It performs sequential recompilation of only the stored PL/SQL code.C
It performs parallel recompilation of any stored PL/SQL as well as Java code.D
It performs sequential recompilation of any stored PL/SQL as well as Java code.
考题
单选题The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A
OracleSIDsonlyB
Oracle homes onlyC
Oracle install timestampD
Oracle inventory pointer filesE
Oracle database creation timestampF
OracleSIDsand Oracle homes onlyG
OracleSIDs， Oracle homes and flag for auto startup
考题
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）A
Implement parameterized Transact-SQL queries in the application.B
Implement Transact-SQL stored procedures in the database.C
Implement CLR stored procedures in the database.D
Implement distributed Web services.
考题
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）A
Implement parameterized Transact-SQL queries in the application. B
Implement Transact-SQL stored procedures in the database. C
Implement CLR stored procedures in the database. D
Implement distributed Web services.
热门标签
最新试卷