QUESTION 51:
Which two statements are true regarding the temporary tablespace? (Choose two.)
A.Used for sort operations
B.Can contain permanent objects
C.Cannot be shared by multiple users
D.Cannot be created with nonstandard block size specification
Answers: A D
QUESTION 52:
You executed the following command to create a database user:
SQL> CREATE USER appsuser
IDENTIFIED externally
TEMPORARY TABLESPACE temp
PROFILE user_profile;
Then, you execute the following command to grant privileges to the user:
SQL> GRANT CREATE SESSION TO appsuser;
Which three statements are true for the user? (Choose three.)
A.The user cannot query any database tables.
B.The user has the SYSTEM tablespace as the default tablespace.
C.The user is authenticated by the operating system or a network service.
D.The user has unlimited quota on all tablespaces including the SYSTEM tablespace.
E.The user is external to the database and can never log in and is only defined to be a schema owner.
Answers: A B C
QUESTION 53:
Which two segment types are implicitly created and managed by the Oracle server? (Choose two.)
A.Undo
B.Index
C.Table
D.Temporary
E.Index partition
Answers: A D
QUESTION 54:
You created the password file in your database server as follows:
$ orapwd file=$ORACLE_HOME/dbs/orapwdb password=dba entries=2
Further, you granted the SYSDBA privilege to the user SCOTT who has TIGER as the password. What effect would the assigning of this privilege have on Scott’s password?
A.The password will change from TIGER to DBA.
B.The password will not be affected and remain as TIGER.
C.The password will be DBA when he connects as SYSDBA, and he can use either TIGER or DBA when connecting as a normal user.
D.The password will be DBA when SCOTT connects as SYSDBA, and TIGER when connecting as a normal user.
Answers: B
QUESTION 55:
Which three statements regarding an extent are true? (Choose three.)
A.It can belong to multiple segments.
B.It is a set of contiguous data blocks.
C.It can be allocated manually to a segment.
D.It may be deallocated when a table is truncated.
E.It is allocated when a new column without a DEFAULT value is added to a table.
Answers: B C D
QUESTION 56:
You are working on an OLTP system where transactions are being performed. In which two situations will the log writer (LGWR) write redo entries to the online redo log files? (Choose two.)
A.every three seconds
B.when a transaction commits
C.when the redo log buffer is one-fourth full
D.after database writer (DBWn) writes dirty buffers to the data files
E.when there is more than 1 KB of changes recorded in the redo log buffer
Answers: A B
QUESTION 57:
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 58:
Which four statements are true about profiles? (Choose four.)
A.Profiles can control the use of passwords.
B.Profile assignments do not affect current sessions.
C.All limits of the DEFAULT profile are initially unlimited.
D.Profiles can be assigned to users and roles, but not other profiles.
E.Profiles can ensure that users log off the database when they have left their session idle for a period of time.
Answers: A B C E
QUESTION 59:
In which three scenarios will the contents of the data dictionary base tables be modified? (Choose three.)
A.when a table is truncated
B.when a new column is added to a table
C.when the rows are deleted from a table
D.when the column values of a table are updated
E.when new rows are inserted, thereby causing an extent to be allocated
Answers: A B E
QUESTION 60:
Which two statements regarding a server process are true? (Choose two.)
A.It is one of the mandatory background processes in an Oracle instance.
B.It starts on the client system when a user establishes a connection to the database instance.
C.It can be used by different user sessions one at a time if the database is in shared server mode.
D.It starts on the server when a user establishes a dedicated connection to the database instance.
E.It starts on the client system when the user starts a SQL*Plus session to interact with the database.
Answers: C D
Passleader Latest Sample Questions for Oracle 1Z0-031 Test
