Sustav za upravljanje bazom podataka (34. - 70.)
Test Your Database Knowledge
Welcome to the ultimate quiz to test your knowledge on database management systems! This quiz consists of 37 engaging questions that cover various aspects of database concepts, architecture, and best practices. Whether you're preparing for a certification or just looking to enhance your skills, this quiz is designed for you.
- 34 questions focused on database concepts
- Multiple choice and checkbox questions
- Score yourself and track your learning journey
Which two statements are true regarding the segment shrink operation? (Choose two.)
It compacts data within the segment
It decreases I he size of the tablespace
It can be performed only on an offline tablespace
It reclaims unused space and retains it within the tablespace
Which two statements are true regarding the Undo Retention Settings? (Choose two.)
Enabling Retenting Guarantee ensures that only long-running Queries do not fail.
Undo Retention Indicates the time period for which committed transaction data is retained
Enabling Retention Guarantee ensures that long running queries and transactions do not fail.
Undo Retention indicates the time period or which uncommitted transaction data is retained.
Which two statements are true regarding views? (Choose two)
Views contain no data
Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table
Views can be created only on tables in the same schema
Views on one or more tables can be used to update the columns specified in the views
Listed below are the database resident program units and their descriptions in random order
1. Package a. Stored subprogram that is associated with a database table, view or event
2. Procedure b. Standalone program that must return a value
3. Function c. Structure that contains program definitions and PL/SQL code
4. Trigger d. stand-alone program that may or may not return a value which option
specifies the correct definition for each program unit? 1-c, 2-d, 3-b, 4-a
1-c, 2 b, 3-d, 4-a
1-a, 2-b, 3-d, 4-c
1-a, 2-d, 3-b, 4-c
Your database instance in running.db01 is a net service name. You issue a connection request using the following command:
SQL>CONNECT scott/tiger@db01.
Which component receives the request and establishes the appropriate connection?
Listener
User process
Service name
Server process
You added the Following code in the tnsnames.ora file in the client PC:
Sales=
(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=salesdatA (PORT=1521)) (SRVICE_NAME=sales.acme))
Which statement is true regarding the above code with respect to creating a new connect identifier?
It gets created for a database, SALE, in the not work domain ACME on the SALESDATA server.
It generates an error because the server configuration mode-(-dedicated or shared is not specified
It generates an error because the conned identifier name cannot be a part of the SERVICE_NAME
It gets created for a database, SALESDATA, on the server SALES in the network domain called
You want to use the automatic management of backup and recovery operations feature for your database. Which configuration must you set?
Enable the flash recovery area and specify it as the archived redo log destination
Disable the flash recovery area and start the database instance in ARCHIVELOG mode
Enable the flash recovery area but do not specify it as the archived redo log destination
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode
Which statement is true regarding the Oracle Universal Installer (OUI)?
OUI supports the installation of several of several active Oracle homes on the same host
Operating system environment variables need to be set before running the OUI.
OUI can be used to uninstall only the complete Oracle software and not specific products
OUI enables configuring of listener as part of the installation process but not the creation of Net.
Which three statements are true about database storage structures? (Choose three.)
A data file can span across tablespaces
An extent contains one or more segments
Table spaces contain one or more data files
Data objects are stored as segments in tablespaces.
Segments can span across data files within a tablespace
A customer recently had a security audit, when they were told that their test and development environment contained test data, which was the copy of production data, yet was not properly protected. What technology should be used to quickly bring these environments into compliance?
Advanced Security Option
Audit Vault
Database Vault
Data Masking Pack or Enterprise Manager
Label Security
Which two options describe the features of simple views?(Choose two.)
Hide data complexity
Improve data storage
Provide additional level of security
Speed up query and data manipulation language (DML) operations
Which two statements ore true regarding the-Database Configuration Assistant (DBCA)? (Choose two.)
It can be used to delete only the logical structure of a database
It can be used to delete Uu1 logical structure and physical files of a database
It can be used to change the configuration of a database only if it has been created using DBCA
It can be used to change the configurations of o database that has been created either manually or using DBCA
Your database is down. You log in as the user SYS and issue the following command: SQL>STARTUP
Which stops occur and in what order as a result of executing this command?
Only the instance is started
Instance is started and then database is mounted but not opened
Instance is started, then the database is mounted and finally opened
Instance is started, then the database is opened and finally mounted
Which three options correctly match environment variables with their specific functionalities? (Choose three.)
ORACLE_SID: specifies the instance name
ORACLE_SID: specifies the global database name
ORACLE_BASE: specifies the toot of the Oracle Database directory tree in all platforms
ORACLE_BASE: specifies the directory containing the Oracle software executables and network file
ORACLE_HOME: specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms
ORACLE_HOME: specifies the directory containing only the Oracle software executables but not the network files
Choose three areas for which Oracle Database 11g Release 2 and Enterprise Manager offer tools that can recommended solutions on optimal implementation
Indexes
Compression
Data recovery
Data block size
CPU usage
Availability
You started up your database In the NOARCHIVELOG mode. Which are the two implications of this setting? (Choose two.)
The database can be backed up only while it is closed
The database can be completely recovered from Instance failure
The database can be backed up when the database instance is running
The database can be completely recovered from disk failure even after a log switch has happened and online redo logs are overwritten
You started up your database In the NOARCHIVELOG mode. Which are the two implications of this setting? (Choose two.)
The database can be backed up only while it is closed
The database can be completely recovered from Instance failure
The database can be backed up when the database instance is running
The database can be completely recovered from disk failure even after a log switch has happened and online redo logs are overwritten
You have to create a table, STUDENTS, with the columns: STUENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on this table:
Each student must be uniquely identifiable by the STUDENT_ID.
The STUDENT_ID columns should not be left blank.
The student should not be less than15 years of age.
The student can only take a course that is specified in the COURSE table in the database.
Which three constraints must be explicitly enforced on the table?(Choose three)
Check constraint on the COURSE_ID colum
Foreign key constraint on the COURSE_ID column
Check constraint on the DATE_OF_BIRTH column
Unique key constraint on the STUDENT_ID column
Primary key constraint on the STUDENT_ID columns
Which method can you use to receive a notification when the free disk space in the recovery area falls below 10%?
Submit a job that queries the Automatic Workload Repository (AWK).
Create an alert that sends a notification when the threshold value is reached.
Invoke the Database Configuration Assistant (DBCA. To configure notifications and set threshold values.
Specify the users who should receive notifications in the Preferred Credential of the Enterprise Manager
Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning message
Which two statements ore true regarding the status of data file backups after 31 days?
In flash recovery area, they are deleted immediately
In non flash recovery area, they are marked as obsolete and have to be deleted manually
In flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.
In non flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?
Disk mirroring and striping would be done automatically
The database files would be managed by the operating system's file system.
DBCA would not save the database files by using Optimal File Architecture (OFA).
The data files are automatically spread across all available storage devices to optimize performance and resource utilization
Which two statements are true regarding Oracle Net? (Choose two.)
It must reside only on the client for traditional client/server applications
It must reside only on the database server for web-based applications
It must reside on both the web server and database server for web-based applications
It must reside on both the client and database server for traditional client/server applications
Which three statements are true regarding the Database Configuration Assistant (DBCA) templates? (Choose three)
Templates are stored as XML files.
Templates are stored as HTML files
A new template can be created using only an existing database
Seed templates contain only the logical strut tuna of .in existing database
A new template can be created using either an existing database or template
Seed templates contain both the logical structure and physical files of an existing database
Which three statements are true regarding the Database Configuration Assistant (DBCA) templates? (Choose three)
Templates are stored as XML files.
Templates are stored as HTML files
A new template can be created using only an existing database
Seed templates contain only the logical strut tuna of .in existing database
A new template can be created using either an existing database or template
Seed templates contain both the logical structure and physical files of an existing database
Which two statements correctly differentiate undo and redo data? (Choose two.)
Undo reverses a change, whereas redo re-creates a change
Redo reverses a change, whereas undo re-creates a change
Undo protects against inconsistent reads, whereas redo protects against data loss
Redo protects against inconsistent reads, whereas undo protects against data loss
Which two statements correctly differentiate undo and redo data? (Choose two.)
Undo reverses a change, whereas redo re-creates a change
Redo reverses a change, whereas undo re-creates a change
Undo protects against inconsistent reads, whereas redo protects against data loss
Redo protects against inconsistent reads, whereas undo protects against data loss
Which two of the following tasks must you perform in order to benefit from the SQL Query Result Cache?
Use a SQL_QUERY_RESULT_CACHE hint in your SQL statement
Set RESULT_CACHE_MODE to FORCE
Make sure the RESULT_CACHE_MAX_SIZE is greater than 0
Have SQL statements that are executed repeatedly
Use temporary tables
Not use bind variables in your query.
Which two statements are true regarding indexes? (Choose two.)
Column can have multiple indexes created on it.
An index can be created on one or more columns
Index must be created in the same tablespace as the table
Indexes are implicitly created by the PRIMARY KEY and UNIQUE constrains
Which statement is true regarding Automatic Memory Management?
You need to specify only the SGA memory size
You need to specify the SGA and PGA memory sizes separately
You need to specify the total memory size, which is dynamically sized for SGA and PGA components and can be exchanged between the SGA and PGA.
You need to specify the total memory size, which is dynamically sized for SGA and PGA components but cannot be exchanged between the SGA and PGA
Which two statements are true regarding the use of SQL in Oracle database? (Choose two)
SQL is used to control access to the database and its objects.
SQL can handle the creation of variables to store temporary values in a session
SQL allows a user to specify where the data is physically stored on the storage device.
SQL is used to manipulate the data in binary file large objects (LOBs) that are stored outside the database
All SQL statements automatically use the optimizing that is available as part of Oracle database to determine the most efficient means of accessing data.
Your test database is currently running in the ARCHIVELOG mode and you plan to switch to the NOARCHIVELOG mode temporarily. Which type of backup should you perform before switching the mode to ensure database recovery is possible?
Whole backup
Level 0 incremental backup of data files
Full backup of data files using only backup sets
Full backup of data files using only image copies
The RECYCLEBIN parameter is set to on for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? (Choose two.)
All the related indexes and views are automatically dropped
The Flashback Drop feature can recover only the table structure
Only the related indexes are dropped whereas views are invalidated
The Flashback Drop feature can recover both the table structure and its data
Which two statements are true regarding the usage of integrity constraints? (Choose two.)
IEM h column can have only one constraint
Primary key constrain can consist of multiple columns from the same table.
Foreign key column can reference e a primary key column in the same of or different tables
More than one row in a table cannot contain null value In a column with unique constraint.
A check constraint can enforce conditions that refer to the values in other columns in the table
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?
Oracle Not Manager
Listener Control utility
Database Configuration Assistant
Oracle Net configuration Assistant
Which two statements ate true regarding the server parameter file? (Choose two)
It can be edited manually
It can be modified only by the server.
Its settings are persistent across shutdown and startup
It must be maintained on the server and client machines
Which two statements are true regarding the usage of tools in administering an Oracle database? (Choose two.)
Oracle Net Manager: configure a new or existing listener
Data Pump: transfer of data from one database to another
SQL*Loader: load data horn an Oracle database to an external file
Database Upgrade Assistant: upgrade only single-instance databases
Database configuration Assistant (DBCA): create new database using an existing database
The DBA of your database informs you that the Oracle instance has started. What does this imply?
Users can access the data in the database
Only the SGA has been allocated for the database
Only the background and user processes are running
Memory areas have been allocated and background processes have been started.
{"name":"Sustav za upravljanje bazom podataka (34. - 70.)", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to the ultimate quiz to test your knowledge on database management systems! This quiz consists of 37 engaging questions that cover various aspects of database concepts, architecture, and best practices. Whether you're preparing for a certification or just looking to enhance your skills, this quiz is designed for you.34 questions focused on database conceptsMultiple choice and checkbox questionsScore yourself and track your learning journey","img":"https:/images/course4.png"}