-
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set?()
A . DBMS_WORKLOAD_REPOSITORY
B . DBMS_RESOURCE_MANAGER
C . DBMS_SQLTUNE
D . DBMS_ADVISOR
-
You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?()
A . It is created as a nondisplay item.
B . The Lock Record property is set to Yes.
C . It cannot be referenced in item level triggers.
D . It is placed on the canvas with the highest sequence number.
-
You want to create a filter for your web application and your filter will implement javax.servlet.Filter. Which two statements are true?()
A . Your filter class must implement an init method and a destroy method.
B . Your filter class must also implement javax.servlet.FilterChain.
C . When your filter chains to the next filter, it should pass the same arguments it received in its doFiltermethod.
D . The method that your filter invokes on the object it received that implements javax.servlet.FilterChaincan invoke either another filter or a servlet.
E . Your filter class must implement a doFilter method that takes, among other things, anHTTPServletRequest object and an HTTPServletResponse object.
-
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?()
A . The CDB must be open.
B . The CDB must be in the mount stage.
C . The CDB must be in the nomount stage.
D . Alt existing PDBs must be closed.
-
You are developing a custom-collection class.You need to create a method in your class. You need to ensure that the method you create in your class returns a type that is compatible with the Foreach statement. Which criterion should the method meet?()
A . The method must return a type of either IEnumerator or IEnumerable.
B . The method must return a type of IComparable.
C . The method must explicitly contain a collection.
D . The method must be the only iterator in the class.
-
The user SYS creates a job by using the following command:
https://assets.asklib.com/images/image2/2018080116584480510.jpg
Which two statements are true about the job that was created by the preceding command? ()(Choose two.)
A . The job is enabled by default after creation
B . The job is automatically dropped after the end date
C . The job executes with the privileges of the user SYS
D . The globalization environment that exists at the time of the job creation prevails at the job ru
-
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
A . The SGA Tuning Advisor
B . The SQL Access Advisor
C . The SQL Tuning Advisor
D . The Memory Advisor
-
View this parameter setting in your database: DB_CREATE_FILE_DEST=’D: \oracle\product\10.2.0\oradata\oracle’ You created a tablespace by using this command: CREATE TABLESPACE USERS; Which two statements are true about the USERS tablespace?()
A . The tablespace has two data files.
B . An error is reported and tablespace creation fails.
C . Data files are created with names generated by the instance.
D . The tablespace can be extended without specifying the data file.
E . Data files belonging to the USERS tablespace cannot be renamed.
-
Which statement creates a new user?()
A . CREATIVE USER susan;
B . CREATIVE OR REPLACE USER susan;
C . CREATE NEW USER susan DEFAULT
D . CREATE USER susan IDENTIFIED BY blue;
E . CREATE NEW USER susan IDENTIFIED BY blue;
F . CREATE OR REPLACE USER susan IDENTIFIED BY blue
-
You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? ()
A . The member jobs would get dropped when the job class is dropped.
B . Both the jobs would be executed concurrently.
C . The member jobs would get disabled when the job class is dropped.
D . The attributes defined at the class level would be applied to both the jobs.
E . Jobs in the job class must have been assigned the same priority.
-
You executed the following command to create a tablespace called SALES_DATA: > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace ()
A . The database automatically determines the extent-sizing policy for the tablespace.
B . The segments are automatically shrunk when the contents are removed from them.
C . The allocation of extents within the tablespace is managed through the dictionary tables.
D . The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E . The space utilization description of the data blocks in segments is managed through free lists.MANUAL
-
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
A . The SGA Tuning Advisor
B . The SQL Access Advisor
C . The SQL Tuning Advisor
D . The Memory Advisor
-
The user SYS creates a job by using the following command:
https://assets.asklib.com/images/image2/2018080215180228159.jpg
Which two statements are true about the job that was created by the preceding command?()
A . The job is enabled by default after creationB . The job is automatically dropped after the end dateC . The job executes with the privileges of the user SYSD .https://assets.asklib.com/images/image2/2018080215181385239.jpg
-
You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?()
A . All system users have access to the MySQL server via—login path local
B . login-path can be used only for MySQL servers running on a local machine
C . login-path allows you to provide login credentials without passing clear text passwords on the command line
D . When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
-
An administrator creates a vNIC and assigns it to Fabric A with the fabric failover feature enabled. Which statement is true?()
A . A· unique vEthernet interface will be created on Fabric A· and Fabric B·
B . A· vEthernet interface will be created only on Fabric A·
C . A· vEthernet interface will be created on Fabric A·, and move across to Fabric B· in the event of failure
D . Fabric B· will learn the vEthernet interface from Fabric A· through a GARP E· The same vEthernet interface will be created on Fabric A· and Fabric B·
-
Krstin has created a page in the videos application .which one of the following statements about pages is not true ?()
A . pages are design elements
B . Pages can be full-text indexed
C . pages can be referenced by outlines or frames
D . pages can include text,graphics ,applets,and link
-
Which statement will NOT create a tablespace?()
A . CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc(datafile)’;
B . CREATE TABLESPACE DATA1 DATAFILE ’+grp1’;
C . CREATE TABLESPACE DATA1 DATAFILE ’+data1(tempfile)’;
D . CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’;
-
You want to create a temporary table while executing a procedure in a form. Which statement is true?()
A . You cannot create a table form within Forms.
B . You must use the FORMS_DDL built-in to create the table.
C . You must use the DBMS_DYNAMIC_DDL package to create the table.
D . You can write the CREATE TABLE statement directly into the trigger.
-
You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()
A . The database automatically determines the extent-sizing policy for the tablespace.
B . The segments are automatically shrunk when the contents are removed from them.
C . The allocation of extents within the tablespace is managed through the dictionary tables.
D . The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E . The space utilization description of the data blocks in segments is managed through free lists.
-
You executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5ignorecase=N Which statement describes the purpose of the above password file()
A . It records usernames and passwords of users when granted the DBA role.
B . It contains usernames and passwords of users for whom auditing is enabled.
C . It is used by Oracle to authenticate users for remote database administration.
D . It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem grou
-
Which is a valid CREATE TABLE statement? ()
A . CREATE TABLE EMP9$# AS (empid number(2));
B . CREATE TABLE EMP*123 AS (empid number(2));
C . CREATE TABLE PACKAGE AS (packid number(2));
D . CREATE TABLE 1EMP_TEST AS (empid number(2))
-
You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?()
A . It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
B . It contains username and passwords of database users who are members of the OSOPER operating system group.
C . It contains usernames and passwords of database users who are members of the OSDBA operating system group.
D . It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
E . It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
-
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()
A . It is a SQL script.
B . It is a PL/SQL file.
C . It is an operating system (OS) file.
D . It is a Recovery Manager (RMAN) script
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? ()
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***