1. The following command was issued on the tablespace containing the ZIP_CODE ta
ID: 3866336 • Letter: 1
Question
1. The following command was issued on the tablespace containing the ZIP_CODE table.
DROP TABLESPACE USER_REF;
What happens?
A. The tablespace and the ZIP_CODE table are dropped.
B. The command fails because the tablespace contains data.
C. The command fails because the ZIP_CODE table was not listed in the command.
D. The tablespace is dropped, and all references to the ZIP_CODE table are removed.
2. User JOHN updates some rows and asks user DAMIR to log in and check the changes before he commits them. Which of the following statements is true?
A. DAMIR can see the changes but cannot alter them because JOHN will have locked the rows.
B. DAMIR will not be able to see the changes.
C. JOHN must commit the changes, so that DAMIR can see them and if necessary roll them back.
D. None of the above
3. Which line of code will cause the following SQL statement to fail?
1 CREATE USER Sam
2 IDENTIFIED EXTERNALLY BY $amP@ssw0rd
3 DEFAULT TABLESPACE Users
4 TEMPORARY TABLESPACE User_Temp
5 QUOTA 2048M ON APPS_DATA
A. 1
B. 2
C. 3
D. 4
E. 5
F. The statement will succeed
4. You want to multiplex a redo log group. Will this involve downtime?
A. Yes, because logfiles can’t be manipulated while the database is open.
B. No, you can always reconfigure logfiles online.
C. No, if your database is in archivelog mode.
D. Yes, because database logging is controlled by static parameters.
5. If your database is in archivelog mode, how can you force an archive?
A. Issue an alter database switch logfile command.
B. Issue an alter system switch logfile command.
C. Issue an alter system log_archive_start command.
D. There is no command to force an archive; they happen automatically.
Explanation / Answer
1. D
the command stated above will drop all references to the tablespace and it's data files from the data dictionary and the controlfile,drop all the objects in the tablespace and remove the physical files from the disk.
2.B
The principle of isolation means that only JOHN can his uncommitted transaction;DAMIR will not be able to see the changes.
3. B
When you create a user, you can specify at most one authentication method. This SQL statement specified both EXTERNALLY and password (BY $amP@ssw0rd) authentication at the same time, which would generate an error when the command was executed.
4. B
The online redo log can always be managed while the database is open (unlike the controlfile).
5.B
A log switch will force an archive, and you effect a log switch with alter system, not alter database.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.