Which SQL statement creates a database link in Oracle?
A) CREATE DATABASE LINK link_name; B) CREATE DB LINK link_name; C) CREATE SYSTEM LINK link_name; D) CREATE DATABASE CONNECTION link_name;
Correct Answer: A) CREATE DATABASE LINK link_name;
Explanation: The correct SQL statement to create a database link is CREATE DATABASE LINK link_name.
Question 42
Which view provides information about the data files in an Oracle database?
A) V$CONTROLFILE B) V$DATAFILE C) V$TABLESPACE D) V$FILESTAT
Correct Answer: B) V$DATAFILE
Explanation: V$DATAFILE provides information about the data files in an Oracle database, including their status and locations.
Question 43
Which Oracle background process monitors the state of the database and handles recovery tasks after a failure?
A) SMON B) CKPT C) PMON D) DBWn
Correct Answer: A) SMON
Explanation: SMON (System Monitor) monitors the state of the database and handles recovery tasks such as instance recovery after a failure.
Question 44
Which of the following commands is used to modify the size of an Oracle data file?
A) ALTER SYSTEM RESIZE DATAFILE; B) ALTER DATABASE RESIZE DATAFILE; C) ALTER TABLESPACE RESIZE DATAFILE; D) ALTER DATAFILE RESIZE;
Correct Answer: B) ALTER DATABASE RESIZE DATAFILE;
Explanation: The correct command to modify the size of an Oracle data file is ALTER DATABASE RESIZE DATAFILE.
Question 45
Which SQL statement is used to enable restricted session mode in Oracle?
A) ALTER DATABASE ENABLE RESTRICTED SESSION; B) ALTER SYSTEM SET RESTRICTED SESSION=TRUE; C) ALTER SYSTEM ENABLE RESTRICTED SESSION; D) ALTER SYSTEM SET SESSION_RESTRICTED=TRUE;
Correct Answer: B) ALTER SYSTEM SET RESTRICTED SESSION=TRUE;
Explanation: The correct SQL statement to enable restricted session mode is ALTER SYSTEM SET RESTRICTED SESSION=TRUE.
Question 46
Which of the following is used to configure memory allocation for the shared pool in Oracle?
A) DB_CACHE_SIZE B) SHARED_POOL_SIZE C) SGA_TARGET D) PGA_AGGREGATE_TARGET
Correct Answer: B) SHARED_POOL_SIZE
Explanation: SHARED_POOL_SIZE is used to configure memory allocation for the shared pool in Oracle.
Question 47
Which SQL statement sets the default undo tablespace for an Oracle database?
A) ALTER SYSTEM SET UNDO_TABLESPACE=undo_tablespace_name; B) ALTER DATABASE SET DEFAULT UNDO TABLESPACE undo_tablespace_name; C) ALTER SYSTEM SET DEFAULT UNDO_TABLESPACE=undo_tablespace_name; D) ALTER SYSTEM SET UNDO_TABLESPACE=undo_tablespace_name DEFAULT;
Correct Answer: A) ALTER SYSTEM SET UNDO_TABLESPACE=undo_tablespace_name;
Explanation: The correct SQL statement to set the default undo tablespace is ALTER SYSTEM SET UNDO_TABLESPACE.
Question 48
Which SQL statement enables force logging mode in an Oracle database?
A) ALTER SYSTEM ENABLE FORCE LOGGING; B) ALTER DATABASE ENABLE FORCE LOGGING; C) ALTER SYSTEM SET FORCE_LOGGING=TRUE; D) ALTER DATABASE SET FORCE_LOGGING=TRUE;
Correct Answer: B) ALTER DATABASE ENABLE FORCE LOGGING;
Explanation: The correct SQL statement to enable force logging mode is ALTER DATABASE ENABLE FORCE LOGGING.
Question 49
What happens if the Oracle SYSTEM tablespace runs out of space?
A) New tables cannot be created. B) The database continues running with warnings. C) The database crashes. D) Users cannot log in.
Correct Answer: C) The database crashes.
Explanation: If the SYSTEM tablespace runs out of space, the database crashes because the SYSTEM tablespace is critical for database operations.
Question 50
Which Oracle background process writes the log buffer to the redo log files?
A) DBWn B) CKPT C) LGWR D) SMON
Correct Answer: C) LGWR
Explanation: LGWR (Log Writer) writes the contents of the log buffer to the redo log files on disk.