QUESTION 121:
You executed the following command to resize a data file, sales.dbf, of size 200MB in your database:
ALTER DATABASE DATAFILE /remorse/sales.dbf RESIZE 150M;
What would be the effect of this command?
A.The command succeeds and the data beyond 150 MB is lost.
B.The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
C.The command fails because it is not possible to reduce the size of the data file.
D.The command fails because it is possible to reduce only the size of the system data file.
Answers: B
QUESTION 122:
You are not able to insert rows into a table because the tablespace does not have free space. Which three actions can you take to solve the problem? (Choose three.)
A.add a data file to the tablespace
B.change the default storage clause for the tablespace
C.resize a data file belonging to the tablespace to make it larger
D.alter a data file belonging to the tablespace to extend automatically
E.alter the next extent size to make it smaller, so that it could fit into the available space
Answers: A C D
QUESTION 123:
You execute the following command to create an index on the EMPLOYEE_NAME column of the EMPLOYEES table:
SQL> CREATE UNIQUE INDEX hr.employee_nm_index
ON hr.employees (employee_name)
NOLOGGING
NOSORT;
Which two statements are true regarding the index? (Choose three.)
A.The index creation does not update the data dictionary.
B.The Oracle server does not sort the rows while creating the index.
C.The statement fails if the values in the EMPLOYEE_NAME column are not sorted.
D.The modifications of the index branch and leaf blocks are not logged in the online redo log file.
E.Unique values are stored in the index although the EMPLOYEE_NAME column can contain duplicate values.
Answers: B C D
QUESTION 124:
You installed the Oracle software and want to create a database manually as per the following plan:
– The database should have 10 tablespaces.
– The database should use OS authentication.
– The database should operate in ARCHIVELOG mode.
Which files do you need to create before creating the database?
A.data files
B.redo log files
C.archived log file
D.password file
E.parameter file
F.response file
Answers: E
QUESTION 125:
You want to use a profile to restrict the resources that the users are utilizing in your database. At which two levels can you enforce the resource limits using a profile? (Choose two.)
A.call
B.session
C.database
D.transaction
E.database object
Answers: A B
QUESTION 126:
Which two statements are true regarding object privileges? (Choose two.)
A.The privileges cannot be granted to a user in the form of a role.
B.The object owner can grant the privileges to any other user in the database.
C.Any user that has the GRANT ANY OBJECT PRIVILEGE can grant the privileges on behalf of the object owner.
D.The grantee of the privileges with WITH GRANT OPTION can revoke the same privileges from any other user irrespective of its grantor.
Answers: B C
QUESTION 127:
Which two statements are true regarding extent management in a tablespace? (Choose two.)
A.In a locally managed tablespace free extents are managed by bitmap.
B.The extents are allocated immediately after the tablespace is created.
C.Coalescing of freespace is not required in a locally managed tablespace.
D.In a dictionary-managed tablespace, the information on free extents is maintained inside the tablespace.
Answers: A C
QUESTION 128:
Consider the following phases involved in the processing of a SQL statement:
– Parse
– Bind
– Execute
– Fetch
Arrange the phases involved in processing a data manipulation language (DML) statement in the correct sequence.
A.Execute, Bind, and Fetch
B.Parse, Bind, and Execute
C.Parse, Execute, Bind, and Fetch
D.Execute, Bind, Parse, and Fetch
Answers: B
QUESTION 129:
While observing the index statistics, you find that the index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce the fragmentation without affecting the users who are currently using the index?
A.validate the index structure
B.rebuild the index using ALTER INDEX..REBUILD ONLINE command
C.change the block space utilization parameters using ALTER INDEX command
D.deallocate the unused space in the index using ALTER INDEX..DEALLOCATE UNUSED command
Answers: B
QUESTION 130:
Which view would you query to identify the space utilization settings for tables owned by the APPS user?
A.DBA_OBJECTS
B.DBA_EXTENTS
C.DBA_SEGMENTS
D.DBA_OBJECT_TABLES
Answers: C
Passleader Latest Sample Questions for Oracle 1Z0-031 Test
