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 executed this command to change the size of the database buffer cache:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;
System altered. To verify the change in size, you executed this command:SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE
------------------- ----------- ------------------ db_cache_size big integer 4194304
Why is the value set to 4194304 and not to 2516582()
A.Because 4194304 is the granule size
B.Because 4194304 is the standard block size
C.Because 4194304 is the largest nonstandard block size defined in the database
D.Because 4194304 is the total size of data already available in the database buffer cache
You notice that the performance of the database has degraded because of frequent checkpoints.
Which twoactions resolve the issue()
A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.
Examine the command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are true after the command is executed()
A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user, on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in
You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.
Which option of IMPDP would you use to accomplish this task()
A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is trueabout the output of the command()
A.The backup piece is expired as the new backup is available.
B.The backup piece is expired because the operating-system file was not found.
C.The backup piece is expired because the retention period for the backup has expired.
D.The backup piece is expired because the backup set to which it belongs is not complete
View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN sessionfor the database. To repair the failure, you executed the following command as the first RMAN command:RMAN>REPAIR FAILURE;
Which statement describes the consequence of this command()
A.The command performs the recovery and closes the failure.
B.The command only displays the advice and the RMAN script required for recovery.
C.The command executes the RMAN script to repair the failure and remove the entry from the AutomaticDiagnostic Repository (ADR).
D.The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command
Examine the following output:
SQL> SELECT index_name,status FROM dba_indexes WHERE status=’UNUSABLE’; INDEX_NAME STATUS------------------------------ -----------
EIND UNUSABLE
Which two statements about the above index are true()
A.It is ignored by the query optimizer.
B.It is not used while the index is being rebuilt.
C.The index cannot be rebuilt, and has to be re-created.
D.The index is automatically rebuilt when used the next time
View the Exhibit. Which statements are true regarding the USERS tablespace()
A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated
最新试题
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()
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()
Which statements are true about logical structures of the Oracle database()
Which statements are true regarding listeners()
Identify the situations in which you use the alert log file in your database to check the detail.()
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()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
Examine the command that is used to create a table:SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command()
Which kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()
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()