-
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
-
Which initialization parameter must you set to enable automatic archiving? ()
A . LOG_ARCHIVE_DEST
B . LOG_ARCHIVE_START
C . LOG_ARCHIVE_FORMAT
D . LOG_ARCHIVE_MAX_PROCESSES
-
Which three statements regarding the server parameter file (SPFILE) are true()
A . An SPFILE is a binary file.
B . An SPFILE cannot reside on a client.
C . An SPFILE cannot contain static parameters.
D . An SPFILE can store changes persistently across instance restarts.
E . An SPFILE can be read by the database server, but it is not written to by the server.
F . An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.
-
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? ()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
When creating a SQL tuning set,which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?()
A . Filter versions
B . Filter loads
C . Filter tasks
D . Filter optio
-
Which site-to-site VPN solution allows Cisco routers, PIX Firewalls, and Cisco hardware clients to act as remote VPN clients in order to receive predefined security policies and configuration parameters from the VPN headend at the central site?()
A . Easy VPN
B . GRE tunneling
C . Virtual Tunnel Interfaces
D . Dynamic Multipoint VPN
E . Group Encrypted Transport VPN
-
Which site-to-site VPN solution allows Cisco routers, PIX Firewalls, and Cisco hardware clients to act as remote VPN clients in order to receive predefined security policies and configuration parameters from the VPN headend at the central site?()
A . Easy VPN
B . GRE tunneling
C . Virtual Tunnel Interfaces
D . DynamicMultipoint VPN
E . Group Encrypted Transport VPN
-
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()
A . ROWS
B . SKIP
C . LOAD
D . BINDSIZE
-
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()
A . NLS_LANG
B . NLS_COMP
C . NLS_SORT
D . None of the above
-
Which statements about the MEMORY_TARGET initialization parameter are true?()
A . MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
B . MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C . MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D . MEMORY_TARGET is static and cannot be modified without shutting down the instance
-
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
You issued the following statement: SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1; Which parameter is NOT overridden by using the above statement?()
A . the value of the NLS_LANGUAGE variable
B . the value of the NLS_TERRITORY variable
C . the value of the NLS_CURRENCY variable
D . the character encoding scheme used by the client applicatio
-
Which site-to-site VPN solution allows Cisco routers, PIX Firewalls, and Cisco hardware clients toact as remote VPN clients in order to receive predefined security policies and configuration parameters from the VPN headend at the central site?()
A . Easy VPN
B . GRE tunneling
C . Virtual Tunnel Interfaces
D . Dynamic Multipoint VPN
E . Group Encrypted Transport VPN
-
Which statements regarding the server parameter file (SPFILE) are true()
A . An SPFILE is a binary file.
B . An SPFILE cannot reside on a client.
C . An SPFILE cannot contain static parameters.
D . An SPFILE can store changes persistently across instance restarts.
E . An SPFILE can be read by the database server, but it is not written to by the server.
F . An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database
-
You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause?()
A . ALL
B . PFILE
C . BOTH
D . NONE
E . SPFILE
F . MEMORY
G . INSTANCE
H . DATABASE
-
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()
A . NLS_LANG
B . NLS_COMP
C . NLS_SORT
D . None of the above
-
Which two routing interface parameters are supported in OSPF implementations?()
A . retransmit - interval
B . de ad - interval
C . stub area
D . virtual link
E . NSSA area
-
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()
A . Bind Variable Peeking
B . SQL Plan Baselines
C . Adaptive Cursor Sharing
D . Bind variable used in a SQL statement
E . Literals in a SQL statement
-
When creating a role in a Cisco Nexus 7000 Series Switch, rules are used to define the type of operations that a role will allow the user to perform. Which two of these parameters cannot be applied as a rule? ()
A . port-profile
B . command
C . access-list
D . feature-group
E . OID
-
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?()
A . The optimizer adds the new plan to the plan history.
B . The optimizer selects the new plan for the execution of the SQL statement.
C . The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D . The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E . The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
-
Which of these are valid Flashback Database recovery point parameters?()
A . SCN
B . Timestamp
C . Named recovery point
D . Transaction ID
E . Session ID
-
Which parameter or parameters are used to calculate OSPF cost in cisco routers?()
A . Bandwidth,Delay,and MTUB
B . andwidth
C . Bandwidth and MTU
D . Bandwidth,MTU,Reliability,Delay,and Load
-
You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()
<img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' />
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
-
Click the Exhibit button.When configuring WXC A‘s local WAN parameters, which QoS network parameter would you choose?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/7a3e04e05d324bd96ad245b89b3b2356.jpg' />
A. over-subscribed
B. under-subscribed
C. dedicated circuits
D. nondedicated circuits