You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()
Which three statements are true regarding the data types in Oracle Database 10g/11g?()
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?()
You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?()
ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? ()
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?()
An existing cluster has an application node and database node. Changes in the application require both nodes to have access to the other’s data all of the time. Which facility managed by HACMP can be implemented with the least amount of impact?()
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()
Records from the data dictionary information are stored in which of the following database memory areas?()
An application connects to a SQL Azure database. The application occasionally loses the connection to the SQL Azure database. You need to recommend an approach for reliably completing data access operations. What should you recommend?()
You need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center. What should you do?()
Your database is in the NOARCHIVELOG mode. Since last night’s offline backup, the logs in group 1 have been written to twice. This morning, the SYSTEM data file has become corrupted. Up to what point can it be recovered?()
What should you set the Client Configuration to when configuring the ODBC Data Source for the Database Subsystem?()
Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do?()
A product manager has prepared catalog data using a spreadsheet and has exported the data to a file in CSV format. What is the correct sequence to execute the Loader Package tools to import the data into the WebSphere Commerce database?()
Examine the command: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; What does the command accomplish?()
Note the following structures in your database server: 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN> BACKUP DATABASE FILESPERSET 2;The database has seven data files.Why is the %_COMPLETE refreshed to 13.59 in the third output afterreaching 88.77?()