-
Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）
A . use the @currenty in thr column formula in the view
B . Select currency on the numbers tab in the view properties box
C . Select currency on the numbers tab in the column properties box
D . Select currency on the numbers tab in the field properties box&e
-
ou are developing an ASP.NET MVC 2 application. You create a view that will be returned by action methods in multiple controllers. You need to place the view in the appropriate folder. To which subfolder within the Views folder should you add the view？（）
A . Master
B . Default
C . Shared
D . Commo
-
You want to allow Router R1 to immediately become the active router if its priority is highest than the active router fails. What command would you use if you wanted to configure this？ （）
A . en standby preempt
B . standby preempt enable
C . standby preempt
D . hot standby preempt
-
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
-
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）
A . Use the DROP DATAFILE command.
B . Use the DROP TABLESPACE command.
C . Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
D . Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
-
You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）
A . by using the ANALYZE utility
B . by using the DBVERIFY utility
C . by using the DB_BLOCK_CHECKING parameter
D . by using the DBMS_REPAIR package
-
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 want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）
A . runtime ()
B . runtimeMbeanServer ()
C . connectRuntime ()
D . beginRuntime ()
E . serverRuntime ()
-
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）
A . V$DATABASE
B . V$FLASHBACK_DATABASE_STAT
C . V$FLASHBACK_DATABASE_LOG
D . V$RECOVERY_FILE_DEST
-
An operator wants to view all the scheduled jobs on a system. Which of the following locations would house scheduled jobs?（）
A . /etc/var/spool
B . /var/spool/cron
C . /var/sched/jobs
D . /usr/sched/cronta
-
During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information？（）
A . V$LOGFILE
B . V$RECOVER_LOG
C . V$RECOVER_DATABASE
D . V$LOG_RECOVER
E . V$LOG
-
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）
A . Displays only the list of default values
B . Displays only the list of all basic parameters
C . Displays the currently in effect parameter values
D . Displays only the list of all advanced parameters
E . Displays the list of all the parameter files of a database
F . Displays the current contents of the server parameter file.
-
View the following SQL statements:
https://assets.asklib.com/images/image2/2018080211430018041.jpg
You want to back out transaction T2. Which option would you use?（）
A . It is possible, but transaction T3 also backs out.
B . It is possible with the NOCASCADE_FORCE option.
C . It is possible with the NONCONFLICT_ONLY option.
D . It is not possible because it has conflicts with transaction T3.
-
You want to capture WebLogic internal events correlated with JVM events for viewing offline. What three actions must you take to enable this within WebLogic?（）
A . Run WebLogic in a JRockit JVM and ensure the Flight Recorder is enabled.
B . Configure the WebLogic Diagnostic Framework Event Volume to Low, Medium, or High depending on the type of events you want to capture.
C . Configure the WebLogic Diagnostic Framework bridge to send events to the JRockit Flight Recording.
D . Take a dump from the default recording or create a new recording for the time period you want to capture.
-
Which IOS command would you enter if you wanted to view a list of IBGP and EBGP neighborrelationships that are configured？（）
A . show ip bgp
B . show ip bgp paths
C . show ip bgp peers
D . show ip bgp summary
E . show ip bgp protocol
-
Which view will you use to view information regarding the jobs that are currently running in a database？（）
A . DBA_SCHEDULER_RUNNING_JOBS
B . DBA_SCHEDULER_JOB_RUN_DETAILS
C . DBA_SCHEDULER_JOBS
D . DBA_SCHEDULER_JOB_LOG
-
Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）
A . use the @function @decimal in the column formula in the view
B . select decimal on the numbers tab in the view properties box
C . select decimal on the numbers tab in the column properties box
D . use the @function @decimal to format the value in the field on the form that will display in the view&e
-
You are granted the CREATE VIEW privilege. What does this allow you to do? （）
A . Create a table view.
B . Create a view in any schema.
C . Create a view in your schema.
D . Create a sequence view in any schema.
E . Create a view that is accessible by everyone.
F . Create a view only of it is based on tables that you created.
-
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）
A . Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
B . Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
C . Issue the SERVICES command at the LSNRCTL> prompt.
D . Issue the STATUS command at the LSNRCTL> prompt.
-
You should check the security guideboard if you want to （ ）.
-
If you want to phone him, you’ll have to ____the number in the book first.
-
If you want the guest to sign the bill, what should you say？
-
lf you want to telephone her you will have to _____the number in the book.
A．look at
B．look into
C．look through
D．look up
-
If you want to eat Chinese food, you will go to the restaurant in（）
A．Fairview Hotel
B．First Hotel
C．Orchard Hotel
D．Osaka Hotel
