0

databases Online Quiz - 178

Description: databases Online Quiz - 178
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query :-) ?

  1. True

  2. False


Correct Option: A

where would you find automatic_ipc parameter ?

  1. listener.ora

  2. sqlnet.ora server file

  3. sqlnet.ora client file

  4. tnsnames.ora server file


Correct Option: B
  1. create user ops$admin identified by os;

  2. create user ops$admin identified externally;

  3. create user ops$admin nopassword;

  4. create user ops$admin authenticated by os;


Correct Option: B
Explanation:

To solve this question, the user needs to have knowledge about Oracle database user authentication methods.

Option A: This option creates an Oracle user account with the name 'ops$admin' and the password 'os'. However, it uses a password file for authentication, not the operating system. Therefore, this option is incorrect.

Option B: This option creates an Oracle user account with the name 'ops$admin' and identifies it as an external user, which means that authentication is done by the operating system. Therefore, this option is correct.

Option C: This option creates an Oracle user account with the name 'ops$admin' and no password. This is not a secure method of authentication and is not related to operating system authentication. Therefore, this option is incorrect.

Option D: This option creates an Oracle user account with the name 'ops$admin' and specifies that it should be authenticated by the operating system. However, it does not create an operating system account for the user. Therefore, this option is incorrect.

The Answer is: B

Which of the following types of statements can use a temporary tablespace?

  1. An index creation

  2. SQL statements with a GROUP BY clause

  3. A hash join operation

  4. All of the above


Correct Option: D
  1. grant alter on gl.accounts to desmond;

  2. grant alter to desmond on gl.accounts;

  3. grant alter table to desmond;

  4. allow desmond to alter table gl.accounts;


Correct Option: A
  1. grant alter any table with grant option to desmond;

  2. grant alter on gl.accounts to desmond with admin option;

  3. grant alter any table to desmond with grant option;

  4. grant alter any table to desmond with admin option;


Correct Option: D
  1. Select the next value from oe.orders_seq.

  2. Alter sequence oe.orders_seq to change the next value.

  3. Change the number of sequence numbers that will be cached in memory.

  4. Both A and C.

  5. All of the above.


Correct Option: A,C,D
  1. B loses his SELECT privilege on sh.products.

  2. B retains his SELECT privilege on sh.products.

  3. B loses his SELECT privilege if A was dropped with the CASCADE REVOKE option.

  4. B retains his SELECT privilege if A was dropped with the NOCASCADE REVOKE option


Correct Option: A
  1. B loses his privileges.

  2. B retains his privileges.

  3. B loses his privileges if A was dropped with the CASCADE REVOKE option.

  4. B retains his privileges if A was dropped with the NOCASCADE REVOKE option.


Correct Option: B
  1. alter session enable role user_admin;

  2. alter session set role user_admin;

  3. alter role user_admin enable;

  4. set role user_admin;


Correct Option: D
  1. set role all;

  2. alter user augustin default role all;

  3. alter session enable role info_czar;

  4. alter session enable info_czar identified by brozo


Correct Option: B

Which things should be considered while deciding the size of undo tablespace in your database ( choose three)

  1. The size of an undo block

  2. The size of the redo log files.

  3. The size of the database buffer cache.

  4. The value of the UNDO_RETENTION parameter.

  5. Undo blocks generated per second.


Correct Option: A,D,E

You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who performing the transactions and the values used in the transactions. Also you plan to transfer these values to another table for analysis. How would you achieve this?

  1. By auditing the all DML operations on table.

  2. By using external table.

  3. By using triggers.

  4. By using anonymous PL/SQL blocks


Correct Option: C
  1. System Services

  2. Locking Services

  3. SQL Services

  4. Distributed DATA Facilities


Correct Option: C
  1. Compiled form of application plan

  2. Compiled form of Database Requests

  3. Collection of Sql statements

  4. Collection of Application plansCollection of Application plans


Correct Option: B
  1. Compiles the SQL statements

  2. Complies the list of packages into application plan

  3. Stored the application plan and packages into Directory

  4. Chooses the best access path from catalog tables


Correct Option: D
Explanation:

To answer this question, the user needs to know about the role of an optimizer in database management systems.

The optimizer is a component of a database management system (DBMS) that is responsible for generating the most efficient execution plan for a given SQL query.

Now let's go through each option and explain why it is right or wrong:

A. Compiles the SQL statements: This option is partially correct. The optimizer does not compile SQL statements, but it does analyze the query and generates an execution plan to execute the SQL statement.

B. Complies the list of packages into application plan: This option is incorrect. The job of the precompiler is to compile the list of packages into an application plan, not the optimizer.

C. Stored the application plan and packages into Directory: This option is incorrect. The job of the precompiler is to store the application plan and packages into a directory, not the optimizer.

D. Chooses the best access path from catalog tables: This option is correct. The optimizer analyzes the query and chooses the best access path from a set of possible access paths based on the metadata stored in the catalog tables.

Therefore, the correct answer is:

The Answer is: D

  1. True

  2. False


Correct Option: A
Explanation:

To solve this question, the user needs to understand the concept of object dropping in DB2 and how it affects application plans.

When an object is dropped in DB2, all application plans that use that object are invalidated by DB2. This is because the object no longer exists and any references to it in the application plans are no longer valid. Therefore, the correct answer is:

The Answer is: A. True

  1. True

  2. False


Correct Option: B
Explanation:

To solve this question, the user needs to know how DB2 handles new objects.

The option A is incorrect because it's false. DB2 does not automatically start using a new object immediately after creation. The object must be activated before it can be used.

The option B is correct because DB2 does not automatically start using a new object. The object must be activated using the ACTIVATE DATABASE command or the ACTIVATE OBJECT command before it can be used.

Therefore, the correct answer is:

The Answer is: B

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS


Correct Option: B
Explanation:

To answer this question, the user needs to have an understanding of database management and utilities used to manipulate data in a database.

The utility used to retrieve data from an Image copy is the UNLOAD utility. This utility is used to extract data from a table or set of tables and write it to an output data set. The output data set can then be used to restore the data to a database using the LOAD utility.

Option A, LOAD, is incorrect because it is used to load data into a database from an input data set. It is the opposite of the UNLOAD utility.

Option C, REORG, is incorrect because it is used to reorganize a table or set of tables in a database, not to retrieve data from an Image copy.

Option D, RUNSTATS, is incorrect because it is used to collect statistics about the data in a table or set of tables. It is not used to retrieve data from an Image copy.

Therefore, the correct answer is:

The Answer is: B. UNLOAD

- Hide questions