Database Interview Questions
10 Feb, 2007
- What is an oracle instance?
- What is a view?
- What is referential integrity?
- Name the data dictionary that stores user-defined constraints?
- What is a collection of privileges?
- What is a snapshot?
- What is a synonym?
- What is a cursor?
- What is a sequence?
- What is a trigger?
- What is an exception?
- What is a partition of table?
- What are pseudo-columns in SQL? Provide examples.
- What are the Data Control statements?
- What is a schema?
- What is a type?
- What is a data model?
10 Feb, 2007
- What SAS statements would you code to read an external raw data file to a DATA step?
- How do you read in the variables that you need?
- Are you familiar with special input delimiters? How are they used?
- If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
- What is the difference between an informat and a format? Name three informats or formats.
- Name and describe three SAS functions that you have used, if any?
10 Feb, 2007
- What is source qualifier?
- Difference between DSS & OLTP?
- Explain grouped cross tab?
- Hierarchy of DWH?
- How many repositories can we create in Informatica?
- What is surrogate key?
- What is difference between Mapplet and reusable transformation?
- What is aggregate awareness?
- Explain reference cursor?
- What are parallel querys and query hints?
- DWH architecture?
- What are cursors?
- Advantages of de normalized data?
- What is operational data source (ODS)?
- What is meta data and system catalog?
- What is factless fact schema?
- What is confirmed dimension?
10 Feb, 2007
- How do you read transaction logs?
- How do you reset or reseed the IDENTITY column?
- How do you persist objects, permissions in tempdb?
- How do you simulate a deadlock for testing purposes?
- How do you rename an SQL Server computer?
- How do you run jobs from T-SQL?
- How do you restore single tables from backup in SQL Server 7.0/2000? In SQL Server 6.5?
- Where to get the latest MDAC from?
- I forgot/lost the sa password. What do I do?
- I have only the .mdf file backup and no SQL Server database backups. Can I get my database back into SQL Server?
10 Feb, 2007
- Compare and contrast SQL Server with MySQL.
- Compare and contrast stored procedures and dynamic SQL.
- Describe a standard 3-tier architecture and the interfaces between each tier.
- Compare and contrast a rich client and browser-based web application
- Compare and contrast WS and remoting protocols.
- Design the data structures for the game battleship.
