SQL SERVER QUESTIONS
1). Explain 12 rule defined by dr. E.F.Codd?
2). What is T-sql ? Explain T-sql Statements ?
3). Explain Database Architecture (physical Architecture, logical architecture, pages and extents, database file and file groups)?
4). Explain Components of SQl Server 2000.
5). Explain Features of SQl Server 2000?
6). What Stored Procedure? List and Explain category of stored Procedure.
7). Explain Six Layer Security Available In SQL server?
9). What is function? List and explain types of SQL Server function?
10). What is index? Explain index Architecture in detail? Give syntax to create a index using t-sql statement.
11). What is cursor? Give Example to create a cursor?
12). What is trigger? Explain types of trigger?
13). Explain BULK INSERT in detail?
14). Explain types of transactions in SQL Server?
15). Explain SQL Profiler, Query analyzer, Enterprise Manager, View in SQL Server 2000.
DIFFERENCES
1). Primary Key Vs Foreign Key Vs Unique Key
2). Truncate Vs Delete
3). SmallDatetime Vs DateTime
4). User Defined Datatype Vs System Defined Datatype
5). Where Vs Having
6). Store Procedure Vs Functions
7). Rollup Vs Cube
8). Charindex() Vs Patindex()
9). Implicit Transaction Vs Explicit Transaction
10). Query Analyzer Vs Enterprise Manager
ORACLE
1). List and Explain Various Startup and Shutdown Methods?
2). Explain the difference between ArchiveLog Mode and NoArchiveLog mode and the benefits and disadvantages of each.
3). Explain difference between Hot Backup and Cold Backup?
4). What is Tablespace? List and Explain different types of Tablespace available in Oracle.
5). Explain types of Backup available in Oracle?
6). Write a steps to Create new Database Manually in Oracle?
7). What is Oracle Instance? Explain Background Processes and SGA?
8). What is tuning? Explain various types of tuning?
9). What is Contention? Explain Contention Issues?
10). What is Auditing? Explain different types of Auditing?
11). Explain Resource Management in detail? (Profile)
12). Explain Database Role in detail. Write a steps to create a role?
13). Explain following terms :
Segments | RowID | Auditing |
Extents | Tablespace | Oracle Database |
Profile | Init.Ora | PMON |
SMON | LGWR | DBWR |
CHECKPOINT | Redolog | Control File |
