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
You are connecting to an Oracle database server from a client by using the following connect string:
SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb
Which naming method is being used in this case?()
A.Local Naming
B.Easy Connect
C.External Naming
D.Directory Naming
A.You performed rollback after commit.
B.If a log switch occurs in your database.
C.Thearchiverfails to generate an archived log file.
D.Instance recovery fails to find one of the redo log files.
E.A long-running query is unable to get read-consistent image.
F.If you perform manual undo management operations in auto mode.
最新试题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the yearend tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?()
Which statement is true about the loss of systemcritical data files in ARCHIVELOG mode?()
You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()
A user receives the following error while executing a query:ORA01555:snapshot too oldWhich two options can be the solutions to avoid such errors in future?()
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
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?()
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?()
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?()
According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()
Which three statements are true regarding the finegrained auditing (FGA)?()