1Z0-052章节练习(2019.03.04)

A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user， on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in.

A.CLOB
B.BLOB
C.BFILE
D.LONG RAW

A.Choosing the extent allocation type to uniform
B.Choosing the Segment Space Management option to manual
C.Setting autoextension on for the data file mentioned for the tablespace
D.Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

A.The MTTR Advisor is disabled.
B.The database is in NOARCHIVELOG mode.
C.The tablespace is already in backup mode.
D.The Flash Recovery Area is not configured

A.EXPDP and IMPDP are the client components of Oracle Data Pump.
B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D.Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
E.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

A.A CHECK constraint is created on the OID column.
B.A NOT NULL constraint is created on the OID column.
C.The ORDERS table is the only object created in the USERS tablespace.
D.The ORDERS table and a unique index are created in the USERS tablespace.
E.The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database by defa

A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated

A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control file.
D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.