Examine the statement： SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）

A . Oracle Managed Files are used for this instance. B . The USER_DATA tablespace is managed using FET$/UET$ tables. C . The COMPATIBLE initialization parameter must be 9.0.0 or higher. D . Space within segments in the USER_DATA tablespace is managed with freelists.

时间：2022-09-17 14:34:55 所属题库：1Z0-032题库

相似题目

Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）

A . The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only. B . The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker. C . The C # # A_ADMIN user can perform wallet operations. D . The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM). E . The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

查看最佳答案
Examine this statement： RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2； What state must the target database be in for you to use this RMAN command？（）

A . The target database must be open. B . The target database must be closed. C . The target database must be mounted. D . The target database must be mounted or open.

查看最佳答案
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL *Loader. D . New data conforms to the constraint， but existing data is not checked. E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

查看最佳答案
Examine these two statements:Which three are true about the MRKT tablespace?（）

A . The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files. B . The MRKT tablespace may be dropped if it has no contents. C . Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace. D . No more data files can be added to the tablespace. E . The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

查看最佳答案
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

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.

查看最佳答案
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）

A . An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data. B . The SQL* Loader data file myfile1.dat has the column names for the EMP table. C . The SQL* Loader operation fails because no record terminators are specified. D . Field names should be the first line in the both the SQL* Loader data files. E . The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

查看最佳答案
Examine the statement： DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（） https://assets.asklib.com/images/image2/2018080111115360474.jpg

A . A B . B C . C D . D

查看最佳答案
Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL*Loader. D . New data conforms to the constraint， but existing data is not checked E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

查看最佳答案
Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）

A . Automatic statistics collection is stopped for the CUSTOMERS table. B . Statistics for the CUSTOMERS table are locked and cannot be overwritten. C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D . Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

查看最佳答案
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

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 i

查看最佳答案
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）

A . Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file. B . All DDL commands are logged in the alert log file. C . All DDL commands are logged in a different log file that contains DDL statements and their execution dates. D . Only DDL commands that resulted in the creation of new segments are logged. E . All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

查看最佳答案
Examine the parameter setting in your database: https://assets.asklib.com/images/image2/2018080215045780340.jpg Which statement is correct about the database?（）

A . Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B . The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C . The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D . Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startu

查看最佳答案
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables: https://assets.asklib.com/images/image2/201808011552157673.jpg Which MERGE statement is valid?（）

A .https://assets.asklib.com/images/image2/2018080115514154580.jpg B .https://assets.asklib.com/images/image2/2018080115514431184.jpg C .https://assets.asklib.com/images/image2/2018080115515173356.jpg D .https://assets.asklib.com/images/image2/2018080115515828127.jpg

查看最佳答案
Examine the following RMAN script： RMAN> run { debug on； allocate channel c1 type disk； backup datafile 5； } Which statement describes the purpose of the script？（）

A . The data file is checked for physical corruption and backed up if found clean. B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

查看最佳答案
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（） https://assets.asklib.com/images/image2/2018080209445455276.jpg

A . The ORCL instance is registered dynamically with the listener. B . The ORCL instance is registered statically in the listener.ora file. C . The number of current client connections handled by the service handler is two. D . The total number of client connections handled so far by the service handler is two

查看最佳答案
View the exhibit and examine the output. https://assets.asklib.com/images/image2/2018080214180714803.jpg Which statement can be an inference from the output?（）

A . The FRA disk group has an asynchronous I/O bottleneck B . The least number of I/Os are performed on the last data file in the list C . The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list D . The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk grou

查看最佳答案
Examine the following RMAN script: https://assets.asklib.com/images/image2/2018080215330499234.jpg Which statement describes the purpose of the script?（）

A . The data file is checked for physical corruption and backed up if found clean. B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

查看最佳答案
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

A . An error is generated. B . You will have two identical tables in the HR schema with different names. C . You create a table called employees in the HR schema based on you EMP table. D . You create an alternative name for the employees table in the HR schema in your own schema.

查看最佳答案
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?（）

A . The data file is checked for physical corruption and backed up if found clean. B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

查看最佳答案
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）

A . None of the data definition language (DDL) statements are logged in the trace file. B . Only DDL commands that resulted in errors are logged in the alert log file. C . A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file. D . Only DDL commands that resulted in the creation of new database files are logged.

查看最佳答案
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true？（）

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/e0e7e26248da659a6662e982bf95acc3.jpg' /> A.The SELECT statement is syntactically accurate. B.The SELECT statement does not work because there is no HAVING clause. C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list. D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

查看最佳答案
Examine the following commands for redefining a table with Virtual Private Database （VPD) policies:Which two statements are true about redefining the table？（）

<img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/398a37009eba261eceebfd5a001edaba.png' /> <img src='https://img2.soutiyun.com/shangxueba/ask/64224001-64227000/64224740/a5add098aa6143b225044036df53c199.png' /> A. All the triggers for the table are disabled without changing any of the column names or column types in the table. B. The primary key constraint on the EMPLOYEES table is disabled during redefinition. C. VPD policies are copied from the original table to the new table during online redefinition. D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

查看最佳答案
View the Exhibit to examine the Automatic Database Diagnostic Monitor （ADDM) tasks.Which statement describes the consequence？（）

<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/d39131b84ca6a8d8b08830b9d4753c7b.jpg' /> <img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/4c44618d517b4d4d3a08325cfb73e2e3.jpg' /> A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema. B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only. C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state. D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

查看最佳答案
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement？（）

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' /> <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' /> A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject. B. The statement returns an error at the SELECT clause. C. The statement returns an error at the WHERE clause. D. The statement returns an error at the ORDER BY clause.

查看最佳答案
Examine the parameters for your database instance:Which three statements are true about the process of automatic optimization by using cardinalityfeedback？（）

A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics. B. The optimizer can re optimize a query only once using cardinality feedback. C. The optimizer enables monitoring for cardinality feedback after the first execution of a query. D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.

查看最佳答案

推荐题目