What is the outcome of this block of code?()https://assets.asklib.com/images/image2/2018080211401883848.jpg
A . It creates a task and workload, and executes the task.
B . It creates a task and workload but does not execute the task.
C . It produces an error because a template has not been created.
D . It produces an error because the SQL Tuning Set has not been created.
-
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?()
A . A syntax error will result as you cannot specify more than one partition in the same statement
B . All data in p1 and p3 partitions are removed and the table definition is changed
C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D . Only the first partition (p1) will be dropped as only one can be dropped at any time
-
our database instance is started using the server parameter file (SPFILE). You executed a command tochange the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
A . The command succeeds only if Automatic Memory Management is not enabled.
B . The command succeeds, but you need to restart the database for changes to take effect.
C . The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D . The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area (SGA)
-
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of the above command?()
A . After two days, the backup will be marked obsolete.
B . After two days, the backup will be deleted from the media.
C . If the RMAN repository has records of two or more recent backups of a file, then the older backup will be deleted from the media.
D . If the RMAN repository has records of two or more recent backups of a file, then the older backup will be marked obsolete.
-
Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command? ()
A . The command would return an error because LOG_BUFFER is a static parameter.
B . The parameter value would be changed and it would come into effect immediately.
C . You need to restart the database so that parameter changes can come into effect.
D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
-
Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command?()
A . The command would return an error because LOG_BUFFER is a static parameter.
B . The parameter value would be changed and it would come into effect immediately.
C . You need to restart the database so that parameter changes can come into effect.
D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
-
You need to create a partitioned table to store historical data and you issued the following command:
https://assets.asklib.com/images/image2/2018080209263145770.jpg
What is the outcome of the above command?()
A . It returns an error because the range partitions P1 and P2 should be of the same range.
B . It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C . It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D . It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.
-
Evaluate the following block of code:
https://assets.asklib.com/images/image2/2018080208432879092.jpg
What is the outcome of the above code?()
A . It produces an error because a fully qualified host name needs to be specified.
B . It produces an error because the range of ports associated with the hosts has not been specified.
C . It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D . It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
-
A system is experiencing performance problems. After checking the CPU usage, the problem identified is that the system is "CPU Bound". Which of the following outcomes will determine if there is a possible CPU constraint?()
A . Low paging
B . High paging
C . Workload manager is not turned on
D . A high run queue length&e
-
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()
A . After two days,a backup will be marked obsolete
B . After two days,a backup will be deleted from the media
C . If the RMAN repository has records of two or more recent backups of a file,then older backups will be deleted from the media.
D . If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
-
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: \> mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?()
A . Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B . An error message is issued because – install is not a valid option for mysqld
C . A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D . Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file
-
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? ()
A . After two days, a backup will be marked obsolete
B . After two days, a backup will be deleted from the media
C . If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D . If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
-
Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
A . The command succeeds only if Automatic Memory Management is not enabled.
B . The command succeeds, but you need to restart the database for changes to take effect.
C . The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D . The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
-
When an employee accept bribes to influence the outcome of a business decision, it is considered as ______.
-
Which of the following is NOT classified into the groups of body language which affect the outcome of a speech?
-
______is the conclusion or the final section of the plot. It is the moment when the complications are resolved and the outcome of the conflicts is reached.
-
The __________ speaker uses communication to achieve some goal or outcome. The __________ speaker is concerned not so much with the outcome of the communication, but with the process.
-
Unregulated power supplies contain three basic components: a transformer, retifier and filter capacitor. Thi type of power supply, because of its simplicity, is the least costly. The disadvantage is that the output voltage is not constant.
-
The Nash equilibrium is an outcome of a game:
-
the well-know verse of \tiger! tiger! Burning bright/in the forest of the night/what immortal hand or eye/could frame thy fearful symmetry?\is written by___________.
-
What is at fault in our present system is not the outcome but the fallible procedure.
A.sublime
B.erroneous
C.plausible
D.impeccable
-
Therefore, today's outcome is_____for us and for the hundreds of other companies who have licensed MP3 technology.
A.disappoints
B.disappointing
C.disappointed
D.disappointment
-
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.C: \> mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?()
A.Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B.An error message is issued because – install is not a valid option for mysqld
C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file
-
_____ is a theory of motivation that concentrates on people’s perceptions of the fairness of their work outcomes relative to, or in proportion to, their work inputs.
A.Equity theory
B.Expectancy theory
C.Goal-setting theory
D.ERG theory
-
The ideal lawyer never forgets that he is an officer of the court, and that he as well as the judge____ responsible for the just outcome of every trial()
A.are
B.was
C.is
D.be