programming languages Online Quiz - 81
|Description: programming languages Online Quiz - 81
|Number of Questions: 20
|Created by: Aliensbrain Bot
|Tags: programming languages
How can the mapping files be configured in Hibernate?
It is possible to re-load an object and all its collections at any time, using the xxxx() method. This is useful when database triggers are used to initialize some of the properties of the object.What is the xxxx() method ?
What is the root level element in a hibernate mapping file?
hibernate.cache.use_query_cache setting true enable cache regions ?
Batch fetching is useful incase of ?
what is the default value in hibernate ?
HQL is used in ?
Which things should be considered while deciding the size of undo tablespace in your database ( choose three)
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?
You want to refer the employee personal information stored in Operating System files EMPLOYEE table. You plan to add a new column in EMPLOYEE table to achieve this. Which data type would you use for the new column?
Which two operations can be flashed back using Flashback Technology?
To answer this question, you need to understand the concept of Flashback Technology in Oracle Database.
Flashback Technology is a feature in Oracle Database that allows you to view and manipulate past data and database states. It provides a way to recover a database or a table to a previous point in time without the need for performing a complete database restoration.
Based on the given options, the two operations that can be flashed back using Flashback Technology are:
C. DROP TABLE EMPLOYEES - This option is correct because when you drop a table using the DROP TABLE statement, you can use Flashback Technology to recover the dropped table and its data. By using the FLASHBACK TABLE statement, you can restore the dropped table to a previous point in time.
D. DROP USER SMITH - This option is correct because when you drop a user using the DROP USER statement, you can use Flashback Technology to recover the dropped user and its objects. By using the FLASHBACK DATABASE statement, you can restore the dropped user and its objects to a previous point in time.
Therefore, the correct answer is C. DROP TABLE EMPLOYEES and D. DROP USER SMITH. These options can be flashed back using Flashback Technology.
Your database is in NOARCHIEVELOG mode. After which two operations you should take backup of control file? ( choose two)
Which is the memory area that is created when a dedicated server process is started, and contains data and information for that server process?
What four data protection components have been enhanced in Oracle database 10g release 2
Which is the correct description of the significance of the ORACLE_HOME environment variable?
Which two statements about recovery manager (RMAN) backup are true?
You want the user APP_DBA to administer the oracle database from remote machine. APP_DBA is granted SYSDBA privilege to perform administrative task on the database. Which file is used by oracle database server to authenticate APP_DBA?
The junior DBA of your organization has accidentally deleted the alert log file. What will you do to create new alert log file?
Which two statements are true about the role in Oracle Database?
Which three information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control?