• databases Online Quiz - 178
Back
0

databases Online Quiz - 178

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

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

where would you find automatic_ipc parameter ?

technology databases

  1. listener.ora

  2. sqlnet.ora server file

  3. sqlnet.ora client file

  4. tnsnames.ora server file

Show answer
Correct Option: B

Which of the following statements creates an Oracle account, but lets the operating system authenticate logons?

technology databases

  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;

Show answer
Correct Option: B

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

technology databases

  1. An index creation

  2. SQL statements with a GROUP BY clause

  3. A hash join operation

  4. All of the above

Show answer
Correct Option: D

Which of the following statements gives user desmond the ability to alter table gl.accounts?

technology databases

  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;

Show answer
Correct Option: A

Which of the following statements gives user desmond the ability to alter table gl.accounts as well as give this ability to other accounts?

technology databases

  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;

Show answer
Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) grant alter any table with grant option to desmond; This option grants Desmond the ability to alter any table, but it does not give him the ability to grant this permission to other accounts. Therefore, this option is incorrect.

Option B) grant alter on gl.accounts to desmond with admin option; This option grants Desmond the ability to alter the table "gl.accounts" specifically, but it does not give him the ability to grant this permission to other accounts. Therefore, this option is incorrect.

Option C) grant alter any table to desmond with grant option; This option grants Desmond the ability to alter any table, but it does not give him the ability to grant this permission to other accounts. Therefore, this option is incorrect.

Option D) grant alter any table to desmond with admin option; This option grants Desmond the ability to alter any table and also gives him the ability to grant this permission to other accounts. Therefore, this option is correct.

The correct answer is Option D. This option gives Desmond the ability to alter the table "gl.accounts" as well as grant this ability to other accounts.

The following SQL statement will allow user regina to perform which operations on sequence oe.orders_seq? GRANT ALL ON oe.orders_seq TO regina;

technology databases

  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.

Show answer
Correct Option: A,C,D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Select the next value from oe.orders_seq - This option is correct. When the user regina is granted ALL privileges on the sequence oe.orders_seq, it includes the ability to select the next value from the sequence.

Option B) Alter sequence oe.orders_seq to change the next value - This option is incorrect. Granting ALL privileges on a sequence does not allow the user to alter the sequence to change the next value.

Option C) Change the number of sequence numbers that will be cached in memory - This option is correct. Granting ALL privileges on a sequence includes the ability to change the number of sequence numbers that will be cached in memory.

Option D) Both A and C - This option is correct. As explained above, the user regina will be able to select the next value from oe.orders_seq and change the number of sequence numbers that will be cached in memory.

Option E) All of the above - This option is incorrect. Granting ALL privileges on a sequence does not include the ability to alter the sequence to change the next value.

The correct answer is D. This option is correct because the user regina will be able to select the next value from oe.orders_seq, change the number of sequence numbers that will be cached in memory, but not alter the sequence to change the next value.

User system granted SELECT on sh.products to user A using WITH GRANT OPTION. A then granted SELECT on sh.products to user B. A has left the company, and his account is dropped. What happens to B’s privileges on sh.products?

technology databases

  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

Show answer
Correct Option: A

User system granted SELECT ANY TABLE to user A using WITH ADMIN OPTION. A then granted SELECT ANY TABLE to user B. Ian A left the company, and his account is dropped. What happens to B's privileges?

technology databases

  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.

Show answer
Correct Option: B

AI Explanation

To answer this question, we need to understand how privilege inheritance works in Oracle databases.

When user A is granted the SELECT ANY TABLE privilege with the WITH ADMIN OPTION, it means that A can not only select from any table but also grant the same privilege to other users.

When A grants the SELECT ANY TABLE privilege to user B, B inherits the privilege from A. This means that B retains the privilege independently of A's account status.

Therefore, even if A's account is dropped or revoked, user B will still retain the SELECT ANY TABLE privilege.

The correct answer is B. B retains his privileges.

Which of the following system privileges can allow the grantee to masquerade as another user and therefore should be granted judiciously?

technology databases

  1. CREATE ANY JOB

  2. ALTER USER

  3. CREATE ANY PROCEDURE

  4. All of the above

Show answer
Correct Option: D

Which of the following statements enables the role user_admin in the current session?

technology databases

  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;

Show answer
Correct Option: D

AI Explanation

To enable the role user_admin in the current session, you would use the SET ROLE statement.

Let's go through each option to understand why it is correct or incorrect:

Option A) alter session enable role user_admin; - This option is incorrect because the ENABLE ROLE statement is used to enable a role for a specific user, not for the current session.

Option B) alter session set role user_admin; - This option is incorrect because the SET ROLE statement is missing. The correct syntax for enabling a role using the SET ROLE statement would be ALTER SESSION SET ROLE user_admin;.

Option C) alter role user_admin enable; - This option is incorrect because the ALTER ROLE statement is used to modify the properties of a role, not to enable it for the current session.

Option D) set role user_admin; - This option is correct because the SET ROLE statement is used to enable a role for the current session. Therefore, the correct answer is option D.

The correct answer is option D.

Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar, which has been granted to him?

technology databases

  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

Show answer
Correct Option: B

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

technology databases

  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.

Show answer
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?

technology databases

  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

Show answer
Correct Option: C

Which of the following is invalid db2 component :

technology databases

  1. System Services

  2. Locking Services

  3. SQL Services

  4. Distributed DATA Facilities

Show answer
Correct Option: C

AI Explanation

To answer this question, we need to understand the components of IBM DB2, a relational database management system. Let's go through each option to understand why it is correct or incorrect:

Option A) System Services - This option is a valid component of DB2. System Services provide the basic functions and utilities required for the operation of the DB2 system.

Option B) Locking Services - This option is a valid component of DB2. Locking Services manage the concurrent access to data by multiple users, ensuring data integrity and preventing conflicts.

Option C) SQL Services - This option is invalid. There is no such component called "SQL Services" in DB2.

Option D) Distributed DATA Facilities - This option is a valid component of DB2. Distributed Data Facilities enable the integration and management of data across multiple DB2 systems.

The correct answer is Option C) SQL Services. This option is incorrect because there is no such component in DB2 called "SQL Services".

Package is a

technology databases

  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

Show answer
Correct Option: B

AI Explanation

To answer this question, we need to understand what a package is in the context of computer programming.

Option A) Compiled form of application plan - This option is incorrect. A package is not specifically a compiled form of an application plan. An application plan is a high-level overview of the steps and logic involved in executing an application.

Option B) Compiled form of Database Requests - This option is correct. A package in this context refers to a compiled form of database requests or SQL statements. It is a collection of SQL statements that are pre-compiled and stored in a database for efficient execution.

Option C) Collection of SQL statements - This option is partially correct. A package does contain a collection of SQL statements, but it is more specifically the compiled form of those statements.

Option D) Collection of Application plans - This option is incorrect. A package is not a collection of application plans. As mentioned earlier, an application plan is a high-level overview of the steps and logic involved in executing an application.

Therefore, the correct answer is B) Compiled form of Database Requests.

Responsibility of OPTIMIZER is :

technology databases

  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

Show answer
Correct Option: D

If an object is dropped , all Application plans that were using the object are marked by DB2 as invalid ( True or False)

technology databases

  1. True

  2. False

Show answer
Correct Option: A

If a new object is created , DB2 automatically starts using it (True or False)

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which utility is used to retrieve data from a Image copy

technology databases

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions