Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

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.

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.

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.

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 . 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.

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

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.

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.

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

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.

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

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

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

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

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

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

A . SER_NO B . ORDER_ID C . STATUS D . PROD_ID E . ORD_TOTAL F . Composite index on ORDER_ID and ORDER_DATE

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

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.

<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.

<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.

<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.

<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.

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.