Database Management System (DBMS)

201. ___________ commands in SQL allow controlling access to data within database:

1. Database
2. Data
3. Data control
4. All of these

View answer

202. How many interfaces provided by oracle:

1. 1
2. 2
3. 3
4. 4

View answer

203. In which are interface provided by oracle:

1. SQL *PLUS
2. SQL*PLUS command line interface
3. SQL Plus Worksheet(introduced in ORACLE8i)
4. SQL *PLUS(introduced in ORACLE9i)
5. All of these

View answer

204. SQL has how many main commands for DDL:

1. 1
2. 2
3. 3
4. 4

View answer

205. Which are main commands for DDL in SQL:

1. CREATE
2. ALTER
3. DROP
4. All of these

View answer

206. How many data types in oracle:

1. 2
2. 3
3. 4
4. 5

View answer

207. In which are the data types in oracle:

1. ANSI standard data types
2. Oracle defined data types
3. Both
4. None

View answer

208. A ___________ is a query that retrieves rows from more than one table or view:

1. Start
2. End
3. Join
4. All of these

View answer

209. A condition is referred to as ___________:

1. Join in SQL
2. Join condition
3. Both
4. None

View answer

210. Which oracle is the join condition is specified using the WHERE clause:

1. Oracle 9i
2. Oracle 8i
3. Pre-oracle 9i
4. Pre-oracle 8i

View answer