Provided by www.YuvaJobs.com - Nihilent Placement Papers how to use in SQLSERVER? what is sql? What are the main differences between PostgreSQl and MySql? what is sql? what is sql? what is difference between generalization and normalization? Shirinkage control in Store. What are concepts of oops? what is the correct meaning of primary key? storein charge How do you verify the name of the database how to store images in oracle Database who can create a database without query? what is the difference between MS Access and SQL server? How can I get the heading of a report to appear on every page? How do I email just one report in my database? How do I password protect my Access database? I am using the Switchboard Manager in MS Access. I am getting an error message "... When I assigned a primary key to my table in Microsoft Access, I was expecting m... Would you like to easily automate your MS Access database through menu driven selections? What is the size limitation of an Access database? How can I open an MS Access database that has been converted to a current version? In MS Access, the long and short date option does not show 4 digit years. How do... I am designing an Access database form. How can I get my next control in the for... What is the maximum size of a database that can be opened in Microsoft Access? What format should my database be saved in to allow different versions of Micros... What format should my database be saved in to allow different versions of Micros... how many commands use in access.? what is the difference between MS Access and SQL server? Define Stored procedure.Why we r use stored Procedure?Explain with example What is the option used in PostgreSQL to increase the number of shared memory bu... What are the ODBC drivers that are available for PostgreSQL? What is used by PostgreSQL in its internal system tables to link rows in separate tables? What does GEQO stands for in PostgreSQL? What is the command that can be used to allocate memory in postgreSQL? What is the command that can be used to allocate memory in postgreSQL? To identify specific physical rows with block and offset values what can be used... Triggers are supported and can be attached in PostgreSQL to tables or views? Does PostgrSQL support Column constraints? If so how is it done? What is used by PostgreSQL in its internal system tables to link rows in separate tables? What can be used in PostgreSQL to send messages to the front-end, and optionally... What is the option that can be used in PostgreSQL to make transactions see rows ... What is the command or the option available in postgresql that can be used to re... What is the command or the option available in postgresql that can be used to re... Does PostgrSQL support Column constraints? If so how is it done? What is used by PostgreSQL in its internal system tables to link rows in separate tables? Triggers are supported and can be attached in PostgreSQL to tables or views? What does the option psql -l of PostgreSQL display? How is the statistics in PostgreSQL updated? What is the Maximum size for a database in PostgreSQL? What are the character types that are available in postgresql? What is the operator that is used for case-insensitive regular expression search... How many byte Unique integers does OIDs in PostgreSQL have? What are the ODBC drivers that are available for PostgreSQL? What does GEQO stands for in PostgreSQL? What is the command that can be used to allocate memory in postgreSQL? To identify specific physical rows with block and offset values what can be used... What is the Maximum size for a table in PostgreSQL? Whar is an index? What are the types of indexes? How many clustered indexes can ... What are constraints? Explain different types of constraints. What are the new features introduced in SQL Server 2000 (or the latest release o... Explain the storage models of OLAP What,s the difference between DELETE TABLE and TRUNCATE TABLE commands? What is lock escalation? Explain the architecture of SQL Server Explain Active/Active and Active/Passive cluster configurations What,s the maximum size of a row? CREATE INDEX myIndex ON myTable(myColumn) Explain different isolation levels What is a transaction and what are ACID properties? What are defaults? Is there a column to which a default can,t be bound? Define candidate key, alternate key, composite key. What is bit datatype and what,s the information that can be stored inside a bit column? What are user defined datatypes and when you should go for them? What,s the difference between a primary key and a unique key? How do you implement one-to-one, one-to-many and many-to-many relationships whil... What is denormalization and when would you go for it? What is normalization? Explain different levels of normalization? Difference between tnsnames.ora and listener.ora? What is TSQL? The Relational model has _____ components? What is the difference between transaction database and data warehouse databases? How to build/install/create demonstration tables (ie.employee,department) in Oracle 9i? There is a new project to acquire a new data feed from a vendor and add it to a ... You are writing a report that needs to format data being extracted from the data... What is the difference between SQL & T-SQL? What is difference between ADO & DAO? What are the different methods to make query faster? While taking hot backup (begin end backup) what will happens back end? Which view shows all partitions of a table and their tablespaces? Briefly explain the difference between first, second, third and fourth normal forms? Post block trigger belongs to which type of trigger? Difference between Two tier architecture and Three tier architecture? What is the difference between delete,drop and truncate? What is view? Types of views?use of views?how to create view(syntax)? Can we update views.If not,why? What is a value set? Different types of joins? How might you quantitatively measure an improvement made to a query? What are parameter files ? Where do we use them? Provided by www.YuvaJobs.com - Nihilent Placement Papers