QUESTION 131:
In which two scenarios does a checkpoint occur? (Choose two.)
A.when a log switch occurs
B.when a segment is dropped
C.when a tablespace is dropped
D.when a tablespace is taken offline in NORMAL mode
Answers: A D
QUESTION 132:
In your database, password file authentication is enabled, and you granted SYSDBA to SCOTT. A user tries to connect to the database as follows:
Enter user-name: scott/tiger AS SYSDBA
Which statement in this scenario is true?
A.connects successfully to the SYS schema
B.connects successfully to the SCOTT schema
C.fails to connect and returns an error with the message “insufficient privileges”
D.fails to connect because the AS SYSDBA option should be used only with SYS users or SYSTEM users
Answers: A
QUESTION 133:
You set the following parameters prior to creating your database:
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_DEST_1
DB_CREATE_ONLINE_LOG_DEST_2
Which three files are created as Oracle Managed Files (OMF)? (Choose three.)
A.data files
B.trace files
C.alert log file
D.control files
E.password file
F.parameter files
G.online redo log files
Answers: A D G
QUESTION 134:
Which options would you specify while creating a database user by using the CREATE USER command? (Choose all that apply.)
A.the profile
B.the default roles
C.the default privileges
D.the default tablespace
E.the authentication mechanism
Answers: A D E
QUESTION 135:
USER01 executes the following command:
SQL> GRANT select, insert, update ON employees TO USER02 WITH GRANT OPTION;
USER02 executes the following command:
SQL> GRANT select, insert ON USER01.employees TO USER03 WITH GRANT OPTION;
USER03 executes the following command:
SQL> GRANT select ON USER01.employees TO USER04;
Then, USER01 executes the following command:
SQL> REVOKE select, insert, update ON employees FROM USER02;
How does the REVOKE affect the users USER02, USER03, and USER04?
A.The privileges are revoked from USER02, but USER03 and USER04 continue to have the privileges.
B.The command fails because the privileges cannot be revoked from USER02 until USER02 revokes the privileges from the users to whom it granted.
C.The privileges are revoked from USER02 and USER03, but USER04 continues to have the privileges.
D.The privileges are revoked from USER02, and that implicitly revokes the privileges from USER03 and USER04.
Answers: D
QUESTION 136:
In your database, customer information is stored in the CUSTOMERS table. While creating the ORDERS table, you need to enforce the following business rules for the table: – The SHIPPED_DATE value must be greater than or equal to the ORDERED_DATE value. – The ORDER_VALUE must not exceed 1000000. – The CUSTOMER_ID column must have a valid customer ID. Which two types of constraints would you use while creating the table? (Choose two.)
A.CHECK
B.UNIQUE
C.NOT NULL
D.FOREIGN KEY
E.PRIMARY KEY
Answers: A D
QUESTION 137:
You need to create the ORDERS table that will contain the order information. The table will have millions of rows and there will be a large number of inserts, deletes, and updates in the table. You must ensure that there is:
– No fragmentation in the table
– Minimal contention in the table
What would you do while creating the table?
A.set PCTFREE to 0 for the table
B.set PCTINCREASE to zero for the table
C.place the table in a dictionary-managed tablespace with a large number of free lists for the table
D.place the table in a locally managed tablespace that has automatic segment space management
Answers: D
QUESTION 138:
You need to increase the value of the OPEN_CURSORS parameter to 500 from its current value of 300. You determined that the database is started using a text initialization parameter file(PFILE) and executed the following command to change the value of the parameter:
SQL>ALTER SYSTEM SET OPEN_CURSORS=500 SCOPE=MEMORY;
What would be the effect of this command?
A.The command successfully changes the value of the OPEN_CURSORS parameter.
B.The command fails with the error “failure in processing system parameters”.
C.The command fails with the error “specified initialization parameter cannot be modified”.
D.The command fails with the error “write to SPFILE requested but no SPFILE specified at startup”.
Answers: A
QUESTION 139:
You need to create a database that must be able to store data in any language. Which character set would you use?
A.ASCII character set
B.Unicode character set
C.fixed-width multibyte character set
D.varying-width multibyte character set
Answers: B
QUESTION 140:
Your database is running with one control file, control01.ctl. In the evening when no users are working, you perform the following steps while the database is open:
-Copy the control file to a backup location by using OS copy command.
-Add one data file to an existing tablespace. -Shut down the database.
The next morning, you find that the control file is missing from its location. So, you copy it from the backup location and execute the startup command to start the database.
Which statement regarding the database is true?
A.The startup fails as the instance cannot identify the control file.
B.The startup fails because the control file is older than the rest of the database.
C.The startup is successful because the users made no changes after the control file was copied.
D.The startup fails as the CONTROL_FILES parameter does not contain the path to the backup location.
Answers: B
Passleader Latest Sample Questions for Oracle 1Z0-031 Test
