1Z0-031 - Oracle9i Database: Fundamentals I

Go back to Oracle

Example Questions

You are working on an OLTP system where transactions are being performed. In which two situations will the log writer (LGWR) write redo entries to the online redo log files? (Choose two.) Question 164 While querying the DBA_TS_QUOTAS view, you find that a user, USER01, has a value, -1, in the MAX_BYTES column for all tablespaces in the database. Which statement is true for the user? Which method is correct for starting an instance to create a database? Which data dictionary view would you use to get a list of all database users and their default settings? Question 232 What determines the initial size of a tablespace? Question 328 Which command can you use to display the date and time in the form 17:45:01JUL2000 using the default US7ASCII character set? Question 344 Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set? Which two statements are true regarding object privileges? (Choose two.) Question 359 You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? You created a user, USER01, and granted it two roles, APPLROLE and HRROLE. Next you execute the following command to set the default role for the user: SQL> ALTER USER user01 DEFAULT ROLE NONE; Which three statements are true in this scenario? (Choose three.) Question 103 You execute the following command on an index, SALES_ORDERS_INDX for the first time: SQL> ALTER INDEX sales_orders_indx MONITORING USAGE; Which task does this command accomplish? Question 161 Which three statements define the properties of a column that has the UNIQUE constraint that is enforced using ENABLE and VALIDATE clause? (Choose three.) Question 54 You want to know if there are any default values assigned to the columns in the TECHDATA table. How could you find this information? Question 361 You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file? Which command would revoke the ROLEEMP role from all users? Question 111 You execute the following command to create a role, ROLE1; SQL> CREATE ROLE role1 IDENTIFIED USING apps.authent; Which statements are true for the role? (Choose all that apply.) Question 376 You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate? Question 367 As the DBA, you are attempting to limit users' misuse of Oracle's capability to use host machine resources. Which of the following features of the Oracle database is useful forthis purpose? Question 156 You are using rollback segments in your database. To ease transaction management, you want to implement automatic undo management by using the following steps: 1. creating an undo tablespace 2. setting the UNDO_MANAGEMENT parameter to AUTO in the parameter file 3. changing the tablespace that has the rollback segments to an undo tablespace by using the ALTER TABLESPACE command 4. setting the UNDO_TABLESPACE parameter to the tablespace that has the rollback segments 5. dropping the rollback segments and create undo segments in the same tablespace that has the rollback segments Which option would you use? Creation of which objects in your schema creates a new segment? (Choose all that apply.) Which type of index does this syntax create? CREATE INDEX hr.employees_last_name_idx ON hr.employees(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx; Question 266 You are logged on to a client. You do not have a secure connection from your client to the host where your Oracle database is running. Which authentication mechanism allows you to connect to the database using the SYSDBA privilege? Question 304 Oracle guarantees read-consistency for queries against tables. What provides read-consistency? Question 276 Which process is started when a user connects to the Oracle server in a dedicated server mode? Question 363 You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? Which statement is true regarding enabling constraints? Question 139 Which two actions does the Checkpoint (CKPT) process initiate when a checkpoint occurs? (Choose two.) What are the two effects of the following command to drop a table? (Choose two.) SQL> DROP TABLE oe.ordershistory CASCADE CONSTRAINTS; Question 148 You executed the following command before starting a transaction: SQL> SET CONSTRAINTS ALL DEFERRED; What is the effect of this command? Which data dictionary view would you use to get a list of object privileges for all database users? You execute the following command on an index, SALESORDERSINDX for the first time: SQL> ALTER INDEX salesordersindx MONITORING USAGE; Which task does this command accomplish? Question 65 While querying the DBA_TS_QUOTAS view, you find that a user, USER01, has a value, -1, in the MAX_BYTES column for all tablespaces in the database. Which statement is true for the user? Question 11 Querying which two dynamic performance views would retrieve information from the control file? (Choose two.) Question 90 Which statement is true regarding the Database Configuration Assistant (DBCA)? Question 93 While observing the index statistics, you find that the index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce the fragmentation without affecting the users who are currently using the index? You started your database instance as follows: SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 118561572 bytes Fixed Size 453412 bytes Variable Size 109051904 bytes Database Buffers 8388608 bytes Redo Buffers 667648 bytes SQL> Which activities occur during this process? (Choose two.) Question 159 You execute the following command after restarting the database instance: SQL> ALTER TABLE employees DROP COLUMNS CONTINUE; This command fails displaying the following error: ORA-12995: no columns in partially dropped state What could have caused the command to fail? Which is true when considering the number of indexes to create on a table? Question 3 You executed the following command in your database: SQL> ALTER DATABASE ADD LOGFILE ('/DISK3/log3a.rdo','/DISK4/log3b.rdo') size 1M; What would this command do? Question 177 You need to create the ORDERS table that will contain the order information. The table will have millions of rows and there will be a large number of inserts, deletes, and updates in the table. You must ensure that there is: - No fragmentation in the table - Minimal contention in the table What would you do while creating the table? Question 336 Which component of the SGA stores parsed SQL statements is used for process sharing? The current password file allows for five entries. New DBAs have been hired and five more entries need to be added to the file, for a total of ten. How can you increase the allowed number of entries in the password file? Question 226 You used the password file utility to create a password file as follows: $orapwd file=$ORACLE_HOME/dbs/orapwDB01 password=orapass entries=5 You created a user and granted only the SYSDBA privilege to that user as follows: CREATE USER dba_user IDENTIFIED BY dba_pass; GRANT sysdba TO dba_user; The user attempts to connect to the database as follows: connect dba_user/orapass as sysdba; Why does the connection fail? Question 99 Which statement regarding the KEEP buffer pool is true assuming that it is sized correctly? Question 2 You have set up password file authentication in your database. You accidentally lost the password file. What would be the effect of this loss on the functional database? While querying the DBATSQUOTAS view, you find that a user, USER01, has a value, -1, in the MAXBYTES column for all tablespaces in the database. Which statement is true for the user? Which four statements are true about profiles? (Choose four.) Question 108 You want to create a password verification function that will validate the password for a user when a new user is created or an existing user's password is changed. What are the two considerations for creating the function? (Choose two.) Question 237 A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends? (Choose two.) You can use the Database Configuration Assistant to create a template using an existing database structure. Which three will be included in this template? (Choose three.)

Study Guides