A.Each segment contains one or more extents.
B.Multiple tablespaces can share single data file.
C.A data block is the smallest unit of I/O for data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one OS block.
您可能感兴趣的试卷
你可能感兴趣的试题
A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.
D.The tablespacelevel logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.
A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E.number of free blocks in the free list
F.number of extents present in the table
The following are the details of your database:
Instance name:test
Host name:tech1.us.oracle.com
IP address:145.33.230.186
Enterprise Manager Console HTTP Port number:5500
You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()
A.http://145.33.230.186:5500/em
B.http://www.145.33.230.186:5500/em
C.http://tech1.us.oracle.com:5500/em
D.http://test.145.33.230.186:5500/em
E.http://test.tech1.us.oracle.com:5500
F.http://www.tech1.us.oracle.com:5500/em
G.http://test.tech1.us.oracle.com:5500/em
A.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual
When you try to open your database, you receive the following error: ORA-00205: error in identifying control file
Where would you find the details required to resolve this error?()
A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer
A.execute the command, ALTER SESSION KILL .., to kill the blocking session
B.execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
C.execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking session
D.execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking session
E.execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session
A.ORA_PATH
B.ORACLE_SID
C.ORACLE_BASE
D.ORACLE_HOME
E.LD_LIBRARY_PATH
While setting up the database for your production environment, you want to create a user with following requirements.
1.The objects created by the user must be stored in a tablespace, TBS1, if the TABLESPACE option is not defined during the object creation.
2.The user should be able to use 10MB of space in the tablespace TBS1.
3.The user must change the password immediately after logging in for the first time.
Which three options of the CREATE USER command would you use to achieve this objective?()
A.profile
B.account lock
C.account unlock
D.password expire
E.quota 10MB on TBS1
F.password never expire
G.default tablespace TBS1
H.quota unlimited on TBS1
I.temporary tablespace TEMP
J.temporary tablespace SYSTEM
A.no profiles
B.the default profile
C.same as the profile of SYS user
D.same as the profile of SYSTEM user
最新试题
Which three statements are true regarding the finegrained auditing (FGA)?()
When you try to open your database, you receive the following error: ORA-00205: error in identifying control file Where would you find the details required to resolve this error?()
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.Which action would you consider to overcome the performance degradation?()
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command?()