You are using Enterprise Manager to schedule backups for your database.
Which type of script would begenerated by the backup scheduler()
A.XML script
B.PL/SQL script
C.Operating system scriptThis document was downloaded from =>> http://www.amaderforum.com
D.Recovery Manager (RMAN) script
您可能感兴趣的试卷
你可能感兴趣的试题
in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting()
A.Optimizer statistics are collected automatically.
B.Only timed operating system (OS) statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
You execute the following command to audit database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command()
A.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
Which statements listed below describe the data dictionary views()
1) These are stored in the SYSTEM tablespace.
2) These are the based on the virtual tables.
3) These are owned by the SYS user.
4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE.
5) The V$FIXED_TABLE view can be queried to list the names of these views.
A.1 and 3
B.2, 3, and 5
C.1, 2, and 3
D.2, 3, 4, and 5
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.
Which constraints will remain enabled by default during this operation()
A.CHECK
B.UNIQUE
C.NOT NULL
D.PRIMARY KEY
E.FOREIGN KEY
Observe the information in the columns:
1. The SGA a. Text and parsed forms of all SQL statements
2. The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved
3. User-session data c. Security and resource usage information
4. The stack space d. Local variables for the process
Which option has the correct match between the memory areas and their contents()
A.1-c, 2-b, 3-d, 4-a
B.1-b, 2-c, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
Identify the memory component from which memory may be allocated for:()
1. Session memory for the shared server
2. Buffers for I/O slaves
3. Oracle Database Recovery Manager (RMAN) backup and restore operations
A.Large Pool
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area (PGA)
In your database instance, the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users:
1. The user account must be locked after four unsuccessful login attempts.
2. The user must be prompted to change the password at regular intervals.
3. The user may not have more than three simultaneous sessions.
4. The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above()
A.By assigning profiles for the users
B.By implementing Fine-Grained Auditing (FGA)
C.By granting a secure application role to the users
D.By implementing the Database Resource Manager plan
Note the following points describing various utilities in Oracle Database 1g:1. It enables the high-speed transfer of data from one database to another.
2. It provides a complete solution for the backup, restoration, and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup()
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
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
最新试题
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command()
Which statement is true about loading data using the conventional path of SQL*Loader()
Which statements are true regarding listeners()
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted()
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()
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
Which statements are true regarding the Oracle Data Pump export and import operations()
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output()
In a new installation of Oracle Database 11g, you perform these activities:1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed()