Tag: databases

Questions Related to databases

Choose the incorrect option about the sql server index

technology databases

  1. Indexes use B-TREE for searching data.

  2. Can create more than one non clustered index on a table.

  3. Up to 256 columns can be combined into a single composite index key.

  4. If not specified, a nonclustered index is created.

Show answer
Correct Option: C

Interface methods can be declared with which the following modifiers
technology databases

  1. public

  2. private

  3. synchronised

  4. native

Show answer
Correct Option: A

Which of the function is used to convert String to Number in java program?
technology databases

  1. toNumber()

  2. conString()

  3. valueOf()

  4. None of the Above

Show answer
Correct Option: C

Implementations of servlets include
technology databases

  1. Apache web server

  2. java.net.HttpURLConnection class

  3. Java web server Tomcat

  4. None of the Above

Show answer
Correct Option: C

The generic two-level data warehouse architecture includes which of the following?
technology databases

  1. At least one data mart

  2. Data that can extracted from numerous internal and external sources

  3. Near real-time updates

  4. All of the above.

Show answer
Correct Option: B

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
technology databases

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system

Show answer
Correct Option: C

Which of the following views provides all the grants on all the objects in the database?

technology databases

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

  4. DBA_TAB_PRIVS

Show answer
Correct Option: A

What is one of the disadvantages of database mirroring?
technology databases

  1. You need to have the same hardware.

  2. The database you mirror to will be in an unused standby state.

  3. You cannot have automatic failover.

  4. You need to have at minimum three servers.

Show answer
Correct Option: B

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

  1. Drop

  2. Delete

  3. Cascade

  4. Truncate

Show answer
Correct Option: D

Which of the following is not a method of a Connection Object in VB.NET?
technology databases

  1. Open

  2. BeginTransaction

  3. Execute

  4. CommitTransaction

Show answer
Correct Option: C