Question { 26322 }
What are cursors? Explain different types of cursors?
Answer
Is This Answer Correct ? | 17 Yes | 6 No |
How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
Answer
Is This Answer Correct ? | 12 Yes | 6 No |
Define candidate key, alternate key, composite key?
Answer
Is This Answer Correct ? | 151 Yes | 207 No |
Question { 7463 }
What is bit datatype and what's the information that can be
stored inside a bit column?
Answer
Is This Answer Correct ? | 3 Yes | 3 No |
Question { 10530 }
Give two examples of how you might determine the structure
of the table DEPT.
Answer
Is This Answer Correct ? | 12 Yes | 0 No |
Question { 13737 }
Compare and contrast TRUNCATE and DELETE for a table.
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 10575 }
Name a tablespace automatically created when you create a
database.
Answer
Is This Answer Correct ? | 6 Yes | 0 No |
Question { 7643 }
When creating a user, what permissions must you grant to
allow them to connect to the database?
Answer
Is This Answer Correct ? | 10 Yes | 2 No |
Question { 7453 }
What view would you use to look at the size of a data file?
Answer
Is This Answer Correct ? | 4 Yes | 0 No |
Question { 11718 }
How can you rebuild an index?
Answer
Is This Answer Correct ? | 10 Yes | 2 No |
Question { 6387 }
Explain what partitioning is and what its benefit is.
Answer
Is This Answer Correct ? | 2 Yes | 0 No |
Question { 18910 }
What is the difference between the SQL Loader and IMPORT
utilities?
Answer
Is This Answer Correct ? | 10 Yes | 2 No |
Question { 13190 }
Name two files used for network connection to a database.
Answer
Is This Answer Correct ? | 9 Yes | 1 No |