-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 1
You are in the process of installing Oracle Database 10g on your client computer. You have set the value for environment variable ORACLE_HOME to /oracle/ora10g. What does this value specify?
A.the directory location for the base of OFA
B.the directory location where the Oracle software is installed
C.the directory location where the script files of the database are stored
D.the directory location where the operating system searches for Oracle executables, such as SQL*Plus
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 2
Your Oracle server has four databases SALESDB, FINDB, HRDB, and TESTDB installed on it. The SALESDB database is currently running. You set the ORACLE_SID environment variable on the operating system as follows: C:\> SET ORACLE_SID=TESTDB Then, you try to start the TESTDB database from another SQL*Plus prompt using this command: SQL> STARTUP; What will be the result of this command?
A.The command will start the TESTDB database without any alterations to the SALESDB database.
B.The command will start the TESTDB database and shut down the already-running SALESDB database.
C.This command will return an Oracle already running, shut it down first error.
D.The command will not start the TESTDB database because the assignment of the ORACLE_SID environment variable isincorrect, and you must specify the specific parameter file when issuing the STARTUP command
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 3
While installing the Oracle10g database on a UNIX platform you are prompted to run the script file orainstRoot.sh, which creates another file oraInst.loc. For which purpose is the newly created oraInst.loc file used?
A.It is used to set the UNIX kernel parameters for the Oracle database.
B.It is used to store information about the users accessing the Oracle database.
C.It is used by Oracle Universal Installer at startup to find the inventory location.
D.It is used by Oracle Universal Installer to store the home directory and base directory locations.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 4
.While installing the Oracle 10g database using OUI, which file storage option will provide you with additional features such as mirroring and stripping?
A.File System
B.Raw Devices
C.Oracle-Managed Files
D.Automatic Storage Management
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 5 You want to use the Oracle-Managed Files feature to minimize file management and provide efficient storage for your Oracle database. Which two initialization parameters are used to configure to use the Oracle-Managed Files feature? (Choose two.)
A. DB_NAME
B. INSTANCE_NAME
C. DB_CREATE_FILE_DEST
D. DB_RECOVERY_FILE_DEST
E. DB_CREATE_ONLINE_LOG_DEST_n
Correct Answer: CE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 6
While installing the Oracle 10g database, you have set the NLS_LANG environment variable to AMERICAN_AMERICA.WE8IS08859P1. What will be the default date format assigned to the Oracle 10g database?
A. DDMMYY
B. DD-MM-YY
C. DD-MON-YY
D. DD-MONTH-YYYY
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 7
You are in the process of installing Oracle 10g on your host computer. Click the Exhibit(s) button to view the hardware composition of your host computer. Which action should you take to successfully complete the installation of Oracle 10g on your computer?
A.Increase the RAM on your computer to 512 MB.
B.Increase the virtual memory on your computer to 1 GB.
C.Increase the free hard disk space on your computer to a minimum of 2 GB
D.Increase the free hard disk space on your computer to a minimum of 1.5 GB.
E.Increase the temporary disk space on your computer to a minimum of 200 MB.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 8
Your Oracle server is running on a Linux platform. You create a new database NEWDB on this server. Which file is updated with the Oracle system identifiers (SIDs) when this new Oracle database, NEWDB, is created?
A. oratab
B. crontaC. catexp.sql
D. orainstRoot.sh
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 9
Your database is running in the shared server mode. You want to ensure that the memory allocated to the shared pool is completely used by the application users and not by RMAN processes or any other I/O server processes. Which component of the Shared Global Area (SGA) should be allocated memory to achieve the objective?
A. Java Pool
B.log buffer
C.large pool
D.buffer cache
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 10
Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the datafiles?
A. CKPT and control file
B. LGWR and online redo log files
C. DBWn and archived redo log files
D. DBWn and database buffer cache
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 11
Which three statements correctly describe the Manage Templates option available with DBCA? (Choose three.)
A.It allows you to create a template based on another template.
B.It allows you to create a database with a structure similar to an existing database.
C.It allows you to create a template that contains only the data of an existing database.
D.It allows you to create a template based on all the tablespaces of an existing database.
E.It allows you to create a template that contains only the structure of an existing database.
F.It allows you to create a template that contains the data as well as structure of an existing database.
Correct Answer: ABF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 12
You are required to create a new database using DBCA. The database is required to store historical data pertaining to the last 20 years for a multinational bank. This data is generally accessed to create reports needed in different quarters of the year. In addition, new data is inserted into the database at the end of every month. Considering these requirements, which template would be the best template to use to create the database?
A.Data Warehouse
B.General Purpose
C.Custom Database
D.Transaction Processing
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 13
You have installed Oracle Enterprise Manager 10g Database Control on your computer to manage your production database located on a remote host computer through a Web-enabled interface. Which component is NOT a component of Oracle Enterprise Manager 10g Database Control?
A.Oracle Management Agent
B.Oracle Management Service
C.Oracle Management Interface
D.Oracle Management Repository
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 14
You are creating a database using DBCA. Which options can be configured when creating a database using DBCA? (Choose all that apply.)
A.character sets
B.memory sizing
C.database block size
D.connection mode
E.maximum number of users in the database
F.default profile allocation for users
Correct Answer: ABCD
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 15
Your database server is running in shared server mode. Which component is a component of the Program Global Area (PGA) when the database is in shared server mode?
A.shared pool
B.stack space
C.user session data
D. memory structures
E.cursor state information
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 17
Your database is running in the ARCHIVELOG mode. After an instance crash, you start up the database by issuing the STARTUP command. Instance recovery is initiated by the SMON background process. Which statements are true about the phases involved in the instance recovery performed by SMON? (Choose all that apply.)
A.The instance recovery will recover data up to the last commit.
B.The information used for instance recovery will be derived from the alert log.
C.The information used for instance recovery will be derived from the control file.
D.The uncommitted changes are rolled back using information in the undo segments.
E.The information used for instance recovery will be derived from the data dictionary.
F.The instance recovery will recover all the data entered into the database before the point of the crash.
G.Only the committed changes stored in the online redo log file are applied to the affected data blocks.
H.The committed and uncommitted changes stored in the online redo log are applied to the affected data blocks.
Correct Answer: ACDH
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 18 During your routine monitoring operations on the database, you observe that there is heavy contention on data dictionary tables whenever extents are allocated or freed from a tablespace. Which action should you take as a measure to eliminate this contention on the SYSTEM tablespace?
A.Use local extent management for the SYSTEM tablespace.
B.Use bigfile tablespaces in the database to avoid contention.
C.Use automatic segment space management for tablespaces.
D.Use local extent management for nonsystem tablespaces if not using it already.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 19
Which stages of Structured Query Language (SQL) statement processing are performed when you issue a MERGE statement? (Choose all that apply.)
A.The rows inserted are written to the datafiles.
B.The data is fetched and returned to the users.
C.The updated blocks are written to the datafiles.
D.The changes made are recorded in the redo log files.
E.The System Change Number is recorded in the control file.
F.A parse tree is generated for the query if it does not already exist.
G.Blocks of data are retrieved into the database buffer cache if they are not already present.
Correct Answer: FG
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 20
You are a DBA with Startel. You have a set of four databases SALESDB, FINDB, HRDB, and PROD. You also have two listeners, L1 and L2, and an application server, APPS1, located on different locations globally. You have been assigned the task of managing all these components from your office located in New York. Which two tools should you install to administer these components centrally on the network? (Choose two.)
A.Oracle Management Agent
B.Oracle Enterprise Manager 10g
C.Oracle Enterprise Manager 10g Grid Control Console
D.Oracle Enterprise Manager 10g Application Server Control
E.Oracle Enterprise Manager 10g Database Control Console
Correct Answer: AC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 21
Users in your application complain of slow response to queries. Upon analysis, you realize that the queries are being reparsed because they are aged out quickly. Which component of the Shared Global Area (SGA) should you modify to avoid the reparsing of queries?
A. Java Pool
B.large pool
C.library cache
D.redo log buffer
E.data dictionary cache
F.database buffer cache
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 22
You need to create a database similar to an existing database. The data and structure of the new database must be the same as the existing database. Which action would best obtain the desired results?
A.Create a database using the CREATE DATABASE statement. Then, perform a complete database import of the original database.
B.Create a template of the existing database using DBCA that incorporates only the structure of the original database. Then,use this template to create the new database.
C.Create a template of the existing database using DBCA that incorporates the structure and data of the original database.Then, use this template to create the new database.
D.Create a template of the existing database using DBCA that incorporates only the structure of the original database anduse this template to create the new database. Then, perform a complete database import of the original database.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 23
Eric is working as a database administrator with Telstar Corporation. He has been granting SYSDBA and SYSOPER privileges to certain users who must perform certain administrative tasks, such as starting and shutting down the database remotely. Which file determines the number of users that can be granted the SYSDBA or SYSOPER privilege?
A.trace file
B.control file
C.alert log file
D.password file
E.system datafile
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 24
You have created a database using DBCA. Now, you want to change the configurations of the database using DBCA. Which option CANNOT be configured using DBCA?
A.configure the database to enable daily backup
B.configure the database to run as a shared server
C.configure the database to use the Local naming method
D.configure the database to use password file authentication
E.configure the database to use Automatic Storage Management
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 25
Which activities in the database signal DBWn to write the data from the database buffer cache to datafiles? (Choose all that apply.)
A. whenever there is a log switch
B.whenever a user transaction is committed
C. whenever the database is shut down cleanly whenever a table is dropped from the database
D. whenever a tablespace in the database is taken offline
E. whenever the server process cannot find free buffers in the database buffer cache
Correct Answer: ACEF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 27
Two users JULIA and SAMUEL are simultaneously working on the table EMP_DET, which has thousands of rows. User SAMUEL issues the following statement: SQL> UPDATE EMP_DET SET EMP_SAL=25000 WHERE EMP_NAME='JACK'; Immediately afterwards, the user JULIA issues the following statement: SQL> SELECT * FROM EMP_DET WHERE EMP_NAME='JACK'; What will happen when the user JULIA issues her SELECT statement?
A.The user JULIA will receive an error because she cannot view the data because SAMUEL is modifying the data.
B.The user JULIA will be able to view the data including the changes made by SAMUEL.
C.The user JULIA will be able to view the data as it existed before the UPDATE statement was issued by SAMUEL.
D.The user JULIA's session will hang because she is trying to access the same row that is currently being modified by SAMUEL's session.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
UESTION 28
You are using Enterprise Manager Database Control to administer your database. The database has lost some of the configuration files due to media failure. This failure has not affected the availability of the database. Among the lost files is the portlist.ini file. Which information is contained in this portlist.ini file?
A.the initialization parameters configured for the database
B.the list of listener configuration parameters used by the remote listeners
C.the port number of the HTTP listener being used by Enterprise Manager Database Control
D.the port number used by the listener configured to listen for the incoming database connections
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 29
Click the Exhibit(s) button to analyze a set of statements issued in a session. If the salary of the employee in the MASTER table with the CODE value of J4569 was 20000 at the beginning of the session,what will be the salary value of this employee in the MASTER2 table displayed when the last query is run?
A. NULL
B. 10000
C. 20000
D. 25000
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 30 Click the Exhibit(s) button to view the details of the ITEMS and ORDERS tables. Which statement will return all the records where PROD_ID values are common to the two tables and any PROD_ID values that are not common to the two tables?
A. SELECT i.PROD_ID, i.PRODUCT_NAME, o.ORDER_ID, o.CUSTOMER_NAME
FROM ITEMS i
B. NATURAL JOIN ORDERS o; SELECT i.PROD_ID, i.PRODUCT_NAME, o.ORDER_ID, o.CUSTOMER_NAME
FROM ITEMS i
FULL OUTER JOIN ORDERS o
ON i.PROD_ID=o.PROD_ID;
C. SELECT i.PROD_ID, i.PRODUCT_NAME, o.ORDER_ID, o.CUSTOMER_NAME
FROM ITEMS i
LEFT OUTER JOIN ORDERS o
ON i.PROD_ID=o.PROD_ID;
D. SELECT i.PROD_ID, i.PRODUCT_NAME, o.ORDER_ID, o.CUSTOMER_NAME
FROM ITEMS i
RIGHT OUTER JOIN ORDERS o
ON i.PROD_ID=o.PROD_ID;
E. SELECT i.PROD_ID, i.PRODUCT_NAME, o.ORDER_ID, o.CUSTOMER_NAME
FROM ITEMS i
INNER JOIN ORDERS o
ON i.PROD_ID=o.PROD_ID;
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 31
You are assigned the task of creating a SQL*Plus report for the number of products sold for a specific manufacturer. You also want to calculate the average sales of products for the given manufacturer for the current year. You want SQL*Plus to prompt you for the name of the manufacturer when the report is run. However, SQL*Plus should not prompt you for the name when the report runs subsequently in the current session. Which option should you use to achieve the objective?
A.a bind variable
B.the DEFINE command
C.a substitution variable with a & prefix
D.a substitution variable with a && prefix
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 32 You created a table EMP using the following statement:
SQL> CREATE TABLE EMP
(NAME CHAR(10),
ADDRESS VARCHAR2(10),
CITY VARCHAR2(20),
EMPCODE NUMBER(10),
DEPT_ID NUMBER(8));
This table contains 1000 records. The largest values in the NAME, ADDRESS, CITY, EMPCODE, and DEPT_ID columns are six characters, 10 characters, 20 characters, four digits, and six digits, respectively. You want to reduce the size of the columns. There are no constraints defined on the table. Which modifications to column(s) of the EMP table CANNOT be made using the ALTER TABLE...MODIFY statement? (Choose all that apply.)
A.The NAME column's width can be reduced to seven characters.
B.The ADDRESS column's width can be reduced to nine characters.
C.The CITY column's width can be reduced to 15 characters.
D.The EMPCODE column's width can be reduced to six digits.
E.The DEPT_ID column's width can be reduced to six digits.
Correct Answer: BC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 33
You are trying to connect to the Oracle database server by using iSQL*Plus.
Which component must be running to enable you to successfully connect to the database?
A. iSQL*Plus server
B.iSQL*Plus on clients
C.Oracle Enterprise Manager
D.Oracle Management Agent
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 34
Which two interfaces can be used as command-line interfaces for accessing an Oracle database? (Choose two.)
A.SQL*Plus
B.iSQL*Plus
C.Oracle Forms
D.Oracle Reports
E.Oracle Enterprise Manager
Correct Answer: AB
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 35 Evaluate this statement: ALTER SYSTEM SET UNDO_TABLESPACE='UNDOTEMP' SCOPE=SPFILE;
What will be the result of executing this statement?
A.The change will only be made in the instance currently running.
B.The change will be persistent across instance shutdown and startup.
C.The change will be made in both the currently running instance and the SPFILE.
D.The statement will fail because the only valid SCOPE values are MEMORY and BOTH.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 36 Eric is working on his production database, PROD. Eric detects a deadlock involving transactions between two users in his database. He wants to view the details of the deadlock to prevent it from occurring the next time. Which initialization parameter will determine the location of the file containing the details of the deadlock?
A. CORE_DUMP_DEST
B. USER_DUMP_DEST
C. LOG_ARCHIVE_DEST
D. BACKGROUND_DUMP_DEST
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 37
You are using SQL*Plus. Which two commands can you use to display the value assigned to the DB_BLOCK_SIZE parameter? (Choose two.)
A. SHOW ALL
B. SHOW DB_BLOCK_SIZE
C. DESCRIBE DB_BLOCK_SIZE
D. SHOW PARAMETER DB_BLOCK_SIZE
E. SHOW PARAMETERS DB_BLOCK_SIZE
Correct Answer: DE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 38
Your database instance fails to start when you issue the following command: SQL> STARTUP NOMOUNT; Which of the following could be the reason for the failure?
A.Oracle database cannot read the datafiles.
B.Oracle database cannot read the control file.
C.Oracle database cannot read the redo log files
D.Oracle database cannot read the initialization parameter file.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 39
Your database exists on a remote location. You want to connect to the database using a Web browser and manage it with Enterprise Manager. Which syntax is correct for you to connect to your database remotely?
A.http://host:portnumber/em
B.http://host.portnumber/em
C.http://host:portnumber.em
D.http://www.host.portnumber.em
E.http://www.host:portnumber/em
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------QUESTION 40
You are configuring your Database Control with the Enterprise Manager console. You also need automatic storage management for the database files of the PRODUCT database. Which steps must you perform to successfully configure Database Control for using automatic storage management? (Choose all that apply.)
A.Use the command emca -s.
B.Use the command emca -a.
C.Use the command emca -m.
D.Use the command emca -x product.
E.Change the directory to ORACLE_HOME/bin directory.
F.Set the ORACLE_HOME and ORACLE_SID environment variables for the PRODUCT database
G.Set the ORACLE_HOME and LD_LIBRARY_PATH environment variables for the PRODUCT database.
Correct Answer: BEF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 41
Which view will you query to display the PFILE information currently in effect for a database that was started by using the initialization parameter file?
A. V$DATABASE
B. V$PARAMETER
C. V$SPPARAMETER
D. V$CONTROLFILE
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 42
You have two listeners named LISTENER and listener2 configured for your database and listening on different port numbers. You executed this command at the command-line: lsnrctl stop What is the result of executing this command?
A.An error will be generated.
B.Both the listeners will be stopped.
C.The default listener will be stopped.
D.The listener that was started first will be stopped.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 43
You have altered the size of the database buffer cache by using the following statement: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=335566624 SCOPE=BOTH; Which two statements characterize the result of this statement? (Choose two.)
A.The value of the DB_CACHE_SIZE parameter is modified. This information is modified only in memory if the PFILE was used to start the instance.
B.The value of the DB_CACHE_SIZE parameter is modified. This information is modified only in the PFILE, if the PFILE was used to start the instance.
C.The value of the DB_CACHE_SIZE parameter is modified. This information is modified in both the SPFILE and PFILE, if the PFILE was used to start the instance.
D.The value of the DB_CACHE_SIZE parameter is modified. This information is modified in both memory and the SPFILE, if the SPFILE was used to start the instance.
E.The value of the DB_CACHE_SIZE parameter is modified only for the current instance. This will be changed back to the previous value after the instance is shut down and restarted.
Correct Answer: AD
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 44 After changing some parameters in your initialization parameter file, you start the database in the NOMOUNT state using the
following command:
SQL> STARTUP NOMOUNT;
After this, you want to enable redo archiving and therefore, you issue the following statement to mount the database: SQL> ALTER DATABASE MOUNT; At this stage, the database fails to mount. Which condition could be the reason for the failure?
A. A datafile in the database cannot be accessed.
B.The control file in the database cannot be accessed.
C.The redo log files in the database cannot be accessed.
D.The parameter file in the database cannot be accessed.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 45
In your production database, you use a parameter file and a server parameter file alternately. You have modified some parameters in your parameter file. After this, you want to incorporate the same changes into your server parameter file. Which action will you use to incorporate PFILE changes into the SPFILE?
A.Create a new SPFILE from the modified PFILE.
B.Use RMAN to update the SPFILE to reflect the changes made in the PFILE.
C. Manually edit the SPFILE to incorporate the changes made in the PFILE.
D.Do not make any changes. The Oracle server will automatically incorporate the changes in the SPFILE.
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 46
You are required to stop the Database Control process. Which command will achieve your objective?
A. emctl stop dbconsole
B. emctl dbconsole stop
C. emctl stop dbconsole process
D. emctl dbconsole process stop
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 47
When trying to connect to a database, you receive an error in Enterprise Manager stating that the network adapter could not establish the connection. What is the reason for receiving this error?
A.No listener is configured for the database.
.The database is not configured for the listener.
C.The database you are trying to connect to is not open.
D.The listener configured for the database is not running.
E.The service name provided in the tnsnames.ora file is incorrect.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 48
While starting your database, you receive an error stating that the database cannot identify one of the redo log files in it. At which stage will you receive this error?
A. when the first transaction ends and the changes to the database must be written to the redo log files
B. when the database changes from the MOUNT to the OPEN state
C. when the database changes from the NOMOUNT to the MOUNT state
D. when the database changes from the SHUTDOWN to the MOUNT state
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 49
While trying to connect to the database you receive the following error:
ORA-12514: TNS:listener does not currently know of service requested in connectdescriptor
Which two conditions could this indicate? (Choose two.)
A.The database is not open
B.The database service is not dynamically registered with the listener.
C.The database service name is not configured in the listener.ora file.
D.The user trying to connect to the database does not have the SYSDBA privilege.
E.The listener is not running on the database specified in the connect descriptor.
Correct Answer: BC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 50
Your database went down abnormally because of power failure. You could not perform a clean shutdown on the
database. After this, you start the database by running the STARTUP command. Which statements are true regarding this scenario? (Choose all that apply.)
A.The recovery is coordinated by the process monitor.
B.The uncommitted changes are rolled back from the database.
C.The committed changes in the database are written to the datafiles.
D.The information required for recovery is derived from the alert log file.
E.The lost changes in the database are recovered by performing a media recovery.
Correct Answer: BC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 51
You must query the EMP table owned by the user SCOTT. You do not have the Oracle client software installed on your computer. You want to invoke iSQL*Plus and query the EMP table. The host name of the database server is UNS. The IP address of the database server is 172.17.24.77. You are using the default port number to access iSQL*Plus. Which two URLs will invoke iSQL*Plus from the Web browser of your computer? (Choose two.)
A. http://uns:5560/isqlplus
B. http://uns:5550/isqlplus
C. http://uns/isqlplus:5560
D. http://172.17.24.77:5560/isqlplus
E. http://172.17.24.77/isqlplus:5550
Correct Answer: AD
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 52
Your database aborted while you were performing database backups by placing the tablespaces in the online backup mode. The tablespaces continued to be in the online backup mode when your database aborted. You issued the following command to start up the database after the instance crash. SQL> STARTUP; Which statement is true in the given scenario?
A.Instance recovery should be performed to recover the database.
B.The undo segments recover the tablespaces that were in the backup mode.
C.The archive redo log files in the database cannot be used to perform recoveries after the instance recovery.
D.Nothing must be done because the database will open successfully on its own.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 53
Your Oracle server has a set of four databases. You want to monitor the startup and shutdown times of the ORCL Oracle database. Assuming you have not modified the default file name, which file will you view to obtain information regarding the startup and shutdown of the ORCL database?
A. ORA00122.TRC
B. ALERT_ORCL.LOG
C. ORCL_ALERT.TRC
D. TRACE_ALERT.LOG
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 54
You view the alert log file regularly to keep track of important messages that may be generated. Which problems can be identified by using the alert log file? (Choose all that apply.)
A.deadlocks occurring in the database
B.the SYSTEM tablespace becoming full
C.a control file missing from the database
D.a redo log file missing from the database
E.users consuming a high amount of CPU
F.dropping of an important user from the database
G.using the SYSTEM tablespace as the temporary tablespace
Correct Answer: ACDG
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 55
Your production database has crashed due to media failure. After analysis, you discover that the instance crashed because some database files were located on failed media. Which file contains detailed information about the background processes, the files that caused the instance to crash, and the time of the crash?
A.datafile
B.control file
C.alert log file
D.redo log file
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 56
You are required to rename the EXAMPLE.DBF datafile of your Oracle database. First, you relocate the file using OS utilities.
After relocating the file by using OS utilities, which statement will accomplish the task of updating the control file with the new name of the datafile?
A. ALTER DATAFILE...RENAME FILE
B. ALTER DATABASE...RENAME DATAFILE
C. ALTER DATABASE...RENAME DATA FILE
D. ALTER TABLESPACE...RENAME DATAFILE
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 57
You have issued the following statement in your Oracle database: SQL> ALTER TABLESPACE SYSAUX OFFLINE; Which statement correctly describes the outcome of this statement?
A.You can write data to the SYSAUX tablespace but cannot read data from it.
B.This statement fails because you cannot take the SYSAUX tablespace offline.
C.You can read data from the SYSAUX tablespace after the SYSAUX tablespace has been taken offline.
D.You cannot read data from or write data to the SYSAUX tablespace after the SYSAUX tablespace has been taken offline.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 58
You are administering an Oracle 10g database in a Windows environment. You must create a smallfile locally-managed tablespace. The default tablespace type for the database was set to SMALLFILE at the time of database creation. Which two statements will accomplish the task of creating a smallfile locally-managed tablespace in this database? (Choose two.)
A. CREATE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 150M;
B. CREATE SMALLFILE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 150M;
C. CREATE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 50G SMALLFILE;
D. CREATE SMALLFILE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 150M
EXTENT MANAGEMENT DICTIONARY;
E. CREATE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 150M
EXTENT MANAGEMENT DICTIONARY
DEFAULT STORAGE
INITIAL 50K
NEXT 50K
MINEXTENTS 2
MAXEXTENTS 50
PCTINCREASE 0);
Correct Answer: AB
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 59
The option
CREATE SMALLFILE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 150M
EXTENT MANAGEMENT DICTIONARY;
is incorrect because this statement will create a dictionary-managed tablespace. A dictionary-managed tablespace is created by
explicitly specifying the EXTENT MANGEMENT DICTIONARY clause in the CREATE TABLESPACE statement.
The option
CREATE TABLESPACE mydata DATAFILE
'f:\oracle\product\10.1.0\oradata\orcl\mydata.dbf' SIZE 150M
EXTENT MANAGEMENT DICTIONARY
DEFAULT STORAGE (
INITIAL 50K
NEXT 50K
MINEXTENTS 2
MAXEXTENTS 50
PCTINCREASE 0);
is incorrect because this statement will create a dictionary-managed tablespace. A dictionary-managed tablespace is created by
explicitly specifying the EXTENT MANGEMENT DICTIONARY clause in the CREATE TABLESPACE statement.
In your production database, you set the COMPATIBLE initialization parameter to 10.0.0. Then, you create seven tablespaces in the database. The details of the tablespaces in the database are summarized as follows:
SYSTEM - Locally-managed system tablespace
SYSAUX - Locally-managed tablespace auxiliary to the SYSTEM tablespace
UNDO - Locally-managed default undo tablespace
TEMP - Default temporary tablespace TEMP1.Temporary tablespace
USERS - Locally-managed tablespace to store user data
IND1.Locally-managed tablespace to store index data To manage the data more effectively, you plan to add a few more tablespaces to the database. Which two statements are true in this scenario? (Choose two.)
A.A bigfile tablespace can be created in the database.
B.All tablespaces in the database will be locally-managed.
C.You cannot create another undo tablespace in the database.
D.All tablespaces will use automatic segment space management.
E.A dictionary-managed tablespace can be created in the database.
F.All newly created tablespaces in the database will be bigfile tablespaces.
Correct Answer: AB
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 60
You have created the USERS tablespace in your PROD database by issuing the following statement:
SQL> CREATE TABLESPACE USERS DATAFILE 'D:\USERS1.DBF'
SIZE 2M AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 500K
SEGMENT SPACE MANAGEMENT AUTO;
Which statements regarding the USERS tablespace are true? (Choose all that apply.)
A.The USERS tablespace is a bigfile tablespace.
B.The USERS tablespace can hold only one datafile.
C.The free space in the USERS tablespace is recorded using bitmaps.
D.The size of all the extents in the USERS tablespace will be the same.
E.Within the USERS tablespace, the maximum size up to which the datafile can grow is 2 MB.
F.Within the USERS tablespace, the datafile automatically increases in size when it becomes full.
Correct Answer: CDF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 61
You have created a tablespace by using the following statement: SQL> CREATE TABLESPACE TBS1 DATAFILE '\NEWDB\DATA\DA1.DBF' SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO NOLOGGING; Which two statements are true about the tablespace created using this statement? (Choose two.)
A.The TBS1 tablespace can be changed to the LOGGING mode.
B.Transactions on the TBS1 tablespace will save space in the redo log files.
C.The statement will generate an error because the NOLOGGING clause cannot be specified for the TBS1 tablespace.
D.All the tables, indexes, and views created in the TBS1 tablespace will be in the NOLOGGING mode.
E.A table created in the TBS1 tablespace will consume less space because of the use of the NOLOGGING clause.
Correct Answer: AB
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 62
You have executed the following statement:
SQL> ALTER TABLESPACE SYSAUX RENAME TO SYSAUXTAB;
Which statement is true about executing this statement?
A.The statement will fail because you cannot rename the SYSAUX tablespace.
B.The statement will fail because you cannot rename tablespaces in Oracle 10g.
C.The statement will change the name of the SYSAUX tablespace to SYSAUXTAB.
D.The statement will drop the existing SYSAUX tablespace and re-create a new SYSAUX tablespace.
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 63
On your Oracle database server, you have installed Oracle Database 10g software and set the COMPATIBLE initialization parameter to 10.0.0.
After doing this, you create a database using the CREATE DATABASE statement. Click the Exhibit(s)button to view the statement used to create the database.
After the database creation, you create a tablespace using the following statement:
CREATE TABLESPACE DATA1 DATAFILE '/ORACLE/ORADATA/TS1.DBF' SIZE 50M;
Which statement is true regarding the tablespace created using this statement?
CREATE DATABASE PROD1
USER SYS IDENTIFIED BY SYSPASS
USER SYSTEM IDENTIFIED BY SYSTEMPASS
SET DEFAULT SMALLFILE TABLESPACE
UNDO TABLESPACE UNDOTBS1
DEFAULT TEMPORARY TABLESPACE TEMPTAB1;
A.The tablespace is a bigfile tablespace
B.The tablespace will be a locally-managed tablespace.
C.The tablespace will be a dictionary-managed tablespace.
D.The tablespace will have automatic segment space management.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 64
Eric is a newly hired database administrator for TelStar. He has been assigned the task of deleting the tablespaces that are not being used by any users. Eric issues the following statement to delete the PROD tablespace: SQL> DROP TABLESPACE PROD INCLUDING CONTENTS; Which statement regarding the result of executing this statement is true?
A.The PROD tablespace and the data contained in it are deleted from the database.
B.The PROD tablespace and the data contained in it are deleted from the database and the associated OS files are removed.
C.The statement will return an error stating that the PROD tablespace cannot be dropped because it contains database objects.
D.Only the PROD tablespace is removed from the database, and the data contained in PROD is transferred to the respective owner's default tablespace.
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 65
Your junior DBA has placed a tablespace in your database offline by using the following statement: SQL> ALTER TABLESPACE TS2 OFFLINE TEMPORARY; Which two statements reflect results of altering the status of the tablespace by using this statement? (Choose two.)
A.The statement will force a checkpoint to be performed in the database.
B.The tablespace cannot be brought online without performing recovery on it.
C.The statement will generate an error if some files in the tablespace are read-only.
D.The tablespace can be brought online the next time without performing a recovery on it.
E.All the datafiles in the tablespace need a recovery before the tablespace can be brought online.
Correct Answer: AD
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 66
You are using locally-managed tablespaces in your database. Which three situations will NOT arise in your database? (Choose three.)
A.contention on the SYSTEM tablespace
B.free extents being managed by the data dictionary
C.allocation and de-allocation of extents using bitmaps
D.contention on a default temporary tablespace in the database
E.the need to specify the default storage parameters when creating segments in these tablespaces
Correct Answer: ABE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 67
You are working on your production database.
The USERS tablespace of your database is running out of space.
The USERS tablespace contains the D:\DATA\USERS01.DBF datafile of size 10 MB.
Which two statements will add more space to the datafile of the USERS tablespace? (Choose two.)
A. ALTER DATABASE DATAFILE 'D:\DATA\USERS01.DBF' RESIZE 20M;
B. ALTER DATABASE DATAFILE 'D:\DATA\USERS01.DBF' AUTOEXTEND ON;
C. ALTER TABLESPACE USERS DATAFILE 'D:\DATA\USERS01.DBF' RESIZE 20M;
D. ALTER TABLESPACE USERS ADD DATAFILE 'D:\DATA\USERS.DBF' SIZE 10M;
E. ALTER TABLESPACE USERS DATAFILE 'D:\DATA\USERS01.DBF' AUTOEXTEND ON;
Correct Answer: AB
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 68
The undo tablespace of your database must be renamed. Which two conditions must be met to update the tablespace name in the server parameter file? (Choose two.)
A.The database must be started by using the server parameter file.
B.The database must be started by using the static initialization parameter file.
C.A new undo tablespace must be created and made the default undo tablespace for your database.
D.The UNDO_MANAGEMENT=MANUAL parameter must be specified for the database instance.
E.The UNDO_TABLESPACE parameter must be specified to indicate the name of the undo tablespace of the database instance.
Correct Answer: AE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 69
You are working on the PROD database that is running in the ARCHIVELOG mode. You want to drop the datafile that exists in the TS1 tablespace of the database. Which sequence of steps will enable you to achieve this objective?
A.Take the TS1 tablespace offline and then drop the datafile by using the ALTER TABLESPACE...DROP DATAFILE statement.
B.Shut down the database, open it in the MOUNT state, and drop the datafile by using the ALTER DATABASE...DROP DATAFILE statement.
C.Shut down the database, open it in the MOUNT state, and drop the datafile by using the ALTER TABLESPACE...DROP DATAFILE statement.
D.Take the datafile offline by using the ALTER DATABASE...DATAFILE...OFFLINE statement, and drop the datafile by using the ALTER DATABASE...DROP DATAFILE statement.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 70
You are working on your PROD database that contains the following configuration of tablespaces: # PROD - tablespace used to store the nonsystem user data and is assigned to all nonsystem users as the default permanent tablespace # IND1.tablespace used to store the indexes created on nonsystem tables # SYSTEM - tablespace used to store the system data # SYSAUX - tablespace used as an auxiliary to the SYSTEM tablespace # TEMP - tablespace used as the default temporary tablespace for the database # UNDOTS - tablespace used as the default undo tablespace for the database Which of the following statements is NOT true for the TEMP tablespace?
A.You can drop the TEMP tablespace.
B.You can assign the TEMP tablespace to database users
C.You cannot change the status of the TEMP tablespace from online to offline.
D.You cannot convert the TEMP tablespace to a permanent tablespace.
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 71 Examine the details of the PROD database:
SYSTEM - Locally-managed system tablespace
SYSAUX - Locally-managed tablespace auxiliary to the SYSTEM tablespace
UNDO - Locally-managed default undo tablespace
TEMP1.Temporary tablespace DATA1.Default permanent tablespace
USERS - Locally-managed tablespace to store user data
IND1.Locally-managed tablespace to store index data You create a user ADAM using the following statement:
SQL> CREATE USER ADAM IDENTIFIED BY PASSWORD; Which two statements are true in the given scenario? (Choose two.)
A.Tables created by ADAM will be stored in the DATA1 tablespace.
B.Tables created by ADAM will be stored in the USERS tablespace.
C.Tables created by ADAM will be stored in the SYSTEM tablespace.
D.Sort data generated by ADAM's transactions will be stored in the IND1 tablespace.
E.Sort data generated by ADAM's transactions will be stored in the TEMP1 tablespace.
F.Sort data generated by ADAM's transactions will be stored in the SYSTEM tablespace.
Correct Answer: AF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 72
A system administrator issues the following statement to alter the profile of a user JOHN:
ALTER PROFILE PROF2 LIMIT
CPU_PER_SESSION 3600
IDLE_TIME 30;
As a result, how much CPU time and time of inactivity is allowed to the user JOHN in the next session?
A.6 hours of CPU time and 30 minutes of inactivity
B.60 minutes of CPU time and 30 minutes of inactivity
C.60 seconds of CPU time and 30 minutes of inactivity
D.36 seconds of CPU time and 30 seconds of inactivity
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 73
ERIC is a database user on your database. When at work, ERIC's session times out frequently. This disrupts his progress. What can be done to prevent this situation?
A.Drop and re-create the user.
B.Assign the CONNECT role to the user.
C.Assign the RESOURCE role to the user.
D.Modify the profile assigned to the user.
E.Assign the required system privileges to the user.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 74
You are using Oracle Enterprise Manager 10g Database Control. You have created a user JOHN, and are assigning him the HR_MGR role. You have selected the DEFAULT check box. Which statement best describes the result of selecting this check box?
A.The user JOHN is granted the HR_MGR role.
B.The user JOHN is granted the ownership of the HR_MGR role.
C.The user JOHN is granted the HR_MGR role as his default role.
D.The user JOHN is granted the HR_MGR role with the ADMIN option.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 75
As a database administrator, you are creating a user. You run the following statement to create the user:
SQL> CREATE USER ADAM IDENTIFIED BY PASSWORD
DEFAULT TABLESPACE SYSTEM
QUOTA 1M ON TS1
QUOTA 10M ON USERS
PROFILE USER_PROF; What will be the result of running this statement?
A.The user will not be able to change his password.
B.The user will be assigned the database's default temporary tablespace, if one exists.
C.The statement will fail because the temporary tablespace for the user has not been specified.
D.The statement will fail because you cannot assign the SYSTEM tablespace as the user's default tablespace
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 76 A user ERIC in your PROD database is the owner of the DETAIL, MASTER, and PRODUCT_DET tables. The tables are located on the TS1, USERS, and PRODUCTS tablespaces, respectively. New rows are constantly being added to the tables. The quotas for users on these tablespaces are rapidly exceeded, and no further insertions can be done before increasing the quotas for the users on these tablespaces. Which is the best method for you to use to avoid this overhead of repeatedly modifying the quotas of the users?
A.Grant the RESOURCE role to the users.
B.Grant the UNLIMITED TABLESPACE role to the users.
C.Grant the UNLIMITED TABLESPACE privilege to the users.
D.Alter the users to ensure that they are granted unlimited quota on the three tables.
E.Alter the users to ensure that they are granted unlimited quota on the three tablespaces.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 77 You are working in your production environment in which you are administering a large number of users. These users are posing a threat to your system by not being prompt in modifying their passwords. You want the users' passwords to expire in 30 days and to issue them a warning five days before the password expiration. Which actions should you take to achieve this objective? (Choose all that apply.)
A.Set the PASSWORD_LOCK_TIME parameter in the users' profile to 30 days.
B.Set the PASSWORD_LIFE_TIME parameter in the users' profile to 30 days.
C.Set the PASSWORD_LOCK_TIME parameter in the users' profile to five days.
D.Set the PASSWORD_LIFE_TIME parameter in the users' profile to five days.
E.Set the PASSWORD_GRACE_TIME parameter in the users' profile to 25 days.
F.Set the PASSWORD_GRACE_TIME parameter in the users' profile to five days.
Correct Answer: BF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 78 John is a database administrator at GlobeComm Corporation. John has been assigned the task of creating users.
He issues the following statements to create a user BARRY and grant privileges to the user:
SQL> CREATE USER BARRY IDENTIFIED BY PASSWORD
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA 2M ON PROD
PASSWORD EXPIRE
ACCOUNT LOCK;
SQL> GRANT CREATE SESSION, CREATE TABLE TO BARRY;
Which statements correctly describe the user BARRY? (Choose all that apply.)
A.The password assigned to BARRY will never expire.
B.BARRY can create a table in the USERS tablespace.
C.BARRY cannot create a table in the USERS tablespace.
D.BARRY does not have privileges on the TEMP tablespace.
E.BARRY cannot access his account without the intervention of the DBA.
Correct Answer: CDE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 79
You created a user SUSAN in your database and assigned her the MANAGER profile. Later, you assigned the SYSDBA privilege to the user to enable the user to perform some administration tasks on the database. After some time, you realize that you do not require the MANAGER profile and decide to drop the profile. What is the result of dropping the profile from the database?
A.The user will not have any profile.
B.The user will have the default profile.
C.The user will have the MANAGER profile.
D.The user will have the profiles assigned to the SYS and SYSTEM users.
E.An error will be received stating the profile is assigned to users in the database and cannot be dropped.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 80
During a single session, you run the following set of statements in your database:
SQL> CREATE USER SCOTT IDENTIFIED BY SCOTT;
SQL> CREATE ROLE HR_ADMIN;
SQL> GRANT SELECT ANY TABLE TO HR_ADMIN;
SQL> GRANT CREATE ANY VIEW TO HR_ADMIN;
SQL> GRANT HR_ADMIN TO SCOTT;
The database user SCOTT tries to execute a SELECT statement against a table in the HR user's schema, but the following error is generated:
SQL> SELECT * FROM HR.TRAINING;
ORA-01031: insufficient privileges Which two could be the possible reasons for this error? (Choose two.)
A.The HR_ADMIN role is a secured application role.
B.The HR_ADMIN role has not been set as the default role for the user SCOTT.
C.A password must be provided to access the privileges granted by the HR_ADMIN role.
D.The user HR has not granted select access on the TRAINING table to the user SCOTT.
E.The user SCOTT has not enabled the HR_ADMIN role by using the SET ROLE statement.
Correct Answer: BE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 81
The default temporary tablespace, TEMP, for your database has become corrupt because of bad disks. To ensure that the database functions properly, the users of the TEMP tablespace and any new users created in the database must use the newly created NEW_TEMP tablespace instead. What would be the best action to take to enable this?
A.While creating any new user, assign the NEW_TEMP tablespace as the temporary tablespace.
B.Alter all the users in the database and assign the NEW_TEMP tablespace as their temporary tablespace.
C.Drop the TEMP tablespace and ask the users to use the NEW_TEMP tablespace for storing the temporary data.
D.Alter the database and make the NEW_TEMP tablespace the default temporary tablespace for the database.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 82
You must limit the amount of CPU time that a user session can utilize. Which resource parameter in the user's profile will you modify to achieve this objective?
A.CONNECT_TIME
B. CPU_PER_CALL
C. CPU_PER_SESSION
D. LOGICAL_READS_PER_SESSION
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 83
You have created a role, WORK_USER, with a set of system and object privileges. You grant this role to a group of users. These users need to perform additional tasks in the database and therefore, there is a need to assign a few more privileges to this group of users. You modify the WORK_USER role and grant the required privileges to this role. Which two statements are true? (Choose two.)
A.The roles that are granted this role will get the new set of privileges.
B.The users who are assigned the role will get the new set of privileges immediately.
C.The users that are granted this role in the future will get only the new set of privileges.
D.The users who are assigned the role will get the new set of privileges in their next session.
E.The users will need to disable the role and re-enable it to get the new set of privileges.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 84
Mark is a team manager of your company's Oracle development team. He is required to work on a new project that involves more resource use. As a DBA, you do not know how much resources he requires to complete this project because the client requirement is still expanding. You have decided to allow him full resource use rights. Which action should you take to enable this?
A.Specify the user as a member of the DEFAULT_CONSUMER_GROUP.
B.Create a profile with RESOURCE_LIMIT=null and assign it to the user.
C.Create a profile and specify the NO LIMIT value for all resource parameters. Then, assign the profile to the user.
D.Create a profile and specify the UNLIMITED value for all resource parameters. Then, assign the profile to the user.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 85
You have created a user GLENN in your Oracle database. You have two permanent tablespaces, PROD and DATA, to store the users' data. You must ensure that the user GLENN does not create any objects in the DATA tablespace and uses only the PROD tablespace to create database objects. Which statements will you execute to ensure this?
A. ALTER USER GLENN QUOTA UNLIMITED ON PROD AND DATA;
B. ALTER USER GLENN QUOTA 0M ON DATA;
ALTER USER GLENN QUOTA UNLIMITED ON PROD;
C. ALTER USER GLENN QUOTA NULL ON DATA;
ALTER USER GLENN QUOTA UNLIMITED ON PROD;
D. ALTER USER GLENN QUOTA UNLIMITED ON DATA;
ALTER USER GLENN QUOTA 0M ON PROD;
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 86
In your database, the user JOHN is creating numerous sessions. You want to restrict the number of sessions JOHN can create. You assign a profile to JOHN and restrict the number of user sessions that he can create. However, you realize that the restrictions are not being enforced. Which initialization parameter must you modify to enforce the limit?
A. RESOURCE_LIMIT
B. CPU_PER_SESSION
C. LICENSE_MAX_USERS
D. SESSIONS_PER_USER
E. LICENSE_MAX_SESSIONS
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 87
You have created a new user, BOB, by executing the following statement: SQL> CREATE USER BOB IDENTIFIED BY PASSWORD; You have not granted privileges to the user BOB. Which three roles and privileges are mandatory for the user BOB to create a table in the default tablespace? (Choose three.)
A. CREATE VIEW
B. CREATE TABLE
C. RESOURCE
D. CREATE SESSION
E. SELECT ANY TABLE
F. RESTRICTED SESSION
G. UNLIMITED TABLESPACE
Correct Answer: BDG
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 88
You are a DBA in your organization. You want to identify the set of privileges granted to the user SCOTT on the EMPLOYEE table owned by the user JACK. Which view will provide the required information?
A. DBA_SYS_PRIVS
B. DBA_TAB_PRIVS
C. USER_SYS_PRIVS
D. USER_TAB_PRIVS
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 89
You have a table named EMPLOYEES. Given these attributes of the table: 1. the column attributes 2. the constraints created on the table 3. the storage attributes for the table 4. the segments associated with the table Which attributes of the EMPLOYEES table can you view using Oracle Enterprise Manager?
A.only 1
B.only 1 and 2
C.only 1 and 3
D.only 1, 2, and 4
E.1, 2, 3, and 4
Correct Answer: E
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 90
You change the state of a PRIMARY KEY constraint of a table from ENABLE VALIDATE to DISABLE VALIDATE by using the following statement: SQL> ALTER TABLE MASTER PRIMARY KEY DISABLE VALIDATE; Which two statements are true in reference to the primary key in this scenario? (Choose two.)
A.The constraint checking will be disabled.
B.The index on the primary key will be disabled.
C.The primary key cannot be dropped from the table.
D.The table can contain data that violates the constraint.
E.The modification of old constrained data that the table contains is allowed.
F.Rows containing data that violates the PRIMARY KEY constraint cannot be inserted in the table.
Correct Answer: AD
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 91
Your database has two tables, MASTER and EMP_MASTER. You want to alter the EMP_MASTER table to create a foreign key on its CODE column, which refers to the CODE column of the MASTER table. You also want to ensure that when you delete a row from the MASTER table, the child records are deleted from the EMP_MASTER table automatically.
Which statement should you use for this purpose?
A. ALTER TABLE EMP_MASTER (FOREIGN KEY (CODE) REFERENCES MASTER);
B. ALTER TABLE EMP_MASTER (FOREIGN KEY (CODE) REFERENCES MASTER ON DELETE CASCADE);
C. ALTER TABLE EMP_MASTER (FOREIGN KEY (CODE) REFERENCES MASTER ON DELETE SET NULL);
D. ALTER TABLE EMP_MASTER (FOREIGN KEY (CODE) REFERENCES MASTER CASCADE CONSTRAINTS);
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 92
You must shrink the EMP table and its dependent segments to release the unused space below and above the High Water Mark (HWM) of the segments. The EMP table and its dependant segments are located in the USERS tablespace, which uses automatic segment space management. Which statement should you use to release the space below the HWM?
A. ALTER TABLE EMP COALESCE;
B. ALTER TABLE EMP SHRINK SPACE;
C. ALTER TABLE EMP SHRINK SPACE CASCADE;
D. ALTER TABLE EMP SHRINK SPACE INCLUDING CONTENTS;
E. You cannot release the space because the USERS tablespace uses automatic segment space management.
Correct Answer: C
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 93 You have just created a sequence, MASTER_SEQ, for generating unique values for the ID column of your MASTER table. Which statement issued on the newly created sequence will complete successfully?
A. SELECT MASTER_SEQ FROM DUAL;
B. SELECT MASTER_SEQ.NEXTVAL FROM DUAL;
C. SELECT MASTER_SEQ.CURRVAL FROM DUAL;
D. SELECT MASTER_SEQ.CURRVAL FROM MASTER;
E. SELECT MASTER_SEQ.NEXTVAL FROM MASTER;
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 94
You create a primary key on the CODE column in your MASTER table using the following statement:
SQL> ALTER TABLE MASTER ADD CONSTRAINT PRIMARY KEY (CODE);
Which statements are true if the constraint is created successfully? (Choose all that apply.)
A.The primary key created will be in the deferred state.
B.A NOT NULL constraint will be created on the CODE column.
C.A unique index will be created on the CODE column of the table.
D.A CHECK constraint will be created on the CODE column of the table.
E.No index will be created because this is not specified by the statement.
Correct Answer: BC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 95
The default permanent tablespace for your Oracle database is set to PROD. You have created a user JOHN in your database, and assigned the USERS tablespace to the user JOHN. Which tablespace stores the tables that the user JOHN creates?
A. PROD
B. USERS
C. SYSTEM
D. UNDOTBS1
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 96 You are in the process of creating a table to hold records for the employees in your organization.
Which data type would be best for the BIRTH_DATE column in your table?
A. DATE
B. NUMBER
C. VARCHAR2
D. TIMESTAMP WITH TIMEZONE
E. TIMESTAMPWITH LOCAL TIMEZONE
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 97
You run the following statement to create a table:
SQL> CREATE TABLE TAB$4-8 (NO NUMBER); However, this statement fails to create the table.
What could be the reason for the failure of this statement to create the table?
A. The column name is too short.
B.You cannot use the - symbol in the table name
C.You cannot use the $ symbol in the table name.
D.You can use only one numeric character in the table name.
E.You cannot use the NUMBER data type without specifying a precision.
F.You have not specified the name of the tablespace in which the table is to be stored.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 98
You have been assigned the task of tuning an application that is performing poorly. The application extensively uses a table named DETAIL from the PROD database. There are millions of rows in the DETAIL table, of which only a few rows are returned when the queries are run on the table. The WHERE clauses of the queries used in the application typically contain a condition on the ITEM_NO column that has sequential values. Which action should you take to improve the performance of the application?
A.Truncate and repopulate the table.
B.Sort the output of the queries based on the ITEM_NO column.
C.Reorganize the table by moving it to a different tablespace that contains more free extents.
D.Create a B-tree index on the ITEM_NO column of the table, if a B-tree index does not already exist.
E.Create a bitmap index on the ITEM_NO column of the table, if a bitmap index does not already exist.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 99
In which scenario can you create a bitmap index to gain considerable improvement in the performance of reports accessing the tables?
A.The EMP_MASTER table is 8 GB in size, and the table contains few rows.
B.The TRANS_DETAIL table contains 8 million rows, and the key column TRANS_NO that is accessed by major queries has high cardinality.
C.The SHIPPING table contains thousands of records, is accessed by an Online Transaction Processing (OLTP) system,and is updated frequently.
D.The EMPLOYEES table contains 10 million rows, the key columns have low cardinality, and most of the SELECT queries are a combination of multiple WHERE conditions with the OR and AND operators.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 100
You want to view the SQL statements used by all the users in the database to create views. Which dynamic view should you use to obtain this information?A. B. C. D. E.
A. ALL_VIEWS
B. DBA_VIEWS
C. USER_VIEWS
D. DBA_OBJECTS
E. ALL_OBJECTS
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 101 Click the Exhibit(s) button to view the structure of the EMP table. The EMP table contains 50 rows. You execute the following set of statements in a session: SQL> DELETE FROM EMP WHERE 1=2; SQL> CREATE TABLE TEMP AS SELECT * FROM EMP WHERE 2=1; SQL> COMMIT; Which statements are true about the result of executing this set of statements? (Choose all that apply.)
A.The newly created TEMP table will contain no rows.
B.The newly created TEMP table will contain 50 rows.
C.The newly created TEMP table will have a structure similar to the EMP table.
D.The newly created TEMP table will contain double the rows as in the EMP table.
E.The structure of the newly created TEMP table will contain only the first two columns from the EMP table.
Correct Answer: AC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 102
You issue the following statement to grant a privilege to the database user JOHN:
SQL> GRANT CREATE ANY DIRECTORY TO JOHN; Which statement is true regarding the privilege granted to JOHN?
A. JOHN can create files anywhere in the OS.
B. JOHN can create directories anywhere in the OS.
C. JOHN can read files located on all the directories in the OS.
D. JOHN can grant this privilege to any other user in the database.
E. JOHN can read and write to the files located on the OS only if
F. JOHN has the read and write permissions on the OS directories in which the files are located.
G. JOHN can read and write to the files located on the OS only if the Oracle database processes have read and write permissions on the OS directories in which the files are located.
Correct Answer: E
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 103
The user A attempts to insert data into the user JOHN's EMP table by issuing the following statement: SQL> INSERT INTO JOHN.EMP VALUES (4563,'ADAM', 5000, 'ACCOUNTS', 125); This statement returns the following error: ORA-01653: unable to allocate extent table JOHN.EMP by 8 in tablespace EXAMPLE What should you do to resolve this problem and ensure that user A can insert data into the EMP table?
A.Add more space to user A's default tablespace.
B.Grant the INSERT ANY TABLE privilege to the user.
C.Add more space to the user JOHN's default tablespace.
D. Allocate additional quota to user A on user A's default tablespace.
E.Add more space to the tablespace in which the EMP table resides.
F.Allocate quota to user A on the tablespace in which the EMP table resides.
Correct Answer: E
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 104
Click the Exhibit(s) button to view the details of the ITEMS and ORDERS tables where the ITEMS table is the parent table and ORDERS table is the child table.
The PROD_ID column is the primary key column in the ITEMS table and a foreign key column in the ORDERS table.
User A is trying to update the ORDERS table to update the status of ORDER_ID 249 using the following SQL statement:
SQL> UPDATE ORDERS SET PROD_ID=8 WHERE ORDER_ID=249;
However, upon execution, the statement returns the following error: ORA-02291: integrity constraint (ORDERS.FK_ID) violated - parent key not found Which of these identifies the correct solution to avoid this error?
A.Drop the primary key from the ITEMS table.
B.Truncate the ITEMS table and then update the ORDERS table.
C.Drop the ITEMS table using the CASCADE CONSTRAINTS clause.
D.Insert the product details with PROD_ID number 8 into the ITEMS table, and then update the ORDERS table.
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 105
Due to changes in the responsibilities of the users, you want to transfer the tables owned by one user to another user's schema. Which tool should you use to effectively achieve this objective with the least administrative effort?
A.direct path load to load the data from one schema to another schema
B.transportable tablespaces to transfer the tablespace that contains the data
C.the command-line mode of Data Pump Import to import the data into the other user's schema
D. the Oracle Enterprise Manager 10g Database Control Re-map Schemas page to import the data into the other user's schema
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 106
You are performing an export of certain objects in your database by using Oracle Data Pump. You are required to unload only the data in the export file and not the metadata information. Which parameter of the Data Pump Export should you use in this scenario?
A. TABLES
B. CONTENT
C. EXCLUDE
D. ESTIMATE
E. DIRECTORY
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 107
While performing an import by using the Data Pump Import utility, you use the following command in the import procedure:
> impdp HR/hr TABLES=employees DIRECTORY=data1 SCHEMAS=scott
NETWORK_LINK=telstar.uk.oracle.com FLASHBACK_SCN=235
Which three statements correctly characterize this command? (Choose three.)
A.The EMPLOYEES table will be imported into the HR schema.
B.The EMPLOYEES table will be imported into the SCOTT schema.
C.The SCN number refers to the SCN number of the target database.
D.The SCN number refers to the SCN number of the source database.
E.The data is transferred to the target database referred to by the telstar.uk.oracle.com link.
F.The data is transferred from the source database referred to by the telstar.uk.oracle.com link.
Correct Answer: ADF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 108 You are importing data into your database by using Data Pump Import.
While importing data from the dump file, dump01.dmp, you want only the views in the ADAM schema to be imported into the database.
You also want only those views whose names contain the SALES string to be imported.
Which import command will successfully achieve this objective?
A. $ impdp john/john SCHEMAS=adam INCLUDE=view:"like '%SALES%'"
B. $ impdp john/john DUMPFILE=dump01.dmp SCHEMAS=adam INCLUDE=view:"like '%SALES%'"
C. $ impdp john/john DUMPFILE=dump01.dmp INCLUDE=view:"like '%SALES%'" CONTENT=VIEW_ONLY
D. $ impdp john/john DUMPFILE=dump01.dmp SCHEMAS=adam EXCLUDE=view:"like '%SALES%'"
E. $ impdp john/john DUMPFILE=dump01.dmp SCHEMAS=adam EXCLUDE=view:"like '%SALES%'" CONTENT=VIEW_ONLY
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 109 You have created a deferred NOT NULL constraint on a column in a table. You are updating the data in the table. Several rows being updated do not conform to the constraint. What will happen when you commit the transaction?
A.All the rows will be updated.
B.No rows will be updated.
C.Only the rows that conform to the constraint will be updated.
D.All the rows will be updated and the constraint state will change to disabled.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 110
A user in the database of your company has inadvertently modified some critical data in the MASTER table, and you do not know the exact time at which the data was modified. You must recover the table to undo the modifications made to the table. Which action should you take to recover the table?
A.Use the LogMiner utility to recover the table.
B.Use the time-based recovery procedure to recover the table.
C.Use the change-based recovery procedure to recover the table.
D.Recover the table by importing the table from the previous export dump of the table.
E.Use the FLASHBACK_SCN option of the Oracle Data Pump Export to perform a flashback export of the table followed by an import of the table.
F.Use the FLASHBACK_TIME option of the Oracle Data Pump Export to perform a flashback export of the schema followed by an import of the schema
Correct Answer: E
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 111
Due to changes in the policies of your organization, you are required to restructure your database.
You issue the following command from the Oracle Data Pump Import:
> impdp SYSTEM/password DIRECTORY=expdat_dmp DUMPFILE=expdat.dmp NOLOGFILE=Y
REMAP_SCHEMA=hr:scott
Which two statements are true about the result of issuing this command? (Choose two.)
A.The HR schema will be renamed as the SCOTT schema.
B.All objects in the SCOTT schema will be transferred to the HR schema.
C.All objects in the HR schema will be transferred to the SCOTT schema.
D.No errors and import progress messages will be generated during the import process.
E.Errors and the import progress messages generated during the import will be stored in the log file.
F.Errors and import progress messages will be written to the standard output device.
G.The objects in the SCOTT schema will be transferred to the HR schema, and the SCOTT schema will be dropped.
H.The objects in the HR schema will be transferred to the SCOTT schema, and the HR schema will be dropped.
Correct Answer: CF
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 112
You are a DBA in your company. Due to a revision in company policies, you must transfer all the data in the FIN_TBS tablespace of your database to the database located at your company head office. Which tool or feature would be the best to use in the given scenario?
A.Data Pump
B.SQL*Loader
C.conventional path load
D.transportable tablespace
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 113
In your database, you want compilation of your PL/SQL code to only generate messages for conditions that can cause performance problems or generate an unexpected behavior or incorrect results. Which initialization parameter value setting can you use to achieve this objective?
A. PLSQL_WARNINGS='ENABLE:ALL'
B. PLSQL_WARNINGS='ENABLE:SEVERE'
C. PLSQL_WARNINGS='ENABLE:PERFORMANCE'
D. PLSQL_WARNINGS='ENABLE:PERFORMANCE', 'ENABLE:SEVERE'
Correct Answer: D
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 114
You have created a database trigger using the following statement:
CREATE OR REPLACE TRIGGER resume_timeout
AFTER SUSPEND ON DATABASE BEGIN
DBMS_RESUMABLE.SET_TIMEOUT(10800);
END;
When will this database trigger fire?
A. when a user abruptly disconnects from the session
B. when a user's session disconnects due to space allocation problems
C. when a user's session is suspended due to space allocation problems
D. when a user's statement is suspended and resumable space allocation is not enabled in the user's session
E. when a user's statement is suspended due to space allocation problems and resumable space allocation is enabled for the user's session
Correct Answer: E
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 115
A user JOHN is the owner of the MASTER table, which has a PRIMARY KEY constraint defined on the CODE column. The MASTER table is used to store the data related to the products manufactured by the company. JOHN wants the values in the CODE column of the MASTER table to range from 1 to 200 because the company does not manufacture more than 200 items. Which action can JOHN take to accomplish this objective?
A.Create a trigger.
B.Create a package.
C.Create a function.
D.Create an anonymous PL/SQL block.
E.Modify the PRIMARY KEY constraint of the CODE column.
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 116 You want to create a PL/SQL construct that will accept the monthly salary and employee number of an employee, calculate the tax the employee will need to pay for the current period, and return this value so that it can be stored in a database. You also want to be able to call this construct from within SQL statements. Which PL/SQL construct would you use for this purpose?
A. Trigger
B. function
C.procedure
D.anonymous PL/SQL block
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------QUESTION 117
Your senior database administrator has instructed you to change the PL/SQL configuration options for your database such that the compiled PL/SQL code in your database is stored as native machine code. Which statement will achieve the desired objective?
ALTER SYSTEM SET PLSQL_CODE_'NATIVE'; ALTER SYSTEM SET PLSQL_CODE_NATIVE='TRUE'; ALTER SESSION SET PLSQL_CODE_NATIVE='ENABLE'; ALTER SYSTEM SET PLSQL_CODE_'INTERPRETED';
Correct Answer: A
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 118
You were recently hired as a database administrator for your company. In your testing environment, you notice this parameter setting in your initialization parameter file: PLSQL_DEBUG=TRUE Which two statements are true about this parameter setting? (Choose two.)
A.It will disable the extended PL/SQL debugging features in your database.
B.It will enable the extended PL/SQL debugging features in your database.
C.It will cause compiled PL/SQL code to be stored as interpreted bytecode regardless of the of PLSQL_CODE_TYPE setting.
D.It will cause compiled PL/SQL code to be stored as native machine code regardless of the PLSQL_CODE_TYPE setting.
E.It will optimize the PL/SQL compiler to enable better run-time performance but degrade the compiler performance slightly.
Correct Answer: BC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 119
Eric has been hired as a new DBA in his organization. His supervisor asks him to make changes in the database to disable OS authentication from remote clients. Which action must Eric take to achieve this objective?A.Set the value of the REMOTE_OS_AUTHENT parameter to TRUE.
B.Set the value of the REMOTE_OS_AUTHENT parameter to FALSE.
C.Set the value of the OS_AUTHENT_PREFIX parameter to REMOTE.
D.Set the value of the REMOTE_LOGIN_PASSWORDFILE parameter to NONE.
E.Set the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE.
Correct Answer: B
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUESTION 120
You are administering 100 users in your database. You want to view the fine-grained audit records and the standard audit trail entries generated for the user AMY in your database. Which SQL statement should you use to achieve this objective?
A. SELECT * FROM DBA_AUDIT_TRAIL WHERE USERNAME='AMY';
B. SELECT * FROM USER_AUDIT_TRAIL WHERE USERNAME='AMY';
C. SELECT * FROM DBA_FGA_AUDIT_TRAIL WHERE DB_USER='AMY';
D. SELECT * FROM DBA_FGA_AUDIT_TRAIL WHERE USERNAME='AMY';
E. SELECT * FROM DBA_COMMON_AUDIT_TRAIL WHERE DB_USER='AMY';
Correct Answer: E
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------