Discussion
Home ‣ Certification ‣ IBM Certification See What Others Are Saying!
- Question
Which statement correctly changes the next extent size?
Options- A. ALTER TABLE customer MODIFY NEXT SIZE 300
- B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300
- C. ALTER TABLE customer MODIFY EXTENT SIZE 300
- D. ALTER TABLE customer NEXT SIZE 300
- Correct Answer
- ALTER TABLE customer MODIFY NEXT SIZE 300
- 1. The status bar of Word 2010 provides useful information about the current document you are working on. You can customize the status bar to add or remove options to suit your needs. By default, which of these options is NOT present on the status bar?
Options- A. Line Number
- B. Page Number
- C. Word Count
- D. Language Discuss
- 2. A large document contains meeting notes from all meeting that took place between HR and Finance. You need to find all instances of 'derive' or 'dive' or 'dave'. What would be the most efficient way to find these terms using the Find & Replace dialog box?
Options- A. Choose Wildcard option and search for d?ve
- B. Choose Wildcard option and search for d*ve
- C. Choose Wildcard option and search for ?ve
- D. Choose Wildcard option and search for *ve Discuss
- 3. 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
- 4. 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
- 5. 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
- 6. 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
- 7. What is the maximum number of triggers, can apply to a single table?
Options- A. 8
- B. 10
- C. 12
- D. 14 Discuss
- 8. Why do you need common fields in a Database? Discuss
- 9. Insert command falls in which sub-language of SQL ?
Options- A. DCL
- B. DQL
- C. DML
- D. DDL Discuss
- 10. How many joining conditions are required to join 4 tables in SQL?
Options- A. 1
- B. 2
- C. 3
- D. 4 Discuss
More questions
Correct Answer: Line Number
Correct Answer: Choose Wildcard option and search for d*ve
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.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.