多项选择题
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN;
Which two statements are true()
A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked
相关考题
-
单项选择题
ForwhichdatabaseoperationwouldyouneedthedatabasetobeintheMOUNTstate()
A.renaming the control files
B.re-creating the control files
C.dropping a user in your database
D.dropping a tablespace in your database
E.configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes -
单项选择题
View the Exhibit and examine the output of the query. What do you infer from this()
A.The SGA_TARGET is a static parameter.
B.The instance is started, but the database is not yet open.
C.The server parameter file (SPFILE) was used to start the instance.
D.The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified. -
多项选择题
Whichthreestatementsregardingtheserverparameterfile(SPFILE)aretrue()
A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameters.
D.An SPFILE can store changes persistently across instance restarts.
E.An SPFILE can be read by the database server, but it is not written to by the server.
F.An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.
