Online Access Free 1Z0-042 Practice Test

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct? (Choose two.)

• A.If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
• B.The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.
• C.This clause is not valid for a temporary or undo tablespace.
• D.The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

• A.The operation would fail if tbs_1 were the default tablespace for the database.
• B.If the above operation were successful, instance recovery would be required to bring the tablespace online.
• C.The operation would fail if tbs_1 were a read-only tablespace.
• D.The operation would fail if tbs_1 were a read/write tablespace.
• E.If the above operation were successful, media recovery would be required to bring the tablespace online.

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.
SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp
PROFILE default
/
SQL> GRANT create session, create table TO user01;
While executing the command to create a table, the user gets the following error message and the CREATE TABLE.. command fails.
ERROR at line 1:
ORA-01950: no privileges on tablespace
What could be the possible reason for this error message?

• A.The user is not the owner of the SYSTEM tablespace.
• B.The user does not have sufficient system privileges to create table in the TBS1 tablespace.
• C.The user does not have sufficient privileges to create table on the default permanent tablespace.
• D.The tablespace TBS1 is full.
• E.The user does not have quota on the TBS1 tablespace.

Which three statements are correct about temporary tables? (Choose three.)

• A.Temporary tables are always created in a user's temporary tablespace.
• B.Data manipulation language (DML) locks are never acquired on the data of temporary tables.
• C.The data inserted into a temporary table in a session is available to other sessions.
• D.Indexes and views can be created on temporary tables.
• E.Both the data and the structure of temporary tables can be exported.

View this parameter setting in your database:
DB_CREATE_FILE_DEST='D:\oracle\product\10.2.0\oradata\oracle'
You created a tablespace by using this command:
CREATE TABLESPACE USERS;
Which two statements are true about the USERS tablespace? (Choose two.)

• A.An error is reported and tablespace creation fails.
• B.Data files belonging to the USERS tablespace cannot be renamed.
• C.Data files are created with names generated by the instance.
• D.The tablespace can be extended without specifying the data file.
• E.The tablespace has two data files.