Discussion
Home ‣ Certification ‣ Oracle Certification See What Others Are Saying!
- Question
Multiple users can share a local temporary table
Options- A. TRUE
- B. FALSE
- Correct Answer
- FALSE
ExplanationMultiple users can't share a local temporary table
- 1. Which hardware platform (or platforms) are supported by Windows 2000?
Options- A. The Intel Pentium/ 166MHZ (and higher) platform
- B. The Compac Alpha platform
- C. The PowerPC platform
- D. The MIPS R4000 platform Discuss
- 2. You decide to change the file system on your Windows 2000 computer. You want to change drive C: from FAT to NTFS. What should you type at the command prompt?
Options- A. FORMAT C: /FS : NTFS
- B. CONVERT C: /FS : NTFS
- C. FORMAT C: /NTFS
- D. CONVERT C: /NTFS Discuss
- 3. You perform a normal backup for your company once a week. In addition, you want to perform a backup of data each day in between normal backups. You want to minimize the amount of time it takes to perform these backups. Which backup type should you use on the days in between normal backups?
Options- A. Normal
- B. Incremental
- C. Differential
- D. Copy Discuss
- 4. You are choosing a Windows 2000 operating system to use on a new computer at your company. This new computer will be a heavily used SQL server in your enterprise network environment. which operating system should you choose?
Options- A. Windows 2000 professional
- B. Windows 2000 Server
- C. Windows 2000 Advanced Server
- D. Windows 2000 Datacenter Server Discuss
- 5. What is the maximum number of triggers, can apply to a single table?
Options- A. 8
- B. 10
- C. 12
- D. 14 Discuss
- 6. Why do you need common fields in a Database? Discuss
- 7. Insert command falls in which sub-language of SQL ?
Options- A. DCL
- B. DQL
- C. DML
- D. DDL Discuss
- 8. How many joining conditions are required to join 4 tables in SQL?
Options- A. 1
- B. 2
- C. 3
- D. 4 Discuss
- 9. What command would you use to create a backup control file? Discuss
- 10. The SQL keyword BETWEEN is used:
Options- A. for ranges
- B. as a wildcard
- C. to limit the columns displayed
- D. All the above Discuss
More questions
Correct Answer: The Intel Pentium/ 166MHZ (and higher) platform
Explanation:
The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.
Correct Answer: CONVERT C: /FS : NTFS
Explanation:
The convert.exe command is used to change a volume's file system from FAT to NTFS.
Correct Answer: Incremental
Explanation:
In terms of the time it takes to perform backups, the incremental backup will take the least amount of time because it is not a cumulative backup, like the differential backup.
Correct Answer: Windows 2000 Advanced Server
Explanation:
Windows 2000 Advanced Server is optimized for use on servers (such as SQL servers) in an enterprise network environment.
Correct Answer: 12
Explanation:
Maximim number of triggers that can be applied to a single table is 12
Correct Answer: A database that contains multiple tables related through common fields A common field is a field of data that is shared among all forms in a database Without them, it would be difficult and/or time-consuming to create other forms
Correct Answer: DML
Correct Answer: 3
Explanation:
To join 'n' tables 'n-1' conditions should be satisfied.
So to join 4 tables 3 conditions should be satisfied.
Correct Answer: Alter database backup control file to trace
Correct Answer: for ranges
Explanation:
In SQL, BETWEEN Keyword is used for ranges like Number Ranges, Date Ranges, etc...
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.