Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）

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.

A . MANAGER must be a role. B . It allows the MANAGER to pass the specified privileges on to other users. C . It allows the MANAGER to create tables that refer to the STUDENT_GRADES table. D . It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table. E . It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table. F . It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

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.

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 . A B . B C . C D . D

A . An error is returned. B . You are prompted to enter a new value. C . A report is produced that matches the first report produced. D . You are asked whether you want a new value or if you want to run the report based on the previous value.

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 . You have no rows in the table. B . You have an employee with the name of James. C . You cannot roll back to the same savepoint more than once. D . Your last update fails to update any rows because employee ID 180 was already eleted.

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 . The set of statements contains an error and does not work. B . It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users. C . It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users. D . It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role. E . It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object. F . It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

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

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

A . Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. B . Statistics collection is not done for the CUSTOMERS table when database stats are gathered. C . Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time. D . Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. E . Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

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/7fe8306013ab0f36b81d7271dc0c8478.jpg' /> A.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/cfff1591b450909431e9f7ae7dc05f14.jpg' /> B.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c75e1c68e2e140258467ca466b7e474d.jpg' /> C.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c87a2c32bbbd462ee3f4b85cd7438fec.jpg' /> D.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/659c7750c67c9d05542c4c9f4dd01ed9.jpg' />

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

A. CREATE INDEX NAME _IDX (first_name, last_name); B. CREATE INDEX NAME _IDX (first_name, AND last_name) C. CREATE INDEX NAME_IDX ON (First_name, last_name); D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name); E. CREATE INDEX NAME_IDX ON employees (First_name, last_name); F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/6bce46904716f2e8357f4849d2a3423d.jpg' /> <img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/c5c76fa6bab26c6735c868df586306cf.jpg' /> A.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/0f921b8c15106e9d6cc8e36a50134106.jpg' /> B.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/d072515564553d90b433296aa71e021a.jpg' /> C.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b4721c6b94a9b61c92cdbe82aabc3ae1.jpg' /> D.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b27c35e83798de4bbbccaef22fa31b48.jpg' /> E. The SQL statement produces an error.