Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Data Systems Administration > Managing User Accounts > Flashcards

Managing User Accounts Flashcards

1
Q

What command is used to create a new user in Oracle Database 12c?

A

CREATE USER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False: User accounts in Oracle Database can only be created by users with the ADMIN privilege.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Fill in the blank: To grant a user the ability to connect to the database, you must use the command ____.

A

GRANT CONNECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the default tablespace for a new user in Oracle Database 12c?

A

USER_DATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which command is used to modify an existing user account?

A

ALTER USER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What role must a user have to create other users?

A

DBA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

True or False: A user can have multiple profiles in Oracle Database 12c.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What SQL command is used to drop a user from the Oracle Database?

A

DROP USER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Fill in the blank: The command to lock a user account is ____.

A

ALTER USER <username> ACCOUNT LOCK</username>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a user profile in Oracle Database 12c?

A

A set of limits and resource allocation settings for user accounts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which privilege allows a user to create other users?

A

CREATE USER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

True or False: The password for a user account in Oracle Database must always be changed every 30 days.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What command would you use to unlock a user account?

A

ALTER USER <username> ACCOUNT UNLOCK</username>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which view can be queried to see all users in the Oracle Database?

A

DBA_USERS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does the command ‘GRANT DBA TO <username>' do?</username>

A

It grants the DBA role to the specified user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Fill in the blank: The maximum number of failed login attempts is controlled by the ____ parameter.

A

PASSWORD_LOCK_TIME

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the purpose of the ‘CREATE SESSION’ privilege?

A

It allows a user to connect to the Oracle Database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

True or False: Users can only be assigned to one role at a time.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What command would you use to change a user’s password?

A

ALTER USER <username> IDENTIFIED BY <new_password></new_password></username>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What does the ‘USER’ function return in Oracle Database?

A

The username of the current session.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Fill in the blank: The command to revoke a user’s privileges is ____.

A

REVOKE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is the purpose of the ‘RESOURCE’ role?

A

It provides the necessary privileges for users to create and manage their own objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Which command can be used to view the current user’s privileges?

A

SELECT * FROM USER_SYS_PRIVS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

True or False: User accounts can be created without specifying a default tablespace.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What SQL clause is used to specify the default tablespace when creating a user?
DEFAULT TABLESPACE
26
What is the effect of the 'PASSWORD EXPIRE' clause when creating a user?
It forces the user to change their password upon first login.
27
Fill in the blank: To assign a profile to a user, you use the ____ clause in the CREATE USER command.
PROFILE
28
Which command can be used to see the roles granted to a user?
SELECT * FROM USER_ROLE_PRIVS
29
What is the maximum length of a username in Oracle Database 12c?
30 characters
30
True or False: Users can be created with the same username in different schemas.
False
31
What command would you use to display the current user's username?
SELECT USER FROM DUAL
32
Fill in the blank: The command to set a user’s profile to 'DEFAULT' is ____.
ALTER USER PROFILE DEFAULT
33
What does the 'CREATE ANY TABLE' privilege allow?
It allows the user to create tables in any schema.
34
Which command is used to grant a user the ability to create sessions?
GRANT CREATE SESSION TO
35
True or False: The 'ALTER USER' command can only be executed by the user themselves.
False
36
What is the purpose of the 'CONNECT BY' clause in user management?
It is not directly related to user management; it is used in hierarchical queries.
37
Fill in the blank: The command to change a user's profile is ____.
ALTER USER PROFILE
38
What is the role of the 'SECURITY' parameter in user management?
It determines security policies for user accounts.
39
Which command can be used to create a role in Oracle Database?
CREATE ROLE
40
True or False: A role can inherit privileges from another role.
True
41
What command do you use to revoke a role from a user?
REVOKE FROM
42
Fill in the blank: The command to view all available roles in the database is ____.
SELECT * FROM DBA_ROLES
43
What does the 'CREATE ANY VIEW' privilege allow?
It allows the user to create views in any schema.
44
Which view shows the roles granted to the current user?
USER_ROLE_PRIVS
45
True or False: Users can be assigned multiple roles at the same time.
True
46
What is the command to view user account status?
SELECT USERNAME, ACCOUNT_STATUS FROM DBA_USERS
47
Fill in the blank: The command to create a user with a specified quota on a tablespace is ____.
CREATE USER QUOTA ON
48
What command is used to grant a user access to specific tables?
GRANT SELECT ON TO
49
True or False: The 'ALTER USER' command can be used to change a user's default tablespace.
True
50
What is the purpose of the 'PASSWORD_REUSE_TIME' parameter?
It specifies the number of days before a password can be reused.
51
Fill in the blank: The command to enable a user account is ____.
ALTER USER ACCOUNT UNLOCK
52
What is the maximum number of roles a user can have in Oracle Database 12c?
Unlimited, but practical limits may apply.
53
True or False: A user can be granted a role without any specific privileges.
True
54
What SQL command is used to display all system privileges granted to users?
SELECT * FROM DBA_SYS_PRIVS
55
Fill in the blank: The command to drop a role is ____.
DROP ROLE
56
What is the command to view all users in a specific tablespace?
SELECT * FROM DBA_USERS WHERE DEFAULT_TABLESPACE = ''
57
True or False: User quotas on tablespaces are set to unlimited by default.
True
58
What does the 'GRANT EXECUTE' privilege allow?
It allows the user to execute stored procedures and functions.
59
Fill in the blank: The command to create a user with a specific profile is ____.
CREATE USER PROFILE
60
What SQL command is used to show all privileges assigned to a specific user?
SELECT * FROM USER_SYS_PRIVS WHERE USERNAME = ''
61
True or False: The 'CREATE USER' command can include a temporary tablespace.
True
62
What command is used to grant all privileges to a user?
GRANT ALL PRIVILEGES TO
63
Fill in the blank: The command to change a user’s password to a specific value is ____.
ALTER USER IDENTIFIED BY
64
What is the purpose of the 'DEFAULT ROLE' clause?
It specifies which roles are enabled by default for a user.
65
True or False: User accounts can be created without specifying a password.
False
66
What command is used to grant access to a user's schema?
GRANT ALL ON TO
67
Fill in the blank: The command to create a user with a specific password is ____.
CREATE USER IDENTIFIED BY
68
What does the 'ALTER USER' command do when used with 'ACCOUNT LOCK'?
It locks the specified user account.
69
True or False: The 'GRANT' command can be used to assign privileges to roles.
True
70
What is the command to view user profiles in Oracle Database?
SELECT * FROM DBA_PROFILES
71
Fill in the blank: The command to drop a user and all their objects is ____.
DROP USER CASCADE
72
What is the effect of the 'ENABLE' clause in user management?
It enables a user account that was previously disabled.
73
True or False: A user can have both a local and a global account in Oracle Database.
True
74
What command can be used to view the history of user account changes?
SELECT * FROM DBA_AUDIT_TRAIL
75
Fill in the blank: The command to grant a user the ability to create other users is ____.
GRANT CREATE USER TO
76
What does the 'USERENV' function return?
It returns information about the user's environment.
77
True or False: Users must be assigned a default tablespace upon creation.
False

Data Systems Administration (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions