You can use views in almost the same way as __________.

• A) Join
• B) Function
• C) Table
• D) Index

A/an ____________ is a collection of column information corresponding to a single record.

• A) Entity
• B) Attribute
• C) Table
• D) Row

A/an _________________ is a schema object that contains an entry for each value that appears in the column of the table or cluster and provides direct, fast access to rows.

• A) Index
• B) Cluster Table
• C) View
• D) Join

To alter an index, your schema must contain the index or you must have the ______________ system privilege.

• A) ANY INDEX ALTER
• B) ALTER ANY INDEX
• C) ALTER PRIVILEGE
• D) ALTER INDEX

Making an index ____________ is an alternative method to make it unusable or dropping it.

• A) MUTE
• B) INVISIBLE
• C) VISIBLE
• D) UNREADABLE

How many types of views are utilized to control table-related information?

• A) 3
• B) 5
• C) 2
• D) 4

_______________ statement is used to change or rebuild an existing index.

• A) ALTER INDEX
• B) REBUILD INDEX
• C) CHANGE INDEX
• D) UPDATE INDEX

Which of the following table statement is used to delete only the table structure from the database?

• A) Drop
• B) Update
• C) Delete
• D) Create

What is the purpose of the MUL instruction in the context of display memory?

• A) Performs unsigned multiplication
• B) Clears the screen
• C) Multiplies ASCII codes
• D) Controls cursor attributes

How is the screen location calculated (in the context of display memory formation)?

• A) Multiplying row number by 80 and adding column number
• B) Dividing row and column numbers
• C) Adding row and column numbers
• D) Using the MUL instruction

What does the attribute byte in the word designated for one screen location hold?

• A) Video controller instructions
• B) ASCII code for the character
• C) Cursor height information
• D) Foreground and background colors

Which of following interrupt is used for BIOS Video Services

• A) 0x13
• B) 0x10
• C) 0x16
• D) 0x21

How is the video device perceived by the computer in terms of memory?

• A) Independent of system memory
• B) Only accessible through I/O ports
• C) Two-dimensional space with ASCII codes
• D) Linearly mapped memory

Service numbers are given in ________ register while sub services in ________

• A) AH, AL or BL
• B) Ax, Bx
• C) Al, Ah or ax
• D) AX, Al or Ah

What effect does setting bit 7 in the attribute byte have on the foreground character (in the context of display memory)?

• A) Clears the screen
• B) Initiates blinking
• C) Intensity of foreground color
• D) Changes background color

While displaying something on screen, why is ES loaded with the segment of video memory?

• A) To open a window to the video memory
• B) To access data
• C) To manipulate ASCII codes
• D) To control cursor position

What is the significance of the memory location B8000 in the context of Display Memory?

• A) BIOS vendor's problem location
• B) Segment register for accessing video memory
• C) Physical memory location for video controller's memory
• D) Default cursor position

What is the purpose of sending 0x40 to the VGA card in the context of display memory formation?

• A) Change cursor position
• B) Set resolution
• C) Clear the screen
• D) Turn pixels on and off

How many I/O Ports are there?

• A) 65536
• B) 65524
• C) 65548
• D) 65520

Which of following jump would perform better to sort the signed numbers?

• A) jz
• B) jcx
• C) jge
• D) jle