-
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 . 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.
-
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
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.
-
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.
-
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 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 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 . 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.
-
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 structure of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080116355281637.jpg
You issue these statements:
https://assets.asklib.com/images/image2/2018080116355826082.jpg
At the end of this transaction, what is true?（）
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.
-
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 these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）
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.
-
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 SQL statements that creates ORDERS table:
https://assets.asklib.com/images/image2/201808011530357709.jpg
For which columns would an index be automatically created when you execute the above SQL statement? （）
A . SER_NO
B . ORDER_ID
C . STATUS
D . PROD_ID
E . ORD_TOTAL
F . Composite index on ORDER_ID and ORDER_DATE
-
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）
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.
-
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.
-
Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task？（）
<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' />
-
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.
-
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.
-
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task？（）
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);
-
Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output？（）
<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.
