View the Exhibit. You are creating an additional database by using the Database Configuration Assistant(DBCA). You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled.
What could be the reason for this()
A.You have chosen the File System option as the storage option.
B.You have chosen the Automatic Storage Management (ASM) as the storage option.
C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
D.You are using General Purpose template and not the Custom Database template to create the database
您可能感兴趣的试卷
你可能感兴趣的试题
A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported
A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the onlineredo log files
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;
Which two statements are true()
A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked
A.When the data file of the undo tablespace is autoextensible
B.When there are more than one undo tablespaces available in the database
C.When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.When the undo tablespace is autoextensible and retention guarantee is not enabled
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()
A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too old
What could be the reason for this error()
A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace
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()
A.The command executes successfully.
B.The command produces an error because the EMP table is owned by SCOTT.
C.The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
D.The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can see theeffect of the UPDATE and DELETE commands()
A.All sessions of the HR user only
B.All sessions of the HR user and the SYS user
C.The session of the HR user that executed the commands
D.All the sessions for which the database users have access privilege to the PERSONS table
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()
A.Flashback log files
B.Backups that have become obsolete
C.User managed backups of the data files and control files
D.Archived redo log files that have multiple copies in a different archive location and not backed up
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()
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management
最新试题
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant(DBCA). You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this()
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()
Which statements are true about checkpointing()
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 statements are true regarding a tablespace()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
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()
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()
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
Identify the situations in which you use the alert log file in your database to check the detail.()