1Z0-023 - Oracle8i: Architecture and Administration
Go back to Oracle
What does the command 'ALTER DATABASE . . . RENAME DATAFILE' do?
It updates the control file.
LGWR frequently waits on a checkpoint before performing a log switch. Which action should a DBA take?
Add a redo log group.
Which two actions can be used to multiplex the control file? (Choose two)
Copy the control when the database is shut down.
List multiple control files in the parameter file during database creation.
What are two components of Oracle instance? (Choose two)
The PMON process
In which two cases do you need to perform a conventional path load? (Choose two)
When clustered tables must be loaded.
When transactions must make changes the tables being loaded.
Which clause CANNOT be used with a CREATE PROFILE command?
What does the command ALTER USER scott DEFAULT ROLE NONE do?
It makes all of the roles granted to Scott nondefault roles.
A DBA enters the command: ALTER DATABASE ADD LOGFILE MEMBER '/w01/oracle/DBA/log1b.rdo' TO GROUP 1, '/w02/oracle/DBA/log2b.rdo' TO GROUP 2; How does Oracle size the new redo logs?
It uses the size of the current members in group 1 and group 2.
You are creating a database with a character set other than US7ACII. Which operating system environmental variable needs to be set to specify the directory location of the NLS support files?
Which two methods can be used to increase the size of tablespace? (Choose two)
The ALTER TABLESPACE command with the ADD DATAFILE clause.
The ALTER DATABASE DATAFILE command with the RESIZE clause.
You created a password file using the operating system command line. Orapwd file=orapsORCL password=secure entries=5 Which two users with a password of "secure" are included automatically in the password file? (Choose two)
Consider the following command to create the user 'peter'. CREATE USER peter IDENTIFIED by panTEMPORARY TABLESPACE temp PASSWORD EXPIRE; Since no default tablespace was specified, what will happen if this command executed?
The user peter will be created using the SYSTEM tablespace as the default.
In which situation is it appropriate to enable the restricted session mode?
Exporting a consistent image of a large number of tables.
Which data dictionary view displays the database character set?
What is the primary function of the redo logs?
To record all changes made to data.
Which password management feature is NOT available by using a profile?
The table should be _____ and _______ used to allow usage of the CACHE clause.
Profiles are created to facilitate which two management items? (Choose two)
A DBA performs the query: SELECT tablespace_name, max_blocksFROM dba_tablespace_quotasWHERE username= "SCOTT; That returns the result: TABLESPACE_NAME MAX_BLOCKS ------------------------------ ------------------ DATA01 -1 What does -1 indicate?
The user has an unlimited quota on tablespace DATA01.
Under which condition is it possible to connect to an Oracle database without providing a password?
The connecting user is a member of a DBA group on the machine where the database is running.
In Oracle8i, what does the FAST_START_IO_TARGET parameter do?
It improves the performance of crash and instance recovery.
Which statement about organizing tablespaces and segments is true?
You should keep good control over space allocation and define storage limits for users.
What are two characteristics of the control file? (Choose two)
It should be multiplexed.
It must be updated at every log switch.
Which two are components of the SGA? (Choose two)
The library cache.
The data dictionary cache.
Which statement about profiles is false?
Profiles are assigned to users, roles, and other profiles.
Which view displays the NLS initialization parameters that have been explicitly set?
Can you drop objects from a read-only tablespace?
Only when the tablespace is online
User A grants the SELECT privilege WITH GRANT OPTION on the table EMP to User
Nothing, unless the CASCADE CONSTRAINTS option was used.
Which two dynamic views can be queried when the database is started up in nomount state? (Choose two)
In an Oracle database, which two types of files should be multiplexed? (Choose two)
Online redo log file
Which statement about segments is true?
They can span multiple data files.
You are responsible for managing disk space used for large sort operations. You are willing to allocate this space as needed and not de-allocate until the database is shutdown. You would like to reduce contention on data dictionary tables when this space is allocated. Where possible, you would like to avoid the overhead of generating rollback information when this space is allocated. What kind of tablespace is appropriate?
A locally-managed temporary tablespace.
A transaction fails and returns an ORA-01562 indicating that there is insufficient space in the rollback segment. What are two possible causes? (Choose two)
There is no room in the tablespace for the rollback segment to extend.
MAXEXTENTS has been reached, preventing the segment from extending.
Which memory area in the SGA us used by Oracle when compiling an SQL statement?
Shared pool area
Which component is NOT part of the shared pool?
The program global area.
In response to the ARCHIVE LOG LIST command, Oracle displays: Database log mode No Archive ModeAutomatic archival EnabledArchive destination C:\ora\backup\archivelogsOldest online log sequence 1059 Current log sequence 1061 The DBA has not issued by any ALTER SYSTEM commands after starting the database. What is the value of the parameter LOG_ARCHIVE_START?
In order to guarantee a minimum number of concurrent updates on a data block, which parameter do you need to set?
When creating a user, which profile is assigned automatically to the user if none is defined?
The DEFAULT profile
When creating a table, you must place the table in which tablespace?
One together with other tables of the same user.
In which two ways can a DBA limit the size of the user trace files? (Choose two)
Set the MAX_DUMP_FILE_SIZE in the initSID.ora file
Initiate the ALTER SYSTEM SET MAX_DUMP_FILE_SIZE=integer command
Which data dictionary view shows the available free space in a certain tablespace?
Which two commands can cause a database event trigger to fire? (Choose two)
How does a DBA specify multiple control files?
By listing the files in the CONTROL_FILES parameter.
Which two dynamic performance views could you query to display the number of online redo log groups and the current log groups? (Choose two)
Which dynamic view should a DBA query to obtain information about the different sections of the control file?
You issue the following command: orapwd file=orapwORCL password=secure entries=5 What is the effect?
A new password file is created.
What is the purpose of Oracle Wrapper utility, also known as the Wrap Utility or PL/SQL wrapper?
To hide application code by encrypting PL/SQL package bodies.
Which statement about an Oracle instance is true?
The memory allocated by an Oracle instance is shareable by the database processes.
Which two data dictionary views would you query to investigate space usage in a tablespace? (Choose two)
Which statement about using PCTFREE and PCTUSED is true?
Block space utilization can be specified only at the segment level.