-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
When you execute the "ip helper-address" command on a router, which three UDP ports getenabled automatically by default?()
A . 53(DNS)
B . 69(TFTP)
C . 515(LPR)
D . 161(SNMP)
E . 49(TACACS)
-
Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
A . The shrink operation touches every block in the BOOKING table
B . The high-water mark (HWM) for the BOOKING table is shifted from its original position
C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio
-
Given the following scripts, both found in /usr/local/bin, what would the output be when executing /usr/local/bin/script1?()https://assets.asklib.com/images/image2/2018080213562876332.jpg
A . dog cat
B . dog fish
C . mouse cat
D . mouse fish
-
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
A . ’SQL ALTER DATABASE OPEN’;
B . SQL ALTER DATABASE ’OPEN’;
C . OPEN DATABASE;
D . DATABASE OPEN
-
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.)
A . It produces less accurate results of the comparison analysis.
B . It automatically calls the SQL Tuning Advisor for recommendations.
C . It shortens the time of execution and reduces the impact on system resources.
D . Only the changes in the execution plan, and not performance regression, are detected.
-
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: $ rman target / What would be the effect of this command?()
A . RMAN would use the current operating system location to place the backup.
B . RMAN would use the control file of the target database to maintain the backup.
C . RMAN would use the recovery catalog of the target database to maintain the backup.
D . RMAN would use the control file of the target database to maintain the backup metadata.
E . RMAN would use the recovery catalog of the target database to maintain the backup metadata.
-
Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
A . The shrink operation touches every block in the BOOKING table
B . The high-water mark (HWM) for the BOOKING table is shifted from its original position
C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio
-
When the rc.cluster script is executed, cluster processes are started in what orde?()
A . topsvcs,clstrmgr,clsmuxpd,grpsvcs,emsvcs,clinfo
B . topsvcs,grpsvcs,emsvcs,clstrmgr,clsmupxpd,clinfo
C . clstrmgr,clsmuxpd,clinfo,topsvcs,grpsvcs,emsvcs
D . clstrmgr,topsvcs,clxmuxpd,clinfo,grpsvcs,emsvc
-
What happens when thread X executes a wait() method on object A, without owning object A’s lock?()
A . Compilation fails.
B . An exception is thrown.
C . The wait() method has no effect.
D . Thread X receives the lock immediately.
E . Object A moves the thread to the wait pool.
-
Your Oracle Database 10g is online when you execute the following statement: SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF; What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
A . The database does not record flashback logs for MY_TABLESPACE
B . The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C . All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D . None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
-
Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?()
A . remove the ORDER BY clause
B . remove the table alias prefix from the WHERE clause
C . remove the table alias from the SELECT clause
D . prefix the column in the USING clause with the table alias
E . prefix the column in the ORDER BY clause with the table alias
F . replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"
-
When a valid SQL Query in a DB Read step returns 0 rows, which branch of the step will be executed? ()
A . Timeout
B . SQL Error
C . Successful
D . Connection Not Available &e
-
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
A . The DBWn process writes to the datafile.
B . Changes in the background process are recorded.
C . The log file is updated with the current SCN number.
D . The System Change Number (SCN) is recorded in the control file.
E . The changes to the listener configuration in the listener.ora file are recorded.
-
When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()
A . It produces less accurate results of the comparison analysis.
B . It automatically calls the SQL Tuning Advisor for recommendations.
C . It shortens the time of execution and reduces the impact on system resources.
D . Only the changes in the execution plan,and not performance regression,are detected.
-
You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted, but only once. Which three are possible mechanisms for performing this initialization code?()
A . In the init method.
B . In the jspInit method.
C . In the constructor of the JSP’s Java code.
D . In a JSP declaration, which includes an initializer block.
E . In a JSP declaration, which includes a static initializer block.
-
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file,current SPFILE file,data files,and archived redo log
-
Which file contains the attributes used to setup a new user account when executing ’mkuser’ without any flags?()
A . /etc/security/user
B . /etc/security/passwd
C . /etc/security/mkuser.sys
D . /etc/security/mkuser.default
-
Examine the following set of RMAN commands:
https://assets.asklib.com/images/image2/2018080210170026958.jpg
Which statement is true when the RMAN RUN block Is executed?()
A . The execution of the script fails because multiple channels cannot coexist.
B . The script is executed and both the channels are used for the script execution.
C . The new channel, CHI, is Ignored because a channel has been configured already.
D . ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.
-
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
-
If a=5、b=6、c=7、d=8、m=2、n=2, what is the value of n, when the following statement is executed?(m=a>b)&&(n=c>d)
-
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.You plan to use a PresentationTraceSources object when the application is executed by users.When the application is executed in a test environment, all debug information is successfully captured.You need to be able to capture debug information when the application is deployed.What should you do?()
A.Enable WPF tracing in the registry.Restart the application.
B.Enable tracing by modifying local Group Policy.Restart the application.
C.Open the XML configuration file for your application on the user‘s computer.Set tracing to a verbose level.Restart the application.
D.Open the XML configuration file for your application on the user‘s computer.Add a trace listener.Restart the application.
-
If a=5 、 b=6 、 c=7 、 d=8 、 m=2 、 n=2 , what is the value of n, when the following statement is executed ()
A.1
B.2
C.3
D.4
-
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' />
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.