You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error()
A.The MTTR Advisor is disabled.
B.The database is in NOARCHIVELOG mode.
C.The tablespace is already in backup mode.
D.The Flash Recovery Area is not configured
您可能感兴趣的试卷
你可能感兴趣的试题
The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the primary key.As part of the archival process, the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products, the company deals with many new products during every quarter.
Whichmethod is best suited for this quarterly data transfer()
A.Using the MERGE command
B.Using the SQL*Loader utility
C.Using the correlated UPDATE command
D.Using the INSERT command to perform bulk operation
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) writes
To make audit information more productive, the DBA executes the following command before starting an auditoperation:
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase()
A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it
View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while
configuring the storage you find that the block size that you can provide is only 8 KB.
Which configuration couldhave enabled the block selection of 16 KB()
A.Choosing the extent allocation type to uniform
B.Choosing the Segment Space Management option to manual
C.Setting autoextension on for the data file mentioned for the tablespace
D.Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database:
1. SGA is allocated.
2. Control file is read.
3. Redo log files are read.
4. Instance recovery is started.
5. Background processes are started.
6. Data files are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur()
A.7, 1, 5, 2, 3, 6, 4
B.1, 2, 3,7, 5, 6, 4
C.7, 1, 4, 5, 2, 3, 6
D.1, 7, 5, 4, 2, 3, 6
The instance abnormally terminates because of a power outage.
Which statement is true about redo log filesduring instance recovery()
A.Inactive and current redo log files are required to accomplish recovery.
B.Online and archived redo log files are required to accomplish instance recovery.
C.All redo log entries after the last checkpoint are applied from redo log files to data files.
D.All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
Examine the command:
SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’);
Which statementdescribes the effect of the above command()
A.Automatic statistics collection is stopped for the CUSTOMERS table.
B.Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C.Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D.Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics
You are installing Oracle Database 11g on a machine. When you run the installer, the Oracle Universal Installer(OUI) shows the message that says one of the product-specific prerequisite checks has failed:Checking available swap space requirements ...Expected result: 1512MBActual Result: 1018MB
Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have therequired swap space.
What happens to the installation in this situation()
A.It can be continued.
B.It resizes the swap space automatically when you proceed further.
C.It can be continued, but the instance cannot be started without increasing the swap space.
D.It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI)
prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.
Which statement is true in this case()
A.The ORACLE_BASE parameter is not set.
B.The installation is being performed by the root user.
C.The operating system group that will be specified should have root user as its member.
D.The installation is being performed without the "Create Starter Database" option selected.
E.The operating system group that will be specified must have permission to write to the inventory directory
You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
method would you use to restrict enabling of such roles()
A.Create the role with external authentication.
B.Create the role as a secure application role.
C.Create the role as a password-protected role.
D.Create a role and use Fine-Grained Access Control (FGAC) to secure the role
最新试题
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
Which statements are true about checkpointing()
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()
Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements aretrue regarding the above command()
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable:ERROR at line 1:ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario()
Which statement is true about loading data using the conventional path of SQL*Loader()
Which statements are true about logical structures of the Oracle database()
You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()