Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Data Systems Administration > All Domains > Flashcards

All Domains Flashcards

1
Q

What is the default database character set for Oracle Database 12c?

A

AL32UTF8

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

True or False: Oracle Database 12c supports multi-tenant architecture.

A

True

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

Fill in the blank: The Oracle Database 12c can support up to _____ pluggable databases.

A

252

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
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
5
Q

Which Oracle Database feature allows for the consolidation of multiple databases?

A

Multi-tenant architecture

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

What is the maximum size of a pluggable database in Oracle Database 12c?

A

Up to 8 exabytes

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

What command is used to grant privileges to a user in Oracle Database?

A

GRANT

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

True or False: The Oracle Database 12c can automatically tune SQL queries.

A

True

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

What type of backup can be performed without taking the database offline?

A

Hot backup

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

What is the command to create a pluggable database?

A

CREATE PLUGGABLE DATABASE

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

Which Oracle tool is used for monitoring database performance?

A

Oracle Enterprise Manager

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

What is the purpose of the Oracle Data Pump?

A

To perform high-speed data and metadata transfer

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

Fill in the blank: The Oracle Database 12c uses _____ to manage memory.

A

Automatic Memory Management (AMM)

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

What is the default mode for Oracle Database 12c installations?

A

Standard Edition

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

True or False: Oracle Database 12c supports JSON data types.

A

True

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

What command is used to start an Oracle database?

A

STARTUP

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

What is the purpose of the Oracle Flashback technology?

A

To recover data from a past point in time

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

Which Oracle Database component manages user sessions?

A

Oracle Listener

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

What is the command to remove a user from Oracle Database?

A

DROP USER

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

Fill in the blank: The Oracle Database 12c uses _____ to ensure data integrity.

A

Transactions

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

What is the purpose of Oracle’s Real Application Clusters (RAC)?

A

To allow multiple instances to access a single database

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

What command is used to create a tablespace in Oracle Database?

A

CREATE TABLESPACE

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

True or False: Oracle Database 12c can be run on both Linux and Windows operating systems.

A

True

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

What is the maximum number of columns allowed in a table in Oracle Database 12c?

A

1000

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What feature in Oracle Database 12c allows for online table redefinition?
DBMS_REDEFINITION
26
What is the primary purpose of the Oracle Recovery Manager (RMAN)?
To perform backup and recovery operations
27
What command is used to alter the structure of an existing table?
ALTER TABLE
28
Fill in the blank: The Oracle Database 12c uses _____ for indexing.
B-trees and Bitmap indexes
29
What is the command to show the current database status?
SELECT STATUS FROM V$INSTANCE
30
True or False: Oracle Database 12c supports partitioning of tables.
True
31
What is the command to create a synonym in Oracle Database?
CREATE SYNONYM
32
What is the default listener port for Oracle Database?
1521
33
What is the purpose of a control file in Oracle Database?
To store metadata about the database structure and state
34
Fill in the blank: The Oracle Database 12c uses _____ for user authentication.
Oracle Net Services
35
What is the command to view active sessions in Oracle Database?
SELECT * FROM V$SESSION
36
What feature allows Oracle Database to automatically manage data placement?
Automatic Data Optimization
37
True or False: Oracle Database 12c allows for cross-platform database migration.
True
38
What is the command to create an index on a table in Oracle Database?
CREATE INDEX
39
What is the purpose of the Oracle Audit feature?
To track user activities and changes in the database
40
Fill in the blank: Oracle Database 12c uses _____ for data compression.
Hybrid Columnar Compression
41
What command is used to drop a tablespace in Oracle Database?
DROP TABLESPACE
42
What is the role of the Oracle Data Guard?
To provide disaster recovery and data protection
43
True or False: In Oracle Database 12c, a tablespace can contain multiple data files.
True
44
What command is used to create a sequence in Oracle Database?
CREATE SEQUENCE
45
What is the purpose of the Oracle Resource Manager?
To manage system resources and workload
46
Fill in the blank: The Oracle Database 12c uses _____ for session management.
Session Pooling
47
What is the command to alter a user's password in Oracle Database?
ALTER USER
48
True or False: Oracle Database 12c supports the use of PL/SQL for programming.
True
49
What command is used to create a materialized view in Oracle Database?
CREATE MATERIALIZED VIEW
50
What is the purpose of the Oracle Flash Recovery Area?
To store backup files and recovery-related files
51
Fill in the blank: The Oracle Database 12c uses _____ to manage database security.
Fine-Grained Access Control
52
What is the command to rename a table in Oracle Database?
ALTER TABLE ... RENAME TO
53
True or False: Oracle Database 12c allows for the creation of external tables.
True
54
What is the purpose of the Oracle Scheduler?
To automate and manage job scheduling
55
What command is used to create a trigger in Oracle Database?
CREATE TRIGGER
56
Fill in the blank: Oracle Database 12c uses _____ to manage user roles.
Role-Based Access Control
57
What is the command to grant a role to a user in Oracle Database?
GRANT ROLE
58
True or False: Oracle Database 12c supports in-memory processing.
True
59
What is the command to create a database link in Oracle Database?
CREATE DATABASE LINK
60
What is the purpose of the Oracle Automatic Storage Management (ASM)?
To manage database storage and optimize performance
61
Fill in the blank: The Oracle Database 12c uses _____ for data encryption.
Transparent Data Encryption (TDE)
62
What command is used to disable a trigger in Oracle Database?
ALTER TRIGGER ... DISABLE
63
True or False: Oracle Database 12c allows for online table partitioning.
True
64
What is the command to analyze a table in Oracle Database?
ANALYZE TABLE
65
What is the purpose of the Oracle SQL Developer tool?
To provide a graphical interface for database management and development

Data Systems Administration (5 decks)

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